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

On Oct 13, 1:05*pm, jake <jakedim... (AT) gmail (DOT) com> wrote:
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.