SQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary (change visibility) |
|||
(One intermediate revision by the same user not shown) | |||
Line 6: | Line 6: | ||
== getting access to == | |||
Add .\administrators to sql administrators | Add .\administrators to sql administrators | ||
<syntaxhighlight lang="powershell"> | <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'" | 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> | </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"