Good Day,
We have a recently developed (and in testing) VB .Net application which attaches to a specific SQL2005 DB. The issue is that when installed (or run in DEBUG mode) on the developer box it successfully connects to the appropriate db locally and to the live server. When installed on a test box (several of them) we receive error - 26 Error locating Server/Instance Specified.
The SQL Server instance is set up for remote connections and works for other dbs.
All of the boxes are running XP Pro, with all SPs applied.
Any thoughts on what may be occuring would be greatly appreciated.
This might help:
"Connection error occurs when the Database Engine service account password expires
The
following error occurs when you connect to a report server, and the
service account password has expired for the SQL Server Database Engine
instance that hosts the report server database: "The report server
cannot open a connection to the report server database. A connection to
the database is required for all requests and processing.
(rsReportServerDatabaseUnavailable)."
The error message includes
these additional statements: "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 Server Network
Interfaces, error: 26 - Error Locating Server/Instance Specified)."
To resolve this error, reset the password. For more information, see Changing Passwords and User Accounts."
http://msdn2.microsoft.com/en-us/library/ms156468.aspx
Also check out this kb:http://support.microsoft.com/kb/905618
