Solved

Trouble configure SharePoint 2010.

Posted on 2010-11-22
9
449 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

776 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