SQL Server Performance

How to Use Public Ip for SQL SERVER 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by silicon_master, Aug 18, 2006.

  1. silicon_master New Member

    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
  2. waqar Member

    Hi,

    Just stupid question,

    Are you using your home broadband or office LAN connections?

    Waqar.


    ________________________________________________
    ~* Opinions are like a$$holes, everyone got one. *~
  3. silicon_master New Member

    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
  4. dineshasanka Moderator

    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


    ----------------------------------------

  5. Chappy New Member

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

    <br />Waqar, please adhere to the forum policies and do not reply using such words...it hurts.[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />SM,<br />Are you using SQL cluster or DHCP is enabled, by any chance?<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" 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"></font id="quote"></blockquote id="quote"> .. this applies to non-cluster environment too in case if you want to use different IP addresses.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  7. waqar Member

    Guys i am sorry, but i was saying the question i asked is stupid not silicon_master's question. <br /><br />I applogizs if you guys read it in the sense that i criticise silicon_master question [<img src='/community/emoticons/emotion-6.gif' alt=':(' />].<br /><br />--EDIT--<br />When i read Silicon_master reply<br /><br /><font size="1"><font color="blue">The question sound stupid but is not so..</font id="blue"></font id="size1"><br />i think he understand that the question i asked is not stupid.<br /><br />I think my reply is misunderstood.<br />--EDIT--<br />________________________________________________<br />~* Opinions are like a$$holes, everyone got one. *~
  8. dineshasanka Moderator

    oh!! sorry for the mistake

    ----------------------------------------

  9. ghemant Moderator

    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
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
    ------------------------
    http://hemantgirisgoswami.blogspot.com
  10. waqar Member

    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.

Share This Page