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_20060
208;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 Ngthe sqlserver ibmdept is probably not configured for standard security (so
sa is not a valid login).
-- bruce (sqlwork.com)
"Benny Ng" <benny_wufree@.hotmail.com> wrote in message
news:%23vEcZPALGHA.1424@.TK2MSFTNGP12.phx.gbl...
> 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_20060
208;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
>
Wednesday, March 28, 2012
Why it would show errors when I used ASP to connected to SQL2005.
Labels:
asp,
connected,
connection,
error,
errors,
following,
net,
runsproperly,
shown,
sql2000providermsdatashapedriver123sql,
sql2005,
string
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment