Helped.! SQL.!

Results 1 to 9 of 9
  1. #1
    OH Yes! Proud to be Me astig01998 is offline
    MemberRank
    Aug 2011 Join Date
    (Philippines)Location
    662Posts

    config Helped.! SQL.!

    Someone give me a SQL PASS Secure!
    and how to change "sa"? to another user?


  2. #2
    Account Upgraded | Title Enabled! tutero69 is offline
    MemberRank
    Jun 2010 Join Date
    1,028Posts

    Re: Helped.! SQL.!

    make your own pass much better if it is a

    combination of numbers and letters

    about changing " sa " check security of

    your SQL ,, BTW what SQL are you using ?

  3. #3
    OH Yes! Proud to be Me astig01998 is offline
    MemberRank
    Aug 2011 Join Date
    (Philippines)Location
    662Posts

    Re: Helped.! SQL.!

    im using SQL 2000 :D!

  4. #4

    Re: Helped.! SQL.!

    on enterprise manager on top menu left u can create new server user and pasr check it
    Posted via Mobile Device

  5. #5
    OH Yes! Proud to be Me astig01998 is offline
    MemberRank
    Aug 2011 Join Date
    (Philippines)Location
    662Posts

    Re: Helped.! SQL.!

    can u give me Screen shot of it?

  6. #6

    Re: Helped.! SQL.!

    here
    Code:
    http://msdn.microsoft.com/en-us/library/aa337562.aspx

  7. #7
    OH Yes! Proud to be Me astig01998 is offline
    MemberRank
    Aug 2011 Join Date
    (Philippines)Location
    662Posts

    Re: Helped.! SQL.!

    That is for SQL 2005

  8. #8

    Re: Helped.! SQL.!

    then
    Code:
    To create a login for the Spy Sweeper Enterprise Database:
    
    1. Open up SQL Server Enterprise Manager.
    2. Navigate to the Security folder.
    3. Expand the Security folder > Logins.
    4. Right click on Logins > New Login.
    5. On the general tab, enter a name for the login. Select SQL Server Authentication. Enter in a password. For the database dropdown, select the database that was created for Spy Sweeper Enterprise.
    6. On the Server Roles tab, verify that nothing is selected.
    7. On the Database Access tab, find the Spy Sweeper database that was created and select it.
    8. For the Permit in Database Role section, select public and db_owner. Please verify that nothing else is selected. Select OK.

  9. #9
    OH Yes! Proud to be Me astig01998 is offline
    MemberRank
    Aug 2011 Join Date
    (Philippines)Location
    662Posts

    Re: Helped.! SQL.!

    How about the "sa" they can connect there too :(

    "sa" have database access :(

    and i cant remove the permit in database access :( help



Advertisement