Share
Report
22,647When the server crashed yesterday, all users were connnected.
We cleared the Activty table - blank
We restarted the Server - physically
We restarted SQL Services
When I first tried to connect to ODBC I got error that the login for SA failed. In SQL Server Express I was able to reset the password - and after changing it I was able to access the rest of the ODBC screens and it claims it is connecting correctly.
When I try to connect to GP - with SA - error message that
"There isn't a valid login record on the server for the login and password you entered. Contact Administrator or try again"
I am the Administrator and the ID I was using was the SA
When I look at SQL Table - Security - the user IDs are all there, the same as in the databases and same as in SY001400. I looked for missing login IDs using the script to compare against
master..syslogins and the only two missing are LESSON1 and LESSON2 - which we have not had in the system for 6 years or more.
If I could connect with SA then I could recreate the USER IDs, however even SA is not connecting.
*This post is locked for comments
All responses (
Answers (
