Sunday, February 12, 2012

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...
>

No comments:

Post a Comment