FAQ


 * Question: Which SQL Server components (client and/or server) do I need to install f****or the course**


 * Answer:** Only the client tools are required for the course as you can access the shared class database. However, if you want to learn about additional database management functionality and analytic tools, please feel free to install your own local database instance.


 * Question: Upgrade Error on MISM Laptops - SQL Server 2005 Installer unable to continue installation and flags an upgrade error**


 * Answer:** MISM laptops has SQL Server 2005 Express edition pre-installed. This installation conflicts with SQL Server 2005 Eval installation. Go to Add/Remove programs, un-install all the existing SQL Server 2005 Applications and re-run the SQL Server 2005 Eval Installer. Hopefully, this should resolve the problem.

If this manual uninstall fails: Download MSI tool from http://support.microsoft.com/kb/290301 to forcibly uninstall components. Then try again.

[Bob Monroe] Another alternative is to install a 'named' instance of SQL Server 2005. That way you can run both SQL Express (which is a very lightweight version of the database) and the full enterprise trial SQL Server 2005 at the same time. To do so, you would give your installation a name (such as BITT). You select this option in one of the earlier dialog boxes during the installation. To connect to the named instance you would then have your client connect to the database MachineName\BITT instead of just connecting to MachineName. Either of these options should work, but using the named option will require your machine to run two instances of SQL Server at the same time, which takes up a lot of system resources.

"Copy error. Setup cannot copy the file staxmem.dl_.
 * Question: How do I resolve the following error message when installing the IIS components:

Answer:** The following Microsoft website will describe the steps to resolve the error: http://support.microsoft.com/kb/555268


 * Problem: If you use Crystal XCelsius ([|http://www.xcelsius.com/)]** **for the dashboard assignment, be forewarned that the demo version does not allow you save (see solution below).**


 * Solution:** Many students were able to quickly create the dashboard and then demo to the professor directly after this step via their laptops (after making a good excel sheet with a few tests of its integration with XCelsius). Also, Xcelsius is **not** required for this assignment. You can use any dashboard software you find to complete the assignment

** Solution: ** Uninstall Office Web Components. This didn’t had any impact on my MS office 07 installation. However be cautious and take back up if required. Steps __ :-Go to add/remove programs part of Windows/Control Panel and uninstall Office Web Components, as it is a stand-alone app. You can also run appwiz.cpl command from start-> run menu to open add/remove programs. Possible systems impacted : Windows Vista/XP, Windows 2000/2003
 * Problem ** : **Error 1706. Setup cannot find the required files. Check your connection to the network or CD-Rom drive. For other potential solutions to this problem, see** ** C:\Program Files\Microsoft Office\....\1033\setup.chm **