locked
OCS R2 Enterprise Database installation issues RRS feed

  • Question

  • Trying to set up OCS r2 enterprise, and running into problems with the DB install.

    When trying to install from the OCS server I am getting the initail pool setup screen, enter my info there and it validates that the SQL server is available and it can get to it, we have removed the rights from the user that is installing and it fails at the check, so we know that it is getting a connection to the server.

    We then get to the location of the install and enter the path, but when we go next the reply from the setup is "database installation path must be a valid local path" and the browse buttons are grayed out.

    I have verified that the user we are installing as has rights to the directory, and we have tried both UNC and D:\MSSQL.1\MSSQL\Data, with no luck

    Any help would be appreciated
    Tuesday, September 15, 2009 3:58 PM

All replies

  • On the Pool Name, Domain, Back-End window the correct format when using a named instance for the SQL Server is servername\instancename (e.g. sqlserver01\ocsfe01).  If you are using the default SQL instance (MSSQLSERVER) then the correct format is sinple just the servername with the \instance appended to it (e.g. sqlserver01)

    But if you are talking about the later Locations for Backend Databases window, then those need to be absolute paths to where the files would be stored on the remote SQL server. (e.g. F:\OCSSQL2005\MSSQL.1\MSSQL\Data)
    Jeff Schertz, PointBridge | MVP | MCITP: Enterprise Messaging | MCTS: OCS
    Tuesday, September 15, 2009 5:49 PM
    Moderator
  • On the first window we put it to SQLSERVER with no instance, no instances to install it to.

    It does a check of the DB server after that and we are allowed to continue.

    The later locations we put it in as an absolute path and then it checks and replies that "database installation path must be a valid local path, and there is no way to use the browse button as that is grayed out, and we are unable to click on the button to see if we can even place it somewhere else.
    Tuesday, September 15, 2009 7:32 PM
  • What are you putting in for the absolute path?  This should be a valid drive/location on the SQL server where you want the OCS files to be created, no the locate of any existing .db files.  So you should be able to enter something as simple as "C:\NewFolder" where that folder name does not yet exist on the SQL server.
    Jeff Schertz, PointBridge | MVP | MCITP: Enterprise Messaging | MCTS: OCS
    Wednesday, September 16, 2009 2:59 PM
    Moderator
  • Hi
    Any update for your issue?

    Thanks.
    Regards!
    Monday, September 21, 2009 8:39 AM
    Moderator