Post reply

db user problem

  • January 3, 2007 at 12:21 am

    #171662

    Hi,

    Strange problem in SQL 2005 Express, suddenly existing user-properties cannot be accessed, we get the following message:

    Property IsLocked is not available for Login '[SQLtest]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo).

    User cannot connect to db anymore.

    When I create a new user and leave the password encryption on, above message appears, when I create user with password encryption off, it works fine.

    It's a clean db-install, no data is transferred from a SQL 2000 instance.

    Anyone seen this problem? Any suggestions?

  • January 4, 2007 at 8:56 am

    #681235

    Not familiar with SQL Express, but in 2000 creating a login with password encryption set to off meant you did not encrypt the password going into syslogins.  This was used if you scripted out the password from syslogins to be able to recreate the password without knowing it.  Like when moving logins to a new server.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply