SQL Server Performance Forum – Threads Archive

How to Use Public Ip for SQL SERVER 2005

Hi All I having a problem when i give a public IP to my SQL SERVER 2005. When i give server name = local or computer name it works. If i give Public IP, access is not granted in fact nothing happens i think the problems start with connection strings in web.config. Silicon Master

Hi, Just stupid question, Are you using your home broadband or office LAN connections? Waqar.
________________________________________________
~* Opinions are like a$$holes, everyone got one. *~

Dear Wagar The question sound stupid but is not so.. Actualy there were some configuration setting done in web.config. Thats why it wasn’t woking live.. Silicon Master

quote:
Just stupid question,

Dear Wagar There are no questions called stupid. All he needs a help. It will be better if you can help him
—————————————-

I think he was refrring to his own question, not silicon_master’s <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ />

Waqar, please adhere to the forum policies and do not reply using such words…it hurts.[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] SM, Are you using SQL cluster or DHCP is enabled, by any chance? <blockquote id="quote">quote:<hr height="1" noshade id="quote">Assign only one IP address for each network and one network for each network adapter. SQL Server requires that each IP address that is assigned to it have its own unique subnet mask. SQL Server does not support multiple IP addresses on the same subnet because this may result in duplicated names on the network. For example, if you have a public network and a private network and you want to assign an additional IP address to your SQL Server virtual server, you must add another network adapter to each node to create a new network. You can then assign the additional IP address to the new network.<hr height="1" noshade id="quote"></blockquote id="quote"> .. this applies to non-cluster environment too in case if you want to use different IP addresses. <hr noshade size="1">Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing.</center>

Guys i am sorry, but i was saying the question i asked is stupid not silicon_master’s question. I applogizs if you guys read it in the sense that i criticise silicon_master question [<img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ />]. –EDIT– When i read Silicon_master reply The question sound stupid but is not so.. i think he understand that the question i asked is not stupid. I think my reply is misunderstood. –EDIT– ________________________________________________ ~* Opinions are like a$$holes, everyone got one. *~

oh!! sorry for the mistake —————————————-

quote:Originally posted by silicon_master Hi All I having a problem when i give a public IP to my SQL SERVER 2005. When i give server name = local or computer name it works. If i give Public IP, access is not granted in fact nothing happens i think the problems start with connection strings in web.config. Silicon Master

Is it access denied ! – check for any firewall setting,
or are you trying to access sql server public/over internet ?!
what errors are thier in ERROR LOG and Event Viewer ? Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
————————
http://hemantgirisgoswami.blogspot.com

Hi Silicon, My question was, 1- If you are using office LAN network then you cannot assign public IP address to your computer you need to ask you LAN administrator to perform NAT to resolve public IP to your internal IP. 2- If you are using personal firewall you need to check if your firewall allow to access SQL port. 3- If you are using SQL server at your home then you need to verify if you ISP allow you to use requested port.
"Hope i have clarify my previous misunderstood reply". Waqar. ________________________________________________
Be great in act, as you have been in thought.

]]>