Difference between revisions of "SME Server Move"
Jump to navigation
Jump to search
(Created page with "SME Server Move Instructions 1. look at server - set up location for high5 on new server 2. look at drives if D setup following: High5Software folder-set share to everyone, pe...") |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
SME Server Move Instructions | 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 | ||
− | + | Click here for information on updating: [[Updating SME 7.2]] | |
− | |||
− | |||
− | |||
− | |||
******IF CLIENT MACHINES CANNOT CONNECT CHANGE THE SERVER NAME TO THE IP ADDRESS OF THE SERVER IN THE ALIAS AND ON THE DESKTOP SHORTCUTS****** | ******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 | DONT FORGET TO COPY ALL INFORMATION TO COMMON SERVICE-INSTALLATION INFO IN CUSTOMER INFORMATION IN SME |
Latest revision as of 22:00, 1 December 2014
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
Click here for information on updating: Updating SME 7.2
- 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