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) |
No edit summary (change visibility) |
||
Line 4: | Line 4: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
browser agent must be running | browser agent must be running | ||
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'" | |||
</syntaxhighlight> |
Revision as of 11:44, 27 October 2016
Find SQL servers with powershell
[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()
browser agent must be running
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'"