Enterprise Manager Showing Wrong Authentication Mechanism

This is strange,
SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
into the server or I look on the console locally, it shows it as only being
Windows Authentication...
Anyone know of this bug? And how to fix?How do you know it's set to mixed mode? Did you try logging
in with a SQL login?
If you are just looking at a registry setting, it's possible
the service was not restarted to allow the server to be set
to mixed mode.
-Sue
On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
<Chuck@.discussions.microsoft.com> wrote:

>This is strange,
>SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
>into the server or I look on the console locally, it shows it as only being
>Windows Authentication...
>Anyone know of this bug? And how to fix?|||Yes, I am currently logging in as an SQL login account. This client of mine
does not use Windows authentication...
"Sue Hoegemeier" wrote:

> How do you know it's set to mixed mode? Did you try logging
> in with a SQL login?
> If you are just looking at a registry setting, it's possible
> the service was not restarted to allow the server to be set
> to mixed mode.
> -Sue
> On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
> <Chuck@.discussions.microsoft.com> wrote:
>
>|||_-=?/today_-=?/354
"Chuck" wrote:

> This is strange,
> SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
> into the server or I look on the console locally, it shows it as only bein
g
> Windows Authentication...
> Anyone know of this bug? And how to fix?|||_-=?/today_-=?/354
"Chuck" wrote:
[vbcol=seagreen]
> Yes, I am currently logging in as an SQL login account. This client of mi
ne
> does not use Windows authentication...
> "Sue Hoegemeier" wrote:
>

Entering maintenance mode through Enterprise Manager?

Is there a way of entering maintenance mode ("-m") through Enterprise
Manager (2000), rather than running sqlservr.exe directly?
Thanks!
You can add it as a start up parameter (right-click your server, startup parameters), these are
stored in the registry. But as this is a one-time, it is easier to use Windows Services applet, and
add the parameter there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neil W." <neilw@.netlib.com> wrote in message news:e97bUWk2FHA.1292@.TK2MSFTNGP12.phx.gbl...
> Is there a way of entering maintenance mode ("-m") through Enterprise
> Manager (2000), rather than running sqlservr.exe directly?
> Thanks!
>

Entering maintenance mode through Enterprise Manager?

Is there a way of entering maintenance mode ("-m") through Enterprise
Manager (2000), rather than running sqlservr.exe directly?
Thanks!You can add it as a start up parameter (right-click your server, startup par
ameters), these are
stored in the registry. But as this is a one-time, it is easier to use Windo
ws Services applet, and
add the parameter there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neil W." <neilw@.netlib.com> wrote in message news:e97bUWk2FHA.1292@.TK2MSFTNGP12.phx.gbl...[
vbcol=seagreen]
> Is there a way of entering maintenance mode ("-m") through Enterprise
> Manager (2000), rather than running sqlservr.exe directly?
> Thanks!
>[/vbcol]

Entering maintenance mode through Enterprise Manager?

Is there a way of entering maintenance mode ("-m") through Enterprise
Manager (2000), rather than running sqlservr.exe directly?
Thanks!May be changing the startup parameters from windows "server properties", tab
"General", then stopping and restarting the service.
AMB
"Neil W." wrote:

> Is there a way of entering maintenance mode ("-m") through Enterprise
> Manager (2000), rather than running sqlservr.exe directly?
> Thanks!
>
>|||Replied in .server. Please don't multi-post.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neil W." <neilw@.netlib.com> wrote in message news:u9SHVNk2FHA.1188@.TK2MSFTNGP12.phx.gbl...

> Is there a way of entering maintenance mode ("-m") through Enterprise
> Manager (2000), rather than running sqlservr.exe directly?
> Thanks!
>
>

Entering maintenance mode through Enterprise Manager?

Is there a way of entering maintenance mode ("-m") through Enterprise
Manager (2000), rather than running sqlservr.exe directly?
Thanks!You can add it as a start up parameter (right-click your server, startup parameters), these are
stored in the registry. But as this is a one-time, it is easier to use Windows Services applet, and
add the parameter there.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Neil W." <neilw@.netlib.com> wrote in message news:e97bUWk2FHA.1292@.TK2MSFTNGP12.phx.gbl...
> Is there a way of entering maintenance mode ("-m") through Enterprise
> Manager (2000), rather than running sqlservr.exe directly?
> Thanks!
>