Slator
asked on
How to Determine what SQL Databases are Installed & Running?
How can I determine (for sure) all of the SQL databases (especially MSDE & SQL Express) installed/running on an SBS Premium machine?
I can only see one instance of a database running: Microsoft SQL Server Workgroup Edition (9.0.4053 SP3) - which is part of SBS Premium. I have looked around (services, programs, tools, etc.) but only see one instance.
The reason for my question is that (based on a SBS program's configuration), there should be an instance of MSDE installed/running.
I can only see one instance of a database running: Microsoft SQL Server Workgroup Edition (9.0.4053 SP3) - which is part of SBS Premium. I have looked around (services, programs, tools, etc.) but only see one instance.
The reason for my question is that (based on a SBS program's configuration), there should be an instance of MSDE installed/running.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK, I think I got it...
My problem (or confusion) was that the SQL management/configuration consoles were showing different SQL version numbers which led me to believe that I had more than one instance of SQL installed/running - in addition to the MSDE version for ISA Server 2004.
I finally realized all the SQL version numbers were referencing the same {root path} and {instance ID}. I have no idea why Microsoft would report:
--Version {9.3.4035} in the SQL Server Configuration Manager
--Version {9.0.4053} in the SQL Server Management Express Console
--Version {9.0.4053} in the Vale Software MSDE Manager Console
In any case, it appears I have 1 instance of {SQL Server 2005 - Workgroup} and 1 instance of MSDE running for ISA Server 2004.
Thanks for the help!
My problem (or confusion) was that the SQL management/configuration consoles were showing different SQL version numbers which led me to believe that I had more than one instance of SQL installed/running - in addition to the MSDE version for ISA Server 2004.
I finally realized all the SQL version numbers were referencing the same {root path} and {instance ID}. I have no idea why Microsoft would report:
--Version {9.3.4035} in the SQL Server Configuration Manager
--Version {9.0.4053} in the SQL Server Management Express Console
--Version {9.0.4053} in the Vale Software MSDE Manager Console
In any case, it appears I have 1 instance of {SQL Server 2005 - Workgroup} and 1 instance of MSDE running for ISA Server 2004.
Thanks for the help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Your responses were helpful but not exactly what I was looking for - probably my fault in how I asked the question.
My issue/problem is that I suspect there is an instance of (MSDE or Express) SQL running that is not visible via any of the (usual) management consoles.
I want to know how to find ALL instances (and verions) of SQL installed/running even if the instance is (hidden) or (MSDE/Express) or (dedicated) to a specific program such as ISA Server.
If I understand the responses, the SQL commands would only help if I was already connected to the SQL instance/database.