Post reply

Need help creating odbc connection from ms web edition server to SBS 2003 SQL Server / NO ISA

  • July 21, 2005 at 12:56 pm

    #576210

    have you tried ?:

    ping infotrail-ink88.infotrails.org


    * Noel

  • July 21, 2005 at 8:12 pm

    #576290

    Hi Joan & Noel,

    I have verified the cliconfg utility settings and I have it pointing to 68.251.xxx.xx

    I have added the sql server to the web server's host file.

    After doing this I can ping the server using the server name.

    I'm now getting a new error:

    Connection Failed:

    SQLState: '01000'

    SQL Server Error: 10060

    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect(().

    Connection failed:

    SQLState: '08001'

    SQL Server Error: 17

    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server does not exist or access is denied.

     
     
    I was previously receiving the following error message:

    Connection Failed:

    SQLState: '01000'

    SQL Server Error: 11004

    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect(().

    Connection failed:

    SQLState: '08001'

    SQL Server Error: 6

    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

     
     
    Yes, when I ping the server it is from the web server to the sql server.

    Would you have any other ideas?

    I really appreciate you help.

    Thanks,

    Don Anderson

  • July 22, 2005 at 7:53 am

    #576409

    Try changing the node in the host file from 192.168.1.10 to 68.251.202.10. Then see if you can still ping. If you can, try the ODBC configuration again.

  • July 24, 2005 at 12:07 pm

    #576631

    Hi All,
     
    With all the responses, I have successfully created a ODBC connection from my web server to the SBS 2003 server with SQL installed on it.  A reply from http://www.smallbizserver.net  helped solved my problem.

    At first I thought I had no fire wall installed as I had not installed ISA server on my

    Small Business Server 2003. Port 1433 was not exposed to the out side network card.

    All I needed to do was

    run the configure Internet and e-mail connection wizard

    Enable the fire wall setting

    Add SQL port 1433 to the services to be accessed through the fire wall by Internet users

    By making this change, I can now create a ODBC connection from the web server that

    is on the SBS external network card.

    Not sure if what I did is a secure way of allowing the 2 servers talk to each other?

    The method does seem to work.

    Thanks again for everyone's help

    I can now start to convert my MS access database to a SQL server database.

    Thanks again,

    Don Anderson

    http://www.theicepit.org

Viewing 4 posts - 16 through 18 (of 18 total)

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