1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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,287
    Likes Received:
    364
    Trophy Points:
    83
    Moved under the Database forum
     

Share This Page