[mapguide-users] MSSQL 2008 R2 and MGOS 2.2

[GIS4U]

Hi,
What is the connection string that you are using?  Is it using SQL Server
Express?  How many tables exist in the database?  Are the connections that
are working in the same database connection or a different one on the same
SQL Server?  Are you using a SQL Server user for all or do some have Windows
Authentication?


On Wed, Jul 20, 2011 at 1:41 PM, elliott17 <elliottd at ae.ca> wrote:

> System is Windows Server 2008, IIS 7, MSSQL 2008 R2, MGOS 2.2
>
> I have several sites within MGOS 2.2. I am getting an error on a few sites
> where the map is not loading and this causes the Mapguide Server to not
> respond and I have to restart the Windows Server.
>
> The error is this:
>
> <2011-07-20T12:51:47>   1432    MapGuide Maestro API v3.1.0.5859
>  127.0.0.1
> Administrator
>  Error: An exception occurred in FDO component.
>        RDBMS: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does
> not exist or access denied.
>        [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
> (Connect()).
>
> The connection to MSSQL within Maestro is successful.
>
> I have other sites on this 2.2 server that are connecting to the same MSSQL
> and the site loads and runs fine.
>
> Any ideas...
>
>
>
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/MSSQL-2008-R2-and-MGOS-2-2-tp6604255p6604255.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/20110720/6015fd7d/attachment.html