如何使用c#远程访问sql server? [英] how to access sql server remotely using c#?
问题描述
我用数据库创建了一个软件? i have created a software with database? 这篇关于如何使用c#远程访问sql server?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
在我办公室有10个人和我一起工作?
所以我创建了软件内部用途
sql位于我的电脑上。
我将软件安装到另一台电脑后,它能够访问我的电脑sql数据库吗?
我该怎么做?
< pre lang =cs> string connetionString = null ;
// string sql = null;
string name = ;
string pass = ;
connetionString = 数据源= 172.21.1.91;初始目录= EnqInfo;网络库= DBMSSOCN;集成安全性= SSPI;
使用(SqlConnection con = new SqlConnection(connetionString) )
{
//
// 打开SqlConnection。
//
con.Open();
//
// 以下代码使用基于SqlConnection的SqlCommand。
// < span class =code-comment>
使用(SqlCommand command = new SqlCommand( SELECT * FROM Login WHERE U_Name = @ Usr,con))
{
command.Parameters.AddWithValue( @ Usr,UName。文本);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
name = reader.GetString( 1 跨度>); // 名称字符串
pass = reader.GetString( 2 跨度>); // 密码字符串
}
if (name == UName.Text&& pass == PWord.Text)
{
ClassEnq.Uname = UName.Text;
MessageBox.Show( 密码已接受);
this .Close();
setEnableToolStripMenuItem( true );
setEnableToolStripMenuItem1( true );
setDisableToolStripMenuItem( false );
}
else
{
MessageBox.Show( 密码不正确,请重新输入密码);
setEnableToolStripMenuItem( false );
setEnableToolStripMenuItem1( false );
}
}
i给了我的ip数据源?< br $>
i配置了防火墙设置。
使用sql sever配置管理器启用tcp / ip。
i尝试了很多方法
我正在使用sql server 2008 r2
什么可以我这样做,请帮我解决这个问题?您是否尝试过连接sql management studio?可能是sql服务被停止,错误的ip或其他细节。
我假设你没有授予你的用户权限。
请看看这个:
http://www.quackit.com/sql_server/sql_server_2014/tutorial /sql_server_user_logins.cfm [ ^ ]
它与SQL Server 2014有关,但SQL Server 2008 R2的配置非常相似。
at my office there are 10 people work with me?
so i created that software to internal purpose
sql located in my pc.
after i installed software to another pc, it will be able to access my pc sql database?
how can i do that?
string connetionString = null;
//string sql = null;
string name = "";
string pass = "";
connetionString = "Data Source=172.21.1.91;Initial Catalog=EnqInfo;Network Library=DBMSSOCN;Integrated Security=SSPI";
using (SqlConnection con = new SqlConnection(connetionString))
{
//
// Open the SqlConnection.
//
con.Open();
//
// The following code uses an SqlCommand based on the SqlConnection.
//
using (SqlCommand command = new SqlCommand("SELECT * FROM Login WHERE U_Name=@Usr", con))
{
command.Parameters.AddWithValue("@Usr", UName.Text);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
name = reader.GetString(1); // Name string
pass = reader.GetString(2); // Password string
}
if (name == UName.Text && pass == PWord.Text)
{
ClassEnq.Uname = UName.Text;
MessageBox.Show("Password Accepted");
this.Close();
setEnableToolStripMenuItem(true);
setEnableToolStripMenuItem1(true);
setDisableToolStripMenuItem(false);
}
else
{
MessageBox.Show("Password Incorrect, Please Re-Enter Your Password");
setEnableToolStripMenuItem(false);
setEnableToolStripMenuItem1(false);
}
}
i have given my ip for data source?
i have configured firewall settings.
enabled tcp/ip using sql sever configure manager.
i have tried many ways
i'm using sql server 2008 r2
what can i do for this, please help me to solve this?Have you tried to connect with sql management studio? may be sql service is stopped, wrong ip, or another detail.
I assume you did not grant permissions to your users.
Please have a look at this:
http://www.quackit.com/sql_server/sql_server_2014/tutorial/sql_server_user_logins.cfm[^]
It is about SQL Server 2014, but the configuration of SQL Server 2008 R2 is very similar.