User management changes in SQL 2005

• Grann0n

  Newbie

  Points: 2

  More actions

  October 25, 2005 at 7:45 am

  #166422

  Hi all,

  I'm working on a dedicated software wich was first create on SQL 97.

  Due to SQL 2005 express licensing, I'm planning to offer the capability to use it for some users but I get a problem and I don't know where to search

  The software get users login directly from the database sql users (and not from a table in the database) but I can't fetch them actually.

  Is there a change in role management or in security diagramm wich can explain that ?

  Thank you for help

• Grann0n

  Newbie

  Points: 2

  More actions

  October 28, 2005 at 3:21 am

  #600835

  I'm back with some clues but no response

  I looked in the software code and I found that users are collecting from the sysusers table. So it works on SQL 2000 but no more in SQL 2005.

  Does anyone got idea to collect Security/Users list instead of the SQL 2000 sysusers values ?

   

  Thank you