2 instant of SQL Server, but 1 instant cannot start. Urgent help.  
Author Message
gasagram





PostPosted: Sun Apr 03 21:24:22 CDT 2005 Top

SQL Server >> 2 instant of SQL Server, but 1 instant cannot start. Urgent help.

In our production machine. I have 2 instants of SQL server. one of them
failed to connect.

When I start it. Service Control Failure - "An error 1060 - (The Specified
service does not exist as an installed service) Occurred while performing
this service operation on the MSSQL Server Service.

When I click on Properties, an Error : A connection could not be established
to Server\MicrosoftBCM. Reason : SQL Server does not exist or access denied.
Connection Open(connect()).. Please verify SQL Server is running and check
your SQL Server registration properties and try again.


When I Edit SQL Server Registration properties, SQL Server registration
failed because of the connection failure displayed below. Do you wish to
Mdify anyway?
SQL Server does not exist or access denied. ConnectionOpen(connect()).

Please help to activate the instant. Urgent

SQL Server305  
 
 
Hari





PostPosted: Sun Apr 03 21:24:22 CDT 2005 Top

SQL Server >> 2 instant of SQL Server, but 1 instant cannot start. Urgent help. Hi Kam,

If you need to see whats really happening during startup then execute the
below command from command prompt.
This will give you an odf errors as well.

For Defaut instance:
----------------------
sqlservr.exe -c

For Named instance
----------------------
sqlservr.exe -c -s {instancename}

--
Thanks
Hari
SQL Server MVP



> In our production machine. I have 2 instants of SQL server. one of them
> failed to connect.
>
> When I start it. Service Control Failure - "An error 1060 - (The Specified
> service does not exist as an installed service) Occurred while performing
> this service operation on the MSSQL Server Service.
>
> When I click on Properties, an Error : A connection could not be
> established
> to Server\MicrosoftBCM. Reason : SQL Server does not exist or access
> denied.
> Connection Open(connect()).. Please verify SQL Server is running and check
> your SQL Server registration properties and try again.
>
>
> When I Edit SQL Server Registration properties, SQL Server registration
> failed because of the connection failure displayed below. Do you wish to
> Mdify anyway?
> SQL Server does not exist or access denied. ConnectionOpen(connect()).
>
> Please help to activate the instant. Urgent
>


 
 
Kam





PostPosted: Sun Apr 03 22:27:02 CDT 2005 Top

SQL Server >> 2 instant of SQL Server, but 1 instant cannot start. Urgent help. I run with the following error - SQL Server could nor find specified named
instance (microsoftbcm)-please specify the name of an existing instance on
the invocation of sqlservr.exe

If you believe that your installation is corrupt or has been tampered with,
uninstall then re-run setup to correct this problem.

I think the trouble may come from the uninstall the ms Project. the sql
desktop edition may installed via the installation of ms project.

Is there any way that I can re-activate the desktop instance without lossing
the local packages that I created under the desktop edition.

The standard edition on the same server do not have any problem.

thanks.


> Hi Kam,
>
> If you need to see whats really happening during startup then execute the
> below command from command prompt.
> This will give you an odf errors as well.
>
> For Defaut instance:
> ----------------------
> sqlservr.exe -c
>
> For Named instance
> ----------------------
> sqlservr.exe -c -s {instancename}
>
> --
> Thanks
> Hari
> SQL Server MVP
>


> > In our production machine. I have 2 instants of SQL server. one of them
> > failed to connect.
> >
> > When I start it. Service Control Failure - "An error 1060 - (The Specified
> > service does not exist as an installed service) Occurred while performing
> > this service operation on the MSSQL Server Service.
> >
> > When I click on Properties, an Error : A connection could not be
> > established
> > to Server\MicrosoftBCM. Reason : SQL Server does not exist or access
> > denied.
> > Connection Open(connect()).. Please verify SQL Server is running and check
> > your SQL Server registration properties and try again.
> >
> >
> > When I Edit SQL Server Registration properties, SQL Server registration
> > failed because of the connection failure displayed below. Do you wish to
> > Mdify anyway?
> > SQL Server does not exist or access denied. ConnectionOpen(connect()).
> >
> > Please help to activate the instant. Urgent
> >
>
>
>