Wednesday, March 7, 2012

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>"
Response.Write"</TR>"
RS.MoveNext
Wend
%>

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!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.

No comments:

Post a Comment