This is more a SQL Server question then it is an SMS question.
SMS is trying to access it’s SQL server and cannot. This is due to the fact that (I believe) A) The ODBC DSN’s are not properly configured, and B) SMS and the DSN’s are not using the proper SQL user names.
Here’s the issue: I don’t remember what account and password we used for the SQL server. If I saw the user name, I probably would know the password for it (since I originally set it up). I believe we stuck with the standard of “SA” but I’m not sure.
Is there any way to at least see a list of the SQL Server users? Anything I can do besides reinstalling SQL?
If I have to reinstall SQL, will that harm SMS?