.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Scaling Single Server Farm by adding a seperate Database server

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :SharePoint
Hi, Right now, I am having a sinle server farm SharePoint 2010 installation. Now I need to seperate out the SQL server from the same box and want to move it to the new SQL server. In short , I need to have a seperate SQL server in my current farm (which is single server farm installtion). Can some one point me to the steps for the same ? Thanks.

View Complete Post

More Related Resource Links

Adding an SP 2010 server to an existing farm. "Failed to connect to the configuration database." dur


I have an existing sp 2010 enterprise server hosting websites and central administration.  I have a seperate sql 2008 r2 server holding the databases.  My goal is to setup another sp 2010 enterprise server to provide redundancy for the websites and central admin.  I believe I am able to accomplish this by adding another web front end to the farm.  On the second server, I install sp 2010, run the config wizard and connect to the config database located on the sql server, however, I am interrupted at step 3 when I am notified of the following:

Failed to connect to the configuration database.
An exception of type System.InvalidOperationException was thrown.  Additional exception information: There was an error encrypting or decrypting credentials. Either a credential update is currently being performed, or you must update the farm account credentials on this server before you can perform this task.
System.InvalidOperationException: There was an error encrypting or decrypting credentials. Either a credential update is currently being performed, or you must update the farm account credentials on this server before you can perform this task.
   at Microsoft.SharePoint.Administration.SPEncryptedString.CheckCredentialLock()
   at Microsoft.SharePoint.Administration.SPManagedAccount.Deploy(SPApplicat

Profile Synchronization on a Single-Server Farm

Profile synchronization is documented to not work on a stand-alone SharePoint 2010 installation, but is it supposed to work on a single-server farm?  Profile import works fine in our single-server SharePoint 2007 farms.  The SharePoint administrator here is telling me that we need to add another server to our SharePoint 2010 single-server farm to get profile synch to work.  That does not make sense to me.  A farm should be able to run all the service applications on 1 server (which is the normal configuration in an evaluation environment).  Jeff B

Move Single MOSS Content Database to Different SQL Server

We want to mmove the single database of MOSS on Network Test and Development to the Production SQL Server. But MOSS aplication server remains same!

So in this condition it points out for the two database servers at the same time.

Is it possible? Or I need to migrate the all concern databases to the another SQL Server?

Pls HelP!

Adding server to a farm


Good day,

I want to add a new server to my existing MOSS 2007 farm. I've followed some of the articles on how to do it. Installed it as complete. When the wizard started I gave the remote server (Sql2005). Now curiously, it came back with 3 databases that seemed random. This is test environment so the db I chose was WSS_Content_Test, wich is what the current wss runs on. After picking that db the domain account was filed in the account field. The account is a domain account called xxxxSharePoint. I used this account to installed the whole thing, it is an administrator account that has also db admin rights including db create, db read, etc.

So when the wizard started I gave it the database, this domain account and password, selected the option not to install the central admin page. Then the wizard continued to perform 10 steps only to fail on the 2nd with a message of denied access. The logs on both  servers revealed that another domain account is trying to access the database and its credentials weren't adequate. I don't where this other acc

Seperate web server & database?


Hello all,

Currently, we have our ASP.NET applications running on windows server 2003.  All of our data resides on an IBM ISeries / AS400.  The 400 people are going to be creating massive new tables with millions of records.  Because of this, I've been asked to look into the idea of putting new ASP.NET pages on the IBM ISeries server.  This server uses APACHE.  I have read that to do this, I will need to use the Mod_Mono Apache module.

I would like to come up with a list of benefits and drawbacks to this new idea.  Initially, it seems like this is a bad idea for a few reasons:

  1. Security: if a users gets unauthorized access to our local server(s), they will only have access to either DB or web server, not both.
  2. Maintainability: Microsoft ASP.NET is easier to implement on a Microsoft Windows Server.
  3. Problem Solving: I will have to first determine if an issue is due to the ISeries server, or the Apache server, or the ASP.NET application.  This could be countered by saying that I would already have to determine if the issue is due to Windows server, or ASP.NET application.  However I have better experience with troubleshooting on a windows box that I am familiar with.
  4. Problem Creating: I could escentially create a problem that not only takes down the web server, but

Max files in a single WSS 3.0 Database (SBS 2008 Server - Window Internal DB)


This site appears to indicate that the max documents per database is 32,767 :


This seems extremely small to me. Is that an accurate number? We have a customer with 300,000 documents and about 30 users. Is this going to be too much for a single DB?

SQL Server 2000 Database in "single user mode"


Hi all,

I've an old production database server with SQL Server 2000 SP4, that runs from 6 years. Now sometimes I find that the production database goes in "single user mode". Why? My error logs don't help me.

having a seperate database server for our business applications


we have a number of applications sprawled over 4 x win2003 servers and wish to consolidate them onto one application server with another server performing backend database functions running predominantly SQL (with perhaps paradox and oracle too). So having 2 servers, 1 for apps and the other for the apps databases.

we were thinking of having both these servers running windows 2008 R2 and leveraging its Virtualisation function for the applications server, only.

would this be feasible to do with Win2008 R2 with our not having to purchase any other virtualisation software or anything?

would it be advantegeous for us to leverage virtualisation for our consolidated apps server?

would having the application backend databases operating on a seperate server be advantagous?

any advice appreciated

thank you

unable to set indexing services on single server farm



I have recently updated from WSS 3 to MOSS 2007. Now I am not able to create SSP because I am not able to enable indexers.

When I am going to Operations-->Services on Server I am not able to find Office sharepoint search. Also the custom is selected as serices you choose run on this server.

Any help will be appreciated.

Thanks & Regards,

Rahul Rashu 

Reconnecting existing configuration database to existing Single-server WSS 3.0 deployment


Hello, see below for my issue:

The problem:
  • Our company's WSS 3.0 sharepoint database recently became corrupted (still unsure what caused the corruption...). While the database was rebuilding we disconnected the farm. Now when we attempt to use the Sharepoint Products and Technologies Wizard to reconnect it asks for the Database Access Account for the configuration database. It is insisting that we use NT Authority\Network Service but if you do not supply a password (NT Authority\Network Service does not have a password) you cannot click next.

Steps we have tried:

  • We have also tried to use a local user that is under the db_owner server role and are still told to use NT Authority\Network Service.
  • We have also tried use psconfig.exe in the command line but get errors there as well when supplying no password.


Is there any way to reconnect to the farm?

Thank you for your help.

Is realtime SQL Server Replicated database usable realtime (not offline / single user mode)


Is SQL Server replicated (destination) database replicated by SQL Server Replication fully usable? Meaning it's not just for Disaster Recovery but is fully usable from various say BI / Reporting purposes.

In the essence it is exactly same as other replication engines and the destination database is very much usable and not just offline / single user mode.



How to Backup Single Server (Database on same server )Extra-net SharePoint Site MOSS 2007 SP1? and H



I have to create Test Server (Single server with Database on Same Server).

What Kind of Backup should i be asking  to Hosting Company,SharePoint MOSS 2007 SP1 Extra net site Hosted by 3rd Party.

How to restore it to Test Server and Has any one documented this process and has anyone had sucess in doing similar work ?

I do not have any access to Production server.How to make sure i have same server setup & configuration as Production Server.


I have to customize this site and do some development work so i thought this would be best approach ?


Please let me know..thanks..



MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Connestion string create any database server

This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

Database Export Wizard for ASP.net and SQL Server

A step wizard for ASP.net to export database objects to CSV, TXT, HTML, XML, or SQL. it guides users through a few simple steps to choose a database object (table, view, or query), select columns, and export the data in any of the standard formats CSV, HTML, XML, or SQL.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend