Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    1

    Unanswered: SQL 2000 database connection problem

    Hello,

    I have installed windows 2000 with service pack 4 and SQL 2000 server with service pack 2 on the same machine. Connection the sql server using windows authentication. Able to open SQL enterprise manager and query analyser using windows authentication. But if try to connect thru ASP page using the following connection string.


    set conn=server.createobject("ADODB.Connection")

    cs="Provider=SQLOLEDB;Persist security info=False; user id=sa; password=; Initial Catalog=TESTING;Data source=TEST;"

    conn.open cs

    The following error message is displayed.

    Microsoft OLEDB Provider for SQL Server (80004005) [DBNETLIB] Connection open(Connect()).] SQL Server does not exist or access denied.

    Do i have change any settings or change the connection string.

    Can any one suggest me what to do?.

    Thanks in advance

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    You need to set up SQL Server 2K from Windows authentication to Both.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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