Hi guys,
I am a newbie in SQL 2005. Actually, I just want to get connect to SQL 2005 via ASP…. but it comes up the following error … ?
[COLOR=Red]Microsoft OLE DB Provider for ODBC Drivers error ‘80040e4d’
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘manfree’. The user is not associated with a trusted SQL Server connection
My Source Code is:
[COLOR=SeaGreen]set adocon = server.CreateObject(“ADODB.Connection”)
adocon.open “Driver={SQL Server};Server=10.0.0.254;Database=myDatabase;Uid=manfree;Pwd=manfree;”
I think I didn’t configure it well … (on permission settings and others …)
Is there any people who can give me a step by step configuration
Or URLs are also welcome ~~ ?
By the way, the Platform is windows 2003, IIS6, SQL 2005
Thanks ~