Link to home
Start Free TrialLog in
Avatar of sp0tta
sp0ttaFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Testing SQL connectivity from a workstation

Hi
I know my way around a SBS (2011) but not SQL (2008 r2)
I only need to test connectivity from a workstation, someone else is going to come in and handle the configuration.
I've found this post http://microsoftplatform.blogspot.co.uk/2010/12/test-remote-sql-connection-very-quickly.html
which seems to do what I require. I run this on the server and I can see the databases fine.
I run it on the workstation and it only shows me the server name and if I hit the test connection I get
Test connection failed because of an error in initialization provider - Server does not exist or access denied.
I've opened ports 135, 1433, 1434, 2383 & 4022 & ran Cliconfg.exe on both server & workstation and moved TCP/IP to the top of the list.

Now it's time to hand this issue over to some experts before I break something!
Avatar of Daniel Wilson
Daniel Wilson
Flag of United States of America image

If it shows you the server name, there's a basic level of communication.  A closed port is not the problem.

Probably the server is denying remote TCP/IP connections.  That is, I think, the default setting in recent versions.
Avatar of sp0tta

ASKER

Hi
Allow remote connections to this server is ticked under Management Studio > Server properties > connections
Is there anywhere else I should also check?
OK, probably permissions.

By default, the server uses only Windows Authentication.  On the remote machine, are you logged on as the same user ON THE SAME DOMAIN as you are when trying it on the server?
Avatar of sp0tta

ASKER

yep.
ASKER CERTIFIED SOLUTION
Avatar of DBAduck - Ben Miller
DBAduck - Ben Miller
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial