Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Question Unanswered: Can SQL server 2000 Enterprise Edition run in Windows XP?

    Please help me here...I am a new user of sql server 2000 and a beginner in asp...We are making a web application and I have some problems with sql server 2000 in my windows XP.

    1. I'm not connected in a network.
    2. When I try to connect to sql server 2000 using this code:
    Dim CN
    Dim RS
    Set CN=Server.CreateObject("ADODB.Connection")
    CN.Open "Provider=SQLOLEDB.1;uid=sa;Initial Catalog=Planetchow;"
    Set RS = CN.Execute ("SELECT Restaurant_Id FROM RestaurantInfo")

    While Not RS.EOF
    Response.Write "<TR>"
    Response.Write "<TD>" & RS.Fields("Restaurant_Id") & "</TD>"

    I get this error message:

    "Error Type:
    Microsoft OLE DB Provider for SQL Server (0x80004005)
    Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection."

    3. How come? What configurations do I have to make to be able to avoid this...

    4. How do I connect to SQL server 2000 in ASP vbscript code?

    Please I really need some help here...thank you!

  2. #2
    Join Date
    May 2002
    Brisbane, Australia
    Go to enterprise manager and right click on the server and select properties then go to the tab that says security and make sure "SQL Server and Windows" is checked.

Posting Permissions

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