<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:Georgia;
        panose-1:2 4 5 2 5 4 5 2 3 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
h1
        {mso-style-priority:9;
        mso-style-link:"Heading 1 Char";
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:24.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.Heading1Char
        {mso-style-name:"Heading 1 Char";
        mso-style-priority:9;
        mso-style-link:"Heading 1";
        font-family:"Times New Roman","serif";
        font-weight:bold;}
span.EmailStyle18
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.apple-style-span
        {mso-style-name:apple-style-span;}
span.apple-converted-space
        {mso-style-name:apple-converted-space;}
span.bold
        {mso-style-name:bold;}
span.EmailStyle22
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Are you using Studio or Maestro? Create a data connection->select the appropriate SQL Server FDO connection->fill in the blanks->connect. Then using that data connection, add a layer.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><p class=MsoNormal><span style='color:#1F497D'>Martin Morrison<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Application Engineer<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Engineering Design Systems, Inc.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>3780 Peters Creek Rd Ext SW<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Roanoke, VA 24018<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>540.345.1410<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>gis.edsi.com<o:p></o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> mapguide-users-bounces@lists.osgeo.org [mailto:mapguide-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Ranjan Kumar<br><b>Sent:</b> Tuesday, October 18, 2011 1:33 AM<br><b>To:</b> mapguide-users@lists.osgeo.org<br><b>Subject:</b> [mapguide-users] Mapguide<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>HI,<o:p></o:p></p><h1 style='mso-margin-top-alt:3.0pt;margin-right:0in;margin-bottom:9.6pt;margin-left:0in'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#333333;background:white;font-weight:normal'>How to connect MapGuide Open Source to MS SQL 2008 Server DB.<o:p></o:p></span></h1><p class=MsoNormal>I don't know how to connect to the MS SQL database which is operating on it's own database server.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>Thanks & Regards</span><o:p></o:p></p><p class=MsoNormal><b><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#4F81BD'>Ranjan Kumar</span></b><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>Application Analyst</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>Technology Solutions </span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>Voxiva, India Pvt Ltd.</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>Mobile | +919717432398</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>Email | </span><a href="mailto:rakumar@voxiva.com" target="_blank"><span style='font-size:11.5pt;font-family:"Georgia","serif"'>rakumar@voxiva.com</span></a><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>SKYPE | urwithranjan</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>Address| G-44, Sector-3, Noida, U.P-201301, India</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>Web | </span><a href="http://www.voxiva.com/" target="_blank"><span style='font-size:11.5pt;font-family:"Georgia","serif"'>www.voxiva.com</span></a><o:p></o:p></p><p class=MsoNormal style='text-align:justify'><b><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>THE </span></b><b><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#00B0F0'>POWER </span></b><b><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>OF THE </span></b><b><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#00B0F0'>INTERNET</span></b><b><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>, THE </span></b><b><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#00B0F0'>REACH </span></b><b><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#1F497D'>OF THE </span></b><b><span style='font-size:11.5pt;font-family:"Georgia","serif";color:#00B0F0'>PHONE</span></b><o:p></o:p></p><p class=MsoNormal><b><span style='color:#1F497D'>One of </span></b><b><span style='font-size:18.0pt;color:#C00000'>FAST COMPANY's</span><span style='color:#1F497D'> </span></b><b><span style='font-size:14.0pt;color:gray'>"</span></b><a href="http://www.fastcompany.com/most-innovative-companies/2011/" target="_blank"><b><span style='font-size:14.0pt;color:gray'>WORLD'S MOST INNOVATIVE COMPANIES</span></b></a><b><span style='font-size:14.0pt;color:gray'>"</span></b><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>