So, my hosting provider is moving my umbraco site to a new enviroment, both db and files. After changing the connectionstring to the new one, the site loads fine. However, I can not log in to back office. I get:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---
The error indicates that it's trying to connect to the old db. Is there more than one place I need to change connectionstring? Any ideas on this?
Its on a remote server, as provided by the host. The front facing site works well though som the connection seems to work. I have confirmed that its using the new db.
if it doesn't work, then if you want to I can set up your database on our server and then you can point the sites connectionstring and see if it works both backend and frontend
Hosting changed, cant login to backoffice
So, my hosting provider is moving my umbraco site to a new enviroment, both db and files. After changing the connectionstring to the new one, the site loads fine. However, I can not log in to back office. I get:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---
The error indicates that it's trying to connect to the old db. Is there more than one place I need to change connectionstring? Any ideas on this?
Hi David,
Which version are you using of umbraco, iis, sql etc?
Scott
Running 4.6.1 on IIS7 and sql server (probably 2005)
And where is the database, on local or remote machine from your umbraco installation?
Its on a remote server, as provided by the host. The front facing site works well though som the connection seems to work. I have confirmed that its using the new db.
oh and what version of .net framework are you using?
It's running 4.0.
Okay, then I guess you are running with default app pool settings like
It does look like that. No real cue on what to try next...
sometimes in the connection string you can try to add ,1433 to the host
so server=dbserver.host.com,1433
if it doesn't work, then if you want to I can set up your database on our server and then you can point the sites connectionstring and see if it works both backend and frontend
is working on a reply...