Solved

Trouble configure SharePoint 2010.

Posted on 2010-11-22
9
441 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
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
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34189372
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
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…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

920 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

12 Experts available now in Live!

Get 1:1 Help Now