SQL: Difference between revisions

From WikiWiki
Jump to navigation Jump to search
No edit summary   (change visibility)
 
Line 1: Line 1:
Find SQL servers with powershell
Find SQL servers with powershell
<syntaxhighlight lang="powershell">
<syntaxhighlight language="powershell">
[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()
[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()
</syntaxhighlight>
</syntaxhighlight>
Line 8: Line 8:
== getting access to ==
== getting access to ==
Add .\administrators to sql administrators
Add .\administrators to sql administrators
<syntaxhighlight lang="powershell">
<syntaxhighlight language="powershell">
sqlcmd -Q "if not exists(select * from sys.server_principals where name='BUILTIN\administrators') CREATE LOGIN [BUILTIN\administrators] FROM WINDOWS;EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\administrators', @rolename = N'sysadmin'" –S ComputerName\InstanceName
sqlcmd -Q "if not exists(select * from sys.server_principals where name='BUILTIN\administrators') CREATE LOGIN [BUILTIN\administrators] FROM WINDOWS;EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\administrators', @rolename = N'sysadmin'" –S ComputerName\InstanceName
</syntaxhighlight>
</syntaxhighlight>


or run in single user mode
or run in single user mode
<syntaxhighlight lang="powershell">
<syntaxhighlight language="powershell">
sqlservr -m
sqlservr -m
</syntaxhighlight>
</syntaxhighlight>


or run management studio as system using psexec
or run management studio as system using psexec
<syntaxhighlight lang="powershell">
<syntaxhighlight language="powershell">
PsExec -s -i "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"
PsExec -s -i "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"
</syntaxhighlight>
</syntaxhighlight>

Latest revision as of 22:49, 21 August 2020

Find SQL servers with powershell

[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()

browser agent must be running


getting access to

Add .\administrators to sql administrators

sqlcmd -Q "if not exists(select * from sys.server_principals where name='BUILTIN\administrators') CREATE LOGIN [BUILTIN\administrators] FROM WINDOWS;EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\administrators', @rolename = N'sysadmin'" –S ComputerName\InstanceName

or run in single user mode

sqlservr -m

or run management studio as system using psexec

PsExec -s -i "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"