Click here to Skip to main content
14,739,836 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I host a asp.net website with sql database. Now I want to update my sql database table form control panel. But they(hostgator.com) said that u need to do all this from sql server login.
Then I login in sql server management studio compact properly with server ip, user name and password.

But there is a problem. Sql server couldn't retrieve my created database and also when I click on database expand option then it displays error "failed to retrieve data for this request. (microsoft.sqlserver.management.sdk.sfc)".

It will be really helpful if u give me proper suggestions.
Posted

1 solution

You need to talk to your hosting service: hostgator.com

What you need is the ip address / server instance name and appropriate login details that they can supply - we can't because all systems are configured differently - many do not allow "remote access" for security reasons, so you can't get in via SSMS at all. They may mean a different "SQL server login" - from your code for example.

Talk to their technical support - they should be pretty used to it!
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900