Access sql server 2005 from internet

Discussion in 'SQL Server' started by manish.m.meshram, Sep 12, 2009.

  1. manish.m.meshram

    manish.m.meshram New Member

    Joined:
    Sep 12, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Hello

    I want Access sql server 2005 from internet.

    My website is running on internet And My
    Sql Server is on Local Machine.

    I Done port forwarding. I can Access Other Port,
    but Sql server Is Not Accessible.

    No firewall is on my Pc.


    when i try configure sql server 2005.
    SQL Server Browser to Configure SQL Server Express 2005 for Remote Access.
    In Sql server Browser Properties.
    Built in Account
    I select Network Service.
    When Apply These Changes
    Following Error Occure:
    "A member could not be added to a local group because the member has the wrong account type.[0*8007056c]"
    Thanks
    My email id=manish.m.meshram@gmail.com
     
  2. manish.m.meshram

    manish.m.meshram New Member

    Joined:
    Sep 12, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Internet------> Router in my network

    ------->LocalMachine(Windows 2003) -->Sqlserver2005

    How access sqlserver through internet via Router in local

    network.

    My router IP Address is =192.142.1.86; My local machine which is connected to the router Ip

    Address is= 192.142.1.81 At port No=1433

    tell how to connect to my sqlserver. Thanks for help in advance
     
  3. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    Moved under the Database forum
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice