Post reply

unable to login via osql using SQL Server authentication -- Please help

  • June 18, 2004 at 6:50 am

    #87701

    I am trying to run a batch script using the command prompt utility osql. I am using MSDE 2000. I also want to use SQL Server authentication and not the Windows authenication. Windows authentication works fine but I want to use SQL server authentication. Below is the syntax I am using:

    osql -Uscott -Ptiger    -----> This gives me an error. But when I use the option -E and dont use U/P I can login. Can someone help me login using SQL Server authentication.

     

    Thanks,

    Srinivas.

  • June 21, 2004 at 6:06 am

    #511194

    What is the error you get?


    Cheers,
    - Mark

  • June 21, 2004 at 6:35 am

    #511198

    Mark,

           This issue has been resolved. I was not using the server name(-S) flag. Using this resolved my issue.

     

    Thanks,

    Srinivas.

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

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