Post reply

Login failed for user

  • April 2, 2009 at 7:39 pm

    #136393

    Guys,

    I have been troubleshooting this error and I still having my SQL DB down...I cannot give the SQL services a domain user, when want to chang eto Network services it give me WMI Protocol Error.

    Please I need help on this..who any one had this before pleae let me know how it was fixed...I have been workaround but nothing change.

    Thank you in advance.

  • April 2, 2009 at 8:05 pm

    #971258

    Go to Surface Area confiiguration, and check what is the remote connection protocal, make sure it is TCP/IP.

    Then go to Service configuration, network protocol configurations> ensure the TCP/IP are enabled for the server itself and the native client.

    If u changed any above options from disable to enable, Restart the SQL service so that the changes will take effect.

  • April 2, 2009 at 8:09 pm

    #971262

    Thank you, but I already done it, and the same error.

    I am attaching the error I am receiving. The worst part is that it does not allow me to change log on user on services. is running with local system.

    Thank you.

  • April 2, 2009 at 8:27 pm

    #971270

    Sorry, I misunderstood your issue. I thought you couldn't connect to the server through domain.

    So, it is about your SQL services. You mean, now your SQL service is Up and running, but running with local systems. And what you want to achieve is to change the service account as some domain account. Right? I am a little confused, you said your SQL DB is down in your original pose. Is the SQL services up and running now?

  • April 2, 2009 at 8:38 pm

    #971276

    Now it was mu fault...

    The first time when open this case was down. i found an interesting note to give me NT AUTHORITY\SYSTEM grant permission, addsrvrolemember, and it ran. However it was under "local system" ...I cannot change it. I am not able to change my Log On services, and it was working clean, and smoothly.

    For some reason does not allow me to input my domain user.

    Any suggestion , please?

  • April 3, 2009 at 7:56 am

    #971574

    I would check to make sure the domain user has the right permission on the local server.

  • April 6, 2009 at 12:45 pm

    #972818

    Thank you Guys, I found it was DNS issue.... I run flushdns and now is working.

    Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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