Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: OSQL didn't like rookies

    Sory for fullish question,but i'm coming from DB2 and Oracle world,and not SQL world.
    How I can understand,OSQL utility is command-line utility in SQL server.So,I tried to start it,but it failed with error:
    Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.

    There is some properties for my sqlserver:
    Authentication is "Windows only".User Administrator is admin on machine.In Windows services,there is one servis ( started) and logon for that service is Administrator.In fact,my SQL server works fine,because other GUIs works ok.
    SQLSERVERNAME=hostname=navtest.
    I tried to logon by entering in cmd this
    osql -S NAVTEST
    but every time I see error :
    Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.
    What i am doing wrong?
    Every help will be great

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Just because the sql service runs under the Administrator's account doesn't meen the Administrator can log onto the SQL Server.

    By default, the Microsoft SQL Server setup creates the "BUILTIN\Administrators" login, which gives any account in the Local Administrators group system administrator (sa) privileges. Most people delete this account, could be the problem you are facing.

    You can add the local Admin account back and grant that account sa privileges.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Jan 2002
    Posts
    165
    Thanks,Paul!
    I entered osql -s <servername> -E and it works!
    Now,I tried to enter some commands,but I don't know how to end it.
    I tried this:
    1> select * from northwind.......
    2>
    3> /
    4>

    Now,how You say to SQLSERVER execute commands?

    Thanks a lot,Zvonimir

  4. #4
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    hum... when you tried the -E what userid had you logged in with?

    go terminates a block of commands.
    Last edited by Paul Young; 08-18-03 at 11:08.
    Paul Young
    (Knowledge is power! Get some!)

  5. #5
    Join Date
    Jan 2002
    Posts
    165
    I find that switch -E by searching this forum....
    And GO really works!!!

    Thanks,Zvonimir

  6. #6
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Could have also found it by looking in Books Online. You can also change the command terminator with the -c switch.

    btw, what userid were you using when you had success with the -E switch, Administrator?
    Paul Young
    (Knowledge is power! Get some!)

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    -E switch explicitly specifies your intent to log on using trusted connection. The default behavior for OSQL is to use Standard SQL Server Security. That's why Z was getting his(/her) error at the beginning. With -E switch the logon succeeded using security context of the currently logged on user, - Administrator.

Posting Permissions

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