SqlConnection myConnection = new SqlConnection("user id=NotRealID;" + "password=NotRealPassword;server=MYPCNAME\\TESTSQLSERVER;" + "Trusted_Connection=yes;" + "database=TestDB; " + "connection timeout=30");
And running the program on the same PC as the server, I can use myConnection.Open(); and a reader to retrieve data from my tables. When I run the program on a different computer I get an error saying the server is not found or inaccessible.
What do I change in the connection string to let me connect?
PS I followed the tutorials and set my server browser service to enabled named pipes as well as TCP/IP enabled and made sure the service was running.