| Author |
 Topic  |
|
|
Analyzer
Yak Posting Veteran
United Kingdom
78 Posts |
 Posted - 05/03/2012 : 10:58:56
|
Unable to start sql 2008R2 due to TempDB move typo resulting in location does not exist. (missing \) To repair problem I start sql in minimal config mode. -s;-f;-c,-T3609 which works - However I cannot obtain the only connection to SSMS. Message says "single user mode, only one administrator can connect at this time".
Read lots of posts, switch off all other services, change to sql service to local account, I cannot block Port 1433 due to other instance on server. Any idea's of method to guarantee starting sql and obtain the only connection? |
|
|
Bustaz Kool
Flowing Fount of Yak Knowledge
USA
1430 Posts |
Posted - 05/04/2012 : 18:53:23
|
Have you tried using a "Dedicated Administrator Connection". Look it up in Books Online and see it there is any joy there for you.
=================================================
There is a foolish corner in the brain of the wisest man. -Aristotle, philosopher (384-322 BCE) |
 |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1771 Posts |
Posted - 05/05/2012 : 05:12:46
|
Try it through the command line - do a NET START MSSQL$MYINSTANCE ...... , disconnect SQL Server through the SSMS Object Explorer, close object explorer. Attempt to connect through a new query.
Before you try this step - check for all other services such as SSIS, Reporting Services. Only try the above when you have just SQL Server and SQL Browser
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
|
Analyzer
Yak Posting Veteran
United Kingdom
78 Posts |
Posted - 05/08/2012 : 07:22:53
|
Hi There.
After trying every other possible syntax string with no success. NET START MSSQL$instance /f /T3608 worked.
Commands like sqlcmd -S; -f INSTANCE -U -P –A, the DAC connection, modifying instance properties in sqlConfiguration Manager for minimal conf start-up all worked, but did not permit the single connection.
A very big thanks |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1771 Posts |
Posted - 05/09/2012 : 01:44:44
|
Are all the auxillary SQL Server services turned off , except SQL Server and SQL Browser?
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
|
Analyzer
Yak Posting Veteran
United Kingdom
78 Posts |
Posted - 05/09/2012 : 03:37:58
|
Thanks. Yup, all auxillary services were turned off. First time I had this issue and been DBA since 6.5 times. My first time attempting this with SS2008R2, so appears in my case the clustered, multi-instance environment I was working on is extremely sensitive to the method required to start in minimal config/single user mode and obtaining the only connection.
Don't know if others have had the same issue? |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1771 Posts |
Posted - 05/09/2012 : 14:49:05
|
Based on your last post , is this server part of a Cluster?
If so , do you have the SQL Server resource offline?
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
|
Analyzer
Yak Posting Veteran
United Kingdom
78 Posts |
Posted - 05/10/2012 : 03:36:37
|
Valid point. This was a multi-instance clustered environment and the sqlServer resource was not offline.
School boy oversight (working on high pressure client site), appreciate the feedback. |
|
|
| |
Topic |
|
Can't Access SQLServer in Single User Mode
