.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

Mount Existing Database to New Install

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#

Hello all,

An SBS 2003 server just failed on me. I have the database and log files out of the server.  I installed a Virtual Machine with SBS 2003 and have Sharepoint running on it.  How can I mount the current database to this new installation?


View Complete Post

More Related Resource Links

Connect to existing sql 2005 database


Hello There,

I had successfully restored sql 2000 database to sql 2005. It works like charm

Now i am creating a database model in MVC

I follow these steps

Right click on model > ADO.NET entity data model > Generate from database > New connection (Microsoft sql server) > server name > select or enter database name

But no server name AND database name show in both drop down lists. When i mannually enter database name (which exists in sql 2005) then click on TEST CONNECTION. It gives follwoing error

"A network-related or instance-specific error while establishing a connection to sql server. the server was not found or was not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections.

Kindly help me with this


Unable to install SP3 on SQL 2005 due to Database Services language being blank

Hi all,   I have an issue that requires me to upgrade to a later SP (currently on RTM), but when I try to install SP3 Database Services cannot be ticked. Upon inspection I see that its reporting "This update requires language ENU.  The language for this product instance MSSQLSERVER is . Download the upadte for langage .", when I check teh Language field to the right it is blank, other parts however are fine and can be upgraded. Can you advise please as I don't know how to manually set the language (which is reported inside SQL itself as English (United Kingdom)) and I cannot un/reinstall. Thanks, John

"The backup set holds a backup of a database other than existing database. Restore Database is term

I have a problem when i restore my .DAT_BAK file.  I am getting error like "The backup set holds a backup of a database other than existing database.  Restore Database is terminating abnormally".   I tried by using   RESTORE DATABASE <DATABASENAME> FROM DISK = 'D:\DATA\MYTEST.DAT_BAK' WITH MOVE 'VZAI_DATA' TO D:\PROGRAM FILES\..\MSSQL\TEST.MDF', MOVE 'VZAI_LOG' TO D:\PROGRAM FILES\..\MSSQL\TEST.LDF', REPLACE   And also i tried like   RESTORE DATABASE <DATABASENAME> FROM DISK = 'D:\DATA\MYTEST.DAT_BAK' WITH REPLACE   When i use like this,   RESTORE FILELISTONLY FROM DISK = 'D:\DATA\MYTEST.DAT_BAK'. I am able to get the output as LogicalName, PhysicalName, Type, FileGroupName, Size, etc.   Can i anyone please help me out?   Thanks in Advance, Anand Rajagopal

Problems with SSRS 2008 Install when configuring a back-end database on a SQL Server 2008 R2 environ

We are tyring to configure SQL Server Reporting Services (SSRS 2008) not the R2 version with a SQL Server 2008 R2 version of database. We are facing error when the configuration manager within SSRS tries to execute its scripts against the database. Do you think that SSRS 2008 may have trouble using a SQL Server 2008 R2 version as the back-end? Also, what kind of permissions does the ID installing SSRS needs to have on the SQL Server database ?  Not much is available in the documenation or online.

How to add existing SourceSafe database to SSMS project


I have a several large Visual Sourcesafe (VSS) databases with scripts of all objects of several SQL server databases. They were integrated into VSS using Visual Studio. But the Solution file in VSS can not be opened from SQL Server Management Studio 2008 (SSMS). (Its a .sln file, and I need a .ssmssln file). If I try I get an error saying that the solution file was created with a newer version ...

My question is : How do I create a new SSMS project and connect it to one of the existing VSS databases to make it possible to view/check in/check out all the procedures, functions, tables etc. already stored in VSS from within SSMS.

failed to create configuration database on Sharepoint 2010 beta install under Windows 7

sharepoint configuration wizard at final step issued message as follows:

failed to create the configuration database.

an exception of type system.io.filenotfoundexception ws thrown.  additional exception informaion. could not load file or assemble 'microsoft.identity.model. version=,culture=neutral, publickeytoken=31bf3856ad364e35' or one of it's dependencies. the system cannot find the file specified.

the only option was to 'finish' the wizard and exit without a successful install.

can anyone help me with diagnosing this problem.

i am running windows 7 on a dell machine and installed all the software requirements for sharepoint install. with the exception of a hotfix for sql server which when i followed the lin appeared to be updated to a more recently posted hotfix.  i downloaded this and installed successfully.


Cannot determine how to set owner to install database design

My compatibility settings are fine. Anyone know how to to this?

Error 3154: The backup set holds a backup of a database other than the existing 'xx' database.



This is happening with a restore to SS 2005 from a SS2000 backup. This article says to use the 'WITH REPLACE' clause. The SS2005 management studio does not seem to allow this via the GUI.




Estimating Web analytics database sizes Sp2010 new install



Does anyone know, if we know the number of expected users, number of documents and general usage of a SP2010 system, how I could estimate the sizes of the 2 web analytics databases please? I'm trying to get a very rough idea of SQL db sizing and this part of the process has me stumped. I have spent a lot of time reading all the MS whitepapers and they are good for size estimation except for these 2 databases.

Any help much appreciated.

Thanks in advance,


how to install image and music into a table/database

Hi can anyone refer me to a step by step tutorial or how do upload image or music into a database

Adding Current Windows User to Database Encounters Existing User with Same Login


In VS2008 in debug mode, I am using SMO to programatically change the users and permissions on a database. Windows authentication alone is being used. I need to limit access to a administrators group and the current user for whom the database has been dynamically created during the first run of the application within their current Windows environment on the machine. I have no problems creating and assigning the administrators group, but when I try to create the user using the environment's UserDomainName and UserName variables (which would be my creditals) I encounter an inner exception "The login already has an account under a different user name". Before doing running the app, I manually have checked the local server for user and logins with my credentials and programatically looked at each login but have not found any matching credentials. 

Insights and suggestions appreciated.


SQL 2005 will not install because of edition upgrade rules do I need to uninstall existing SQL "lite

SQL 2005 will not install because of edition upgrade rules.  Do I need to uninstall existing SQL "lite"?

SQL 2005 will not install blocked because of edition upgrade rules should I uninstall existing SQL?

SQL 2005 will not install   blocked because of edition upgrade rules    should I uninstall existing SQL?

creating profile using an existing database raither than default database of ASPNETDB.MDF


Alternatively, you could create your own custom Profile provider that operates against existing database tables .

Please, i want u to help me out if u have an idea where i can get steps by steps to carry out the above operation.

i know there are various options in creating profile , particularlly the use of web. configuration, the default ASPNETDB,  and XML files, BUT i wish to use an existing database which i prefer.

SQL Server Express R2 Database Engine fails to install on XP Home (SP3)


I have had multiple failed attempts at installing SQL Server 2008 R2 Express on an elderly but reliable machine running XP Home with SP3. 
The support files and management tools loaded OK when I de-selected the database engine.  I was installing as a user with administrator rights. 
I wanted to start the DB as a service following boot without a user logged on.

The failure appeared as a message a 'Library not registered' at stage Slp_Config_SQLEngine_ADHlpr_Cpu32.  I cancelled at this point (although in other attempts I let it run on with similar, unsuccessful results).

Other posts covering failed installation do not appear to cover the same problem.  If they do, I am afraid it is my limited understanding!

The summary log file is below and what I think are the relevant lines from the detail are given after. 

Can anyone help identify the cause and suggest what I need to do to rectify it?

Many thanks.

Summary Log File
Overall summary:
  Final result:                  User cancelled
  Exit code (Decimal):    

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

Creating Site Collection in Existing Content Database

Hi All,

I'm trying to create a site collection in a existing content database. I haven't found a method in Sharepoint object model to perform such a action. There is an option to create a site collection in a new database using the following command:
SPSiteCollection.Add(url, siteDescription, siteDescription, 1033, siteTemplate,
                                                                siteCollPrimaryAdmin.LoginName, siteCollPrimaryAdmin.Name, siteCollPrimaryAdmin.Email,
                                                                siteCollSecondaryAdmin.LoginName, siteCollSecondaryAdmin.Name, siteCollSecondaryAdmin.Email,
                                                                strSQLServerName, siteContentDBName, null, null);

Is there a different object to do this creation on existing database? Any ideas to approach this problem will be greatly appreciated



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