Wednesday 2 May 2012

Installing Lync Database Error

Problem:
When installing the Lync Server Databases the following error was thrown;
Installed SQL Server 2005 Backward Compatibility version is 8.05.2312
Connecting to SQL Server on
SqlMajorVersion : 10
SqlMinorVersion : 50
SqlBuildNo : 2500
SQL version is acceptable: 10.50.2500.0
Default database data file path is D:\Data
Default database log file path is E:\Logs
Database doesn't exist.
(Database rgsconfig doesn't exist.)
Creating database rgsconfig
    DbFile : PhysicalName = d:\data\rgsconfig.mdf
    LogFile: PhysicalName = e:\logs\rgsconfig.ldf
Failed to create database rgsconfig
Error (
  name:        Error
  description:
  number:      -2147221504
  message:    
)
---------------
Exit code: ERROR_CREATE_DB (-4)
---------------


Resolution:

To resolve this issue I followed this TechNet article; http://support.microsoft.com/kb/2502792
Before re-running the Install Databases you will need to delete the database that failed to create, in my instance the “rgsconfig” database. You can also run the Install-Database cmdlet from Lync Management shell with the -clean switch. Other wise you will receive the following error:
---------------
Installed SQL Server 2005 Backward Compatibility version is 8.05.2312
Connecting to SQL Server on isp-osb-lyncsql
SqlMajorVersion : 10
SqlMinorVersion : 50
SqlBuildNo : 2500
SQL version is acceptable: 10.50.2500.0
Default database data file path is D:\Data
Default database log file path is E:\Logs
Opened database rgsconfig
Opened database rgsconfig

Db version unknown. Clean install required.
Database rgsconfig exists, but needs to be installed with /clean
---------------
Exit code: ERROR_DATABASE_REQUIRES_CLEAN (-25)
When running /dbexists, non-zero exit codes are not necessarily errors

---------------

Any questions please email me; james.rogers@4logic.com.au

No comments:

Post a Comment