</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_RATING%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="LogoImage" --><!--DXMETADATA end--> <div id="ProjectTitle"><!--DXMETADATA start type="ProjectTitle" -->LightSwitch HTML Edition<!--DXMETADATA end--></div> <div id="PageTitle"><div id="PageTitleText"><!--DXMETADATA start type="ItemTitle" -->Connect to SQL Server Database<!--DXMETADATA end--></div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel"><!--DXMETADATA start type="Phrase" name="COLLAPSE_ALL" -->Collapse All<!--DXMETADATA end--></label> <label id="ExpandAllLabel" style="display: none;"><!--DXMETADATA start type="Phrase" name="EXPAND_ALL" -->Expand All<!--DXMETADATA end--></label> </span><!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_DROPDOWN%%" --><!--DXMETADATA end --> </div> <!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><div class="BreadcrumbsContainer"><table><tr><td> <a href="ConnectingtoData.html">Connecting to Data</a> > Connect to SQL Server Database</td></tr></table></div><!--DXMETADATA end --> <div id="BodyContent"> <!--DXMETADATA start type="TopicSection" name="BodyText"--><p>To connect to a SQL Server Database, complete the following:</p> <ol> <li>In the Solution Explorer, click the <b>Data Sources</b> node.</li> <li>On the Project menu, click <b>Add Data Source</b>. The <b>Attach Data Source Wizard</b> appears.</li> <li>In the <b>Choose a data Source Type</b> page, click <b>Database</b>, and then click <b>Next</b>.</li> <li>If the Choose Data Source dialog box appears, click <b>Microsoft SQL Server</b>, and then click <b>Continue</b>.<img border="0" alt="" src="images/LightSwitchApp_Window7.png"></li> <li>In the <b>Connection Properties</b> dialog box, make sure that Microsoft SQL Server (SqlClient) appears as selected in the Data source box.</li> <li>In the Server name box of the Connection Properties dialog box, type the name of the SQL Server instance that you want to connect to.</li> <li>If your database is set up to sue Windows authentication, click <b>Use Windows Authentication</b>. Otherwise, click <b>Use SQL Server Authentication</b>, and then provide the user name and password of a user who has access to the database.</li> <li>Click <strong>Select</strong> or or enter a database name. Then, in the Select or enter a database name drop-down list, select or type the name of the database that you want to connect to, and then click Ok. The Choose Your Database Objects page appears.</li> <li>In the <strong>Choose Your Database Objects</strong> page, select the tables and views that you want to use in your LightSwitch application, and then click <b>Finish</b>. The database, tables, and views that you selected appear in the <strong>Solution Explorer</strong> as sub nodes of the Data Sources node.</li> </ol> <p><!--DXMETADATA end--> <a name="seealsobookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORISED_LINKS" namespace="linkcategory" source="Item" filter="" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=seealso,caption=""%%phrase:name=SeeAlso%%%%designlist:tagidentifier=seealso,itemtype=See Also%%""%%%%filtereditemlist%%</div>"--><!--DXMETADATA end--> </div> <div id="FooterContent"> <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_FOOTER" --><!--DXMETADATA end --> <!--DXMETADATA start type="Variable" name="CopyrightNotice" format="<p> </p><p> </p><hr style=""height: 1px"" /><p>%%variable%%</p>" --><p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p><!--DXMETADATA end --> <!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><a href="http://feedback.componentone.com/forums/255790-asp-netlightswitch-documentation" target="_blank">Documentation Feedback </a> | <a href="http://our.componentone.com/groups/" target="_blank">Product Support Forum </a><!--DXMETADATA end--> </div> </body> </html>