General information
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only