Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2009-07-08
15
Medium Priority
?
1,220 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

670 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