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.

thanks
screenshot1.jpg
screensot2.jpg
LVL 1
jtiernan2008Asked:
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.

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

HTH
0
jtiernan2008Author Commented:
Thanks a million for the quick response.

However I already done that
screenshot3.jpg
0
St3veMaxCommented:
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.

Steve

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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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

:(
screenshot4.jpg
0
wiljeCommented:
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.
0
jtiernan2008Author Commented:
Hi Wilje,

ye, it seems to be alright, see screenshot below.
screenshot5.jpg
0
wiljeCommented:
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:
.\SQLEXPRESS
localhost\SQLEXPRESS
[JUSTIN-PC]\SQLEXPRESS
I am just guessing here.
0
jtiernan2008Author Commented:
none work :(
0
wiljeCommented:
And the only error you are getting is that you cannot connect?
0
wiljeCommented:
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.
0
St3veMaxCommented:
Try creating an ODBC Connection on the machine with the credentials you created and see if that works.

0
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.
0
St3veMaxCommented:
Try [Justin-PC\SQLExpress]

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

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

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.