SQL: Difference between revisions

From WikiWiki
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"