Transfer SophosDB to remote server

HI,

Edit, I just re-read your post to see the command again:

sqlcmd -E -S .\sophos -Q "EXEC sp_helplogins @LoginNamePattern ='SOPHOSSEC\Sophos DB Admins'"

Doesn't look right, what is SOPHOSEC, this should be being run on the SQLServer, so the command should be:

sqlcmd -E -S .\sophos -Q "EXEC sp_helplogins @LoginNamePattern ='SQLSERVER\Sophos DB Admins'"

As Sophos DB Admins is a local group on SQLSERVER.

I think we need to confirm the environment as this is getting confusing.

• Your domain is called DELL (seems an odd name for a domain, sounds more like a computer name)
• SQL server is called SQLSERVER
• Both the management server and SQLServer are in the same DELL domain
• SophosManagement is a domain account that can therefore be referenced DELL\SophosManagement
• Based on the previous command you ran Is the SEC server called SOPHOSSEC then? 

There are potentially a number of combinations regarding the account depending on the environment.

• If the 2 computers are in a domain then typically you would use a domain account.
• If the 2 computers are in a workgroup then you would have to create SophosManagement on both computers with the same password.  When you ran the installer on the SQL server you would choose the local account and likewise when you instal the management component on the management server you would use the local account.
• If the SEC server is in a domain and the SQL server is in a workgroup and the SEC server is not a DC, you could create a local SophosManagement account on both with the same password.  You would choose the local accounts when you ran both installers.
• If the SEC server is a DC and the SQL server is a member server you would just create one domain "SophosManagement" account and enter the same account when running both installers.
• If the SEC server is a DC and the SQL server is in a workgroup, you would create a domain account on the DC called SophosManageemnt and a local account on the SQL Server called "SophosManagement".

Regards,

Jak

HI,

Edit, I just re-read your post to see the command again:

sqlcmd -E -S .\sophos -Q "EXEC sp_helplogins @LoginNamePattern ='SOPHOSSEC\Sophos DB Admins'"

Doesn't look right, what is SOPHOSEC, this should be being run on the SQLServer, so the command should be:

sqlcmd -E -S .\sophos -Q "EXEC sp_helplogins @LoginNamePattern ='SQLSERVER\Sophos DB Admins'"

As Sophos DB Admins is a local group on SQLSERVER.

I think we need to confirm the environment as this is getting confusing.

• Your domain is called DELL (seems an odd name for a domain, sounds more like a computer name)
• SQL server is called SQLSERVER
• Both the management server and SQLServer are in the same DELL domain
• SophosManagement is a domain account that can therefore be referenced DELL\SophosManagement
• Based on the previous command you ran Is the SEC server called SOPHOSSEC then? 

There are potentially a number of combinations regarding the account depending on the environment.

• If the 2 computers are in a domain then typically you would use a domain account.
• If the 2 computers are in a workgroup then you would have to create SophosManagement on both computers with the same password.  When you ran the installer on the SQL server you would choose the local account and likewise when you instal the management component on the management server you would use the local account.
• If the SEC server is in a domain and the SQL server is in a workgroup and the SEC server is not a DC, you could create a local SophosManagement account on both with the same password.  You would choose the local accounts when you ran both installers.
• If the SEC server is a DC and the SQL server is a member server you would just create one domain "SophosManagement" account and enter the same account when running both installers.
• If the SEC server is a DC and the SQL server is in a workgroup, you would create a domain account on the DC called SophosManageemnt and a local account on the SQL Server called "SophosManagement".

Regards,

Jak