MSSQL\Veeam Monitoring is not a valid login or you do ...

Real-time performance monitoring and troubleshooting

MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby xmk » Fri Apr 17, 2009 11:38 am

Hello,

I am installing Veeam Monitor on W2K3 connecting to a named instance on MS SQL 2005 Standard. I'm getting the following error:

04/16/09 23:18:11000052400x00001478"A database error (code:0x80040E14, ) has occured in context of EXEC master.dbo.sp_addsrvrolemember @loginame = N'MSSQL\Veeam Monitoring', @rolename = N'sysadmin'EXEC master.dbo.sp_grantlogin @loginame = N'MSSQL\Veeam Monitoring'. Error information follows"
04/16/09 23:18:11000052400x00001478"Error record 1 of 1: 'MSSQL\Veeam Monitoring' is not a valid login or you do not have permission."
04/16/09 23:18:11000052400x00001478"Throwing exception."

Any idea?

Thanks,

Michal
xmk
Novice
 
Posts: 4
Liked: never
Joined: Fri Apr 17, 2009 10:59 am

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby Gostev » Fri Apr 17, 2009 12:21 pm

Hello, are you trying to use remote SQL and either Veeam Monitor server or SQL server are not part of a domain?
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby xmk » Fri Apr 17, 2009 1:06 pm

Hi,
Both servers are part of the same domain.
xmk
Novice
 
Posts: 4
Liked: never
Joined: Fri Apr 17, 2009 10:59 am

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby Gostev » Fri Apr 17, 2009 1:13 pm

Do you specify domain account for SQL connection?
Does this account have rights to add logins to SQL server?
Also, do you have your SQL configured to accept Windows authentication?

Also, just to make sure, you are not installing Veeam Monitor server on Domain Controller here, right?
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby xmk » Fri Apr 17, 2009 1:39 pm

> Do you specify domain account for SQL connection?
> Does this account have rights to add logins to SQL server?
> Also, do you have your SQL configured to accept Windows authentication?
Looking into the Database tab in Veeam Monitor Settings application I'm using the "current user" setting which is a domain user and is an administrator on both the SQL server and local server. The database is in the mixed mode.

> Also, just to make sure, you are not installing Veeam Monitor server on Domain Controller here, right?
right -- no domain controllers here.
xmk
Novice
 
Posts: 4
Liked: never
Joined: Fri Apr 17, 2009 10:59 am

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby Gostev » Fri Apr 17, 2009 3:25 pm

OK, let me get further troubleshooting instructions from developers... myself or my colleagues from support will update this thread later.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby NShatsky » Tue Apr 21, 2009 2:33 pm

Hello Michal,

Can you please create a support case and provide us with contact information. I would recommend a quick meeting to take a look at your environment in order to resolve this issue.
NShatsky
Lurker
 
Posts: 2
Liked: never
Joined: Sun Jan 01, 2006 1:01 am

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby xmk » Tue Apr 21, 2009 7:22 pm

I'd be happy to...
xmk
Novice
 
Posts: 4
Liked: never
Joined: Fri Apr 17, 2009 10:59 am

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby Luckas » Mon Jun 15, 2009 8:03 am

Hi,

Why is it a non supported configuration to setup veeam monitor in an existing sql 2005 Server, hosted on a Domain controller?
There are many SQL Installations that runs on a DC. I was able to setup monitor 3.x in this way :shock:

And, we have also our Veeam Backup DB, VC Database, View DB and mutch more DB´s on a common SQL Server (running on a DC including a working Backup and Disaster Recovery scenario).

I dont like to break this solution with a local Express DB on the VC Host!

Please give me a work around or working setup file, or must i setup a call to support team?

Thanks to all,
Helmut
Luckas
Novice
 
Posts: 8
Liked: never
Joined: Mon Jun 15, 2009 7:28 am
Full Name: Helmut Luckas

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby Gostev » Mon Jun 15, 2009 8:28 am

Luckas wrote:Why is it a non supported configuration to setup veeam monitor in an existing sql 2005 Server, hosted on a Domain controller?

Hi Helmut, this is because Veeam Monitor 4.0 creates local groups on SQL server computer, and local groups behave differently on domain controllers.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby Luckas » Mon Jun 15, 2009 5:04 pm

Gostev,

ok, :( but is this the right way for our customers and myself? I guess they should think about the design of "local groups" and sql db servers...

What can i do now? This situation needs local Express Server on my virtual center host... (which is a VM itself!!!)

Helmut
Luckas
Novice
 
Posts: 8
Liked: never
Joined: Mon Jun 15, 2009 7:28 am
Full Name: Helmut Luckas

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby Gostev » Mon Jun 15, 2009 5:23 pm

Helmut, typically many customers avoid installing any application on domain controllers, thus we expected this to be a rare case and do not support it yet. As a workaround, can you simply install Veeam Monitor on a separate VM? Veeam Monitor does not need to be installed on vCenter server...
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby Luckas » Mon Jun 15, 2009 5:48 pm

Gostev,

ok. I did a setup in the vm. But in deed, its no a rare case in small environments :lol:

thanks for your fast reply.

Helmuz
Luckas
Novice
 
Posts: 8
Liked: never
Joined: Mon Jun 15, 2009 7:28 am
Full Name: Helmut Luckas

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby Gostev » Mon Jun 15, 2009 6:54 pm

No problems. You can setup Veeam Monitor server in a VM, and install client-only setup on your admin workstation, then connect the client to Veeam Monitor server.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: MSSQL\Veeam Monitoring is not a valid login or you do ...

Veeam Logoby fd99tpr » Fri Jul 31, 2009 2:18 pm

Has there been a resolution to the original issue? I am having the same problem ( MSSQL\Veeam Monitoring is not a valid login or you do ...) Seems this forum got off topic talking about installing on a domain controller. I am not installing on a domain controller and I am using a valid SQL admin account that is also part of the domain admin group. I am attempting to connect to a SQL 2005 cluster. Can anyone shed some light? Thanks!
fd99tpr
Novice
 
Posts: 3
Liked: never
Joined: Fri Jul 31, 2009 1:50 pm
Full Name: Phil Roth

Next

Return to Monitoring



Who is online

Users browsing this forum: No registered users and 6 guests