SharePoint Services Server error when connecting to company web "Cannot connect to database"

I had to move the content database for our sharepoint services server.  I followed the steps on microsoft document 843580.  Using the detach and atach commands.  I did not get any errors while performing the steps.  Now on our workstations, when we try to access the companyweb, we get the error "cannot conect to database".

I followed the steps exactly.  Am I missing something?  Is there an addittional step?
rrinconesAsked:
Who is Participating?
 
Rob WilliamsCommented:
I am afraid it is not much help at this point but this is SBS not server standard, the correct way to move Sharepoint on an SBS is to use the SBS console under Backup  and Server Storage | Server Storage | "Move Windows Sharepoint Services Data".  KB843580 doesn't mention SBS under "Applies to".   Always try to find SBS specific articles.

Sharepoint is intertwined with SBS, as are most other services, making using the wizards critical.  Is it possible to use your method to move it back and then run the wizard?
0
 
rrinconesAuthor Commented:
i will try
0
 
rrinconesAuthor Commented:
I found a document that refrenced sbs 2003, and except for some recommendations in naming the folders, it listed the exact same commands as the article I listed in my original post.  Where I went wrong on the article I refrenced above had, was the following section.

Step 11.  Attach the content database.

EXEC sp_attach_db @dbname = N'STS_spsrvlc_1', @filename1 = N'C:\new_datase_location\STS_ServerName_1.mdf', @filename2 = N'C:\new_database_location\STS_ServerName_1_log.ldf'

I failed to repalce 'STS_SPSRVLC_1' with the actual database name.
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Rob WilliamsCommented:
Is it working now?

Sorry The recommendation I provided was for SBS 2008/2011, I should have asked.
0
 
rrinconesAuthor Commented:
yes it is working now.
0
 
Rob WilliamsCommented:
Great, glad to hear.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.