Retrieve database to server login on sql server 2008
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.