Difference between revisions of "SME Server Move"

From High5Wiki
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
  
1. look at server - set up location for high5 on new server
+
# look at server - set up location for high5 on new server
2. look at drives if D setup following:  
+
# look at drives if D setup following:  
High5Software folder-set share to everyone, permissions domain users
+
## High5Software folder-set share to everyone, permissions domain users
SQLBackup folder
+
## SQLBackup folder
SQLTempDB folder
+
## SQLTempDB folder
3. goto to other server  
+
# goto to other server  
1.copy files from OLD high5software folder EXCEPT Data folder to NEW high5software folder.
+
## copy files from OLD high5software folder EXCEPT Data folder to NEW high5software folder.
2. create empty Data folder in NEW high5software folder and create folder Company name + Data ex CompanyNameData
+
## create empty Data folder in NEW high5software folder and create folder Company name + Data ex CompanyNameData
3. enter OLD data folder and copy all except MDF & LDF files into new CompanyNameData folder
+
## enter OLD data folder and copy all except MDF & LDF files into new CompanyNameData folder
4. NEVER MOVE A VERSION TO A NEW SERVER AND UPGRADE AT THE SAME TIME!
+
# NEVER MOVE A VERSION TO A NEW SERVER AND UPGRADE AT THE SAME TIME!
6. copy to new server data backup folder
+
# copy to new server data backup folder
7. download and install newest version of SQL XXXX RX (year version) of server.
+
# download and install newest version of SQL XXXX RX (year version) of server.
1. run installer from download folder
+
## run installer from download folder
8. Open Server configuration manager
+
# Open Server configuration manager
9. Server Services
+
# Server Services
1. right click SQL Server, properties - FILESTREAM tab, click all 3 checkboxes, enable, enable, allow
+
## right click SQL Server, properties - FILESTREAM tab, click all 3 checkboxes, enable, enable, allow
2. SQL Server Browser properties- start mode Automatic
+
## SQL Server Browser properties- start mode Automatic
3. SQL full text filter - start mode automatic
+
## SQL full text filter - start mode automatic
4. SQL Server, full text, and Browser should only be running
+
## SQL Server, full text, and Browser should only be running
10. Protocols for SQLEXPRESS
+
# Protocols for SQLEXPRESS
1. Shared Memory, Named Pipes, TCP/IP should all be enabled
+
## Shared Memory, Named Pipes, TCP/IP should all be enabled
2. 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
+
## 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
11. SSMS - right click tempdb in databases
+
# SSMS - right click tempdb in databases
1. in files set for both filetype rows and logs - intial size - autogrowth in MB, Initial size 512 MB
+
## in files set for both filetype rows and logs - intial size - autogrowth in MB, Initial size 512 MB
2. copy path of SQLBackup folder to right click top server in object explorer, open facetsBackup directory  
+
## copy path of SQLBackup folder to right click top server in object explorer
select files radio button, choose backup in SWLBackup,  
+
## open facets
on files tab choose relocate all files to folder then data folder on top 2 options
+
## 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
12. Rename Alias62.old
+
# SSMS Restore database from bakup, restore as path to CompanyNameData\CompanyNameData.mdf and CompanyNameData.LDF select files radio buttoms
13. SSMS Restore database from bakup, restore as path to CompanyNameData\CompanyNameData.mdf and CompanyNameData.LDF
+
# Set up for initial company
select files radio buttoms
+
## Server name is Local CompanyName-SME1\SQLEXPRESS
14. Set up for initial company
+
## Company name, database name - CompanyNameData
1. Server name is Local CompanyName-SME1\SQLEXPRESS
+
## Common files to DB folder
2. Company name, database name - CompanyNameData
+
## Database Path to DB folder
3. Common files to DB folder
+
# Set CFPath - CompanyNamedata Users remove SMElogin
4. Database Path to DB folder
+
# Create New SMELogin, dbOwner in User Mapping, sysadmin in server roles
15. Set CFPath - CompanyNamedata Users remove SMElogin
+
# make admin and users dbOwner
16. Create New SMELogin, dbOwner in User Mapping, sysadmin in server roles
+
# select CFPath From Defaults
17. make admin and users dbOwner
+
## Update Defaults
18. select CFPath From Defaults
+
## Set CFPath - 'local path to CompanyNameData'
Update Defaults
+
## Update Defaults Set CFPath = 'Server path'19.  Make 2 shortcuts, UNC & local
Set CFPath - 'local path to CompanyNameData'
+
# firewall.cpl - set ports inbound rules & outbound rules
Update Defaults
+
## _MS SQL TCP - 1433
Set CFPath = 'Server path'19.  Make 2 shortcuts, UNC & local
+
## _MS SQL UDP - 1439
 +
# take old server offline CompanyName62
  
20. firewall.cpl - set ports inbound rules & outbound rules
+
Click here for information on updating:  [[Updating SME 7.2]]
_MS SQL TCP - 1433
 
_MS SQL UDP - 1439
 
21. take old server offline CompanyName62
 
See upgrade from 7.2-8.0 in docs and follow that
 
  
 
******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

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