Hi there. Im new to asp programming. And I am doing a research project for my school.
I'm create a website with MS SQL SERVER 2005 with ASP. But the problem is the right connection. I have searched the web almost 2 weeks but nothing happened.
Here's what my code for the connection
<%
<%
dim con, Rs
set con=server.CreateObject("adodb.connection")
con.Open "Provider=sqloledb;SERVER=localhost;DATABASE=SMS;UID=sa;PWD=;"
set Rs=server.CreateObject("adodb.recordset")
%>
and here's the error message
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa '. The user is not associated with a trusted SQL Server connection.
/SEARCH MANAGEMENT SYTEM WEBSITE/sample.asp, line 4
Please help me with my problem. And can you teach me how to connect using Windows Authentication in MS SQL?
Response is highly appreciated. Thanks guys.