<div>Hi,</div><div>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?</div>
<div><br> </div><div class="gmail_quote">On Wed, Jul 20, 2011 at 1:41 PM, elliott17 <span dir="ltr"><<a href="mailto:elliottd@ae.ca">elliottd@ae.ca</a>></span> wrote:<br><blockquote style="margin: 0px 0px 0px 0.8ex; padding-left: 1ex; border-left-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid;" class="gmail_quote">
System is Windows Server 2008, IIS 7, MSSQL 2008 R2, MGOS 2.2<br>
<br>
I have several sites within MGOS 2.2. I am getting an error on a few sites<br>
where the map is not loading and this causes the Mapguide Server to not<br>
respond and I have to restart the Windows Server.<br>
<br>
The error is this:<br>
<br>
<2011-07-20T12:51:47> 1432 MapGuide Maestro API v3.1.0.5859 127.0.0.1<br>
Administrator<br>
Error: An exception occurred in FDO component.<br>
RDBMS: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does<br>
not exist or access denied.<br>
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen<br>
(Connect()).<br>
<br>
The connection to MSSQL within Maestro is successful.<br>
<br>
I have other sites on this 2.2 server that are connecting to the same MSSQL<br>
and the site loads and runs fine.<br>
<br>
Any ideas...<br>
<font color="#888888"><br>
<br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/MSSQL-2008-R2-and-MGOS-2-2-tp6604255p6604255.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/MSSQL-2008-R2-and-MGOS-2-2-tp6604255p6604255.html</a><br>
Sent from the MapGuide Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</font></blockquote></div><br>