Information générale
Forum:
Microsoft SQL Server
>Hello all,
>I just installed the Service Pack 1 for Windows 2003 and when I try to connect to sql server through my foxpro application I get the following error.
>
>Connection failed:
>SQLState: '28000'
>SQL Server Error: 18452
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'.
>Reason : Not associated with a trusted SQL server
>
>
>Users connect to the server using Terminal Services and run the application
>on the server.
>
>Here is the connection string:
>
>ConnectString=DRIVER=SQL*SERVER;Trusted_Connection=YES;SERVER=216.199.156.93;DATABASE=dms
>Server_MAS=MAS_001.dbo
>Maintenance = "YES"
>
>
>
>Any help is greatly appreciated.
Reload the SQL trusted accounts's SID, probably the SP have changed they on the W2003 server.
Look for:
- sp_validatelogins
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement