I am having a problem getting authenticated so that I can manage my databases in the Microsoft SQL Server manager. A while back (< 3 months)we had to setup a new password policy and change everyone's passwords and since then we haven't been able to access the account. We've tried taking the policy back and changing the administrator password back to what it was, but to no avail. To get the programs working temporarily I was able to changed the login setting of the SQL services in microsoft management console so they would run and that side is working fine. The databases are functioning correctly and everything is peachy there. The issue is, I need to login so that I can backup the database and I can authenticate. When the login screen pops up for the SQL Server Manager the authentication is set to SQL Server Authentication. SA is the username and the password is saved, we're not sure what it is. I can't find that account in active directory. I've also tried swtiching to Windows authentication, but that also fails. Here's the error message I recieve:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server, Error: -2146893019)
The System running the database is a Dell PoweEdge T110
Intel Xeon X3430 @2.4 GHz 2.39 GHz
4 GB of RAM
587 GB of free space
Running Microsoft Server 2003 Standard R2 SP2
Please advise, SQL is not one of my strong suits.