你需要和你的托管服务商谈：hostgator。 com b / b


您需要的是IP地址/服务器实例名称以及它们可以提供的相应登录详细信息 - 我们不能，因为所有系统的配置都不同 - 很多都是出于安全原因不允许远程访问，因此您无法通过SSMS进入。它们可能意味着不同的SQL服务器登录 - 例如来自您的代码。



与他们的技术支持人员交流 - 他们应该习惯它！

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.

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!