Re: [mapguide-users] Problem with SQL connection

2012-08-21 Thread Jackie Ng
This is because the physical directory of MapGuide's www root is actually: C:\Program Files\OSGeo\MapGuide\Web\www Any directory under here is available under http://localhost:8008/mapguide give-or-take the default htaccess rules. - Jackie -- View this message in context:

[mapguide-users] Problem with SQL connection

2012-08-20 Thread sidecar5
Hi, can someone give me some guidance with a SQL connection please? I am using 2.4 RC1 MG and 5.03b Maestro, SQL Express 2008 r2, Win 7 x86. Database details Lap-01\SQLEXPRESS db SPATIAL_01 (The Service name under Computer Management - Services is 'MapGuideServer2.4') user: Administrator pwd:

Re: [mapguide-users] Problem with SQL connection

2012-08-20 Thread Ryan Northcott
I think for SQL server, it wants your server name: SPATIAL_01 and then your user account that has access to read/etc to your SQL DB it appears you are trying to pass your MapGuide Administrator account to your SQL DB engine. Two separate systems. On Mon, Aug 20, 2012 at 9:41 PM, sidecar5

Re: [mapguide-users] Problem with SQL connection

2012-08-20 Thread Jackie Ng
Service: The SQL Server instance name (Lap-01\SQLEXPRESS) DataStore: The name of the SQL Server database Username: The SQL Server username Password: The SQL Server password If username/password both blank, the SQL Server FDO provider will default to Windows Authentication using the account the

Re: [mapguide-users] Problem with SQL connection

2012-08-20 Thread Peter Shoemark
Awesome thanks team. The bit I was stuck on was I didn't understand, If username/password both blank, the SQL Server FDO provider will default to Windows Authentication using the account the MapGuide Server process is running under Cheers, Peter ___

Re: [mapguide-users] Problem with SQL connection

2012-08-20 Thread Jackie Ng
In SQL Server, there's 2 ways to authenticate when connecting 1. Using SQL Server logins 2. Using Windows user accounts Connecting without specifying a username/password in the UI will instruct the SQL Server FDO provider to use Windows Authentication using the username/password of the windows

Re: [mapguide-users] Problem with SQL connection

2012-08-20 Thread Peter Shoemark
Excellent thanks Jackie. Last question for today and I realise a little off topic but, I have a 'Hello.htm' file in C:\Program Files\OSGeo\MapGuide\Server\Repositories\Site\Test_07\ I haven't managed to get it to display when I paste the string into the Initial task Pane URL box for my Layout.