[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 855
  • Last Modified:

SBS SQL Databases No Longer Connecting

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.
0
GISCOOBY
Asked:
GISCOOBY
  • 9
  • 9
1 Solution
 
Justin SmithSr. System EngineerCommented:
What exactly do you mean by " removed the logical drive letter from the old path and added it to the new path (hoping this would just work)." ??


Did you dismount and re-mount all your databases, from the new location?
0
 
GISCOOBYAuthor Commented:
I went into Disk Manager, removed the logical path (J:) from the old HD and added that path to the new HD. As you can tell, I'm not a DB Admin. I dismounted the WSUS db, but didn't for the other sites (because I don't know how). I think I have the WSUS db back online, so now it is just Sharepoint sites that are messed up.
0
 
Justin SmithSr. System EngineerCommented:
Wow.  Was SQL installed to J as well?  I'm guessing so, which is why none of the services started.  I suggest you switch everything back, if possible.

You said you have WSUS running now.  So are the SQL services now starting?
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
GISCOOBYAuthor Commented:
ACH1LLES: I can't move it back because the original physical drive is gone. My OS partition on that drive ran out of space, and the J: drive didn't have enough free space to float to the OS, so I had to remove the J: partition and move it's data to another drive. It was in a critical state, so I didn't get to put a lot of preparation behind the process.

It does appear that the SQL services are starting, but even after an IIS Reset, the companyweb isn't back online. Which service do I need to restart to allow companyweb to be published? Thank you for all of your help.
0
 
Justin SmithSr. System EngineerCommented:
If they are now running, you need to open SQL Manager and connect to the ##SSEE instance.  You then need to mount your databases from the correct location.

If you don't know how to connect to the ##SSEE instance, use this connection:

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
0
 
GISCOOBYAuthor Commented:
I have it reconnected and all the databases remounted, but I still can't get companyweb back online. Is there something else I'm missing?
0
 
Justin SmithSr. System EngineerCommented:
IIS is started?  Is the app pools for SharePoint started in IIS?
0
 
GISCOOBYAuthor Commented:
IIS is started, and it appears the app pools for SharePoint are also started in IIS.
0
 
Justin SmithSr. System EngineerCommented:
What is the exact error when you try to bring up Central Admin?  What about companyweb?
0
 
GISCOOBYAuthor Commented:
Central Admin: The website declined to show this webpage
companyweb: The webpage cannot be found
0
 
Justin SmithSr. System EngineerCommented:
What else was on the drive that you dropped?  Were the IIS virtual directories on there?  Or are you 100% positive it only contained SQL stuff?
0
 
GISCOOBYAuthor Commented:
It contains program files for backup software (which is working properly), Exchange server transport roles (which is also working properly), SQL databases and WSUS data/databases (which appears to be working properly).
0
 
GISCOOBYAuthor Commented:
I'll reboot the server tonight to ensure that all of the ducks are starting in the order as they are intended.
0
 
GISCOOBYAuthor Commented:
Unfortunately, that wasn't the fix it needed. Companyweb is still not operational.
0
 
Justin SmithSr. System EngineerCommented:
It's tough to know exactly what piece of the puzzle isn't working.  Unfortunately the mistake you made was pretty drastic.  

Do you have a "wss" folder in C:\inetpub\ ?
0
 
Justin SmithSr. System EngineerCommented:
By the way, if you need remote assistance, I'm available.
0
 
GISCOOBYAuthor Commented:
Yes, there is a WSS folder within the wwwroot directory of inetpub. One thing different I do notice from my backups is that there is a new folder with the wws\VirtualDirectories called 33229. Originally, I only had 4721, dated from the original install. This new directory is empty. Is there a way to determine if the site has bound itself to this empty directory?
0
 
Justin SmithSr. System EngineerCommented:
Look at the properties of the site(s) in IIS
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 9
  • 9
Tackle projects and never again get stuck behind a technical roadblock.
Join Now