Unable to switch MSSQL from external to local

Created:

2016-11-16 12:46:33 UTC

Modified:

2017-04-24 12:12:09 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to switch MSSQL from external to local

Applicable to:

  • Plesk 12.5 for Windows

Symptoms

One site in particular, for example http://domain.tld/ used to have a DB connection to old web server via IP 123.123.123.123. If edit the web.config file back to this it works fine. However the site is not load by changing it to use the local system .\\MSSQLSERVER2014 or a variation of this.

Additionally, attempt to connect to the SQL server via 'SQL Server Management Studio' is failed with "Cannot open user default database. Login failed" error message.

Cause

SQL user was created as "SQL user without login"

Resolution

  1. Add new database user or remove exiting one and recreate it via Home > Subscriptions > domain.tld > Databases
  2. Modify connection string in the web.config accordingly.

Additional information about connection strings available at The Connection Strings Reference website

Have more questions? Submit a request
Please sign in to leave a comment.