SQL server not starting

• alovegrove

  SSC Rookie

  Points: 25

  More actions

  March 18, 2008 at 11:38 am

  #188322

  I currently have a problem starting the SQL server instance on our server. This has happened to me after I moved and re-attached the master database. I changed the entries for the parameters of the master data and log files to their new location by right clicking on the instance name, going to ‘Properties’ and ‘Startup Parameters’. I then stopped SQL server and moved over the master data and log files. I attempted to restart SQL server but it came up with the following message.

  'A connection could not be established to 10.0.137.3\ts28a.

  Reason - SQL Server does not exists or access denied. Connection Open (Connect())..

  Please verify SQL Server uis running and check your SQL server registration properties (by right-clicking on the 10.0.137.3\ts28a node) and try again'

  Any ideas why this may be happening? I’ve checked the registration properties and they seem to be fine and also have tried manually starting the service but have had no joy.

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  March 18, 2008 at 12:25 pm

  #791047

  Move your master database files back;

  Modify their paths from the server properties;

  ...

  For detail, refer to the link below.

  http://support.microsoft.com/kb/224071