Issue creating Database into SQL 2005 Cluster

Real-time performance monitoring and troubleshooting

Issue creating Database into SQL 2005 Cluster

Veeam Logoby dimetronic » Fri Nov 13, 2009 1:08 pm

Hi guys,

i have a problems with veeam monitor installation, i want to install the database in our sql cluster, but although installation process create the database, veeam monitor doesn´t inicializate, it shows an error message with:

"this database it is not a veeam monitor database"

Could you help me please??

Thanks.
dimetronic
Lurker
 
Posts: 1
Liked: never
Joined: Fri Nov 13, 2009 1:04 pm

Re: Issue creating Database into SQL 2005 Cluster

Veeam Logoby Vitaliy S. » Fri Nov 13, 2009 1:38 pm

Hello,

Unfortunately, Veeam Monitor doesn't support SQL cluster installations.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Issue creating Database into SQL 2005 Cluster

Veeam Logoby jasco » Fri Dec 25, 2009 10:51 am

Have the same issue.
I'm Sorry how could that be??? You say its enterprise solution and it is not supporting Clustered SQL. You must be joking :)
how can it matter is it a cluster or not, it is just sql server.
As I understand veeam supports sql2005. So if I Have a dedicated sql server 2005 I should be able to connect to it. And veeam connects to it and shows the DBs we have there... But after I choose the correct DB it says it is not a veeam DB...
or Veeam supports only the local sql servers??
jasco
Novice
 
Posts: 4
Liked: never
Joined: Fri Dec 25, 2009 10:37 am
Full Name: jasco

Re: Issue creating Database into SQL 2005 Cluster

Veeam Logoby Gostev » Fri Dec 25, 2009 11:08 am

Hello Jasco, I cannot really add much to the previous reply of my colleague except confirming it. We are working on adding cluster support in the next release. It is impossible for us to have all features at once, so we have to prioritize based on number of requests. To this date, no SQL cluster support has only been an issue for about 3-4 customers among 30K plus (including free version users).

As for regular remote SQL servers, they are fully supported (if not clustered).
Gostev
Veeam Software
 
Posts: 21390
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Issue creating Database into SQL 2005 Cluster

Veeam Logoby jasco » Fri Dec 25, 2009 12:00 pm

Thanks!
I'm sorry.
But out DB guys tell it is not a cluster as I though...
So that could be the Case?
jasco
Novice
 
Posts: 4
Liked: never
Joined: Fri Dec 25, 2009 10:37 am
Full Name: jasco

Re: Issue creating Database into SQL 2005 Cluster

Veeam Logoby Gostev » Fri Dec 25, 2009 12:05 pm

Not so sure... should work out of box with sufficient permissions and SQL settings. If you are using licensed version of Veeam Monitor, feel free to open a case with our support, and they will assist you in determining the issue.
Gostev
Veeam Software
 
Posts: 21390
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Issue creating Database into SQL 2005 Cluster

Veeam Logoby jasco » Fri Dec 25, 2009 3:39 pm

Thanks again!

So as I see in docs veeam monitor user must have admin privileges on the SQL server?
Creating a DB and making a user owner of it is not enough?
I don't this it is a common practice making every user who needs a DB an admin on the server...
So if that is the problem, Why does the software needs such permissions?
I need only an explanation, so I can describe it to the customer.
jasco
Novice
 
Posts: 4
Liked: never
Joined: Fri Dec 25, 2009 10:37 am
Full Name: jasco


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 6 guests