Solved

Trouble configure SharePoint 2010.

Posted on 2010-11-22
9
428 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
  • 4
  • 3
  • 2
9 Comments
 
LVL 10

Expert Comment

by:Humpdy
Comment Utility
is your firewall off ?
0
 
LVL 10

Expert Comment

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

Expert Comment

by:Justin Smith
Comment Utility
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
 
LVL 38

Expert Comment

by:Justin Smith
Comment Utility
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:Powerhousecomputing
Comment Utility
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
Comment Utility
servername\instancename
0
 

Author Comment

by:Powerhousecomputing
Comment Utility
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
Comment Utility
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
Comment Utility
The other comments were not the correct course of action to resolve this question.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now