如何连接远程sql server

问题描述

我正在尝试从asp.net连接远程sql server2012



收到错误

 System.Data .SqlClient.SqlException：用户登录失败

我的连接字符串是

 <   add     name   =  libacpConnectionString    connectionstring   = 数据Source = 103.21.58.192; Initial Catalog = libacp; Persist Security Info = True; User ID = my id; Password = my passowrd >  
 providerName =System.Data.SqlClient/> 

代码在本地服务器上运行正常





请帮帮我



[edit]已添加代码块 - OriginalGriff [/ edit]

解决方案

I am trying to connect remote sql server2012 from asp.net

getting error

System.Data.SqlClient.SqlException: Login failed for user

my connection string is

<add name="libacpConnectionString" connectionstring="Data Source=103.21.58.192;Initial Catalog=libacp;Persist Security Info=True;User ID=my id ;Password=my passowrd">
      providerName="System.Data.SqlClient" />

code is working ok on local server


pls help me out

[edit]Code block added - OriginalGriff[/edit]

解决方案

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