Why it would show errors when I used ASP to connected to SQL2005.

[Benny Ng]

The error is shown by the following connection string.£¨But it can be runs
properly in SQL2000£©

PROVIDER=MSDATASHAPE;DRIVER={SQL
SERVER};SERVER=ibmdept;DATABASE=CY_20060208;UID=sa;PWD=111111;

The following is the error message:
<<<<<<<<<<<<<
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
The user is not associated with a trusted SQL Server connection.

/cyfactory/Conn/Conn.asp, line 13
<<<<<<<<<

Now the configuration is win2003 + sql2005. In before that can be runs
smoothly with win2003 + sql2000.
But now the server is upgraded to SQL 2005. But the error shown.

Anyone can give me suggestion about this?

Urgently!

Many Thanks!

Benny Ng

 

[Bruce Barker]

the sqlserver ibmdept is probably not configured for standard security (so
sa is not a valid login).

-- bruce (sqlwork.com)