Post reply

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

  • July 14, 2005 at 7:37 pm

    #167883

    Good Day,

    I'm trying to create a ODBC connection from a windows web edition 2003 server to a windows SBS 2003 server with SQL I can ping the server by ip address but can not

    ping by computer name. I can see the server through the

    cliconfg utility.

    I get the following error when I try to create a odbc connection. See Below

    My current network configuration consits of the web edition server and the sbs server connected by a

    netopia dsl router/modem with the sbs machine connected

    on the external network card.

    Could anyone help with getting a odbc connection between the 2 machines?

    Any help would be greatly appreciated.

    Don Anderson

    http://www.loon-a-ticks.com

    anderson@infotrails.com

    error message

  • July 14, 2005 at 9:18 pm

    #574659

    Images don't get displayed in the forums. You'll have to post the text version of the error.

     

    --------------------
    Colt 45 - the original point and click interface

  • July 15, 2005 at 5:03 am

    #574721

    Error reads:

     

    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.

    The above error is the text in the image I sent.

    Any one have any ideas how I can get this ODBC connetion

    established between the 2 servers?

    Thanks again

    Don Anderson

     

  • July 15, 2005 at 6:48 am

    #574768

    From the error it seems your trying to connect to the SQL Server using TCP.

    On the server you're trying to connect to, run the Server Network Utility and make sure TCP/IP protocol is enabled. Also check you don't have any firewall/port blocking that is prevent SQL Server from communicating.

     

    --------------------
    Colt 45 - the original point and click interface

  • July 15, 2005 at 3:03 pm

    #575054

    I have check the server using the Server Network Utility

    and only TCP/IP is enabled. Also hide server is unchecked.

    I can ping the server infotrails.org

    and the ping comes back OK.

    I have no firewall currently running or port blocking and I still cannot

    create a ODBC connection to the server from the

    other server.

    Would anyone have any other Ideas as to what might

    be wrong with my setup?

    I have no idea what I need to change to get it working.

    Don Anderson

  • July 16, 2005 at 1:49 am

    #575094

    Are you trying to connect with an ODBC DSN, or using a connection string? What settings/string are you using?

    I have a niggling thought that the problem could be related to the server name 'INFOTRAIL-INK88'. It's not normal practice to have hyphens in the name.

     

    --------------------
    Colt 45 - the original point and click interface

  • July 16, 2005 at 7:14 am

    #575096

    Phil,

    I'm trying to create a system ODBC DSN connection from the web server to the SBS 2003 server with SQL.

    My network setup look like the following

                                                                      ----- Web Edition Server 2003

                                                                    /

    Internet --------- netopia dsl router modem  ---                                                                \

                                                                      ------SBS 2003 with SQL

                                                                                        |

                                                                                        |

                                                                                    Switch

                                                                                   /           \ 

                                                                              PC1            PC2
     

    I can create a ODBC connection from both of the PC's

    I'm not able to create a connection from the web editon server to the server with SQL

    The process I'm using is a follows:

    -start

    -administrative tools

    -Data Sources (ODBC)

    -system DSN

    -Add

    -SQL Server

    -Name = Test

    -Description = test Database

    -Server = INFOTRAIL

    -With sql authenication

    -user id = sa

    -Password =

    Next I get the error message above

    Would you have any ideas as to what might be wrong with my setup

    or what I need to do to get a ODBC Connection to work between the

    2 server?

    My network settings are below

    Thanks again for helping me

    Don Anderson

    http://www.theicepit.org

     

    web edition server

    Windows IP Configuration
     
       Host Name . . . . . . . . . . . . : infotrail
       Primary Dns Suffix  . . . . . . . :
       Node Type . . . . . . . . . . . . : Unknown
       IP Routing Enabled. . . . . . . . : No
       WINS Proxy Enabled. . . . . . . . : No
     
    Ethernet adapter Local Area Connection:
     
       Connection-specific DNS Suffix  . :
       Description . . . . . . . . . . . : Intel(R) PRO/1000 CT Network Connection
       Physical Address. . . . . . . . . : 00-11-D8-14
       DHCP Enabled. . . . . . . . . . . : No
       IP Address. . . . . . . . . . . . : 192.168.1.xxx
       Subnet Mask . . . . . . . . . . . : 255.255.255.0
       Default Gateway . . . . . . . . . : 192.168.1.xxx
       DNS Servers . . . . . . . . . . . : 151.xxx.1.8
                                                 206.13.xx.xx
     
     
     
    SBS Server 2003
    Windows IP Configuration
       Host Name . . . . . . . . . . . . : infotrail

       Primary Dns Suffix  . . . . . . . : Infotrails.local

       Node Type . . . . . . . . . . . . : Unknown

       IP Routing Enabled. . . . . . . . : Yes

       WINS Proxy Enabled. . . . . . . . : Yes

       DNS Suffix Search List. . . . . . : Infotrails.local

    Ethernet adapter Server Local Area Connection:
       Connection-specific DNS Suffix  . :

       Description . . . . . . . . . . . : Realtek RTL8169 Gigabit Ethernet Adapter

       Physical Address. . . . . . . . . : 00-08-54-D1

       DHCP Enabled. . . . . . . . . . . : No

       IP Address. . . . . . . . . . . . : 192.168.16.xxx

       Subnet Mask . . . . . . . . . . . : 255.255.255.0

       Default Gateway . . . . . . . . . :

       DNS Servers . . . . . . . . . . . : 192.168.xx.2

       Primary WINS Server . . . . . . . : 192.168.xx.2

    Ethernet adapter Network Connection:
       Connection-specific DNS Suffix  . :

       Description . . . . . . . . . . . : Intel(R) PRO/1000 CT Network Connection

       Physical Address. . . . . . . . . : 00-0C-6E-FC

       DHCP Enabled. . . . . . . . . . . : No

       IP Address. . . . . . . . . . . . : 192.168.1.xxx

       Subnet Mask . . . . . . . . . . . : 255.255.255.0

       Default Gateway . . . . . . . . . : 192.168.1.xxx

       DNS Servers . . . . . . . . . . . : 192.168.xx.xx

       Primary WINS Server . . . . . . . : 192.168.xx.xx

       NetBIOS over Tcpip. . . . . . . . : Disabled

  • July 19, 2005 at 7:38 am

    #575476

    Could someone take another look at my setup

    and see if they can figure out what I have

    done wrong. Still trying to get my 2 server to

    allow me to make a ODBC connection to my

    SBS 2003 SQL server.

     

    Thanks for any help you can provide.

    Don Anderson

  • July 19, 2005 at 7:59 am

    #575486

    Sorry, got side tracked and forgot this.

    Can you connect if you use the IP address of the server?

     

    --------------------
    Colt 45 - the original point and click interface

  • July 19, 2005 at 7:06 pm

    #575693

    Hi Phil,

    Thanks for the reply.

    No, I have not been able to make a ODBC connection

    using the ip address of the server. I have used both

    the ip that is being forwarded by the router which

    is 192.xxx.1.10 and the internet address to the

    server which is 68.251.xxx.10.

    When I created the connection I tried using

    sql authentication with

    user = sa

    password = ??????

    server = 192.xxx1.10    and I tried 68.251.xxx.10

    The sbs 2003 server name with SQL on it is   

    My web server is located on the external part of the network

    From this location I can't make a connection.

    From a computer that is located on the internal server nic

    I can make a connection.  See network diagram above.

    Some how I need to find a way to get the server that is on the

    SBS external nic to see the server.

    Any other Ideas?

    Don

     

  • July 19, 2005 at 7:52 pm

    #575696

    Dug these up from the MS support site.

    http://support.microsoft.com/?scid=kb;en-us;138541&spid=2852&sid=332

    http://support.microsoft.com/?scid=kb;en-us;827422&spid=2852&sid=332

     

    --------------------
    Colt 45 - the original point and click interface

  • July 19, 2005 at 7:54 pm

    #575697

    You could also try using a UDL file and select the OLE/DB driver for SQL instead of the ODBC driver.

     

    --------------------
    Colt 45 - the original point and click interface

  • July 20, 2005 at 5:39 pm

    #575946

    Hi Phil,

    Any ideas as to why I am able to ping the server using the ip address of the server and why I can't ping the server using the server name?

    I think this is where my problem exists but I do not know how to fix it.

    The following works when trying to ping the sql server from my web server:

    ping 192.168.1.xxx    internal network ip address of sbs server with sql (inside router)

    ping 68.251.xxx.xxx  external ip address of the sbs server with sql (outside router)

    (both of these go to the same nic card)

    ping infotrails.org also works FQDN

    infotrail    is the server name

    infotrails           is the domain

    infotrails.org      is the web url

    Any ideas on the network configuration?

    Don

  • July 20, 2005 at 6:20 pm

    #575953

    As I mentioned in my earlier post, I have a sneaky suspicion that its the hyphen in the servername. Although I can't find anything that proves, or disproves that. On the web server, you should be able to run cliconfg.exe and configure an alias that should get around any naming problems. Personally I'd look at renaming the server and getting rid of the hypen.

     

    --------------------
    Colt 45 - the original point and click interface

  • July 21, 2005 at 11:33 am

    #576172

    Don, thanks for the detailed information.

    You say you can see the server from the cliconfg utility. This will only show what has been configured, not an actual server. Double check the alias you have defined and make sure it is pointing to 68.251.202.10.

    I assume when you say you can ping with the IP address that you mean from the web server. So you can use the IP address (68.251.202.10) in place of the server name (or alias) when specifying the server you want to connect to. (Forget about the server name having a hyphen. We have one of these and can create ODBC connections with no problem.)

    Assuming the above is OK, if your error message changes after entering this info when adding the system DSN, then we may have to tweak some parameters.

Viewing 15 posts - 1 through 15 (of 18 total)

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