Post reply

MSDE Authentication Mode/ sa Account & osql

  • August 13, 2004 at 10:13 am

    #161312

    Hi, there isn't an icon that sums up my state of mind regarding using osql. I'm trying to see what type of authentication my MSDE instance is using. I've followed the instructions in MS KB 322336 which tells me that I'm using Windows Authentication. So I now want to change the sa password so it tells me to type the following: 

    "To connect by using Windows authentication, type this command: use osql -E"

    to which I get the reply "'USE' is not recognised as an internal or external command......"

    Any ideas?

  • August 13, 2004 at 12:07 pm

    #518939

    osql.exe -Syoursqlservername -E

     

  • August 16, 2004 at 10:55 am

    #519182

    Thanks, I'll give it a go.

  • August 16, 2004 at 3:04 pm

    #519218

    Check the registry, HKLM\Software\Microsoft\MSSQLServer\MSSQLServer (or instance name).  Look at the data in the LoginMode.  If it is 2 you are using SQL Mixed Mode, otherwise you are using NT Authentication.

    Don

Viewing 4 posts - 1 through 3 (of 3 total)

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