Solved

SharePoint the server instance specified was not found

Posted on 2010-09-09
11
1,847 Views
Last Modified: 2012-05-10
I'm trying to move a copy of our current SharePoint 2007 site to a new server that will be hosting SharePoint 2010. I'm getting an error when I try to attach the SharePoint 2007 database to SharePoint 2010.

I'm trying to run stsadm -o addcontentdb -url http://<servername> -databasename SharePoint_2010_Test -databaseserver <servername>

When running that I get the follwoing error

"The server instance specified was not found. Please specify the servers address and port"

This is a Virtual Server running in Microsoft Hyper-V with Server 2008R2 Enterprise with SQL Server 2008R2 installed.

Here are the steps we performed to get this far

1. backup existing content DB from SharePoint 2007 Server
2. copy file to SharePoint 2010 server
3. Install SharePoint 2010
4. Created new site collection in 2010
5. Went to central admin removed new site collection web db
6. Tried using stsadm to add new content DB into SharePoint 2010

and that's when I'm getting the error from above.
0
Comment
Question by:bkpierce
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
11 Comments
 
LVL 6

Expert Comment

by:Inderjeetjaggi
ID: 33640914
Not sure about access but you can try below article to achieve the same with an infopath form
Publish a database to a SharePoint site:
http://technet.microsoft.com/en-us/library/cc262263.aspx

Inder
0
 
LVL 6

Expert Comment

by:Inderjeetjaggi
ID: 33641012
Sorry i wanted to post it on some other issue.

I am not sure about 2010 but in WSS we can get the instance name from below registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33643016
when you created the new web app in 2010, did you use the same URL as 2007?  are you sure you aren't typing something in wrong?
0
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 

Author Comment

by:bkpierce
ID: 33646101
I used a different URL because we still want to keep the 2007 site live for a few weeks while we do some testing with 2010.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33646140
and you are running this command on the 2010 box, correct?
0
 

Author Comment

by:bkpierce
ID: 33646143
correct
0
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 33646164
create another web app, using the same url from 2007, and repeat the process.  i dont see why this would matter, but try it.  you can adjust the HOSTS file on the 2010 box if you need to reach the 2010 URL.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33749081
please update or close this question
0
 

Author Comment

by:bkpierce
ID: 33749111
Nothing has worked yet, I need to have the 2007 still up and continue to function and have a copy of the content from that site on the 2010 site with a differnt URL. We still want all users to use the 2007 until we are ready to migrate. For now we just want to test stuff with the 2010 site.

Tried creating a web app, deleting and then attaching the copy of the 2007 content db but I keep getting an error that says "Server instace specified could not be found"
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33769952
The users won't be affected as you aren't updating DNS to point to the 2010 server.  The 2010 site would only be accessable from the 2010 server (through the HOSTS file).

0
 

Author Comment

by:bkpierce
ID: 33823165
Wiped out SharePoint 2010, reinstalled on the server and had to update some service accounts. This time when running the power shell command line everything worked fine. Thanks for the help.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

717 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