September 12, 2012 at 1:44 am
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.
September 12, 2012 at 2:50 am
SQL Browser service started?
Firewall blocking the dynamic port of the named instance?
September 12, 2012 at 3:02 am
sqlserver services started
how to release named instance firewall block? what are all the ports should be open?
September 12, 2012 at 3:23 am
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.
September 12, 2012 at 3:39 am
Hi thank u for ur reply
How to open the port in sqlconfig manager ? which port i should open working condition in named instance?
September 13, 2012 at 4:08 am
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
all the best............
Thanks,..
kranthi
SQL server DBA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply