KnowledgebaseHow can we help you?

Errors in accessing remote database via SQL Management Studio

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



+91 9569505379 (Till Covid -19 Outbreak)
10:00 am to 7:30 pm IST Monday to Saturday
Live Chat, Email and Tickets are available 24/7

HostAdvice Great Uptime Award for Gen X Web Hosting
Gen X Web Hosting Reviews