在sql server 2008上检索数据库到服务器登录 [英] Retrieve database to server login on sql server 2008

问题描述

我主持一个带有sql数据库的asp.net网站。现在我想更新我的sql数据库表格表单控件面板。但是他们（hostgator.com）说你需要从sql server登录做所有这些。

然后我用服务器ip，用户名和密码正确登录sql server management studio。



但是有一个问题。 Sql server无法检索我创建的数据库，当我单击数据库展开选项时，它会显示错误无法检索此请求的数据。（microsoft.sqlserver.management.sdk.sfc）。



如果你给我正确的建议，那将非常有帮助。

解决方案

你需要和你的托管服务商谈：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!

这篇关于在sql server 2008上检索数据库到服务器登录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！