Solved

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

Posted on 2009-07-08
15
1,207 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

726 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