Re: Changing passwords / Blocking SA login attempts
From: BP Margolin (bpmargo@attglobal.net)
Date: 02/13/03
- Next message: BP Margolin: "Re: When comparing a field name with a column name of more than one word"
- Previous message: Brian Noyes: "Registry permissions getting reset on restart"
- In reply to: Fox: "Re: Changing passwords / Blocking SA login attempts"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "BP Margolin" <bpmargo@attglobal.net> Date: Thu, 13 Feb 2003 17:00:26 -0500
Fox,
Can't say that I'm sure that I completely understand the situation you're
in, but it sounds as if you need to "re-register" to be able to use
Enterprise Manager:
Right-click the SQL Server instance name, and choose the "Edit SQL Server
registration properties" option. Since you now have SQL Server in Windows
Authentication mode, you need to connect via your Windows login. I'm
assuming you are an administrator on the box on which you have your SQL
Server instance. By default, administrators are mapped to the SysAdmin role
(which is where the special sa login is also mapped).
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"Fox" <fox@connexions.net> wrote in message
news:OpT4AW50CHA.2488@TK2MSFTNGP12...
> OK, now I understand all the ramifications. I guess I can look into the
> templates
> and figure out how to change them. But I now have a more urgent issue.
>
> I did as you suggested, but now have a serious problem. Since I changed to
> Windows Authentication, I can no longer access Enterprise Manager.
>
> I am guessing that the Start SQL server account I had in there was not
> a Trusted Account. I had my name in there probably as an SQL
> authentication. Now that I screwed myself, what must I do to get
> back into Enterprise Manager ;)
>
> Regards,
> Fox
>
>
>
> "BP Margolin" <bpmargo@attglobal.net> wrote in message
> news:eiLlz1w0CHA.2296@TK2MSFTNGP10...
> > Fox,
> >
> > The authentication mode covers **all** connections to SQL Server. The
> > purpose of Windows Authentication is not just to "thwart" the sa account
> ...
> > that is simply a "side-effect" of changing to Windows Authentication.
> >
> > Windows Authentication is more secure because, for example, SQL Server
has
> > no mechanism to require that users periodically change passwords, or to
> > enforce password standards. Windows does have those abilities.
> >
> > Basically the idea behind Windows Authentication is that SQL Server
relies
> > upon the Windows operating system to authenticate that a user is who he
> says
> > he is. After that, the SQL Server administrator can choose which Windows
> > users or Windows groups to access the SQL Server databases. But the
basic
> > authentication process is left to Windows rather than to SQL Server.
> >
> > -------------------------------------------
> > BP Margolin
> > Please reply only to the newsgroups.
> > When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.)
which
> > can be cut and pasted into Query Analyzer is appreciated.
> >
> > "Fox Bortniker" <fox@connexions.net> wrote in message
> > news:OmCMaEw0CHA.2076@TK2MSFTNGP10...
> > >
> > >
> > > Great, that brought me to it. Just one question. I have a pre-existing
> > > set of templates running in a database that are in PHP. They are
> > > numerous and complex. They use my name for login via SQL. If I change
> > > the authentication to Windows where you said to do so, is that for all
> > > authentication or is that just for the SA account ? I am afraid that
if
> > > I change that, the other template will not allow me to log in as the
> > > admin for the application. Is this going to happen ? Will I need to
find
> > > out how to change the log in that is built into that set of templates
so
> > > I can change it as well ?
> > >
> > > Thanks,
> > > Fox
> > >
> > > *** Sent via Developersdex http://www.developersdex.com ***
> > > Don't just participate in USENET...get rewarded for it!
> >
> >
>
>
- Next message: BP Margolin: "Re: When comparing a field name with a column name of more than one word"
- Previous message: Brian Noyes: "Registry permissions getting reset on restart"
- In reply to: Fox: "Re: Changing passwords / Blocking SA login attempts"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
