Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2013

    Unanswered: Issue with the device activation while accessing database

    imsu2@harsh:/home/fnb/harsh> uatdb
    Msg 840, Level 17, State 2:
    Server 'IMSU2':
    Device 'uat_log1' (with physical name '/fnb/dbdevice1/uat_log1', and virtual
    device number 33) has not been correctly activated at startup time. Please
    contact a user with System Administrator (SA) role.
    Msg 4001, Level 11, State 1:
    Server 'IMSU2':
    Cannot open default database 'uatdb'.

    Plz help


  2. #2
    Join Date
    Mar 2008
    Seems there is a device initilazation issue during last sybase server start up.
    Possible reason is that the device don't have proper permissions for sybase user.
    Please go through you ASE error log and search for the message for the device in question there.
    Also check the physical file's permission which is related to the logical sybase device, get this fixed by OS admin and reboot the system.
    This would also have caused your database offline, which are using the device in question.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts