I've been having a problem using Visual Studio to coect to a networked sql server with a networked user, a local administrator, and a domain administrator.
Here's the coection string in Visual Studio:
string coecitonstring = "Server=development;Database=testdb;User Id=TestUser;Password=TestPassword;";
co = new SqlCoection(coecitonstring);
1) Ruing Visual Studio as non-administrator and as an administrator, I get the following error.
{"A network-related or instance-specific error occurred while establishing a coection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote coections. (provider: Named Pipes Provider, error: 40 - Could not open a coection to SQL Server)"}
2) Without changing any code and ruing VS as a domain administrator I get a successful coection.
Compiling and ruing the application as a non-administrator has a successful coection.