The server principal 'MyDomain\DomainUserA' already exists.

Question

DBAs!

I'm about ready to tear my hair out on this one; I have encountered this before, but following the normal troubleshooting steps to solve this has not yielded the necessary outcome... i.e. FIXED!

This occured after deleting a login from SSMS by simply doing a right-click | delete on the login.
I then tried to re-add the login a while later and received this error.
This has occured for Domain Group Logins, Domain User Logins and straight SQL logins (i.e. more than one occurrence).
It has occured for a brand new login not even associated/linked/mapped to a database.

Thinking it was an orphan record of some kind, I tried the following:

1. Checked every database to ensure the entry was not listed under the database's user list

2. Ran as sa: DROP LOGIN [MyDomain\DomainUserA]
*Result: "Cannot drop the login 'MyDomain\DomainUserA', because it does not exist or you do not have permission."

3. Ran as sa against each database: DROP USER [MyDomain\DomainUserA]
*Result: "Cannot drop the user 'PPM-SA\SQL DBAs', because it does not exist or you do not have permission."

4. Ran as sa: select * from sys.syslogins where name = 'MyDomain\DomainUserA'
*Result: No records found.

5. Ran as sa: select * from sys.server_principals where name = 'MyDomain\DomainUserA'
*Result: No records found.

6. Ran as sa: SELECT SUSER_SID('MyDomain\DomainUserA')
*Result: 0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000

7. Ras as sa: select * from sys.syslogins where sid = '0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000'
*Result: No records found.

8. select * from sys.server_principals where sid = '0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000'
*Result: No records found.

I simply can't add this user back!

Your EXPERT assistance is most appreciated! If I am being a NOOB, feel free to tell me!

As you can imagine, this is causing some frustration and I am unable to continue in many regards with what I am trying to accomplish.

Kind regards,

Nick

Answer 1

Is that a group?

Can you use PSGetSID from SysInternals and check SID in AD for the user you are trying to add.
http://technet.microsoft.com/en-us/sysinternals/bb897417.aspx

---

Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog: http://blogs.msdn.com/blakhani
Team Blog: http://blogs.msdn.com/sqlserverfaq

Answer 2

Was this user got renamed or it was renamed from someone else?

 

You might not get result, but why not try to see what you got

SELECT SUSER_SNAME(SUSER_SID('TestComputer\User', 0)) ;

---

If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.

Sevengiants.com

Answer 3

Dear Balmukund,

Apologies, ihe SID examples are for a group and here is the return for your PSGetSID request:

C:\SysinternalsSuite>PSGETSID "DomainGroupA"

PsGetSid v1.43 - Translates SIDs to names and vice versa
Copyright (C) 1999-2006 Mark Russinovich
Sysinternals - www.sysinternals.com

SID for MyDomain\ DomainGroupA :
S-1-5-21-436374069-861567501-725345543-10378

Answer 4

Dear SevenGiants,

Per my response to Balmukund... my apologies, it is actually a group I am using in my initial example.

Either way, I ran your suggestion as a sysadmin: SELECT SUSER_SNAME(SUSER_SID(' MyDomain\DomainGroupA', 0)) ;

*Result: MyDomain\DomainGroupA

Answer 5

Dear SevenGiants,

Per my response to Balmukund... my apologies, it is actually a group I am using in my initial example.

Either way, I ran your suggestion as a sysadmin: SELECT SUSER_SNAME(SUSER_SID(' MyDomain\DomainGroupA', 0)) ;

*Result: MyDomain\DomainGroupA

This means the group is already in the system!?

SUSER_NAME : http://msdn.microsoft.com/en-us/library/ms187934.aspx

---

If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.

Sevengiants.com

Answer 6

Dear SevenGiants,

Please excuse my ignorance, but to run the script above, I note that 0x01 becomes 1 for SA, but what does 0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000 become?

Nick

 

Answer 7

Dear SevenGiants,

Please excuse my ignorance, but to run the script above, I note that 0x01 becomes 1 for SA, but what does 0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000 become?

Nick

 

Hi Nick,

I think the SUSER_SNAME() did tell you the group is there. which means  you wont be able to create a duplicated sid.

Just realised that when you doing the search again sys.server_principals you shouldn't use any quotes for SID

try just search like this

select * from sys.server_principals where sid = 0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000

you should get  a hit.

---

If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.

Sevengiants.com

Answer 8

Dear SevenGiants,

Thanks for your continued support here!

SELECT SUSER_SNAME(0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000) does return MyDomain\MyDomainGroupA

But, with or without quotes, select * from sys.server_principals where sid = 0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000 returns no results; this is what is "freaking" me out here!

Surely if I am getting it already exists, it must exist in some sys. ?!?! And I can't find a thing on the net that would suggest where!

Your insight is most appreciated!

Regards,

Nick

 

 

Answer 9

Dear SevenGiants,

Thanks for your continued support here!

SELECT SUSER_SNAME(0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000) does return MyDomain\MyDomainGroupA

But, with or without quotes, select * from sys.server_principals where sid = 0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000 returns no results; this is what is "freaking" me out here!

Surely if I am getting it already exists, it must exist in some sys. ?!?! And I can't find a thing on the net that would suggest where!

Your insight is most appreciated!

Regards,

Nick

 

 

how about checkdb(master)?

---

If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.

Sevengiants.com

Answer 10

Apologies Seven Giants,

 

Should have mentioned that I already treid a DBCC CHECKDB on master:

DBCC results for 'master'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 693 rows in 6 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 101 rows in 1 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 112 rows in 2 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 693 rows in 7 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 101 rows in 1 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 112 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 17 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysdbreg'.
There are 24 rows in 1 pages for object "sys.sysdbreg".
DBCC results for 'sys.sysprivs'.
There are 1802 rows in 17 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 72 rows in 3 pages for object "sys.sysschobjs".
DBCC results for 'sys.syslogshippers'.
There are 0 rows in 0 pages for object "sys.syslogshippers".
DBCC results for 'sys.syscolpars'.
There are 561 rows in 10 pages for object "sys.syscolpars".
DBCC results for 'sys.sysxlgns'.
There are 52 rows in 1 pages for object "sys.sysxlgns".
DBCC results for 'sys.sysxsrvs'.
There are 2 rows in 1 pages for object "sys.sysxsrvs".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.sysusermsgs'.
There are 0 rows in 0 pages for object "sys.sysusermsgs".
DBCC results for 'sys.syscerts'.
There are 5 rows in 1 pages for object "sys.syscerts".
DBCC results for 'sys.sysrmtlgns'.
There are 0 rows in 0 pages for object "sys.sysrmtlgns".
DBCC results for 'sys.syslnklgns'.
There are 3 rows in 1 pages for object "sys.syslnklgns".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 165 rows in 2 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 283 rows in 2 pages for object "sys.sysiscols".
DBCC results for 'sys.sysendpts'.
There are 5 rows in 1 pages for object "sys.sysendpts".
DBCC results for 'sys.syswebmethods'.
There are 0 rows in 0 pages for object "sys.syswebmethods".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 277 rows in 36 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 18 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 147 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 111 rows in 1 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 50 rows in 4 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 1 rows in 1 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syschildinsts'.
There are 0 rows in 0 pages for object "sys.syschildinsts".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 10 rows in 1 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'spt_fallback_db'.
There are 0 rows in 0 pages for object "spt_fallback_db".
DBCC results for 'spt_fallback_dev'.
There are 0 rows in 0 pages for object "spt_fallback_dev".
DBCC results for 'spt_fallback_usg'.
There are 0 rows in 0 pages for object "spt_fallback_usg".
DBCC results for 'sys.queue_messages_1003150619'.
There are 0 rows in 0 pages for object "sys.queue_messages_1003150619".
DBCC results for 'sys.queue_messages_1035150733'.
There are 0 rows in 0 pages for object "sys.queue_messages_1035150733".
DBCC results for 'sys.queue_messages_1067150847'.
There are 0 rows in 0 pages for object "sys.queue_messages_1067150847".
DBCC results for 'spt_monitor'.
There are 1 rows in 1 pages for object "spt_monitor".
DBCC results for 'spt_values'.
There are 2346 rows in 16 pages for object "spt_values".
DBCC results for 'MSreplication_options'.
There are 3 rows in 1 pages for object "MSreplication_options".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'.
DBCC results for 'mssqlsystemresource'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 792 rows in 7 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 148 rows in 1 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 159 rows in 2 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 792 rows in 7 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 148 rows in 1 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 159 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 14 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 20 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 2754 rows in 49 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 15799 rows in 290 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 2 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 3 rows in 1 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 348 rows in 6 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 506 rows in 3 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 3126 rows in 1181 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 16 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 766 rows in 5 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 1007 rows in 5 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 2 rows in 1 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 435 rows in 4 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 666 rows in 4 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 289 rows in 2 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 833 rows in 5 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 847 rows in 26 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syspalvalues'.
There are 384 rows in 3 pages for object "sys.syspalvalues".
DBCC results for 'sys.spt_server_info'.
There are 27 rows in 1 pages for object "sys.spt_server_info".
DBCC results for 'sys.spt_datatype_info'.
There are 66 rows in 1 pages for object "sys.spt_datatype_info".
DBCC results for 'sys.role_permissions'.
There are 169 rows in 2 pages for object "sys.role_permissions".
DBCC results for 'sys.sysbinpals'.
There are 45 rows in 1 pages for object "sys.sysbinpals".
DBCC results for 'sys.syscolrdb'.
There are 10710 rows in 165 pages for object "sys.syscolrdb".
DBCC results for 'sys.spt_provider_types'.
There are 27 rows in 1 pages for object "sys.spt_provider_types".
DBCC results for 'sys.syspalnames'.
There are 112 rows in 1 pages for object "sys.syspalnames".
DBCC results for 'sys.spt_permission_names'.
There are 5 rows in 1 pages for object "sys.spt_permission_names".
DBCC results for 'sys.sysobjrdb'.
There are 1771 rows in 24 pages for object "sys.sysobjrdb".
DBCC results for 'sys.spt_datatype_info_ext'.
There are 10 rows in 1 pages for object "sys.spt_datatype_info_ext".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'mssqlsystemresource'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

 

Any ideas?

Answer 11

Not sure if this is pertinent, but I do have another server that I have setup with similar users (incl. MyDomain\DomainUserA) and found the following...

select * from sys.server_principals where name = 'MyDomain\DomainUserA'

RESULT: MyDomain\DomainUserA    350    0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000    G    WINDOWS_GROUP    0    2011-03-07 07:20:26.873    2011-03-07 07:20:29.530    master    us_english    NULL

select * from sys.syslogins where name = 'MyDomain\DomainUserA'

RESULT: 0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000    9    2011-03-07 07:20:26.873    2011-03-07 07:20:29.530    2011-03-07 07:20:26.873    0    0    0    0    0    MyDomain\DomainUserA     master    NULL    us_english    0    1    1    1    0    1    0    0    0    0    0    0    0    MyDomain\DomainUserA

select SUSER_SID('MyDomain\DomainUserA')

RESULT: 0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000

select SUSER_SNAME(0x010500000000000515000000358A021A0D7A5A3307E53B2B8A280000)

RESULT: MyDomain\DomainUserA

But I imagine this would be expected assuming that nothing is wrong on this server?!?! *TEARS*

Answer 12

How about create a trace that logging all events ( especially errors warnings section)? Let's see when you are trying to add it, what would happen.

---

If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.

Sevengiants.com

Answer 13

First off, a huge thank-you for your efforts in helping me solve this!

Secondly, an apology for the fact that I found this to be an absoluetly STUPID reason/cause (NOOB)!

Thirdly, a "rookie" mistake... I should have gone to look at SQL Profiler in the first place!

I had a DDL trigger on CREATE_LOGIN which would "replicate" the creation of the login on our DR server by running a CREATE LOGIN on that DR server for the same user name; only problem is... I didn't forgot to code thetrigger to have it check whether the login existed on that end first; thus, the following transpired.

1. Create MyDomain\DomainUserA on PROD_SERVER (which created this user on DR_SERVER)

2. Delete/drop MyDomain\DomainUserA on PROD_SERVER (which DID NOT drop the user on DR_SERVER)

3. (Re)create MyDomain\DomainUserA on PROD_SERVER (which TRIES TO (re)create this user on DR_SERVER).

Thanks to all again and I hope this helps someone in the future!

Answer 14

First off, a huge thank-you for your efforts in helping me solve this!

Secondly, an apology for the fact that I found this to be an absoluetly STUPID reason/cause (NOOB)!

Thirdly, a "rookie" mistake... I should have gone to look at SQL Profiler in the first place!

I had a DDL trigger on CREATE_LOGIN which would "replicate" the creation of the login on our DR server by running a CREATE LOGIN on that DR server for the same user name; only problem is... I didn't forgot to code thetrigger to have it check whether the login existed on that end first; thus, the following transpired.

1. Create MyDomain\DomainUserA on PROD_SERVER (which created this user on DR_SERVER)

2. Delete/drop MyDomain\DomainUserA on PROD_SERVER (which DID NOT drop the user on DR_SERVER)

3. (Re)create MyDomain\DomainUserA on PROD_SERVER (which TRIES TO (re)create this user on DR_SERVER).

Thanks to all again and I hope this helps someone in the future!

Pleasure.

---

If you think my suggestion is useful, please rate it as helpful.
If it has helped you to resolve the problem, please Mark it as Answer.

Sevengiants.com