I recently moved a SQL database to a new serve. Both Servers are running SQL Express 2005 and IIS 6.0; both applications are configured exactly the same except for the service name (SLQEXPRESSS on the old server and MSSQLSERVER on the new). When I try to access the new webserver I get an error 25 - Connection string is not valid.
Can anyone offer any suggestions at this point?
NEW SERVER:OLD SERVER:Code:<add name="LocalSqlServer" connectionString="Data Source=BODHOST-CB1D\MSSQLSERVER;Initial Catalog=newFileSys;Integrated Security=True" providerName="System.Data.SqlClient" />Code:<add name="LocalSqlServer" connectionString="Data Source=BODVPS3\SQLEXPRESS;Initial Catalog=newFileSys;Integrated Security=True" providerName="System.Data.SqlClient"/>Code:[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)] <snip>



Reply With Quote
Bookmarks