Re: Change max-number logins to zero
From: Peter Bij (peter.bij@klm.com)
Date: 03/12/03
- Next message: Linda: "Recieving error # 111"
- Previous message: Allan Mitchell: "Re: bo-bo question"
- In reply to: Tom Moreau: "Re: Change max-number logins to zero"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Peter Bij" <peter.bij@klm.com> Date: Wed, 12 Mar 2003 00:48:34 -0800
Thanks Tom
You have been most helpfull
>-----Original Message-----
>One more thing - don't use EM to run sp_configure, since
EM opens more than one connection. Use osql or QA instead.
>
>--
> Tom
>
>----------------------------------------------------
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:OnP6Hx95CHA.2392@TK2MSFTNGP09.phx.gbl...
>You'll have to start SQL Server in single-useer mode.
This means you'll have to run the SQL Server service from
the command prompt:
>
>sqlservr -m -d<data file> -l<log file> -e<error file>
>
>Check out "sqlservr Application" in the BOL for details.
Once this is done, you can run sp_configure to set 'user
connections' to zero.
>
>--
>Tom
>
>----------------------------------------------------------
-----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada tom@cips.ca
>www.pinnaclepublishing.com/sql
>
> "Peter Bij" <peter.bij@klm.com> wrote in message
news:06a801c2e7d8$1d6fbed0$a301280a@phx.gbl...
> Someone accidentaly changed the max-number logins to 1.
> The only-one who can login is SQL-Server itself.
> Can any-one help how to change this number to zero or
at
> least more than one
>
> Kind regards
> Peter Bij
- Next message: Linda: "Recieving error # 111"
- Previous message: Allan Mitchell: "Re: bo-bo question"
- In reply to: Tom Moreau: "Re: Change max-number logins to zero"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
