SQL: Difference between revisions
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 | <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 | <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 | <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 | <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"