I reinstall sql server develope edition. Then I try to connect the server from another computer, it shows below infomation. But in server property, it allows remote connection. I don't know whether it was caused by reinstall. Before reinstall, I can connect to the server, but it's edtion is group version. And edition for client is also group version. Any one can help me? Thank you very much!
TITLE: Connect to Server
Cannot connect to *.*.*.*.
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
BUTTONS:
OK
Hi,
Have you checked if the Named Pipe and TCP/IP are enabled? Ensure firewall rules are in proper manner!!1
Also refer NET DDE and NET DDE DSDM and SQL Browser Service are started in Control Panel -> Administrative Tools-> Services
Hemantgiri S. Goswami
|||Now I'm reinstalling again. If issue still exists after that, I'll take your suggestion. Thank you!|||After reinstall, issue has been solved.|||Hi,
Thanks for the information , nice to know that your issue has been resolve.
Hemantgiri S. Goswami
No comments:
Post a Comment