I keep getting the following Error when trying to access the SQL db over a WAN, (though it does work on some computers):

Number:- 2147467259
Description: (DBNMPNTW) Specified SQL server not found.
Source: Microsoft OLE DB Provider for SQL Server.

My application is running as a separate exe on individual computers across the WAN, all connectiong to a SQL server computer. I found that by cahanging my connectionstring from this:

.ConnectionString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dbname;Data Source=servername"

to:

.ConnectionString = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=dbname;Data Source=server ip address"

I connected without any problems and the connection proved to be quicker. However today this doesn't seem to be the case.
Anyone


It Ends Here

__________________
It Ends Here