Cannot connect to SQL Server via LAN
Home > IT Answers > SQL Server > Cannot connect to SQL Server via LAN
MissBelle
5 pts.
0
Q:
Cannot connect to SQL Server via LAN
SQL Server Enterprise Manager, SQL Server registration, SQL Server administration
I try to add a new server registration using Enterprise Manager in a client machine to the SQL database in the server machine. I somehow keep getting 'Access denied' or registration failed. Then I can finally add the server registration after I open the shared folder at the server. Can anybody explain to me why opening the shared folder suddenly gives me permission to add the new server registration? And how do I connect without having to open the shared folder beforehand?
ASKED: Apr 2 2009  2:58 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
MissBelle
5 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Apr 2 2009  2:58 AM GMT by MissBelle   5 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

mrdenny   46795 pts.  |   Apr 2 2009  6:32PM GMT

For some reason the server isn’t processing the NTLM authentication correctly. I restart of the SQL Service, or possible the entire SQL Server may be required.

 
0