http://ab.edge-technologies.com/docs/index.php?action=history&feed=atom&title=Appboard%2F2.5%2Fadmin%2Fconfiguration_database%2Fexample_mssql 2026-05-01T14:01:16Z Revision history for this page on the wiki MediaWiki 1.38.4 http://ab.edge-technologies.com/docs/index.php?title=Appboard/2.5/admin/configuration_database/example_mssql&diff=7474&oldid=prev 2014-07-18T11:28:56Z

<p>1 revision</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:28, 18 July 2014</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

imported>Jason.nicholls http://ab.edge-technologies.com/docs/index.php?title=Appboard/2.5/admin/configuration_database/example_mssql&diff=7473&oldid=prev 2014-07-18T11:25:08Z

<p></p> <p><b>New page</b></p><div>{{DISPLAYTITLE:Installing Microsoft SQL Server}}<br /> [[Category:AppBoard 2.5]]<br /> ==Overview==<br /> This document covers an example installation of Microsoft SQL Server for use with AppBoard as an external configuration database.<br /> <br /> <br /> == Installation ==<br /> <br /> These installation instructions apply to SQL Server 2000. To install Microsoft SQL Server:<br /> <br /> #Select Install SQL Server 2000 Components.<br /> #Select Install Database Server. The InstallShield begins.<br /> #On the first screen, select Local Install. Click Next or Yes on the following screens until the Setup Type screen opens.<br /> #On the Setup Type screen, select Custom and click Next.<br /> #On the Select Components screen change or accept the default settings and click Next.<br /> #On the Character Set/Sort Order/Unicode Collation screen, in the Sort Order field, select Dictionary Order, Case Sensitive. Keep the other default settings and click Next.<br /> #On the Network Libraries screen, accept the defaults and click Next.<br /> #On the Services Accounts screen, select Use the same account for each service. Autostart SQL Server Service. For Service Settings, select Use the local system account. Then click Next.<br /> #Click Next until you reach the final screen and then click Finish when the installation is complete.<br /> <br /> === Creating a Database and Configuring Security ===<br /> <br /> To create and configure a Microsoft SQL database, do the following:<br /> <br /> #From the Windows Start menu, select SQL Server – Enterprise Manager.<br /> #Expand SQL Servers.<br /> #Expand SQL Server Group.<br /> #Expand your host name (to get to the local databases).<br /> #Right-click Databases and select New Database. <br /> #Enter portal in the Name field and click OK.<br /> #Expand Security.<br /> #Right-click Logins and select New Login.<br /> #Enter portal in the Name field.<br /> #Select SQL Server Authentication and enter a password for the portal user.<br /> #For Defaults, select portal as the database.<br /> #Click the Database Access tab and select portal as the permitted database.<br /> #For Database roles for portal select:<br /> #*db_ddladmin<br /> #*db_datareader<br /> #*db_datawriter<br /> #Select OK.<br /> #Because the default is blank, it is recommended that you change the password for the sa account.<br /> ##Click Logins.<br /> ##Right-click sa and select Properties.<br /> ##Enter a password and click OK.<br /> <br /> === Configuring Automatic Startup ===<br /> <br /> To configure a Microsoft SQL database for automatic startup:<br /> <br /> #From the Windows Start menu, select Settings→Control Panel.<br /> #Open Services and double-click MSSQLServer.<br /> #For Startup Type, ensure that Automatic is selected.<br /> #For Log On As, select System Account.<br /> #Click OK.</div>

imported>Jason.nicholls