April 10, 2008 at 3:51 pm
I installed a new SQL Server 2005 instance on a clustered server and can't connect to it. Its running fine, there is no firewall, all of the configuration settings look fine... I just can't figure out what is going on. I can't connect locally or remotely in Management Studio or anything else...
Please Help!!!
April 10, 2008 at 4:26 pm
as a clustered instance you should be connecting to SQL by its virtual name you specified when installing, not the machine name, could that be your problem?
---------------------------------------------------------------------
April 10, 2008 at 5:06 pm
I've tried machinename\instancename and machinename\virtualinstancename and none of them work...
April 11, 2008 at 3:15 am
if it is a default instance you need only the virtualname, machine name not required at all. Local will not work either.
---------------------------------------------------------------------
April 11, 2008 at 8:21 am
Its a named instance. I can ping the virtual ip and the physical one as well locally and remotely...
April 11, 2008 at 8:55 am
this is posted under reportig services, is it reporting services you are trying to connect to?, does not sound like it. If it is not you would do well to repost this under SQL 20005 administation.
I do not have a set up where I can test this. machine name is not relevant in a cluster as it can change, so connect to instance name only.
---------------------------------------------------------------------
April 11, 2008 at 10:12 am
sorry I never realized I was in the Report Services forum.
I'll repost under Admin.
Thanks for your help.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply