SBS SQL Databases No Longer Connecting
Posted on 2012-08-20
The SBS 2008 databases, including SBSMONITORING, MICROSOFT###SSEE and SUS databases are no longer connecting. One of the errors I receive is "The configuration of the AdminConnection\TCP protocol in the SQL instance MICROSOFT##SSEE is not valid." This started when I had to move the data from one physical drive to another. I shut down all database services, copied the data to the new location, removed the logical drive letter from the old path and added it to the new path (hoping this would just work). Unfortunately, these databases and their respective sites no longer are connecting. I cannot open the companyweb, nor is Update Services operational. Is there some type of configuration in SQL or the registry that uses Arc paths to the physical drive? Again, the new path has the exact same logical drive path as the original location (in this case J:\Windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\DATA). IIS no longer shows the instances of the sites. I cannot open the properties for these databases in SQL Server Management Studio Express and they don't even appear in SQL Server Configuration Manager.