OK I have added in the SIMS2AD views to the SQL Server
The adsync View returns data, but the admanager does not?
Do I need to use the 'sa' username & password for enrolment?
Am getting something similar to this..
field headers are :Code:Tue:2 10A/Sp1 <<UPN>> <<STAFF-CODE>> 52 Mon:1 10C/Hi1 <<UPN>> <<STAFF-CODE>> 59 Wed:5 10C/Hi1 <<UPN>> <<STAFF-CODE>> 59 Wed:2 10B/Gg1 <<UPN>> <<STAFF-CODE>> 57Code:period_name | class_name | unique_pupil_no | staff_initial | room_name
OK, in trying to figure out whats wrong with my set up I added
to the end of the $dbhandle statement in he view.php file for the mod..PHP Code:
or die ("Cant Connect!");
Refreshed the page and got a "Cant Connect" message in my browser - looks like I cannot talk to MS SQL!!
I have been through everything - its all correct
dbhost - server,1427
dbuser - sa
dbpass - <pasword>
dbname - sims_mors
dbtable - dbo.mdl_enrolment_current
Question - Do you need to connect using "sa" ? - Of So then it looks like my LEA have changed it - and prob wont give me it
Last edited by Gatt; 9th January 2009 at 04:08 PM.
how is moodle setup? is it on linux or windows?
if you have access to add view you will be able to reset the sa password, but hang fire until you have answered the above.
If your setup is on windows then you need a slight adjustment.
Its on Linux (Fedora 10)
have you setup freetds on fedora so that the moodle server can talk to the mssql?
you need to install freetds. you also need php-mssql installed.
there are rpm's available for this. our /etc/freetds.conf file looks like this:
where x.x.x.x is the hostname of the SIMS server and 1427 is the port.Code:[global] host = x.x.x.x port = 1427 client charset = UTF-8 tds version = 7.0 text size = 20971520
yeah installed FreeTDS - will need to check the conf file but did put in the IP and port for our SIMS server
Installed php-mssql and restarted apache...
freetds.conf is correct
Cannot telnet to the SQl server
when I try tsql I get "unable to connect: Adaptive server is unavailable or does not exist"
is the port correct?
IIRC MSSQL 2000 and 2005 run on different ports
1433 and 1427?
yeah its set for 1427 in both FreeTDS and in the SIMS Course Template (as server-ip,1427)
if that doesn't connect it's probably that the sims server is firewalled, or isn't listening on the external interface.Code:telnet x.x.x.x 1427
Doesn't work -
Will check firewalls
If its not listening how do i get it to listen?
I just googled, and got back an awnser from Geoff !
Moodle & SQL Server 2005
2. Make sure MS SQL Server can accept incoming TCP/IP connections on port 1433 (the standard one).
You might need to explicitly allow this in your Windows firewall (see the Control Panel). You may also need to edit options in the :SQL Server Configuration Manager -> Network Configuration -> Protocols -> TCP/IP enabled
There are currently 1 users browsing this thread. (0 members and 1 guests)