I am having trouble creating System DSN for my server which has a static IP address (eg. 22.214.171.124). I am runnign SQL Server 2005.
I am creating native Client
Desc: My Database
Server:\\126.96.36.199\SQLEXPRESS (I think thats where the problem is)
When I do test the DB it gives me the follwoing error
Microsoft SQL Native Client Version 09.00.3042
Running connectivity tests...
[Microsoft][SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
Any idea whats causing this. Note my SQL Server and my web app and web services are running fine.