Editing SME Server Move

SME Server Move Instructions

# look at server - set up location for high5 on new server
# look at drives if D setup following: 
##	High5Software folder-set share to everyone, permissions domain users
##	SQLBackup folder
##	SQLTempDB folder
# goto to other server 
## copy files from OLD high5software folder EXCEPT Data folder to NEW high5software folder.
## create empty Data folder in NEW high5software folder and create folder Company name + Data ex CompanyNameData
## enter OLD data folder and copy all except MDF & LDF files into new CompanyNameData folder
# NEVER MOVE A VERSION TO A NEW SERVER AND UPGRADE AT THE SAME TIME!
# copy to new server data backup folder
# download and install newest version of SQL XXXX RX (year version) of server.
## run installer from download folder
# Open Server configuration manager
# Server Services
## right click SQL Server, properties - FILESTREAM tab, click all 3 checkboxes, enable, enable, allow
## SQL Server Browser properties- start mode Automatic
## SQL full text filter - start mode automatic
## SQL Server, full text, and Browser should only be running
# Protocols for SQLEXPRESS
## Shared Memory, Named Pipes, TCP/IP should all be enabled
## Right CLick TCP/IP, properties, IP Addresses tab TCP Port 1433 in IPV4 and , enabled yes, IPv@IPAll address, delete 0 from Port in both also
# SSMS - right click tempdb in databases
## in files set for both filetype rows and logs - intial size - autogrowth in MB, Initial size 512 MB
## copy path of SQLBackup folder to right click top server in object explorer
## open facets
## Backup directory select files radio button, choose backup in SWLBackup,  on files tab choose relocate all files to folder then data folder on top 2 options
# Rename Alias62.old
# SSMS Restore database from bakup, restore as path to CompanyNameData\CompanyNameData.mdf and CompanyNameData.LDF select files radio buttoms
# Set up for initial company
## Server name is Local CompanyName-SME1\SQLEXPRESS
## Company name, database name - CompanyNameData
## Common files to DB folder
## Database Path to DB folder
# Set CFPath - CompanyNamedata Users remove SMElogin
# Create New SMELogin, dbOwner in User Mapping, sysadmin in server roles
# make admin and users dbOwner
# select CFPath From Defaults
## Update Defaults
## Set CFPath - 'local path to CompanyNameData'
## Update Defaults Set CFPath = 'Server path'19.  Make 2 shortcuts, UNC & local
# firewall.cpl - set ports inbound rules & outbound rules
## _MS SQL TCP - 1433
## _MS SQL UDP - 1439
# take old server offline CompanyName62 


******IF CLIENT MACHINES CANNOT CONNECT CHANGE THE SERVER NAME TO THE IP ADDRESS OF THE SERVER IN THE ALIAS AND ON THE DESKTOP SHORTCUTS******

DONT FORGET TO COPY ALL INFORMATION TO COMMON SERVICE-INSTALLATION INFO IN CUSTOMER INFORMATION IN SME