Connecting to a SQL Server database, newbie question

Discussion in 'Databases' started by rodmjay, Dec 14, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. rodmjay

    rodmjay

    I am having a hard time connecting to the SQL server from my computer. Here is what i have in client network utility.

    Tab 1 (General): Enabled Protocols By Order: TCP/IP (on top), Named Pipes -- Properties for TCP/IP: Default Port: 1433
    Tab 2 (Alias): Server Alias: RODMJAY, Network Library: TCP/IP, Connection Parameters: mssql07.discountasp.net

    (Note: I pinged the mssqlp7.discountasp.net to make sure that it was valid)

    I disabled my firewall, so that should not be blocking the port (that i know of, i dont know how to test this)

    Here is the error message that i get when i try to connect the RODMJAY server Ive setup via query analyzer

    'Unable to connect to server RODMJAY:

    Server: Msg 17, Level 16, State 1
    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Sql Server does not exist or access denied.'
     
    rodmjay, Dec 14, 2005
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    rodmjay,


    to test to see if the port is open, run the follwing commands:
    1. From the Start Menu, select: RUN
    2. Type in: cmd
    3. In the popup window, type: telnet mssql07.discountasp.net 1433
      if it fails, it will display - Connecting To mssql07.discountasp.net...Could not open connection to the host, on port 1433: Connect failed= port not open and try using 14330. if successful, a blank screen will appear= port is open
    4. You want to make sure that you are using the correct username and password for your SQL server which the sql login can be found in the control panel - and the sql link of the sql server version that you have purchased


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Dec 14, 2005
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page