SQL: Difference between revisions

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