WSS 3 fails during creation of new farm, cannot connect to database server

I am having the lousiest time getting this to work.  

I have Server A running Windows Server 2008R2 & SQL Server 2008 R2

I have Server B running Windows Server 2003 R2 and WSS 3.

I installed WSS3 and when using the SPTCW wizard to create a new farm I cannot get it to connect to the SQL Server.  

Here is what I have done so far:

1.  I can connect to the SQL Server and use it via another server 2003 install with solarwinds orion.  That has been running fine for a week.

2.  I have ensure 1433/1434 are open in the firewalls.

3.  I have even tried disabling the firewalls on both machines but still get he same error.

4.  I can ping from Server to Server B and vice versa.

5.  I am using a seperate instance as the Solarwinds Database though.

6.  I have checked the SQL network config and made sire it matched the Solarwinds instance.

7.  I am using a domain account that has been given every single permission on the SQL Server I can think of.

Any help would be greatly appreciated.


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Justin SmithSr. System EngineerCommented:
Did you grant your farm admin account dbcreator and securityadmin roles in SQL?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TrackpadsAuthor Commented:
I did but I think its a connectivity issue, I am clueless to what it could be:  Here is a screen of the error
Install SQL Management Studio on the problem server (just the tools) and try to connect to the DB Server using the same account that you are logged in as under Windows.

Also, your error refers to an "more detailed log file" can you attach the contents of that file?
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

TrackpadsAuthor Commented:
Ok will do, I do not have access to the logs at the moment.

I can log in via studio on the server itself and access the instance.  What I did last night was to create the database on the server and gave access to the sql account.

the sharepoint installed then went through but it concerns me, I dont want to have trouble creating the content databases.

I gave that sql account all the permissions, not just db creator and security admin so I have no clue why it can do everything else but cant create the database via sharepoint.

Thanks again, will get the info back to you soonest.

Justin SmithSr. System EngineerCommented:
The farm account is what I told you go grant access.  Not the sql account.
TrackpadsAuthor Commented:
Sorry, thats what I meant.  The account I am using to login to sql and on the WSS setup is the farm account.


TrackpadsAuthor Commented:
Ok, here are the logs from yesterday and when I finally got it to install today.
Justin SmithSr. System EngineerCommented:
I don't see any issues in these logs.  Is everything ok now?  If so, what did you change?
TrackpadsAuthor Commented:
No, still no luck on creating databases.  I went ahead and created the database manually on the SQL Server itself and the install atleast completed.

However, now I am trying to set up the search and it is giving this windows error in the logs:

Event Type:      Error
Event Source:      Windows SharePoint Services 3
Event Category:      Database
Event ID:      5586
Date:            3/14/2012
Time:            10:43:55 PM
User:            N/A
Computer:      GRANT
Unknown SQL Exception 262 occured. Additional error information from SQL Server is included below.

CREATE DATABASE permission denied in database 'master'.

For more information, see Help and Support Center at
TrackpadsAuthor Commented:
AS a followup.  The user i am using, forest.admin, I can log into the SQL server, open the studio and create a new database without any errors.  So I am not sure why I am getting this error.

It hates me :)
Justin SmithSr. System EngineerCommented:
When you run the config wizard, it asks you to specify a database access account.  What are you putting here?  Are you putting the account you are logged in as?
TrackpadsAuthor Commented:
Yes, but that was when I set up the server and it never worked.  I ended up creating the config account manually.

Right now I logged into the machine with CA as 'forest.admin' and then opened CA.  Went to the CA and tried to setup the Search service but it fails.  The logs give me the error I posted above.

No matter what permission I give this account in SQL it doesnt work.  I even logged into the SQL server as forest.admin and created new databases with no problem.

Thanks again,

TrackpadsAuthor Commented:
Damn, I found it.  It was this solution:

That is incredibly wierd.  It was the domain account that I was using for the CA App Pool in IIS.  Once I gave that account dbcreator and sec admin it worked.

Thanks again for the help guys,

TrackpadsAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for Trackpads's comment #37722882
Assisted answer: 200 points for ACH1LLES's comment #37708055

for the following reason:

It was something I found on google, not an expert, just luck.
Justin SmithSr. System EngineerCommented:
What exactly did you have to do?
Justin SmithSr. System EngineerCommented:
It was the domain account that I was using for the CA App Pool in IIS.  Once I gave that account dbcreator and sec admin it worked.

This is exactly what I told you to do.  This is the farm admin account that you specifiy in the config wizard.
TrackpadsAuthor Commented:
No, I use a seperate account for the CA pool, a seperate account for the app pools and then another for the CA farm account.  I am using the 6 recommended accounts.  

The confusion was my mistake, apologies,

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.