Re: SQL sever 2000 security

From: LaoJ (LaoJ_at_discussions.microsoft.com)
Date: 09/13/04 

Date: Mon, 13 Sep 2004 15:27:09 -0700

This is what I did, but there is no security tab on my SQL server 2000. I
don't know why.

"Hassan" wrote:

> Its not on the property tab of database.. Right click on the servername and
> then go properties. The security tab is out there.. You may need to restart
> SQL after making those changes..
>
>
> "LaoJ" <LaoJ@discussions.microsoft.com> wrote in message
> news:E99A549D-96A7-4567-938A-324BE4B409C2@microsoft.com...
> > How to change SQL server 2000 security from Windows Athentication to SQL
> > server Athentication. According online help of SQL server, using
> Enterprise
> > Manager, I cannot find Securit tab when Openning the the property item of
> the
> > Database.
> > Thanks.
>
>
>

Relevant Pages

  • linked server security for dummies
    ... I didn't find BOL or online help that clear. ... I've got SQL Server running on two machines in the same network. ... Manager I added someusers as a login to both machines. ... I then tried experimenting with the Security Tab. ...
    (microsoft.public.sqlserver.security)
  • Problems with setting up security tab
    ... When I click on the security tab on the WSAT page (Website/ASP.NET ... "There is a problem with your selected data store. ... to SQL Server database. ... I have SQL Server 2005 running ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: User Login Failed
    ... But after I changed it to Mixed Mode, ... up the security tab again, it's back to Windows only. ... > Does SQL Server allow mixed mode? ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to start SQL Server
    ... You can also change the password in Enterprise manager by ... security tab. ... >> I have had SQL Server up and running for almost 3 months ... >> I have been disconnected from the network ...
    (microsoft.public.sqlserver.security)
  • Re: SQL sever 2000 security
    ... You originally said that you couldn't find the Security tab on the database ... Instead of right clicking on the database name, right click on the server ... > This is what I did, but there is no security tab on my SQL server 2000. ...
    (microsoft.public.sqlserver.server)