June 28, 2004 at 7:59 am
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!!!
June 29, 2004 at 12:40 am
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>
June 30, 2004 at 2:39 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply