General discussion

Locked

SQL2005 Upgrade Adivsor Utility error

By pafan23 ·
I receive an error in a Sql 2000 Enterprise clustered enviroment. I receive the error after entering connection parameters. Any ideas?
Unable connect to server. Reason: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by mtalcott In reply to SQL2005 Upgrade Adivsor U ...

If it is not the obvious problem with the remote sql server not being configured to allow connections, then it is probably that your machine.config file or web.config file is not specifying the correct database for memberhship information.
The full answer to solving this is at <a href="http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx">http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx</a>

-MTalcott

Back to Networks Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums