- Community Home
- >
- Networking
- >
- IMC
- >
- IMC Database New database Creation error
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
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
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
тАО04-13-2016 06:57 AM
тАО04-13-2016 06:57 AM
Hi,
Im trying to install the UAM component on my IMC standard.
When deploying it I end up with an error stating that the DB for UAM is not created.
Begin to install EAD database and data...
--------------------------------
Begin dboptions.DBS
Configuration option 'show advanced options' changed from 1 to 1. Run the
RECONFIGURE statement to install.
Configuration option 'Ad Hoc Distributed Queries' changed from 1 to 1. Run the
RECONFIGURE statement to install.
End dboptions.DBS
--------------------------------
Begin to create EAD database...
execute ead.DBS ... ...
Msg 5133, Level 16, State 1, Server SQL13PROD\HPIMC, Line 2
Directory lookup for the file "E:\MSSQL.HPIMC\Data\\ead_data01.mdf" failed
with the operating system error 3(The system cannot find the path specified.).
Msg 1802, Level 16, State 1, Server SQL13PROD\HPIMC, Line 2
CREATE DATABASE failed. Some file names listed could not be created. Check
related errors.
My issue is that my db files are on a different drive, not E:. This is cause the DBA want to split DB and logs and have moved them to different drives. The first install was made with the default E: path, but later moved.
How can i specify and in which config file that the path is moved to another drive letter.
Also. Is the duble backslash an issue? E:\MSSQL.HPIMC\Data\\ead_data01.mdf
Any comments, Have anyone a simliar experience?
Regards
Regnadner
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-15-2016 05:52 PM
тАО04-15-2016 05:52 PM
SolutionI've seen something similar, a few years ago. Basically the way around it is to let IMC go ahead and create the DB & logs on the same disk, then stop the DB, move the logs, then restart it.
But when you go to add a new component, it will create a new DB. It will default to doing that using the same path as you used originally. You need to go through the same steps for this new DB.
Create the "E:\MSSQL.HPIMC\Data\" directory, run through the UAM install, then shut down IMC, move those DB files around as your DBA needs, then re-start IMC.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-19-2016 12:28 AM
тАО04-19-2016 12:28 AM
Re: IMC Database New database Creation error
Thanks for the tip. That totally made it work.