Results 1 to 4 of 4

Thread: Error with osql

  1. #1
    Join Date
    Mar 2004

    Unanswered: Error with osql

    Locally executing osql to create db files on a remote Webserver, I get this error:

    41> 42> 43> 44> 45> Meldung 916, Ebene 14, Status 1, Server USER-EQ9OV60EMF, Zeile 12
    Server user 'Robse_Testlogin' is not a valid user in database 'msdb'.

    (The above is german and translates into "Message 916, Level 14,..., Row 12")

    This is the command with parameters:

    osql -S servername -U Robse_Testlogin -P password -i c:\Store\storedb.sql"

    Up to that line, everything works fine...what could be wrong?
    Last edited by Robse; 04-21-04 at 15:00.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    My first guess would be that you are trying to get Job related data from one of the msdb tables, and your server login doesn't have permission to SELECT from that table. That is only a guess, but it is a place to start.


  3. #3
    Join Date
    Dec 2002
    Antwerp, Belgium
    You have created a database login called 'Robse_Testlogin', but didn't give it access to the msdb database. When you have done this, you need to assign permissions.

  4. #4
    Join Date
    Mar 2004
    OK Thank you I shall try and create Permissions for this Login
    Last edited by Robse; 04-21-04 at 17:23.

Posting Permissions

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