.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

Attaching the Config Database in SharePoint 2007 with STSADM

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :SharePoint
Hello, We've moved our MOSS 2007 dev environment SQL database to a new server and we're having trouble attaching the config database to SharePoint using stsadm so we can access central admin. Here is the command we're running: stsadm -o setconfigdb -connect -databaseserver kraspsqltest\mosstest -databasename wss_config -farmuser "farmaccountname" -farmpassword "farmpassword" When I run this command (obviously with the correct username and password), the only message I see is: Access denied. I've checked with our DBA and nothing on his end is blocking the command. I do see the following in the event log where the command is being run: "Unknown SQL Exception 10061 occured. Additional error information from SQL Server is included below. A network-related or instance-specific error occurred 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. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)" I've also noticed the folder containing the web.config file in IIS is no longer present on the MOSS server. Is this deleted when the config database is detached and added back when reattached? This server was working just fine prior to the database move

View Complete Post

More Related Resource Links

Cannot crawl sharepoint site and mysite after database attach upgrade form sharepoint 2007 to 2010.

After database attach upgrade site and mysite from sharepoint 2007 to 2010 , I have full crawl and get "The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. If the repository was temporarily unavailable, an incremental crawl will fix this error. ( Error from SharePoint site: HttpStatusCode ServiceUnavailable The request failed with HTTP status 503: Service Unavailable. )" for mysite and get "Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled." for sharepoint site. The content access account for search is "db_owner" of both of site and mysite. How do I solved this problem ?

How to configure Sharepoint 2007 Reporting Services 2005 with NLB sharing same RS database

Hello, I'm trying to configure RS using two FE and a single SQL database in sharepoint integrated mode. At first i was getting an error about version of reporting server wouldnt support scale-out configuration, so i upgraded RS Instances in both FE's to 2005 Ent Ed. and re-installed sharepointRS_Addin in both FE servers and successfully initialized both with the reporting services configuration tool. after successfully granted database access to both FE's using CAS.  if i browse to                    http://WFE1:port/ReportServer/                    or                    http://WFE2:port/ReportServer/                    the database content is listed in browser.   if i browse to:                    http://NLB-sitename:port/ReportServer                    the database content gets listed also, tho it seams to list random conten

Unable To Connect Database Error:Sharepoint 2007 Internet Site.

Hi Techies,  we are running 4farm Sharepoint internet site. now a days we are getting the below error very regularly. Event Viewer :The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SPPREPROD02VMDK\SPPREDPROD.  Check the database connection information and make sure that the database server is running.. Sharepoint Logs:#50071 :#50071: Unable to connect to the database SharePoint_Config on pfc-penndb-tst. Check the database connection information and make sure that the database server is running.. Please Advice . Regards, raju.  Nag: http://nagaraju-sharepoint.blogspot.com. Posting is provided with no warranties.

Stuck installing Sharepoint 2010 - Config Wizard saying Cannot connect to database master


Hi all

I have setup 2 servers in hyper-v.
SERVER-SHP = Sharepoint 2010
both running on windows server 2008 R2.
Both servers are joined to the same domain, have fixed ip addresses and can ping each other.

When I get to the part in Sharepoint 2010 setup where I'm runnng "Sharepoint Products Configuration Wizard" where I specify the database server and name and username and password I get the following error which I can't get past "Cannot connect to database master at SQL server at SERVER-SQL. The database might not exist, or the current user does not have permission to connect to it."

I have read the following link and followed it but the problem remains

I don't see where it is falling over as the username and password is the domain administrator one (have also tried the spAdmin) mentioned to setup in the above link. And it says at the notes at the top of the page that if the database (SharePoint_Co

unable to save data in SQL Server database through Sharepoint 2007


Hi All,

I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.

Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.

Can some one have idea on this. Please help me to get it done

Thanks in Advance.

How to add a Database Connection on Sharepoint Designer 2007 to access SQL 2005 tables?


I've tried and looked on many sites with different solutions for which non of them resolved my issue. I've a blank Sharepoint site and want to view data from an SQL DB. It says that a Server Error occurred and that the Data Retrieval Service didn't worked out while listing the DB's.

I tried using the 3 methods... using the also the connection string in different ways... when I do it using VB, Office and Java... I can see the data from that DB... why on Sharepoint Designer it doesn't? It supposed to be more easier than other tools.

I'm really desperate. Any help is very welcome.



Web.config and Sharepoint Designer 2007 aspx datasource


I have taken over a project that was developed in Sharepoint Designer 2007 with about 10 .aspx pages. The problem is that these pages have data sources embedded in them(inline). The datasources have explicit server/username/password information in them. So, when we want to move this from dev to test to prod I have to create the backup .cmp file from dev and restore it to test. However test is using a different database along with different login credentials so I have to manually change the datasource info.

So my question is, how can I create a variable in the web.config file to specify this datasource connection so it is not hard coded in the inline aspx page.

Remember these pages do NOT have code behind. They were developed in Sharepoint designer 2007 using the GUI.

I have tried adding a <key> or a <connectionStrings> item in the web.config file in hopes that the .aspx page would recognize it and problem solved. When I reference the item in the .aspx page as <%$ ConnectionStrings:dbname %> it just does not recognize it.

Please help, under some pressure here.

Database server migration - renaming database server in SharePoint 2007


We are migrating our SharePoint databases to a new database server.  This new database server will have a new name for SharePoint to reference.  How do I go about pointing SharePoint 2007 from the old database server name to the new name?

It seems like there should be a simple solution, but I have yet to find a solid procedure.

Thank you,

- Tom


SharePoint Server 2007 Database


Hi Guys,

I'm done with the installation of our new SharePoint Server 2007 but i was not able to find its config database. Can you please help me locate it? We are running SQL Server 2005.

Best Regards,

Albie Bokingkito
Systems Administrator

Attaching a 2007 content database to a 2010 Farm

I attached a 2007 content database to a 2010 farm. Is it possible for me to get the 2010 site templates on the sites in that content db?
James Grizzle

Access Database 2007 in Sharepoint 2007 connectivity


Hi  i have access 2007 database , in that D/B i have some really important information about employee stock purchase activity.

i want to put that database(Or Access That DataBase) in sharepoint so employee can check their activity but i want employee can see only their own data from access databse so what i have to do for this kind of scenario?



SharePoint 2007 can't successfully run the config wizard


I keep trying to setup 207 on my new vm.

When I run the config wizard (as local admin or domain acct with admin rights) I get an error that says "Configuration Failed".  If I go into sql management studio, I see SharePoint_config.  In my event viewer, I see the following:


Failed to create the configuration database.
An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown.  Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.
Microsoft.SharePoint.Upgrade.SPUpgradeException: One or more types failed to load. Please refer to the upgrade log for more details.
   at Microsoft.SharePoint.Upgrade.SPDelegateManager.RegisterAssembly(Assembly asm, UInt32 nOrder)
   at Microsoft.SharePoint.Upgrade.SPDelegateManager.get_InitialTypeDictionary()
   at Microsoft.SharePoint.Upgrade.SPDelegateManager.GetDelegateTypes(Type tpObject)
   at Microsoft.SharePoint.Upgrade.SPDelegateManager.GetDelegates(Object o)
   at Microsoft.SharePoint.Upgrade.SPDelegateManager.GetUpgraders(Object o)
   at Microsoft.SharePoint.Upgrade.SPManager.NeedsUpgradeFalse(Object o)
   at Microsoft.SharePoint.Administration.SPPersistedUpgradableObject.set_NeedsUpgrade(B

SQL Server database permission problem in SharePoint 2007


Hi All,

I created few users from "Computer Management" --> "Local Users and Groups" --> "Users" --> "New User" as my login user in SharePoint 2007

Then I having a custom page where store the data into SQL Server Database.

below is how my connectionstring look like:

<add name="XXConnectionString" connectonString="Data Source=XXX;Initial Catalog=YYY;Integrated Security=True" providerName="System.Data.SqlClient"/>

however I hit error when browse to the custom page by the users.


Cannot open database "XXX" requested by the login. The login failed. 

Login failed for user 'xx\user1'.   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 

It was fine if I login as System Account.
Can anyone help me in this? thank you in advance.

Move SharePoint-2007 Database.



I have sharepoint-2007 farm we are using sql server 2005 as databse, now we are plning to migrate our sql server from 2005 to 2008, new sql server will have different name, so can any one let me know which would be the easyest way for me to redirect the farm to reference the new databse server.

our DBA is going to create SQL server connection alias.

bhaumik patel

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..



SharePoint 2007 Upgrade to 2010 and the SSP database (woops)


OK everyone, I got myself a little stuck on something. We upgraded SP 2007 to 2010 in test, planned the production upgrade and upgraded production using the database attach approach, everything went pretty well except...

Users complained pretty quickly that their 'My Links' were missing and that the profile information they had previousely entered was gone... hmmm... we didn't actually check that stuff during testing, oops.

Well looking at the documentation I 'quickly' realized I had missed a step during the upgrade, both in test and prod; I never upgraded the SSP database. I created a new profile service, synch'd with AD, managed meta data service is working, upgraded the mysite content databases and bam, everything was good, or maybe not so good because I'm missing profile information that was manually entered by users.

So of course all the documentation says you need to attach that SSP database during the creation of the Profile Service, well I'm not recreating my profile service... no way. Is it to late to upgrade the SSP database? Do my users just need to start with fresh profiles and suck it up or is there some way I can get that profile data into my new environment?


Write Custom WebParts for SharePoint 2007

The popularity of SharePoint Portal Server 2003 led Microsoft to tightly integrate the next SharePoint version, Microsoft Office SharePoint Server (MOSS) 2007, with its ASP.NET 2.0 WebPart framework. This tight integration enables the ASP.NET and SharePoint developer to do a number of things that previously weren't possible
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