We help IT Professionals succeed at work.

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

Medium Priority
1,283 Views
Last Modified: 2012-05-07
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
Comment
Watch Question

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

HTH

Author

Commented:
Thanks a million for the quick response.

However I already done that
screenshot3.jpg

Commented:
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.

Author

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

:(
screenshot4.jpg

Commented:
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.

Author

Commented:
Hi Wilje,

ye, it seems to be alright, see screenshot below.
screenshot5.jpg

Commented:
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.

Author

Commented:
none work :(

Commented:
And the only error you are getting is that you cannot connect?

Commented:
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.

Commented:
Try creating an ODBC Connection on the machine with the credentials you created and see if that works.

Author

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.

Commented:
Try [Justin-PC\SQLExpress]

I would also check that Moodle supports SQL Instances.

Author

Commented:
nope....

It does support SQL instances as it works fine with MS SQL 2008
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.