most recent 30 from http://fogbugz.stackexchange.com 2013-05-20T16:19:27Z http://fogbugz.stackexchange.com/feeds/question/234 http://www.creativecommons.org/licenses/by-nc/2.5/rdf http://fogbugz.stackexchange.com/questions/234/installing-sql-server-express FogBugz KB 2009-10-13T21:52:07Z 2010-04-06T17:19:51Z

<p>How do I install and configure SQL Server Express for use with FogBugz?</p>

http://fogbugz.stackexchange.com/questions/234/installing-sql-server-express/235#235 FogBugz KB 2009-10-13T21:53:03Z 2010-04-06T17:19:51Z

<p>SQL Server Express is a great new free option from Microsoft, for those who want more power than is available from Access, but do not feel a full installation of SQL Server is worth the investment. In particular, SQL Server Express allows FogBugz to do a full text search of its cases, which is not possible within Access. </p> <p>To make things easier for our customers who might be interested in SQL Server Express, here's a step-by-step guide to installing SQL Server Express for use with FogBugz.</p> <ol> <li>Download <a href="http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx" rel="nofollow">SQL Server 2005 Express Edition with Advanced Services</a> (the 234 MB version around the middle of the page) or <a href="http://www.microsoft.com/express/Database/default.aspx#Installation_Options" rel="nofollow">SQL Server 2008 Express with Advanced Services</a> (the 515 MB version on the right).</li> <li>When installing, select SQL Server Management Studio to be installed. It's in the bottom part of the tree. Continue the installation.</li> <li>Once SQL Server Express is installed, open up SQL Server Management Studio Express. Go to Security-&gt;Logins. Right-click, and select New Login... Use the account that you are currently logged in as, making sure to specify it as a domain account if necessary.</li> <li>Right-click on the newly created login, go to Server Roles in the menu on the left, and make the login a sysadmin by checking the appropriate checkbox.</li> <li>Exit SQL Server Management Studio Express.</li> <li>Now do the FogBugz install. When it asks you for the SQL Server location, put in the same settings that SQL Server Management Studio had for the Server field (usually just the name of your computer, sometimes it might be &lt;computername&gt;\SQLExpress if you created a named instance)</li> <li>The rest of the FogBugz installation should go smoothly. Your login should have sysadmin rights, so that the FogBugz installer can add a FogBugz user to SQL Server. </li> </ol> <p>These steps have been tested in an installation at Fog Creek Software. If you have any difficulties, let us know and we will help you get your installation working.</p>

http://fogbugz.stackexchange.com/questions/234/installing-sql-server-express/1599#1599 Jan Fabry 2010-01-25T19:45:16Z 2010-01-25T19:45:16Z

<p>The direct link has changed, it is now <a href="http://www.microsoft.com/express/Database/" rel="nofollow">http://www.microsoft.com/express/Database/</a></p>

http://fogbugz.stackexchange.com/questions/234/installing-sql-server-express/1602#1602 Rick Schummer 2010-01-25T21:02:46Z 2010-01-25T21:02:46Z

<p>Before they decide to use SQL Server Express one should know the limitation of the FogBugz database in SQL Server cannot exceed 4 GB in total size. So it depends on how you use FogBugz (bug tracking with lots of attachments, wiki, etc) and how long before your database requires maintenance and shrinking, or even upgrading to SQL Server Standard Edition.</p> <p>Rick</p>