June 3, 2009 at 12:54 pm
I have a windows 2008 cluster, with sql 2008 sql cluster installed. In addition to this sql cluster, I installed a stand-alone named instance. The intent is for this named instance to be our test environment.
The problem is that I cannot figure out how to connect to it remotely from my desktop using Mgmt Studio. When I'm Rdp'd, I can easily type in machinename\instancename without any problems. But that does not work from my desktop.
I've been doing some digging, but have not a concrete answer to my question. Any ideas and/or suggestions would be welcome. Thank you in advance.
June 8, 2009 at 1:41 pm
is there a firewall between you and the sql server? have you tried hardcoding the port on the server line to connect to ie. sqlserver\instance,port ? if hardcoding works then it could be that your browsers are not able to function properly because of firewall rules.
if you have a firewall then this blog post may help-it helped me quite a bit http://blogs.msdn.com/sql_protocols/archive/2006/02/27/unable-to-connect-to-a-sql-server-named-instance-on-a-cluster.aspx
db
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy