Can not start server after setting open objects to 2147483647

SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
TammyTry starting the server using the -f option, then change this value back to 0.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I can
> not start the server any more, nor can I set open objects to a smaller value.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:
> Try starting the server using the -f option, then change this value back to 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> > SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> >
> > I set open objects to 2147483647 for research purpose. After I did it, I can
> > not start the server any more, nor can I set open objects to a smaller value.
> > The error message I got was:
> > [Shared Memory]SQL Server does not exist or access denied.
> > [Shared Memory]ConnectionOpen (Connect()).
> >
> > What should I do to be able to start the server again?
> >
> > Thank you,
> > Tammy
>

Can not start server after setting open objects to 2147483647

SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
Tammy
Try starting the server using the -f option, then change this value back to 0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I can
> not start the server any more, nor can I set open objects to a smaller value.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy
|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:

> Try starting the server using the -f option, then change this value back to 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
>

Can not start server after setting open objects to 2147483647

SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
I set open objects to 2147483647 for research purpose. After I did it, I can
not start the server any more, nor can I set open objects to a smaller value
.
The error message I got was:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).
What should I do to be able to start the server again?
Thank you,
TammyTry starting the server using the -f option, then change this value back to
0.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tammy" <Tammy@.discussions.microsoft.com> wrote in message
news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
> SQL Server 2000 Enterprise installed on Windows 2000 Advanced Server.
> I set open objects to 2147483647 for research purpose. After I did it, I c
an
> not start the server any more, nor can I set open objects to a smaller val
ue.
> The error message I got was:
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).
> What should I do to be able to start the server again?
> Thank you,
> Tammy|||That solves the problem. Thank you, Tibor.
"Tibor Karaszi" wrote:

> Try starting the server using the -f option, then change this value back t
o 0.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Tammy" <Tammy@.discussions.microsoft.com> wrote in message
> news:C97AD036-A6FA-4120-861F-19FEDD921EE2@.microsoft.com...
>