Errors accessing database via SQL management studio
When you connect your database with remote connection on SQL Management Studio, It is possible that you get an error when expanding the list of database like shown below:
In order to resolve this issue, follow the steps given below:
1. After connecting to your remote database via SQL Management Studio, Select the Database tab on the left sidebar.
2. Click on Object Explorer Details in View Tab.
3. Object Explorer will open now.
4. Right Click on Name Header and navigate to Collation. Click on collation to uncheck it.
5. Now disconnect and reconnect your database and it will be working fine.
6. If issue is not resolved yet, Contact your hosting support team.
Was this answer helpful?
Also Read
-
Taking backup of database and restoring it in Plesk Open or Close
Manual database backup in Plesk Login to plesk panel and Go to Websites & Domains >... Read More
-
How to enable GZip compression in Windows Open or Close
GZIP compression may be enabled either directly through a web.configOnce enabled, it can be... Read More
-
How to add user in Plesk Open or Close
1. Login in to Plesk.2. Click on Users.3. Click on Create User Account4. Now fill the All... Read More
-
How to View Full ASP.NET Error Details Using web.config Open or Close
If your application is throwing errors, but you cannot see the full error message, you can... Read More
-
Change Permission of folder in Plesk Open or Close
1. Login to Plesk Control Panel. 2. Click on the Websites & Domains tab and navigate to... Read More
