Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I installed Service Pack 1 for Windows 2003 and get an e
Message
From
24/07/2005 03:31:53
 
 
To
22/07/2005 11:00:40
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01035126
Message ID:
01035474
Views:
14
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform