Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-07-08
15
Medium Priority
?
1,222 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

783 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