After several attempts to install SQL2005 I finally got Microsoft SQL Server Management Studio installed.
But now I get the error below:
An error has occurred while establishing a connection to the server. 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: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
The sa account username/password are correct and don't work, windows authentication does not work, I have stopped/started all the services, I have all Protocols enabled correctly, I have my Firewall turned off.
Is there anything else I can try? Anything!
After 24 hours of looking at this, I just figured out the answer!!! ServerName\instance is needed for logging on!!
No comments:
Post a Comment