HELP osql

• carolina garcia

  Mr or Mrs. 500

  Points: 537

  More actions

  June 28, 2004 at 7:59 am

  #66016

  Hi

  Can anybody help me? I have a server (cluster) and i am trying to install our maintenance. The maintance was installed succesfully in one of the server but the other one is not working. When we try to run it we get this message:

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

  [Shared Memory]ConnectionOpen (Connect()).

  The scripts run O.K. using SQL Query Analyzer, but when ewe tried to run it using osql (Sql Server AGent ) is not working.

  Any suggestions??? Thank you so much!!!

   

• dbuchan

  SSCrazy

  Points: 2278

  More actions

  June 29, 2004 at 12:40 am

  #512350

  As long as you get no errors, probably you need to explictly reference the named instance e.g.

  OSQL -Uhewhoisgod -Ppassword -dLive -SCCSQLDOCS\INSTDOCS -iE:\SQLStuff\NEWPROF1.SQL  -h-1 -w300 -n

  Where select @@servername gives you the name to use. The (local) reference will not work on a cluster.

  DB

   

  
  The systems fine with no users loggged in. Can we keep it that way ?br>

• r_monov

  SSC Journeyman

  Points: 91

  More actions

  June 30, 2004 at 2:39 pm

  #512757

  If the machine name was changed after the SQL server have been installed some connnections will fail. Check these :

  sp_helpserver 'SERVERNAME'

  Select SERVERPROPERTY ('SERVERNAME')

  SELECT SERVERPROPERTY ('SERVERNAME')

  SELECT @@SERVERNAME