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

Real-time performance monitoring and troubleshooting

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

Veeam Logoby Gostev » Fri Jul 31, 2009 3:00 pm

Phil, can you please provide more details on the error (log snippet).
Also, which version are you using - this thread is quite old and is about version 3.0.
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 6:15 pm

07/31/09 09:34:33000034280x00000D64"----------------------------------- New session -----------------------------------"
07/31/09 09:34:33000034280x00000D64"WinVer=Microsoft Windows Server 2003 Enterprise Edition; Platfrom=32"
07/31/09 09:34:33000034280x00000D64"UserIsAdmin=true; UserIsPowerUser=false"
07/31/09 09:34:33000034280x00000D64"A database error (code:0x80040E14, ) has occured in context of EXEC master.dbo.sp_addsrvrolemember @loginame = N'FEPSQLVS2\Veeam Monitoring', @rolename = N'sysadmin'EXEC master.dbo.sp_grantlogin @loginame = N'FEPSQLVS2\Veeam Monitoring'. Error information follows"
07/31/09 09:34:33000034280x00000D64"Error record 1 of 1: 'FEPSQLVS2\Veeam Monitoring' is not a valid login or you do not have permission."
07/31/09 09:34:33000034280x00000D64"Throwing exception."


We are attempting to run version 3.0. Going through setup for the first time. At the end of running setup it throws the exception. Please let me know if you need anything else. Thanks!
fd99tpr
Novice
 
Posts: 3
Liked: never
Joined: Fri Jul 31, 2009 1:50 pm
Full Name: Phil Roth

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

Veeam Logoby Gostev » Fri Jul 31, 2009 6:26 pm

Phil, could you please download and install the current version (4.0.1) and see if it fixes the issue?
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 » Wed Aug 05, 2009 12:56 pm

Gustev,

I have downloaded the latest version of the monitor and I am still having the issue. Funny thing, the old version started working before I uninstalled it. I wanted the latest version installed. Now it doesn't matter what I try I get the same error. It trys to upgrade the DB and fails because it can't connect with the sql id I am using. This is the same SQL id that started working in the old version. Any ideas?
fd99tpr
Novice
 
Posts: 3
Liked: never
Joined: Fri Jul 31, 2009 1:50 pm
Full Name: Phil Roth

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

Veeam Logoby Gostev » Wed Aug 05, 2009 1:21 pm

Phil, if both Monitor client and server are in the same domain and you are not installing on domain controller, then I am not sure what this might be and what are you doing wrong. If you are using licensed Veeam Monitor, feel free to contact our support to setup a live webex and they will help you to make this work.
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 glen.rhea » Mon Aug 24, 2009 6:44 pm

I can replicate the issue as well. I am using the default instance of SQL Server 2005 in a cluster too. The logs are below. It looks like it is trying to put hostname\localusername for the username when it calls master.dbo.sp_addsrvrolemember. Obviously that wont work on a clustered instance of SQL Server and I would prefer to use my domain service account for this service anyway. I would like to test this product and if it fits our needs we will purchase it, however it is difficult to justify the purchase for something that wont even install.

08/24/09 13:18:43 Generic 0x1188 main"Instance=geostorsql; DB=veeammonitor; Username=HDS\grhea"
08/24/09 13:18:43 Inform 0x1188 main"A database error (code:0x80040E14, ) has occured in context of EXEC master.dbo.sp_addsrvrolemember @loginame = N'GEOSTORSQL\Veeam Monitoring', @rolename = N'sysadmin'EXEC master.dbo.sp_grantlogin @loginame = N'GEOSTORSQL\Veeam Monitoring'. Error information follows"
08/24/09 13:18:43 Inform 0x1188 main"Error record 1 of 1: 'GEOSTORSQL\Veeam Monitoring' is not a valid login or you do not have permission."
08/24/09 13:18:43 Inform 0x1188 main"Throwing exception."
08/24/09 13:18:43 Inform 0x1188 main"Impersonate: Reverting to self..."
08/24/09 13:18:43 Inform 0x1188 main"Impersonate: OK"
08/24/09 13:18:43 Error 0x1188 main"IDispatch error #3092 (Code: 0x80040E14, Source: Microsoft SQL Native Client, Description: 'GEOSTORSQL\Veeam Monitoring' is not a valid login or you do not have permission.)"
glen.rhea
Lurker
 
Posts: 1
Liked: never
Joined: Mon Aug 24, 2009 6:29 pm
Full Name: Glen Rhea

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

Veeam Logoby Gostev » Fri Aug 28, 2009 9:39 am

Hello Glen, unfortunately right now we do not support clustered SQL server - but we are planning to add such support later.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Previous

Return to Monitoring



Who is online

Users browsing this forum: No registered users and 3 guests