Post reply

logon failure

  • May 7, 2004 at 5:45 pm

    #66800

    Really easy question for you guys:

    I have a SQL server 2k DB on my server. I installed Enterprise Manager on my laptop computer and downloaded the DB so I can tweak the frontend off site. I turned SQL services off on the laptop a few days ago so it wouldn't run down the battery. Now when I click the start button on the SQL Server service manager, I get an error "logon failure". How do I make it happy again?

    Thanks!

    SMK

  • May 8, 2004 at 3:37 pm

    #505733

    Try workarrounds in the link:

    http://www.tkdinesh.com/faq/ans/Snapinfail.html

    I had similar problem. After I resgistered sqlmmc.dll, It works now.

     

    Good Luck!

     

  • May 10, 2004 at 7:50 am

    #505790

    Apparently the issue is related to Service Accounts. SQL Server 2000 services accounts and passwords are linked to Windows user accounts and passwords. If you make changes in one location you must make the same changes in the other.

    To change SQL Server Services Accounts after you have installed SQL Server 2000, use SQL Server Enterprise Manager to change the assigned account and password to SQL Server service and SQL Server Agent

    I suggest to change the MSSQLServer service login in your laptop as follows:

    1. Expand a server group.
    2. Right-click a server, and then click Properties.
    3. In the SQL Server Properties dialog box, click the Security tab.
    4. In the Startup service Account box, the option for This Account is probably selected. Since you are running SQL Server from a laptop and assuming your SQL Server will not access resources on the network, I suggest to change to System Account.

    I suggest to change the SQLServerAgent service login in your laptop as follows:

    1. Expand a server group, and then expand a server.
    2. Expand Management.
    3. Right-click SQL Server Agent, and then click Properties.
    4. In the SQL Server Agent Properties dialog box, click the General tab.
    5. In the Service startup Account box select System Account.

    Regards

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

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