none
There are currently no logon servers available to service the logon request

    Question

  • I am getting error message like  "There are currently no logon servers available to service the logon request" while connecting to SQL Server 2000 using "runas" command from Command prompt.

    Scenario :: I connected to my system with local network domain credentials. And I connected to client VPN using their domain credentials. Now I tried to connect SQL Server 2005 and SQL Server 2000 using sql server 2005 management studio and enterprise manager respectively, but i am unable to connect to the client database servers because its showing local domain credentials while connecting with windows authentication mode. Client given only windows authentication to me to access their DB servers. So I googled and found that ,I can run sql server 2005 from command prompt using client domain credentials. But when I tried the same for sql server 2000 its giving the above mentioned error. Please help me in this as soon as possible. Thanks in advance.


    Sateesh Maduri
    Wednesday, November 10, 2010 12:29 PM

Answers

All replies

  • This error message means that SQL Server was not able to connect to the Active Directory to authenticate the login credentials supplied. Check for any error message during that time in System Event Log.


    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    Wednesday, November 10, 2010 4:15 PM
  • Is there any other alternative to connect SQL Server 2000 from my machine with client domain credentials(windows authentication).
    Sateesh Maduri
    Thursday, November 11, 2010 4:42 AM
  • You should be connected to the client domain. Like I mentioned earlier, this error message is due to the fact that SQL Server is not able authenticate your ID with the Active Directory.


    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    Thursday, November 11, 2010 5:33 AM
  • When you use VPN, your local credentials get passed to client domain. To avoid that, you can try the suggestion mentioned in the discussion here http://www.eggheadcafe.com/software/aspnet/29397470/windows-authentication-in-management-studio-over-vpn.aspx
    Thursday, November 11, 2010 5:42 AM
  • I logged into my system using local my company domain credentials. And I connected to client domain using VPN, but im accessing sql server 2000 from my system itself.
    Sateesh Maduri
    Thursday, November 11, 2010 6:08 AM
  • Still an issue?

    Thanks!


    Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Thursday, April 04, 2013 5:34 AM
    Owner