Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out
[run as Admin]
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Windowssystem32>
C:Windowssystem32>net stop mssqlserver
The SQL Server (MSSQLSERVER) service is stopping.
The SQL Server (MSSQLSERVER) service was stopped successfully.
C:Windowssystem32>net start mssqlserver /m
The SQL Server (MSSQLSERVER) service is starting.
The SQL Server (MSSQLSERVER) service was started successfully.
C:Windowssystem32>sqlcmd
1> EXEC sp_addsrvrolemember 'MSDOMAIN1RT-DBA', 'sysadmin';
2> GO
1> quit
C:Windowssystem32>net stop mssqlserver
The SQL Server (MSSQLSERVER) service is stopping.
The SQL Server (MSSQLSERVER) service was stopped successfully.
C:Windowssystem32>net start mssqlserver
The SQL Server (MSSQLSERVER) service is starting.
The SQL Server (MSSQLSERVER) service was started successfully.
C:Windowssystem32>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/66009/viewspace-1060770/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SQL Server的BUILTIN\Administrators使用者SQLServerUI
- Connecting to the MySQL ServerMySqlServer
- sql server select case when的用法SQLServer
- Your account has been locked out. Please contact the system administrator for further assistance.
- Resource is out of sync with the file system
- Troubleshooting: SQL Server連線錯誤解決方法列表SQLServer
- A significant part of sql server process memory has been paged outNifiSQLServer
- SQL Case WhenSQL
- Eclipse:Resource is out of sync with the file systemEclipse
- SQL SERVER 忘記了sa的密碼,又刪除了builtin\administrators帳號SQLServer密碼UI
- SQL not exist out joinSQL
- Hide RMAN Passwords when Connecting to a Target Database (Doc ID 183377.1)IDEDatabase
- System.out.print實現原理猜解
- sql when null 判斷SQLNull
- 關於sql server case when ..else ..end結果型別的小議SQLServer型別
- ORACLE ORA-04030之 out of process memory when trying to allocateOracle
- Oracle case when改寫SQLOracleSQL
- SQL中的CASE WHEN使用SQL
- PL/SQL Case when應用SQL
- sql case when, Exist ,group by ,聚合SQL
- Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]SQL
- SQL Case when 的使用方法SQL
- sql中case when的小學SQL
- Troubleshooting The Relink Errors When Missing RPMs on Linux x86-64_786995.1ErrorLinux
- WGET command is getting 403 forbidden response when remote install gc agent,TroubleshootingwgetORBREMGC
- 機器學習之nltk download出錯:Error connecting to server: [Errno -2]機器學習ErrorServer
- ORA - 1461 encountered when generating server alertServer
- ERROR 23 (HY000) at line 29963: Out of resources when opening fileError996
- System Requirements for WebSphere Application ServerUIREMWebAPPServer
- Myeclipse:resource is out of sync with the file system的解決辦法Eclipse
- Troubleshooting ORA-3137 [12333] Errors When Using Oracle JDBC DriverErrorOracleJDBC
- SQL中的case when then else end用法SQL
- 解決eclipse中出現Resource is out of sync with the file system問題Eclipse
- Which SPFILE is Impacted when Issuing an ALTER SYSTEM Command? [ID 138119.1]UI
- SQL in ORACLE and SQL ServerSQLOracleServer
- sql ServerSQLServer
- 靈魂拷問:你真的理解System.out.println()列印原理嗎?
- Connecting to Nomounted databaseDatabase