Post reply

OSQL - [Shared Memory]SQL Server does not exist or access denied.

  • September 3, 2008 at 8:58 am

    #190094

    I am unable to run a very simple OSQL query:

    C:> osql -E -q "select getdate()"

    I get this error message:

    [Shared Memory]SQL Server does not exist or access denied.

    [Shared Memory]ConnectionOpen (Connect()).

    I am an administrator on the local machine, and my AD user has sysdba privs on the SQL Server.

    :w00t:

    What do I need to do, to get this to work???

    Thank you greatly.

    Jason

  • September 3, 2008 at 10:27 am

    #866632

    I figured it out....

    The problem was this machine has no default instance, and 2 named instances.

    Once I added a -s SERVER\INSTANCE to the command line...it worked.

  • July 8, 2012 at 9:17 pm

    #1510158

    do you add the instance at the end of your command line?

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

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