?
Solved

Trouble configure SharePoint 2010.

Posted on 2010-11-22
9
Medium Priority
?
483 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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. …
In this article I will describe the Copy Database Wizard 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 video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

830 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