SQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary (change visibility) |
No edit summary (change visibility) |
||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
Find SQL servers with powershell | Find SQL servers with powershell | ||
<syntaxhighlight | <syntaxhighlight language="powershell"> | ||
[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | [System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Line 6: | Line 6: | ||
== getting access to == | |||
Add .\administrators to sql administrators | Add .\administrators to sql administrators | ||
<syntaxhighlight | <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'" | 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> | |||
or run in single user mode | |||
<syntaxhighlight language="powershell"> | |||
sqlservr -m | |||
</syntaxhighlight> | |||
or run management studio as system using psexec | |||
<syntaxhighlight language="powershell"> | |||
PsExec -s -i "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe" | |||
</syntaxhighlight> | </syntaxhighlight> |
Latest revision as of 23: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"