其实关键的只有一点,服务器的IP地址为"."时做为判断条件,不再需要用户名和密码
string strConnection = "Server=" + RemoteServer + ";uid=" + SQLServerUserId + ";pwd=" + SQLServerUserPwd + ";database=" + RemoteDataBaseName+ ";MultipleActiveResultSets=True";
if (RemoteServer ==".")
strConnection = " Initial Catalog=" + RemoteDataBaseName + ";Data Source = .\\MSSQL; Integrated Security = true; MultipleActiveResultSets=True";