MS SQL / SMS 2.0 SP2 Connectivity Issue - TechRepublic
General discussion
November 10, 2000 at 01:58 AM
bbuechler

MS SQL / SMS 2.0 SP2 Connectivity Issue

by bbuechler . Updated 25 years, 8 months ago

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?

This discussion is locked

All Comments