Re: please Help-changed from mixed windows authentication tho windows only locked out

From: Narayana Vyas Kondreddi (answer_me@hotmail.com)
Date: 12/05/02 

From: "Narayana Vyas Kondreddi" <answer_me@hotmail.com>
Date: Thu, 5 Dec 2002 18:08:14 -0000

If you are trying to connect using Enterprise Manager, then delete the SQL
Server registration first, and reregister with Windows authentication. This
will let you connect.

When using Query Analyzer, log into windows with an account that has access
to SQL Server and connect using Windows authentication. 

--
HTH,
Vyas, MVP (SQL Server)
SQL Server FAQ, articles, code samples, interview questions and more @
http://vyaskn.tripod.com/
"Ciara Asple" <ciaraasple@yahoo.ie> wrote in message
news:6ecf39dd.0212050957.59911737@posting.google.com...
> Dear people
>
> windows  2000 server
> sql server 2000
>
> In properties, of instance 01 of sql I changed authentication mode to
> windows only-this however completely stoped sql service [I got
> error1069-(?)] and was completely locked out -could not gain access to
> sql.I changed the sqlservice password and this allowed service to
> restart but I still cannot logon to instance_o1 of sql.I cannot access
> properties to change back and as the system only used windows logins
> anyhow cant see why changing to windows only mode would cause this to
> happen.
>
>
> Incidently to get everyone back onto the database I created a new
> instance of sql and restored last nights back up from the tape to that
> so at least I know back up and restore works now-
>
> regards Ciara

Relevant Pages

  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.portalserver.development)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.office.developer.web.components)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.inetserver.iis)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.windowsservices)