Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Setting multiple users after being in single user mode

3 posts in Windows NT Last posting was on 2000-05-01 12:29:12.0Z
Neil Frieband Posted on 2000-04-30 23:56:20.0Z
From: "Neil Frieband" <ngf@world.std.com>
Subject: Setting multiple users after being in single user mode
Date: Sun, 30 Apr 2000 19:56:20 -0400
Lines: 23
Organization: F & S Systems, Inc.
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <O6nWZ$vs$GA.263@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ppp0a108.std.com 208.192.100.108
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2232
Article PK: 1089665

How do I go from single user to multiple user mode in an NT server?

Sybase SQL Server version 11.0.3 using NT on a Compaq Proliant platform.

I needed to load the master database from a backup and as directed needed to
be in single user mode. The only way I could see to this was by setting the
command line parameter to "-m" which I did using the Sybase configuration
program.
Master then loaded ok and I then logged in successfully as sa from a client.
In order to switch back to multiple users, I again ran the configuration
program (with no users logged in). When requested entered sa as user and
the same password used to log in from the client as above.
The result is a can't connect error ( I apologize for not having the exact
error text that appeared in the message box.)
What do I need to do to set-up for multiple users? Any ideas will help!

TIA

Neil Frieband
F & S Systems, Inc.


Rob Verschoor Posted on 2000-05-01 08:36:14.0Z
From: "Rob Verschoor" <rob@sypron.nl>
References: <O6nWZ$vs$GA.263@forums.sybase.com>
Subject: Re: Setting multiple users after being in single user mode
Date: Mon, 1 May 2000 10:36:14 +0200
Lines: 42
Organization: Sypron B.V.
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <$hn3Jl0s$GA.263@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: i0076.pvu.euronet.nl 194.134.164.77
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2231
Article PK: 1089663

You should shutdown the server again, remove the "-m", and reboot the
server.

HTH,

Rob V.

Neil Frieband wrote in message ...
>How do I go from single user to multiple user mode in an NT server?
>
>Sybase SQL Server version 11.0.3 using NT on a Compaq Proliant
platform.
>
>I needed to load the master database from a backup and as directed
needed to
>be in single user mode. The only way I could see to this was by
setting the
>command line parameter to "-m" which I did using the Sybase
configuration
>program.
>Master then loaded ok and I then logged in successfully as sa from a
client.
>In order to switch back to multiple users, I again ran the
configuration
>program (with no users logged in). When requested entered sa as user
and
>the same password used to log in from the client as above.
>The result is a can't connect error ( I apologize for not having the
exact
>error text that appeared in the message box.)
>What do I need to do to set-up for multiple users? Any ideas will
help!
>
>TIA
>
>Neil Frieband
>F & S Systems, Inc.
>
>
>


David Owen Posted on 2000-05-01 12:29:12.0Z
Sender: dowen@kashka.midsomer.org
Subject: Re: Setting multiple users after being in single user mode
References: <O6nWZ$vs$GA.263@forums.sybase.com> <$hn3Jl0s$GA.263@forums.sybase.com>
From: David Owen <dowen@midsomer.org>
Organization: Midsomer Consultants Inc.
Date: 01 May 2000 06:29:12 -0600
Message-ID: <m2k8heihd3.fsf@kashka.midsomer.org>
Lines: 11
User-Agent: Gnus/5.0802 (Gnus v5.8.2) Emacs/20.5
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: h29-5d-f4-26324826.cg.shawcable.net 24.70.23.180
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2230
Article PK: 1089660

>>>>> "Rob" == Rob Verschoor <rob@sypron.nl> writes:

Rob> You should shutdown the server again, remove the "-m", and reboot
Rob> the server.

And you do this in the RUN_database.BAT file that is to be found in the
%SYBASE%/INSTALL directory.

--
David Owen Midsomer Consultants Inc. dowen@midsomer.org
Sybase FAQ: http://www.isug.com/Sybase_FAQ