SQL: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Find SQL servers with powershell <syntaxhighlight lang="powershell"> [System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() </syntaxhighlight> browser agent must...") (change visibility) |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 4: | Line 4: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
browser agent must be running | browser agent must be running | ||
== getting access to == | |||
Add .\administrators to sql administrators | |||
<syntaxhighlight lang="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 | |||
</syntaxhighlight> | |||
or run in single user mode | |||
<syntaxhighlight lang="powershell"> | |||
sqlservr -m | |||
</syntaxhighlight> | |||
or run management studio as system using psexec | |||
<syntaxhighlight lang="powershell"> | |||
PsExec -s -i "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe" | |||
</syntaxhighlight> |
Revision as of 14:52, 16 May 2017
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"