在建立与服务器的连接时出错。在连接到 SQL Server 2005 时,在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: SQL 网络接口, error: 26 - 定位指定的服务器/实例时出错)
webconfig 配置:
<add key="elgsdirng" value="packet size=4096;user id=sa;data source=111.111.111.111\mydatabase;persist security info=True;initial catalog=elsdlfdg;password=sdfkjsdkfjkljsdflkjsdlfjk"/>
webconfig 配置:
<add key="elgsdirng" value="packet size=4096;user id=sa;data source=111.111.111.111\mydatabase;persist security info=True;initial catalog=elsdlfdg;password=sdfkjsdkfjkljsdflkjsdlfjk"/>
选中第三个,同时使用***
data source=111.111.111.111\mydatabase; 改成data source=111.111.111.111;
<add key="elgsdirng" value="data source=111.111.111.111,1433;initial catalog=elsdlfdg;user id=sa;password=sdfkjsdkfjkljsdflkjsdlfjk"/>