Cannot get into SQL Server. Help please!

I accidently changed the maximum connections from 0 (unlimited) to 10 and rebooted my server. now I can't connect to it! is there anyway to change that connection number without being able to connect to the server via EM?

Running MSSQL7 on Windows NT4 SP6.

Thanks for any advice!!

Joshua GregoryNot that I'm aware off. Perhaps during an off peak time or non-production period you'll be able to login ?|||Thanks for the help. I unplugged the NIC and rebooted. Then I went into EM and changed the setting back.

Can anyone point me to a good information source for using the sp_configure command? I read lots of info about this command, but when I tried to type it in a DOS command prompt it said unknown command.|||If you want to run sql outside of sql you need to place the code in a file (*.sql), whatever, and execute using isql or osql from a command line...

syntax is in bol

Cannot Generate SSPI context

Hi,
I disabled the Namedpipes and enabled the TCP/IP
protocol in the the sql server box. The box/server
is rebooted after this change. My client workstation
is not to connect to the SQL Server. The SQL Server is
running. With in the SQL Server box, I can use query
analyzer to connect to sql server and works.
From my client workstation, I receive the below error
message.
"Cannot Generate SSPI context"
I restart my workstation too. Still the same problem.
I tried the possible solutions given in the web site.
Article#: 269541.
Could you please help me.
Thanks
Saravanan KunjuSome things to check -
can you ping the server from your workstation?
Have you tried setting up an alias to the server from your
workstation using the Client Network Utility?
You should also refer to the following article for
additional troubleshooting steps:
HOW TO: Troubleshoot the "Cannot Generate SSPI Context"
Error Message
http://support.microsoft.com/?id=811889
-Sue
On Tue, 20 Apr 2004 09:34:54 -0700, "Saravanan Kunju"
<kavisarav@.yah00.com> wrote:

>Hi,
>I disabled the Namedpipes and enabled the TCP/IP
>protocol in the the sql server box. The box/server
>is rebooted after this change. My client workstation
>is not to connect to the SQL Server. The SQL Server is
>running. With in the SQL Server box, I can use query
>analyzer to connect to sql server and works.
>From my client workstation, I receive the below error
>message.
> "Cannot Generate SSPI context"
>I restart my workstation too. Still the same problem.
>I tried the possible solutions given in the web site.
>Article#: 269541.
>Could you please help me.
>Thanks
>Saravanan Kunju
>