Area: SQL Server
Issue: Installing SQL Express 2005 for RedBeam Use.
Generally Caused By: Customer needing a 64 bit SQL install.
Level of Complexity: Medium
Go to this web address: This will take you through a manual install of SQL express for 32 or 64 bit machines: Click Here
Read and accept the licensing terms of Microsoft and click Next.
Click Install to continue.
After Microsoft SQL native client and the setup files install click Next.
When the “Welcome to the Microsoft SQL Server Installation Wizard” message is displayed, click Next.
Enter your name and company name and check off of Hide advanced configuration options. These will be accessed later on. Click Next.
The named instance depends on the following: If you have RedBeam Asset Tracking your instance=RBAT. If you have RedBeam Inventory Tracking your instance=RIT. If you have RedBeam Checkin/Check out your named instance will be RCO.
Change your use the built in System account setting to Local System. Check each SQL service at the end of setup box and click Next.
Change Authentication mode to Mixed and change the sa logon password to 34TJ4@#$. If military or corporation that uses password policy requirements, change password to meet policy requirements. Click next.
Leave the collation settings to default with SQL collations selected then Click Next
Choose enable user instances and check Add user to the SQL Server Administrator role click Next.
After completion of the SQL setup files (Note: not all computers will have this many components), click Next.
Select Start >> All Programs >> Microsoft SQL Server 2005 >> Configuration Tools and select SQL Server Configuration Manager.
On the left window pane, select SQL Server 2005 Network Configuration. Then on the right window pane, select the SQL Server Instance you installed. (RBAT, RIT, or RCO).
On the right window pane, right click on Named Pipes and select enable. Then right click on TCP/IP and select enable.
On the left window pane, select SQL Server 2005 Services. Then right click on the correct SQL Server Instance on the right window pane and select Restart.
Begin the install of the RedBeam application if it has not been installed as of yet.
Note: if the SQL portion of the install fails, you can continue with the install of the application since you already installed SQL. If the application gives you errors, please proceed to the following page to view directions for creating the seed.