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
-
Getting Started with Windows Reseller Hosting Open or Close
1. Purchase a Windows Reseller Hosting. 2. Login to plesk. You can login to plesk via following... Read More
-
Getting Started with Windows Shared Hosting Open or Close
To make your website visible on the Web, your website’s files and data must be stored or "hosted"... Read More
-
Redirect HTTP to HTTPS automatically in .Net Open or Close
Using the following code in your web.config file automatically redirects visitors to the HTTPS... Read More
-
Manually Install Wordpress on your Domain using Plesk Open or Close
1. To install WordPress for your website, Click On WordPress in the left sidebar of Plesk Panel.... Read More
-
How to add Email forwarding in plesk Open or Close
1. Login to Plesk. 2. Click on Email addresses in your panel. 3. Select your email... Read More
