Connect to SQL 2008 R2 with ASP/VBScript
Posted on 2010-11-19
we have a classic ASP page where we want to connect to a sql 2008 R2 server.
The connection string so far to connect to sql 2005 was:
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = database; User Id = userABC; Password=abcd"
this worked perfectly. But now with sql2008 it doesn't work any more and throws the following error:
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'userABC'.
/web/db.asp, line 11
Thanks a lot