Connect MS-SQL2005 using public IP Address

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Connect MS-SQL2005 using public IP Address

Author

Topic

Anuj.sharma
Starting Member

1 Post

Posted - 2009-09-14 : 01:36:45

Hi,

I have a dot net windows application which can be download from the website. I want to use the database for the application by using public IP address. I am not able to connect SQL server 2005 from remote connection it is giving me the error, SQL server does not allow remote connection.

I changed my server remote connection configuration to

Local and remote connection

using both TCP/IP and named pipes

but still i am getting the error.

please help me

Thanks

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-09-14 : 03:03:04

Login to SSMS using windows authentications, right click on your server name, click properties, on left select CONNECTIONS, and on right select option for ALLOW REMOTE CONNECTION FOR THIS SERVER

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2009-09-14 : 03:05:39

DO NOT forget to restart services, after changes are made.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources