如何通过服务器资源管理器将SQL Server 2008数据库连接到Visual Studio 2010 [英] how to connect sql server 2008 database to visual studio 2010 through server explorer

问题描述

hai all

如何通过服务器资源管理器将sql server 2008数据库连接到Visual Studio2010.
我已经使用sql server 2008创建了一个数据库.我需要将此数据库与Visual Studio 2010相连接才能在ASP，NET和C#中开发网站.

谁能帮助我通过服务器资源管理器将sql Server 2008数据库连接到Visual Studio2010.

我试过了..
但是我坚持登录到服务器..

我需要使用sql server身份验证登录...
我输入的用户名是sa
密码是dbace..

错误是用户sa登录失败

在此先感谢....

hai all

how to connect sql server 2008 database to visual studio 2010 through server explorer.
I had created a database with sql server 2008. i need to connect this with visual studio 2010 for developing a website in asp,net and C#

can any one help me for connecting sql server 2008 database to visual studio 2010 through server explorer.

i tried it ..
but i stuck with the log on to the server..

i need to log on with sql server authentication...
username i inputed is sa
and password is dbace..

the error is login failed for user sa

thanks in advance....

推荐答案

要做的第一件事是在Visual Studio 2010服务器窗口中添加数据连接.右键单击数据连接"，然后单击添加新连接":



在添加连接"对话框中输入所需的连接信息，然后单击测试连接"以测试连接.如果成功，请单击确定":



添加数据连接后，您将能够在数据连接"树中看到该连接:

试试这个..


谢谢.

The first thing you want to do is add a data connection in the Visual Studio 2010 Servers windows. Right click on "Data Connections" and click on "Add New Connection":



Enter the required connection info in the "Add Connection" dialog and click "Test Connection" to test the connection. If that succeeds, click OK:



After you add the data connection you will be able to see the connection in the Data Connections tree:

Try this..


Thanks.

这篇关于如何通过服务器资源管理器将SQL Server 2008数据库连接到Visual Studio 2010的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！