SLQ Server [need help ] Found my id and pass

Results 1 to 12 of 12
  1. #1
    Member yuki69 is offline
    MemberRank
    Mar 2007 Join Date
    53Posts

    SLQ Server [need help ] Found my id and pass

    Hello Ragezoner , i need help i don't have my id and pass my sql ...

    I know we can lauch without id and pass , but i need for change info in server.txt ...

    My question : How found my id and pass Sql ?


  2. #2
    Proficient Member -RooK- is offline
    MemberRank
    Jun 2007 Join Date
    171Posts

    Re: SLQ Server [need help ] Found my id and pass

    Id = "sa" w/o ""

    to get pass, just login via windows auth. and follow these steps

    Security > Logins > Right click "sa" > type in new password and then re-type to confirm then hit ok

    Once doing this, new user/pass = sa/whateveryoutyped

  3. #3
    Member yuki69 is offline
    MemberRank
    Mar 2007 Join Date
    53Posts

    Re: SLQ Server [need help ] Found my id and pass

    Where is security ? XD

    i am french sorry ...

  4. #4
    Proficient Member -RooK- is offline
    MemberRank
    Jun 2007 Join Date
    171Posts

    Re: SLQ Server [need help ] Found my id and pass

    security is located on the left hand side right under database

  5. #5
    Member yuki69 is offline
    MemberRank
    Mar 2007 Join Date
    53Posts

    Re: SLQ Server [need help ] Found my id and pass

    Can u make screen ? plz

  6. #6
    Proficient Member -RooK- is offline
    MemberRank
    Jun 2007 Join Date
    171Posts

    Re: SLQ Server [need help ] Found my id and pass

    Here is a s/s of where to find user 'sa', all you need to do is follow the other instructions I posted
    Attached Thumbnails Attached Thumbnails sql.bmp  

  7. #7
    Member yuki69 is offline
    MemberRank
    Mar 2007 Join Date
    53Posts

    Re: SLQ Server [need help ] Found my id and pass

    Ty but i can't change my pass ..

  8. #8
    Proficient Member -RooK- is offline
    MemberRank
    Jun 2007 Join Date
    171Posts

    Re: SLQ Server [need help ] Found my id and pass

    just right click on sa and click properties
    fill in passwords and should be it

  9. #9
    The beer?? Its here !!! Rotana is offline
    MemberRank
    Jan 2007 Join Date
    The NetherlandsLocation
    1,733Posts

    Re: SLQ Server [need help ] Found my id and pass

    this shut do it
    Code:
    USE [master]
    GO
    ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master],
    DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
    GO
    USE [master]
    GO
    ALTER LOGIN [sa] WITH PASSWORD=N'blah' MUST_CHANGE
    GO

  10. #10
    Member redhellhound is offline
    MemberRank
    Sep 2007 Join Date
    BC, Canada! EHLocation
    99Posts

    Re: SLQ Server [need help ] Found my id and pass

    the query wont work because my computer has windows 2002 lol

  11. #11
    Member Spawn. is offline
    MemberRank
    Sep 2007 Join Date
    HeavenLocation
    94Posts

    Re: SLQ Server [need help ] Found my id and pass

    SQL Manger

  12. #12
    Member redhellhound is offline
    MemberRank
    Sep 2007 Join Date
    BC, Canada! EHLocation
    99Posts

    Re: SLQ Server [need help ] Found my id and pass

    you mean manager? and how can i change the password with my version of windows. or give me the download for the updated system >.<



Advertisement