Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  ASP.NET  SQL Connection Problem

Author  Topic  KP Starting Member 1 Post Posted - 2005-11-10 : 09:52:12 Have a connection problem with a C# application. Issue is that it works fine on the development box, works fine using a colleagues development machine, but refuses to connect to the SQL database in the live environment. Connection Strings involved are as follows: this.sql_con.ConnectionString = "server=tecnico_a;database=clienta;user id=sa;password=sa"; - works this.sql_con.ConnectionString = "server=tecnico_c;database=clienta;user id=sa;password=sa"; - works this.sql_con.ConnectionString = "server=live_client;database=clienta;user id=sa;password=sa"; - fails (I have changed only the client name for confidentiality - and the user ids and passwords of course) The databases have all been set up by the same person and are believed to be identical - what I am after is some advice on where I can look to see if there are any differences between the databases. Am open to any ideas - it is getting a bit embarrassing when the application works fine at base but not at the clients site..... Updated to pass on additional information. Error code received is 17 - SQL Server does not exist or access denied. But it exists and other applications can connect to it. Firewalls seem to tbe the main suspect, but how can that be if other applications can access it?