Can I use Microsoft SQL Spatial Database table

DustinWhisel

I'm new to this so please excuse me.  If I have my information contained in a Microsoft SQL 2008 Spatially enabled database, I can connected ArcGIS Viewer for Silverlight to that database to serve my information up to the net?

DerekLaw

Hi Dustin,

If I have my information contained in a Microsoft SQL 2008 Spatially enabled database, I can connected ArcGIS Viewer for Silverlight to that database to serve my information up to the net?

You can't directly "connect" the ArcGIS Viewer for Silverlight to the Microsoft SQL Server 2008 spatially enabled database. It is possible to make your spatial data in the Microsoft SQL Server 2008 database available on the web, but there are some additional steps you'll have to do.

By "Microsoft SQL 2008 Spatially enabled database",

a) If you mean a "regular" Microsoft SQL Server 2008 database with spatial type data, you can access this spatial type data with query layers in ArcMap. Then publish the map doc as a map service with ArcGIS for Server. The ArcGIS Viewer for Silverlight can access the map service.

b) If you mean an ArcSDE geodatabase implemented on Microsoft SQL Server 2008, you can access the spatial data directly with ArcMap. Then publish the map doc as a map service with ArcGIS for Server. The ArcGIS Viewer for Silverlight can access the map service.

Hope this helps,