Remote connections

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Remote connections

Remote connections

Rate Topic

Display Mode

Topic Options

Author

Message

premkuttan

Posted Saturday, July 31, 2010 3:00 PM

Old Hand

Group: General Forum Members
Last Login: Monday, November 26, 2012 9:08 AM
Points: 310, Visits: 243

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?????

Post #961806

Andy Hogg

Posted Saturday, July 31, 2010 4:27 PM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, February 23, 2013 11:11 AM
Points: 488, Visits: 810

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.

Post #961810

premkuttan

Posted Saturday, July 31, 2010 4:37 PM

Old Hand

Group: General Forum Members
Last Login: Monday, November 26, 2012 9:08 AM
Points: 310, Visits: 243

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"

Post #961811

Andy Hogg

Posted Saturday, July 31, 2010 8:11 PM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, February 23, 2013 11:11 AM
Points: 488, Visits: 810

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.

Post #961838

premkuttan

Posted Saturday, July 31, 2010 9:02 PM

Old Hand

Group: General Forum Members
Last Login: Monday, November 26, 2012 9:08 AM
Points: 310, Visits: 243

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?????

Post #961844

Andy Hogg

Posted Sunday, August 01, 2010 4:05 AM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, February 23, 2013 11:11 AM
Points: 488, Visits: 810

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?

Post #961871

ALZDBA

Posted Sunday, August 01, 2010 4:42 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 6,862, Visits: 8,049

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

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #961874

« Prev Topic | Next Topic »

Permissions