Reg: Not Connecting Named Instance through Public IP

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Reg: Not Connecting Named Instance through...

Reg: Not Connecting Named Instance through Public IP

Rate Topic

Display Mode

Topic Options

Author

Message

vs.satheesh

Posted Wednesday, September 12, 2012 1:44 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 4:19 AM
Points: 54, Visits: 306

Hi

In my production server i installed sqlserver 2005 in default instance and one more named instance also .In this server i am having public IP. My problem is outside through that server default instance connecting properly.But Named instance not connecting . please give me solution? Please give me a step by step solution..I am new in DBA side.

Post #1357822

anthony.green

Posted Wednesday, September 12, 2012 2:50 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

SQL Browser service started?
Firewall blocking the dynamic port of the named instance?

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1357840

vs.satheesh

Posted Wednesday, September 12, 2012 3:02 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 4:19 AM
Points: 54, Visits: 306

sqlserver services started

how to release named instance firewall block? what are all the ports should be open?

Post #1357844

anthony.green

Posted Wednesday, September 12, 2012 3:23 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833

you will need to check the port in the SQL config manager and then open the port, be aware that if you dont set it to a static port it will change when the service is restarted, so either set static port or disable firewall completly.

Post #1357857

vs.satheesh

Posted Wednesday, September 12, 2012 3:39 AM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 4:19 AM
Points: 54, Visits: 306

Hi thank u for ur reply

How to open the port in sqlconfig manager ? which port i should open working condition in named instance?

Post #1357861

Database admin(DBA)

Posted Thursday, September 13, 2012 4:08 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 06, 2013 3:36 AM
Points: 158, Visits: 562

Hey Hi,

you can do simply to open the SQL Server Configuration Manager.

Start -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager-->SQL Server Network configuration-->Named SQL server Instance-->then enabled TCP\IP and you can set 1433(sql server default port number) or 1434 or it depends what You want port number you can enabled...
You can go through below article

http://blogs.msdn.com/b/sqlblog/archive/2009/07/17/how-to-configure-sql-server-to-listen-on-different-ports-on-different-ip-addresses.aspx

all the best............

Thanks,..
kranthi

SQL server DBA

Post #1358449

« Prev Topic | Next Topic »

Permissions