Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2002
    Posts
    1

    Unanswered: Newbie help: SQL Server does not exist or access denied

    I have created a simple ASP page, but when I call it up, I receive the following error:

    SQL Server does not exist or access denied

    I am using SQL Server 2000 and Win2K. Any idea what may be causing this error?

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    What are you supplying for your connection string?

    1) SQL Server name
    2) Username
    3) Password
    4) Database

    If you use a trusted connection remember that the ASP page will connect to SQL Server as the user account that IIS is running under.

  3. #3
    Join Date
    Feb 2002
    Location
    New York, NY
    Posts
    14

    Question SQL Server does not exist or access denied - Why?

    Hi,

    I am getting the same error message:

    "SQL Server does not exist or access denied"

    when I attempt to register a SQL Server in SQL Server 2000.

    Any ideas?

    Thanks,

    Chris

  4. #4
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    'csf' can you ping the server from your workstation

    c:\> ping MyServer

    I have a feeling that you can not see the server by its user friendly name. Can you ping it by it's IP address.

    c:\ ping xxx.xxx.xxx.xxx

    If so, then use the Client Network Utility for SQL Server and define an Alias to this server. Set the network library to TCP/IP, set the server alias name to the server name and enter the IP address for the server name.

  5. #5
    Join Date
    Feb 2002
    Location
    New York, NY
    Posts
    14
    Thanks for the reply.

    I will try this when I get home this evening

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •