SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict AHMED's Avatar
    Join Date
    Oct 2002
    Location
    Egypt
    Posts
    399
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    new database user

    hi all
    i have an asp app runing with sql server 2000 and i have created a user in the database called ahmed with some good permissions

    till now it's cool .....

    now i need to create an ew user with another permissions so i found that i must specify another login name

    the user name ahmed has the login name THINK-TANK\IUSR_THINK-TANK

    (my computer name is think-tank)

    so what is the right login name for the new user and what is the different between login names ?
    and also how can i create a new password for the new user

    thx

  2. #2
    SitePoint Addict AHMED's Avatar
    Join Date
    Oct 2002
    Location
    Egypt
    Posts
    399
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    any ideas ?

  3. #3
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, you seem to be confusing things.

    You have created a login for a windows user (THINK-TANK\IUSR_THINK-TANK). You can also create SQL Users for use only in the Database and not within Windows. When using SQL Enterp. manager, just type in a new Username instead of choosing one from the list. In the next stage you can assign a password to your (database) user.


Bookmarks

Posting Permissions

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