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
-
Changing MX, A, CNAME Records - Plesk 12.0 and 12.5 Open or Close
To edit an existing DNS zone record: Log into Plesk. Click the Websites & Domains tab,... Read More
-
Change Default Mail box Size in Plesk Open or Close
1. Login to Reseller Plesk Account. 2. Click on Subscriptions. 3. Select your... Read More
-
How to change ASP version in Plesk Open or Close
1. Login to Plesk. 2. Go to ASP Settings. 3. Click on Change Version. 4. Select your... Read More
-
How to Add DNS Records in Plesk Open or Close
1. Login to Plesk. 2. Click on DNS Settings in your Domain Panel. 3. Now click on Add... Read More
-
Customize Plan Of Subscription in Plesk Open or Close
All actions take place in your Plesk Administration Panel.1. Login in your Panel.2. Click On... Read More
