Trying to configure Moodle with MS SQL 2005 (screenshot attached)

Can someone please take a look at the below. I got this working ok with MS SQL 2008 but now I am trying to setup using MS SQL 2005 and no luck.

Can someone please take a look at the screenshots to see what I am doing wrong.

Who is Participating?
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.

In Management Studio Express, Expand Databases, Expand Security and add the account running Moodle in at that level.

jtiernan2008Author Commented:
Thanks a million for the quick response.

However I already done that
No Worries. From what You've said - you've not actually done that...

You've created the SQL User account/password and set it's default database.

You need to expand 'Databases', Expand 'Moodle', Expand 'Security' and then ensure the account in there has 'dbo' permissions to begin with.

Give that a go and see how you get on.


p.s. off to bed now as 2230 over here and need my beauty sleep! - no doubt another expert will be able to assist should the above not work.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics ā€“ known as key performance indicators (KPIs) ā€“ for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

jtiernan2008Author Commented:
hmmm, ye... I see dbo under users

Yes, the user is mapped to the database but what privileges does that user have?  Double-click on the user and check to see whether or not that user is db_owner.  If not, make the user db_owner.
jtiernan2008Author Commented:
Hi Wilje,

ye, it seems to be alright, see screenshot below.
Okay, that user owns the database and appears to have the right privileges.  So, what I would try next is changing the Type option - if there is another type for SQL Server.
You could also try the following for the Host Server:
I am just guessing here.
jtiernan2008Author Commented:
none work :(
And the only error you are getting is that you cannot connect?
Are you logging into SSMS with this account?  Or are you logging in with your Windows account, or sa?
Have you verified that SQL Authentication is enabled?  I know we went through this for the 2008 setup - but thought I would ask anyways.
Try creating an ODBC Connection on the machine with the credentials you created and see if that works.

jtiernan2008Author Commented:
The strange thing is I have MS SQL 2005 and 2008 installed. 2008 says that the database is located in Justin-PC as opposed to Justin-PC/SQLEXPRESS in 2005 and when I enter this, it works fine. I have tried looking at the database securuty properites side by side and cannot see anything.
Try [Justin-PC\SQLExpress]

I would also check that Moodle supports SQL Instances.
jtiernan2008Author Commented:

It does support SQL instances as it works fine with MS SQL 2008
jtiernan2008Author Commented:
no solution

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
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 SQL Server 2005

From novice to tech pro — start learning today.