Link to home
Start Free TrialLog in
Avatar of henkzet
henkzet

asked on

Sharepoint 2010 wizard doenot connect to SQL

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
Avatar of Ivan Padabed
Ivan Padabed
Flag of Belarus image

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.
Avatar of henkzet
henkzet

ASKER

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
ok, so please try sbsmonitoring  as SQL Server name instead of localhost
Avatar of henkzet

ASKER

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 ??
ASKER CERTIFIED SOLUTION
Avatar of henkzet
henkzet

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial