CCE5.0 and SQL2008 Standard

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • mjervis01
    Member
    • Jan 2011
    • 9

    CCE5.0 and SQL2008 Standard

    I am trying to re-install CCE5 on a new server and the client has upgraded to SQL2008 Standard on a separate server.
    I have succesfully installed and connected to the ASMS Control and Contact Databases but cannot run the .bat file for the Configuration Server in order to add users. I can run this on the local server with SQL Express but cannot run it locally on the new SQL Standard server.
    Is there any limitations on running on SQL2008 Standard or is there something I am missing?

    Thanks
  • aapawan123
    Hot Shot
    • Jan 2011
    • 18

    #2
    Please make sure the MS SQL Server 2008 xp_cmdshell is enabled. You can do so by executing the SQL command on the MS SQL Server 2008.

    EXEC sp_configure 'show advanced options', 1
    GO
    RECONFIGURE
    GO
    EXEC sp_configure 'xp_cmdshell', 1
    GO
    RECONFIGURE
    GO

    To disable the xp_cmdshell, execute the following:

    EXEC sp_configure 'xp_cmdshell', 1
    GO
    RECONFIGURE
    GO

    Comment

    Loading