cancel
Showing results for 
Search instead for 
Did you mean: 
Munkee
Level 7
Report Inappropriate Content
Message 1 of 3

Installing EPO 4.5 on a VM with a seperate SQL Instance on a cluster

Jump to solution

Hopefully someone can point me in the right direction.

I have been trying to install EPO 4.5 on to a VM but it fails to Authenticate to our SQL Instance.

The SQL Instance is on a High Availabity SQL Cluster.

The account I am using has SysAdmin privileges to the SQL Instance but no other right on the Server or SQL.

The error I receive points to the account needing "Log on as batch job" right on the SQL server. (Our SQL dba & policy will not allow this)

Questions:

1. Is there anyway to pre-stage the SQL database on the SQL server.

2. Why does the account need logon as batch (I'm assuming it needs it to build the database)???

3. Is there any other way of getting the SQL Db created? (script, query etc.)

I have hunted through KB articles and everything I can find but they all relate to installing EPO on the Cluster. (Only SQL is clustered in this instance)

Thanks for any response.

Labels (1)
1 Solution

Accepted Solutions

Re: Installing EPO 4.5 on a VM with a seperate SQL Instance on a cluster

Jump to solution

Hi,

I am not sure if that right is required after installation, however you must build the ePO database through the ePO installer.

About the only option I can think of therefore is that you install using a different Sql server (Use the bundled MSDE version locally if needs be) just to get past that phase.

After that move the DB to your Sql cluster and point ePO at it through the https://servernameSmiley Tongueort/core/config page on the ePO server.

No promises this will be a success though, given the rights applied.

n.b. 'default' collation is a requirement. If your Sql cluster is otherwise configured you may still have issues.

Rob.

2 Replies

Re: Installing EPO 4.5 on a VM with a seperate SQL Instance on a cluster

Jump to solution

Hi,

I am not sure if that right is required after installation, however you must build the ePO database through the ePO installer.

About the only option I can think of therefore is that you install using a different Sql server (Use the bundled MSDE version locally if needs be) just to get past that phase.

After that move the DB to your Sql cluster and point ePO at it through the https://servernameSmiley Tongueort/core/config page on the ePO server.

No promises this will be a success though, given the rights applied.

n.b. 'default' collation is a requirement. If your Sql cluster is otherwise configured you may still have issues.

Rob.

Re: Installing EPO 4.5 on a VM with a seperate SQL Instance on a cluster

Jump to solution

Hi,

How was your experience? Did you get ePO DB on the created instance?

Thanks.

- AB