Connection problem using EM, but not command line

• Nancy Lytle-175868

  SSC Rookie

  Points: 31

  More actions

  January 3, 2007 at 8:25 am

  #176234

  My supervisor asked me to move the database mdf and ldf files which had been installed in a default location.  The data files were moved to one drive and the log files to a different drive.  I followed the MS instructions for moving user and systems files (using Query Analyzer and EM for startup properties as needed).  The move seemed to work fine, but after when I got to the point of moving the Master database files (remove the listings from the startup parameters, stop SQL Server, move the files, restart, something went wrong.  I could not get SQL Server to restart, except by using the command line.  Now the SQL Server service will not start, or it starts and stops immediately. If I start using the command line, I can use Query Analyzer without a problem, otherwise I get an Unable to connect to server error (Msg 17, level 16, state 1 ...[shared memory] SQL Server does not exist or access is denied.

  The error I when trying to start it in EM is: A connection could not be established (LOCAL) Reason: SQL Server does not exist or access is denied.  Please verify SQL Server is running and check your SQL Server registration.....

  This is SQL Server 2000 (8.00.2039) on Windows 2003 sp1, and I am doing a remote desktop into the server.

  I rebooted the server and this didn't make a difference.

  Any ideas, suggestions?  All appreciated.

  TIA,

  Nancy

   

• Jo Pattyn

  SSC-Dedicated

  Points: 32473

  More actions

  January 4, 2007 at 11:08 am

  #681273

  Have you checked the event logs?

• Nancy Lytle-175868

  SSC Rookie

  Points: 31

  More actions

  January 4, 2007 at 2:39 pm

  #681341

  These are the types of messages I could locate: But access should not have been a problem since I was logged in as an administrator.

  17050:

  initerrlog: Could not open error log file 'L:\SQLServer\Log\ERRORLOG'. Operating system error = 5(Access is denied)

  17204 :

  FCB:pen failed: Could not open device L:\SQLServer\Log\mastlog.ldf for virtual device number (VDN) 2

  17204 :

  FCB:pen failed: Could not open device E:\SQLServer\Data\master.mdf for virtual device number (VDN) 1.

   

  Nancy

   

• Jo Pattyn

  SSC-Dedicated

  Points: 32473

  More actions

  January 5, 2007 at 10:24 am

  #681527

  Have you tried starting sql server from the command line

  with the

  -dmaster_data_file_path

  -lmaster_log_file_path

  -eerror_log_path

  parameters ?

  example :

  sqlserver.exe -dC:\MyNewDBLocation\master.mdf -lC:\MyNewLogLocation\master.ldf -eC:\MyNewErrorLocation\ERRORLOG

  Since L & E seems to be unavailable (see event viewer)