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