Invalid connection. .Net SqlClient Data Provider

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

General SQL Server Forums

New to SQL Server Administration

Invalid connection. .Net SqlClient Data Provider

Author

Topic

philb101
Starting Member

3 Posts

Posted - 2010-07-13 : 11:25:22

A customer has been given access to a database to update their website by the web design people
The settings she has on a window are
Database Name: bobsmithretailDb
Server Name:bobsmith.com
Username:bobsmith
Password:******
She has a Test button to check the connection can be established
From her office she gets the message "Invalid connection. .Net SqlClient Data Provider" when pressing Test
The test completes successfully from her home
Initially I thought the Company firewall but from Home I can Test successfully from my Vista PC but not my XP Laptop
The customer has an XP office PC but Vista at home

Any ideas why Vista will connect but XP SP3 will not

I hope I'm in the correct forum for this poser, if not please advise

Thanks for all replies

rdjabarov
Starting Member

8 Posts

Posted - 2010-07-13 : 13:28:49

Ping the server from XP by name, then take the IP that got returned, and ping it with "-a" between "ping" and "xxx.xxx.xxx.xxx": ping -a 192.168.10.1
then see if the name gets resolved to the same server name you used in the first step. Of course all this is providing that ICMP packets are not blocked by the firewall on the server and on the client.

"The data in a record depends on the Key to the record, the Whole Key, and nothing but the Key, so help me Codd."

philb101
Starting Member

3 Posts

Posted - 2010-07-14 : 03:45:27

From XP at Home

ping domain name, replies from nnn.nnn.nnn.nnn ok

ping -a nnn.nnn.nnn.nnn replies ok but the domain name is not as above, its listed as above

rdjabarov
Starting Member

8 Posts

Posted - 2010-07-14 : 16:58:41

Ask your admin to check the A records in DNS.

"The data in a record depends on the Key to the record, the Whole Key, and nothing but the Key, so help me Codd."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources