Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

sql server 2008 single user mode and sqlcmd

 
   Database Help (Home) -> Setup RSS
Next:  comment ca marche  
Author Message
jake

External


Since: Apr 14, 2008
Posts: 4



(Msg. 1) Posted: Tue Oct 13, 2009 10:05 am
Post subject: sql server 2008 single user mode and sqlcmd
Archived from groups: microsoft>public>sqlserver>setup (more info?)

I need to change the erroneous location of tempdb. Sql server service
now does not start. When I start it in single user mode "net start
mssqlserver /f", it starts, but then when I try to start sqlcmd (to
correct the tempdb path) I get an error stating that the sql server is
in single user mode and Administrator cannot connect to it, and so
sqlcmd fails to start. Is there a way out of this?
Your help is greatly appreciated.
jake

 >> Stay informed about: sql server 2008 single user mode and sqlcmd 
Back to top
Login to vote
con-man-jake

External


Since: Oct 13, 2009
Posts: 1



(Msg. 2) Posted: Tue Oct 13, 2009 10:45 am
Post subject: Re: sql server 2008 single user mode and sqlcmd [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Oct 13, 1:05 pm, jake wrote:
> I need to change the erroneous location of tempdb.  Sql server service
> now does not start.  When I start it in single user mode "net start
> mssqlserver /f", it starts, but then when I try to start sqlcmd (to
> correct the tempdb path) I get an error stating that the sql server is
> in single user mode and Administrator cannot connect to it, and so
> sqlcmd fails to start.  Is there a way out of this?
> Your help is greatly appreciated.
> jake

Nevermind...the server agent was automatically connecting to it every
time I start it. I had to stop it first, then sqlcmd started working
again.

 >> Stay informed about: sql server 2008 single user mode and sqlcmd 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL Server 2005 on Windows Server 2008 - sqlcmd can not co.. - SQL Server 2005 SP2 (9.0.3068) installed on Windows Server 2008 Enterprise. When I installed SQL Server I specified a "named instance" with the name TEAMFOUNDATION. This appears to be working OK; I have Team Foundation Server and SharePoint ...

2008 x64 RC0 on Windows Server 2008: corrupting Registry ACL - Hi, During the uninstall (only one error during uninstall) and consequent attempt to reinstall, this problem became overpowering: ============== Detailed results: Feature: Database Engine Services Status: ...

Visual Web Developer 2008 + SQL Server 2008 Express = Bad .. - Platform: Win XP SP2 History: I had Visual Web Developer 2005 Express and SQL Server 2005 Express installed. I uninstalled both and installed a package of both Visual Web Developer 2008 Express and SQL Server 2008 Express Beta. I received an error whe...

Domain or Local User Account for Laptop SQL 2008 Services - I'm trying to install the Developer edition of SQL Server 2008 on my laptop, and the setup of the SQL Server Services has me stumped. I'm on an XP sp3 laptop that is occasionally connected to my SBS 2003 domain. I think I'd like to use a Domain User...

Newbie: Can SQL Server 2005 be installed under Windows Ser.. - I'm a bit confused. When I look at the system requirements for SQL Server 2005, WS 2008 is never mentioned (or maybe my tired eyes just missed it). Will SQL Server 2005 install and run properly on a WS 2008 box? TIA Robert
   Database Help (Home) -> Setup All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]