-
- Novice
- Posts: 4
- Liked: never
- Joined: Apr 17, 2009 10:59 am
- Contact:
MSSQL\Veeam Monitoring is not a valid login or you do ...
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:11 00005240 0x00001478 "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:11 00005240 0x00001478 "Error record 1 of 1: 'MSSQL\Veeam Monitoring' is not a valid login or you do not have permission."
04/16/09 23:18:11 00005240 0x00001478 "Throwing exception."
Any idea?
Thanks,
Michal
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:11 00005240 0x00001478 "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:11 00005240 0x00001478 "Error record 1 of 1: 'MSSQL\Veeam Monitoring' is not a valid login or you do not have permission."
04/16/09 23:18:11 00005240 0x00001478 "Throwing exception."
Any idea?
Thanks,
Michal
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
Hello, are you trying to use remote SQL and either Veeam Monitor server or SQL server are not part of a domain?
-
- Novice
- Posts: 4
- Liked: never
- Joined: Apr 17, 2009 10:59 am
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
Hi,
Both servers are part of the same domain.
Both servers are part of the same domain.
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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?
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?
-
- Novice
- Posts: 4
- Liked: never
- Joined: Apr 17, 2009 10:59 am
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
> 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.
> 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.
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
OK, let me get further troubleshooting instructions from developers... myself or my colleagues from support will update this thread later.
-
- Lurker
- Posts: 2
- Liked: never
- Joined: Jan 01, 2006 1:01 am
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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.
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.
-
- Novice
- Posts: 4
- Liked: never
- Joined: Apr 17, 2009 10:59 am
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
I'd be happy to...
-
- Novice
- Posts: 8
- Liked: never
- Joined: Jun 15, 2009 7:28 am
- Full Name: Helmut Luckas
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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
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
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
![Shocked :shock:](https://forums.veeam.com/images/smilies/icon_eek.gif)
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
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
Hi Helmut, this is because Veeam Monitor 4.0 creates local groups on SQL server computer, and local groups behave differently on domain controllers.Luckas wrote:Why is it a non supported configuration to setup veeam monitor in an existing sql 2005 Server, hosted on a Domain controller?
-
- Novice
- Posts: 8
- Liked: never
- Joined: Jun 15, 2009 7:28 am
- Full Name: Helmut Luckas
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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
ok,
![Sad :(](https://forums.veeam.com/images/smilies/icon_sad.gif)
What can i do now? This situation needs local Express Server on my virtual center host... (which is a VM itself!!!)
Helmut
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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...
-
- Novice
- Posts: 8
- Liked: never
- Joined: Jun 15, 2009 7:28 am
- Full Name: Helmut Luckas
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
Gostev,
ok. I did a setup in the vm. But in deed, its no a rare case in small environments
thanks for your fast reply.
Helmuz
ok. I did a setup in the vm. But in deed, its no a rare case in small environments
![Laughing :lol:](https://forums.veeam.com/images/smilies/icon_lol.gif)
thanks for your fast reply.
Helmuz
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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.
-
- Novice
- Posts: 3
- Liked: never
- Joined: Jul 31, 2009 1:50 pm
- Full Name: Phil Roth
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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!
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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.
Also, which version are you using - this thread is quite old and is about version 3.0.
-
- Novice
- Posts: 3
- Liked: never
- Joined: Jul 31, 2009 1:50 pm
- Full Name: Phil Roth
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
07/31/09 09:34:33 00003428 0x00000D64 "----------------------------------- New session -----------------------------------"
07/31/09 09:34:33 00003428 0x00000D64 "WinVer=Microsoft Windows Server 2003 Enterprise Edition; Platfrom=32"
07/31/09 09:34:33 00003428 0x00000D64 "UserIsAdmin=true; UserIsPowerUser=false"
07/31/09 09:34:33 00003428 0x00000D64 "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:33 00003428 0x00000D64 "Error record 1 of 1: 'FEPSQLVS2\Veeam Monitoring' is not a valid login or you do not have permission."
07/31/09 09:34:33 00003428 0x00000D64 "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!
07/31/09 09:34:33 00003428 0x00000D64 "WinVer=Microsoft Windows Server 2003 Enterprise Edition; Platfrom=32"
07/31/09 09:34:33 00003428 0x00000D64 "UserIsAdmin=true; UserIsPowerUser=false"
07/31/09 09:34:33 00003428 0x00000D64 "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:33 00003428 0x00000D64 "Error record 1 of 1: 'FEPSQLVS2\Veeam Monitoring' is not a valid login or you do not have permission."
07/31/09 09:34:33 00003428 0x00000D64 "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!
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
Phil, could you please download and install the current version (4.0.1) and see if it fixes the issue?
-
- Novice
- Posts: 3
- Liked: never
- Joined: Jul 31, 2009 1:50 pm
- Full Name: Phil Roth
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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?
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?
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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.
-
- Lurker
- Posts: 1
- Liked: never
- Joined: Aug 24, 2009 6:29 pm
- Full Name: Glen Rhea
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
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.)"
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.)"
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: MSSQL\Veeam Monitoring is not a valid login or you do ...
Hello Glen, unfortunately right now we do not support clustered SQL server - but we are planning to add such support later.
Who is online
Users browsing this forum: No registered users and 4 guests