使用sql server远程连接到数据库 [英] Connect to database using sql server remotely

问题描述

我已经使用c＃语言完成了使用sql server和visual studio的程序。
我想将数据库放在pc上，并将程序连接到其他PC上的数据库

我在App.config中使用这个连接字符串：

 < connectionStrings> 
< add name =MWEConnectionStringconnectionString =integrated security = yes; initial catalog = MWDB; data source = .\sqlexpress/> 
< / connectionStrings> 
  

我应该通过pc外部ip地址更改服务器名称吗？
和根据sql server应该使用windows身份验证还是什么？
我不知道该怎么做。

解决方案

您应该使用Sql访问服务器的地址服务器身份验证。

您的连接字符串应如下所示：

  connectionString =Data Source = 192.168.0.5\SQL2008R2;初始目录= MWDB; Persist安全信息= True;用户ID =用户;密码=密码
  

（这只是一个例子，您的设置可能不同。）

  connectionString =Data Source = NAMEOFCOMPUTER\SQL2008R2; Initial Catalog = MWDB; Persist Security Info = True; User ID = user; Password = password 
 
  $ b         p>您可以从Visual Studio为应用程序生成连接字符串。从数据库浏览器 - >连接到数据库 
 
I have finished a program using sql server and visual studio using c# language .
I want to put the database on pc and the program that connected to that database on other PCs

I'm using this connection string in App.config :
<connectionStrings>
<add name="MWEConnectionString" connectionString ="integrated security=yes;initial catalog=MWDB;data source=.\sqlexpress"/>
</connectionStrings>
Should I change server name by pc external ip address?
and according to sql server Should I use windows authentication or what?
I don't know how to do it.
解决方案
You should access the server by it's address by using Sql Server authentication.

Your connection string should look something like this:
connectionString="Data Source=192.168.0.5\SQL2008R2;Initial Catalog=MWDB;Persist Security Info=True;User ID=user;Password=password"
(this is just an example, your settings will probably be different).

Another example:
connectionString="Data Source=NAMEOFCOMPUTER\SQL2008R2;Initial Catalog=MWDB;Persist Security Info=True;User ID=user;Password=password"
for accessing the server by name.

You can generate a connection string for your application from Visual Studio. From Database Explorer -> Connect to Database

                        
这篇关于使用sql server远程连接到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！