Solved

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

Posted on 2009-07-08
15
1,201 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
  • 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
 
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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now