Hi,
It was the startup parameters for SQL server within the Sql server
enterprise. I can manually start the SQL Server with the parameters. I can
put them in the registry. After I start the SQL server manually I can put
them using the SQL server enterprise. However if I stop the manual start,
the startup parameters disappear from the registry and I cannot connect
using the SQL server enterprise.
[quoted text, click to view] "Edwin vMierlo" wrote:
>
>
> > Is there a way to readd the startup options for a server
>
> what service ?
> (assuming that you mean service, and not server)
>
> also, what startup options did you delete ?
>
>
You can go into the services applet from control panel and add them
manually.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
[quoted text, click to view] "snazzy" <snazzy@discussions.microsoft.com> wrote in message
news:79A9286C-922F-453F-837A-D87657D3D5E1@microsoft.com...
> Hi,
> It was the startup parameters for SQL server within the Sql server
> enterprise. I can manually start the SQL Server with the parameters. I
> can
> put them in the registry. After I start the SQL server manually I can put
> them using the SQL server enterprise. However if I stop the manual start,
> the startup parameters disappear from the registry and I cannot connect
> using the SQL server enterprise.
>
> "Edwin vMierlo" wrote:
>
>>
>>
>> > Is there a way to readd the startup options for a server
>>
>> what service ?
>> (assuming that you mean service, and not server)
>>
>> also, what startup options did you delete ?
>>
>>
>>
The quorum replicates the deleted entries on cluster resource startup.
You will have to perform the cluster quorum registry repair sequence I
submitted to you in a previous post.
Good luck.
Anthony Thomas
--
[quoted text, click to view] "snazzy" <snazzy@discussions.microsoft.com> wrote in message
news:79A9286C-922F-453F-837A-D87657D3D5E1@microsoft.com...
> Hi,
> It was the startup parameters for SQL server within the Sql server
> enterprise. I can manually start the SQL Server with the parameters. I
can
> put them in the registry. After I start the SQL server manually I can put
> them using the SQL server enterprise. However if I stop the manual start,
> the startup parameters disappear from the registry and I cannot connect
> using the SQL server enterprise.
>
> "Edwin vMierlo" wrote:
>
> >
> >
> > > Is there a way to readd the startup options for a server
> >
> > what service ?
> > (assuming that you mean service, and not server)
> >
> > also, what startup options did you delete ?
> >
> >
> >
I am assuming that you want to keep the registry options as is after
reboots. the best way to do is to use clusterrecovery.exe that comes with
win2k3 resource kit.
this will make the registry entries to stick as is even after the reboots
thx
J
[quoted text, click to view] "Anthony Thomas" <ALThomas@kc.rr.com> wrote in message
news:%23kmB3kqeHHA.4128@TK2MSFTNGP05.phx.gbl...
> The quorum replicates the deleted entries on cluster resource startup.
>
> You will have to perform the cluster quorum registry repair sequence I
> submitted to you in a previous post.
>
> Good luck.
>
>
> Anthony Thomas
>
>
> --
>
> "snazzy" <snazzy@discussions.microsoft.com> wrote in message
> news:79A9286C-922F-453F-837A-D87657D3D5E1@microsoft.com...
>> Hi,
>> It was the startup parameters for SQL server within the Sql server
>> enterprise. I can manually start the SQL Server with the parameters. I
> can
>> put them in the registry. After I start the SQL server manually I can
>> put
>> them using the SQL server enterprise. However if I stop the manual
>> start,
>> the startup parameters disappear from the registry and I cannot connect
>> using the SQL server enterprise.
>>
>> "Edwin vMierlo" wrote:
>>
>> >
>> >
>> > > Is there a way to readd the startup options for a server
>> >
>> > what service ?
>> > (assuming that you mean service, and not server)
>> >
>> > also, what startup options did you delete ?
>> >
>> >
>> >
>
>
Don't see what you're looking for? Try a search.
