Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 29 replies
  • Subscribers 1 subscriber
  • Views 25661 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Transfer SophosDB to remote server

tedz

Hi,

Need advice to transfer my sophosDB in a central console to remote server. 

Running SEC 4.7 

updrage to SEC 5.1 

what is the steps to do this? 

Regards,

tedz

:28377


This thread was automatically locked due to age.
Parents
  • 0

    Hi Jak,

    thanks for the reply. based on the logs im getting this error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    i checked the link you have given me for simulation purposes.

    Perform the following tests:

    1. Check that the SQL Server service referenced in the connection string established above is started.  Typically on a default installation this service is called 'SQL Server (SOPHOS)'. (yes)
    2. Ensure that the SQL server referenced in the connection string can be resolved by the management server (ping and nslookup). yes, can ping the sql server from management server
    3. Check that the SQL Server instance hosts the database name referenced in the connection string.
      sqlcmd -E -S .\sophos -Q "select name from sysdatabases" error encounter+++++

    C:\>sqlcmd -E -S .\sophos -Q "SOPHOS47"
    Msg 2812, Level 16, State 62, Server SOPHOSSEC\SOPHOS, Line 1
    Could not find stored procedure 'SOPHOS47'.

    4. Create a UDL test file to test connectivity to the SQL database and appropriate database. successful

    5. If the SQL Server instance is remote to the management server, check that SQL Server is accepting remote TCP/IP connections.  This can be checked using the 'SQL Server Configuration Manager', accessible from the Start menu. enabled

    :28883
Reply
  • 0

    Hi Jak,

    thanks for the reply. based on the logs im getting this error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    i checked the link you have given me for simulation purposes.

    Perform the following tests:

    1. Check that the SQL Server service referenced in the connection string established above is started.  Typically on a default installation this service is called 'SQL Server (SOPHOS)'. (yes)
    2. Ensure that the SQL server referenced in the connection string can be resolved by the management server (ping and nslookup). yes, can ping the sql server from management server
    3. Check that the SQL Server instance hosts the database name referenced in the connection string.
      sqlcmd -E -S .\sophos -Q "select name from sysdatabases" error encounter+++++

    C:\>sqlcmd -E -S .\sophos -Q "SOPHOS47"
    Msg 2812, Level 16, State 62, Server SOPHOSSEC\SOPHOS, Line 1
    Could not find stored procedure 'SOPHOS47'.

    4. Create a UDL test file to test connectivity to the SQL database and appropriate database. successful

    5. If the SQL Server instance is remote to the management server, check that SQL Server is accepting remote TCP/IP connections.  This can be checked using the 'SQL Server Configuration Manager', accessible from the Start menu. enabled

    :28883
Children
No Data