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

x
?
Solved

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

Posted on 2012-09-03
6
Medium Priority
?
476 Views
Last Modified: 2012-09-10
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?
0
Comment
Question by:rrincones
  • 3
  • 3
6 Comments
 
LVL 78

Accepted Solution

by:
Rob Williams earned 1500 total points
ID: 38361907
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
 

Author Comment

by:rrincones
ID: 38361919
i will try
0
 

Author Comment

by:rrincones
ID: 38362075
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
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.

 
LVL 78

Expert Comment

by:Rob Williams
ID: 38362086
Is it working now?

Sorry The recommendation I provided was for SBS 2008/2011, I should have asked.
0
 

Author Comment

by:rrincones
ID: 38362127
yes it is working now.
0
 
LVL 78

Expert Comment

by:Rob Williams
ID: 38362130
Great, glad to hear.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Screencast - Getting to Know the Pipeline
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question