Post reply

SQL Server 2008 Conectivity Problem Through IP Address

  • June 7, 2010 at 2:31 am

    #233457

    Hi All

    Recently My Sys Admin installed the SQL 2008 Developer Editition .Using my System name & instance ,i can able to connect to my sql server (i.e, : computername\instancename) .But I cant able to connect using IP addres (192.168.1.10\instance). It is thowing an error using IP address .please can any body help me to reslove this problem.

    Opertaion System . Windows 7

    SQL : SQL Server Developer Edition

    Thanks,

    Deepak.A

  • June 7, 2010 at 3:44 am

    #1176978

    U might look into DNS

  • June 7, 2010 at 4:14 am

    #1176988

    Thanks Ratheesh for u r Quick Reply . Can u please explain more on this

    Thanks

    Deepak.A

  • June 7, 2010 at 8:03 am

    #1177088

    did someone enable tcp/ip access for your instance ?

    If not, this should be done (using sqlserver configuration manager followed by a stop/re-start of your sqlserver instance)

    Keep in mind : many things are "off by default" !!

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • June 7, 2010 at 8:08 am

    #1177090

    If it's the first instance try 192.168.1.10,1433 instead of 192.168.1.10\instance.

    Using the port rather than the instance name often works.

    Tim

    .

  • June 7, 2010 at 10:34 pm

    #1177297

    hi Thanks for the reply guys.

    Thanks ALZDBA Yes you are rite it is worked for me i enabled tcp/ip it is disabled by default.

    I have one doubt can u please hel me to unsdersatnd about this,

    in

    SQL Server Network Configuartion

    -- > Protocols for SQL 2008

    In TCP/IP Properties i have two tabs one is protocol and other is Ip Address Tab

    (Protocol | Ip Address) in protcol Tab i enabled TCP/IP properties, & Ip Address Tab

    i have the lists Like below

    IP1

    IP2 -- Ip Addr

    IP3

    IP4

    IP5

    IP6

    IP7

    IP ALL

    in Ip2 it showing some other ip number What it is actually.

    whatis the above lists .Is that Protocal versions and in IP2

    Why it showing some other ip number

    Thanks,

    Deepak.A

  • June 8, 2010 at 12:28 am

    #1177322

    Probably you're using DHCP addresses on your client.

    The IPadress registered is the one it had at install time.

    It's the port number that is unique for your machine, so that's the most important.

    More info on this subject can be found in BOL and technet.

    e.g. http://technet.microsoft.com/en-us/library/ms189083.aspx

    also have a look at how or what service broker is all about: http://msdn.microsoft.com/en-us/library/ms181087.aspx

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • June 8, 2010 at 12:51 am

    #1177325

    Thanks a lot ALZDBA for your reply

  • June 8, 2010 at 1:44 am

    #1177339

    thanks to who help the topic

    new york city pass - new york pass - seo expert

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply