Sqlserversetup

New Install Instructions

Be sure to download the advanced SP2 package

When presented with the option - choose to unhide advanced options

Run Setup

  • Pre-setup and Analysis Dialogs
  • Follow instructions and click through

Registration Information

  • As below (Name - x, Company - x)

Feature Selection

Database Services - Select Entire feature will will be installed from local harddrive (replication is disabled by default)
Client Components - Select Entire feature will will be installed from local harddrive (disabled by default)

Instance Name
Select Default Instance
Click Next

Existing Components (Optional Dialog)
Service Access (Optional Dialog)
Authentication
Enable Mixed Mode Authentication
Password: Sk1nk3rs
Collation (Optional Dialog)
Configuration Options
Add current user to sysadmin role

Error logging and Reporting
Ready to install
click next to proceed

++Existing Install Instructions
This a two step process

Install new instance Exactly as above (no uninstall required)
Remove old instance
1. Add new default instance
Run Setup
Follow instructions exactly as above; ensuring you choose to create a default instance
If you recieve a dialog on attempting to pass the next screen stating no changes have been made - go back and click "existing instances" to see whether you already have a default instance.
2. Remove old instance
Run the following command;
"%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe" /Remove
Select the instance you wish to remove (i.e. SQLExpress)
Click Next

Downloading and Installing Microsoft SQL Server Management Studio Express

In addition to SQL Server, you may need to install SQL Server Management Studio Express (~40MB). If the application does not appear in the Microsoft SQL Server section in the start menu, it can be downloaded from the following location on the MSDN website:

http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en

Note that you should only need to install the Managment Studio application (bottom of page) since the rest of the componants mentioned on the MSDN website will be installed when the SQL Server software was installed.

Upgrading from SQL Express to SQL Developer

This can be acheived by passing the SKUUpgrade parameter to the setup.exe via the commandline

Creating a SQL Server Alias

  • Launch SQL Server Configuration Manager tool
  • Navigate to the SQL Server 2005 Network Configuration in the tree view, and open the Protocols for SQLEXPRESS node.
  • Click on the Protocols for SQLExpress node and enable the Named Pipes protocol by right-clicking on it and choose Enable from the context menu.
  • Right click on the Named Pipes node and copy the Pipe Name to the clipboard.
  • Click on the SQL Server 2005 Services node on the tree view.
  • Right click on the SQL Server (SQLEXPRESS) instance item and choose Restart to restart the service.
  • Navigate to the SQL Native Client Configuration node in the tree view, open the Client Protocols and Aliases subnodes.
  • Right click on the Aliases node and click on New Alias… from the context menu, this will bring up the New Alias dialog box.
  • Create a new alias named local (etc). Set the protocol to named pipes. Put in the pipe name copied eariler e.g. \\.\pipe\MSSQL$SQLEXPRESS\sql\query. Set the server to localhost. Click Ok
  • Close the SQL Server Configuration Manager tool
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License