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!
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!
Microsoft SQL Server 2008Microsoft SQL Server
Last Comment
DBAduck - Ben Miller
ASKER
Hi
Allow remote connections to this server is ticked under Management Studio > Server properties > connections
Is there anywhere else I should also check?
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?
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?
ASKER
yep.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Probably the server is denying remote TCP/IP connections. That is, I think, the default setting in recent versions.