Solved

Sharepoint 2010 wizard doenot connect to SQL

Posted on 2010-09-13
5
369 Views
Last Modified: 2012-06-21
Hello Experts

Situation: Windows 2008 server
I want to installe Sharepoint 2010 and SQL on 1 server.

Sql 2005 is running

After installation of the sharepoint 2010 i must start the wizard, there i have to choose to connect to a existing farm or make a new farm.

We dont have a farm, so i choosse the second option.

As database server i choose localhost
I accept the default name: sharpoint_config

user and password

after a while i get the answer cannot connect to sql server, database may not exist or the permissions are not valid

any idea ??

thanks in advance

regards
henk
0
Comment
Question by:henkzet
  • 3
  • 2
5 Comments
 
LVL 9

Expert Comment

by:Ivan Padabed
Comment Utility
you can use SQL Server configuration manager to find out correct SQL instance name. and please ensure that you run configuration wizard as user with access to SQL server instance.
0
 

Author Comment

by:henkzet
Comment Utility
Ivan_padabed, thanks for the response. The instance name is sbsmonitoring (i think) i didnot change anything.
I can start the sql server studio with no problem, but when i open the permissions and i want to grant myself then i get an exception error..'grantor does not have grant permissions  microsoft sql server error #4613'

i gave myself all the permission that has anything to do with sql....

regards
0
 
LVL 9

Expert Comment

by:Ivan Padabed
Comment Utility
ok, so please try sbsmonitoring  as SQL Server name instead of localhost
0
 

Author Comment

by:henkzet
Comment Utility
If i use sbsmonotoring as a server name then i get the response that there is  no server with that name, if i try localhost\sbsmonitoring then i get the following response:
'sql server not supported version 9.0.4053.0 got to the following site for information' wel, this site doesnot exist...

Do you thing it would be wise to install sql server 2008 ??
0
 

Accepted Solution

by:
henkzet earned 0 total points
Comment Utility
Ivan_Padabed:

You may close the ticket.. i de-installed SQL server 2005 and installed sql server 2008. I had now the opportunity to tell sql what user is the administrator of sql. i think this was the clue...

thank you for your time sofar.

How do i close the ticket ? can i give the points to myself ?  :)

thanks again
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
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…
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…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 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