[mapguide-users] Problem with SQL connection

[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 <shoemark.peter at gmail.com> wrote:

> 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: admin
>
> Working through the samples, I can get most things to happen with a bit of
> experimenting here and there but I just dont seem able to make the 'Add
> Data' bit to work in Maestro for SQL.
>
> The steps I'm taking are;
> Data -> New Resource -> Feature Source -> Add -> MS SQL Server Spatial
> Provider........then failure that i will post *but* before I get to that,
> can someone tell me am I correct in entering on the SQL Server Spatial
> Feature Source page,
>
> Service:     MapGuideServer2.4
> Username:  Administrator
> Password:  admin
>
> or should the service name be something else??
>
> Cheers, peter
>
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.n6.nabble.com/Problem-with-SQL-connection-tp4996520.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20120820/03bb36d4/attachment.html>