Help Desk Software & Beyond
August 21, 2017, 01:17:25 AM *
Welcome, Guest. Please login or register.
To post messages you need to register. We apologize for inconvenience, but this is to prevent spam.
Registration is instant (no email verification) and we do not ask for any personal information.

Login with username, password and session length
News: Welcome to Help Desk Software forum!
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: TTX migration  (Read 4915 times)
networkie
Newbie
*

Karma: 0
Posts: 7


View Profile
« on: September 11, 2015, 08:28:46 AM »

Hello,

I'm looking to migrate our TTX installation. Currently it's running on Windows 2003 server, IIS v6 and SQL 2008 R2.

I intend to migrate to a Windows 2012 r2 server, IIS 8 and SQL 2012

I was just checking if TTX will be compatible with IIS 8 and SQL 2012.

Thanks.

Networkie
Logged
jpinegar
Newbie
*

Karma: 0
Posts: 7


View Profile
« Reply #1 on: February 19, 2016, 11:16:14 AM »

Networkie, did you ever migrate? Did you ever find answers to your questions? I'm currently running TTX on Windows Server 2008 R2 64bit/IIS 7/SQL 2003 without issue. I'm planning on migrating to SQL 2014 shorlty and I'm wondering if there were any issues migrating to SQL 2012.
Logged
jpinegar
Newbie
*

Karma: 0
Posts: 7


View Profile
« Reply #2 on: June 08, 2016, 08:59:22 AM »

Migration from MS SQL 2005 Standard (on Server 2003 32bit) to MS SQL 2008 Standard R2 64bit (on Server 2008 Standard R2 64bit) Successful.


   • Put the database in Single User Mode
      ○ In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
      ○ Right-click the database to change, and then click Properties.
      ○ In the Database Properties dialog box, click the Options page.
      ○ From the Restrict Access option, select SINGLE_USER.
   • Take a FULL backup of the database
   • Take database offline
   • Copy the backup file to the new SQL server
   • Restore the database to the new SQL server
   • Take new database out of Single User Mode
      ○ In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
      ○ Right-click the database to change, and then click Properties.
      ○ In the Database Properties dialog box, click the Options page.
      ○ From the Restrict Access option, select MULTI_USER.
   • Delete System DSN entry for old SQL server (32 bit ODBC)
      ○ C:\Windows\SysWOW64\odbcad32.exe (32bit)
      ○ System DSN (tab) > Select [TTX DB Name] > Remove
   • Setup System DSN entry for new SQL server
      ○ C:\Windows\SysWOW64\odbcad32.exe (32bit)
      ○ System DSN (tab) > Add…
      ○ SQL Server Native Client 10.0
         § Name: [TTX DB Name]
         § Description: TTX database
         § Server: [MS SQL Server Name]
   • Connect to TTX using web browser


   1. There is a 32 bit and 64 bit ODBC console in Windows Server 2008 R2 64bit. The correct version needs to be used based on the application. TTX required 32 bit.
   2. When setting up the ODBC connection for TTX, the default database needs to be changed to the [TTX DB Name].
   3. When setting up the ODBC connection for TTX, the [TTX admin] account needs to be used for the connection.

Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1 RC3 | SMF © 2001-2006, Lewis Media Valid XHTML 1.0! Valid CSS!
Page created in 0.016 seconds with 19 queries.