Solved

Trouble configure SharePoint 2010.

Posted on 2010-11-22
9
470 Views
Last Modified: 2012-05-10
Hi,

I am trying to configure microsoft SharePoint 2010, we have share point 2007 installed and working.

After installing Sharepoint 2010 and running the configuration wizard.

I select "Create new server farm" and get to the stage where it asks me for the Database Server, Database name (default: SharePoint_Config), Username and password.

Our server name is SBS08.

After filling them out as follows;

Database Server: SBS08
Database name: SharePoint_Config
Username: domain\Administrator
password: *********

OR

Database Server: SBS08\MICROSOFT##SSEE
Database name: SharePoint_Config
Username: domain\Administrator
password: *********


I recieve the following error.

SharePoint Products Configuration Wizard

Cannot connect to database master at SQL server at SBS08. The database might not exsist, or the current user does not have permission to connect to it.

0
Comment
Question by:Powerhousecomputing
[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
  • 4
  • 3
  • 2
9 Comments
 
LVL 10

Expert Comment

by:Humpdy
ID: 34189349
is your firewall off ?
0
 
LVL 10

Expert Comment

by:Humpdy
ID: 34189356
make sure named pipes is also enabled on sql server
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34189359
Are you trying to install SharePoint 2010 over the top of 2007?  Is it currently on SP2 ?  Did you read the following:

http://technet.microsoft.com/en-us/library/cc263212.aspx
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 38

Expert Comment

by:Justin Smith
ID: 34189372
0
 

Author Comment

by:Powerhousecomputing
ID: 34196166
Named pipes are enabled and it is not the firewall.

We have 2007 installed an have installed 2010 over the top. 2007 still works though. We are currently repairing the installation to see if this changes anything.

What I am most curious about is what to type in the SQL Server text field? Should I be able to just type in our server name.

We have SQL Server 2005, 2008 and 2008 R2 installed.

Thanks for your help.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34196271
servername\instancename
0
 

Author Comment

by:Powerhousecomputing
ID: 34211153
Yes I can see this is what it is asking for. But I do not know what the instance name is. How would I find this out? Do I need to create an instance?
0
 

Accepted Solution

by:
Powerhousecomputing earned 0 total points
ID: 34228470
OK we have worked it out now. The Wizard suggested in its wording that it would create a new instance. But this was not the case. To fix this error we had to create a new black instance with SQL Server 2008 R2 Studio. Then type this instance name into the wizard.
0
 

Author Closing Comment

by:Powerhousecomputing
ID: 34265419
The other comments were not the correct course of action to resolve this question.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

696 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