- Community Home
- >
- Networking
- >
- IMC
- >
- IMC - Installing 7.3 with a remote SQL 2016 databa...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2019 01:41 AM
05-29-2019 01:41 AM
We are trying to carry out a clean install of IMC 7.3 onto a WS 2016 VM (Hyper-V) and connect it to a remote SQL 2016 database on our SQL farm. There doesnt seem to be a document indicating how to carry out this version of install just one for SQL Server 2014.
We have followed the guide for installing using a SQL Server 2014 server but there are some differences which may be the issue. On running the osql –S 192.168.20.110 –U sa –P iMC123456 command with the relevant server, user and password for the database it seems to connect ok as we get the SQL command prompt but when we run the envcheck.bat tool it tells us that "a database or database client was not detected".
I have installed SQL Management Studio and Client Tools Connectivity and Integration Services, Client Tools Backwards Compatibility and Client Tools SDK from the 2016 install media. We have checked that the specified port used for the database is the same as what has been manually selected on the SQL server.
Does anyone have access do a SQL 2016 remote install document or any advice on how to get the database and IMC install to communicate correctly?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2019 03:08 AM
05-29-2019 03:08 AM
SolutionHello Ed,
The SQL Server 2016 Installation and Configuration Guide for IMC should be in the process of getting officially published, but unfortunately it hasn't happened yet. In the meantime, I'll send you a PM with a link to download the guide.
Justin
Working @ HPE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2021 08:53 PM - last edited on 03-18-2021 04:28 AM by Parvez_Admin
03-17-2021 08:53 PM - last edited on 03-18-2021 04:28 AM by Parvez_Admin
Re: IMC - Installing 7.3 with a remote SQL 2016 database
Hi there
I am attempting to do the same, however I cannot find any doco to assist. Basically want to move IMC to another upgraded server and install the database on our external database server. started the new installation of IMC using custom settings however I didnt get any db settings as I think that I need to install the db connectivity tools first. Dont know what is required so if I could grab a copy of the guide, that would geatly assist me
cheers
Andrew
personal info erased
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2021 01:40 AM
03-18-2021 01:40 AM
Re: IMC - Installing 7.3 with a remote SQL 2016 database
Hello,
Please have a look here for iMC documentation in general.
SQL Server 2016 installation guide (and newer SQL version guides) have since been published and can be found by searching there. Here is a direct link to the SQL 2016 guide: https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=a00079689en_us
If you don't get any DB settings when installing, then iMC did not detect any DB Client installed on your system. The client is needed to connect to the DB server and you can see how to install it in the guide. Make sure you don't forget MSSQL Management Studio, as this includes some tools like bcp.exe that iMC requires.
Justin
Working @ HPE