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:
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 "<TD>" & RS.Fields("Restaurant_Id") & "</TD>"
I get this error message:
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?