Solved

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

Posted on 2009-07-08
15
1,211 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
0
Comment
Question by:jtiernan2008
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
  • 4
15 Comments
 
LVL 13

Expert Comment

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

HTH
0
 
LVL 1

Author Comment

by:jtiernan2008
ID: 24808464
Thanks a million for the quick response.

However I already done that
screenshot3.jpg
0
 
LVL 13

Expert Comment

by:St3veMax
ID: 24808518
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
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 
LVL 1

Author Comment

by:jtiernan2008
ID: 24808669
hmmm, ye... I see dbo under users

:(
screenshot4.jpg
0
 
LVL 7

Expert Comment

by:wilje
ID: 24808860
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
 
LVL 1

Author Comment

by:jtiernan2008
ID: 24809004
Hi Wilje,

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

Expert Comment

by:wilje
ID: 24809057
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
 
LVL 1

Author Comment

by:jtiernan2008
ID: 24809109
none work :(
0
 
LVL 7

Expert Comment

by:wilje
ID: 24809283
And the only error you are getting is that you cannot connect?
0
 
LVL 7

Expert Comment

by:wilje
ID: 24809328
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
 
LVL 13

Expert Comment

by:St3veMax
ID: 24811358
Try creating an ODBC Connection on the machine with the credentials you created and see if that works.

0
 
LVL 1

Author Comment

by:jtiernan2008
ID: 24811849
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
 
LVL 13

Expert Comment

by:St3veMax
ID: 24811872
Try [Justin-PC\SQLExpress]

I would also check that Moodle supports SQL Instances.
0
 
LVL 1

Author Comment

by:jtiernan2008
ID: 24811919
nope....

It does support SQL instances as it works fine with MS SQL 2008
0
 
LVL 1

Accepted Solution

by:
jtiernan2008 earned 0 total points
ID: 25004842
no solution
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question