Post reply

Starting SQL Server from the command line ????

  • June 20, 2006 at 4:01 am

    #114020

    I've restored the master database - in order to do this I had to put it in single user mode (through EM).

    I can't now connect to SQL Server through EM as it says only one user can connect.

    From reading other discussions I can see that using the -f option should get me access. I don't know however where to use this -f option, do I put it in the command line?

    How do you start SQL Server from the command line ? Any help would be greatly appreciated.

  • June 20, 2006 at 4:17 am

    #644756

    managed to find and run the sqlservr.exe -f from the command line. It is now saying that it can't connect to the ERRORLOG because it is being accessed by another user (presumably the single user).

    I seem to therefore have started with single user and locked myself out - any ideas ??

  • June 20, 2006 at 4:27 am

    #644757

    Hi,

    stop the mssqlserver servoce from controlpanel-administrative tools- services.After that start the sql server service normally.I think you should be able to get access

  • June 20, 2006 at 5:27 am

    #644765

    You're right - thanks for your help !!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply