2,187
edits
Difference between revisions of "Virtual Centre"
Jump to navigation
Jump to search
m
→Create DSN: Minor additions
(→Install: Move Update manager upgrade proc) |
m (→Create DSN: Minor additions) |
||
| Line 26: | Line 26: | ||
=== Create DSN === | === Create DSN === | ||
Use this procedure to create a new SQL DSN on the server on which you are installing vCentre, if your database is Oracle rather than Microsoft then you'll need to install an Oracle db driver 1st and select that rather than the SQL Native Client in this procedure. A blank/empty database should be create on the database server prior to carrying out this procedure. | Use this procedure to create a new SQL DSN on the server on which you are installing vCentre, if your database is Oracle rather than Microsoft then you'll need to install an Oracle db driver 1st and select that rather than the SQL Native Client in this procedure. A blank/empty database should be create on the database server prior to carrying out this procedure (see [[#Create Database|Create Database]]). | ||
'''If you | '''If you need to specifically create a 32-bit DSN'''. Start the ODBC admin tool from <code>%systemdrive%\Windows\SysWoW64\Odbcad32.exe</code> instead of the Administrative Tools menu. | ||
# Go to '''Data Sources (ODBC)''' in the Administrative Tools menu in order to start the ODBC admin tool | # Go to '''Data Sources (ODBC)''' in the Administrative Tools menu in order to start the ODBC admin tool | ||
| Line 36: | Line 36: | ||
#* '''Name:''' ''This is the name that you'll know the DSN by, and use in the vCentre setup, eg <code>VC</code>'' | #* '''Name:''' ''This is the name that you'll know the DSN by, and use in the vCentre setup, eg <code>VC</code>'' | ||
#* '''Description:''' ''Optional description for DSN, eg <code>vCentre database</code>'' | #* '''Description:''' ''Optional description for DSN, eg <code>vCentre database</code>'' | ||
#* '''Server:''' ''Database server hostname, eg <code>db1.company.com</code>'' | #* '''Server:''' ''Database server hostname, eg <code>localhost</code> or <code>db1.company.com</code>'' | ||
# Enter the appropriate authentication options for your database (ask your DBA if in doubt!), and then click '''Next''' | # Enter the appropriate authentication options for your database (ask your DBA if in doubt!), and then click '''Next''' | ||
# Check the '''Change the default database to''' option and select the appropriate database (that's been created on the database server, then click '''Next''' | #* Use ''With SQL Server authentication...'' and enter the <code>vpxuser</code> credentials if you pre-created them when creating the database | ||
# Check the '''Change the default database to''' option and select the appropriate database (that's been created on the database server), if required, then click '''Next''' | |||
# Leave default options as is on final screen, and click '''Finish''' | # Leave default options as is on final screen, and click '''Finish''' | ||
# Click the '''Test Data Source...''' button to test connectivity to the database, then '''OK''' to finish | # Click the '''Test Data Source...''' button to test connectivity to the database, then '''OK''' to finish | ||