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

Answer 1

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

Answer 2

Is there any other alternative to connect SQL Server 2000 from my machine with client domain credentials(windows authentication).

---

Sateesh Maduri

Answer 3

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

Answer 4

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

Answer 5

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

Answer 6

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!