July 31, 2010 at 3:00 pm
I need to enable remote connections in my server for which i had tried enabling it in surface area configuration but for clustered server we have different procedures it seems..can any one help me on this?????
July 31, 2010 at 4:27 pm
Hi Premkuttan,
Whether a standalone instance or a clustered instance, in SQL Server 2005 remote connections are enabled \ disabled through the Surface Area Configuration tool, under the Surface Area Configuration for Services and Connections option.
July 31, 2010 at 4:37 pm
when i select surface area configuration for services and connections and click on remote connections it shows a msg like"you cannot configure surface area for clustered services by connecting to a computer name.connect to the virtual sever to configure clustered services"
July 31, 2010 at 8:11 pm
So if the full name of the clustered instance is MYSERVER\INST1, then the name that you have to feed the configuration tool is MYSERVER (in other words the name of the virtual server that you gave when you installed the cluster originally, minus the instance name).
With a clustered instance, you cannot connect the tool to the physical server name, only the virtual server name.
July 31, 2010 at 9:02 pm
Now i enabled the remote connections in my production server
but still it shows unable to establish a connection to SQL server
what are the other steps i need to consider to establish a remote connections?????
August 1, 2010 at 4:05 am
By default remote connections should be enabled anyway on everything except Developer Edition, so it is surprising that you needed to configure that.
That should be all you need to do to enable remote connections anyway, are you seeing any kind of an error message when you try to connect? Is there anything in the SQL Server logs to give us a clue?
August 1, 2010 at 4:42 am
Remote connections ?
- to linked servers ?
- for your applications ?
Did you enable TCP/IP for your instance ? Use Server configuration manager to enable tcp/ip.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply