Re: server error 18456 when trying to login

Do you mean you can connect to your SQL Server Instance now? So this thread is closed?

--
Ekrem Önsoy



"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D265C9AF-D3EC-4C26-BAA9-6DC9E00C929E@xxxxxxxxxxxxxxxx
I do not think the problem is SQL server as it looks like I now have
restricted rights on the machine, thanks for the assistance.
--
Paul G
Software engineer.


"Ekrem Önsoy" wrote:

Is this a domain member or a stand alone machine?

I mean are we talking about a active directory authentication or local
windows authentication here?

Also, will you check out your Windows Event Logs to have more info about
this error and can you check the SQL Error Logs? They'll provide the info
that'll help us to resolve the issue.

--
Ekrem Önsoy



"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:870A9209-2BBB-457B-9837-370894381B3C@xxxxxxxxxxxxxxxx
> Thanks for the response. I restarted the machine a few times but it
> seemed
> to have no effect. There was a power outage (low voltage condition) > but
> all
> other programs appear to be working ok.
> -- > Paul G
> Software engineer.
>
>
> "Ekrem Önsoy" wrote:
>
>> Did you try logging off and on your Windows and then try log in to >> your
>> SQL
>> Server instance?
>>
>> -- >> Ekrem Önsoy
>>
>>
>>
>> "Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:26C4FF38-9B7A-412E-B4F7-18C81D78EB26@xxxxxxxxxxxxxxxx
>> > Hi I have a 2005 sql database that I have been logging into using
>> > windows
>> > authentication. I now can not log in, get the server error 18456. >> > My
>> > password changed to log onto my machine (windows authentication) so
>> > wondering
>> > if something needs to be reset in SQL or would it automatically >> > detect
>> > the
>> > password change?-- >> > Paul G
>> > Software engineer.
>>
>>


.

Relevant Pages

  • Windows Impersonation authentication to SQL Server?
    ... Impersonation will each Windows Domain user accounts need to be granted ... all be tracked and displayed in SQL Profiler? ... or SQL security but the article is discussing Windows security. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication to SQL Server?
    ... oranges in trying to convert an asp.net app which uses forms authentication ... mode throughout the app with one SQL login account into SQL Server versus ... converting the asp.net app into a full individual Windows authentication ... Ultimate goal would be to see the individual windows ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • [TOOL] Resources for Combating the Slammer Worm
    ... installations of Microsoft® SQL Server™ and the Microsoft SQL Server ... SQL Server 2000 SQL Scan Tool ... runs on computers running Windows 2000 or higher and can identify ... Check runs on computers running Windows 98, Windows ME, Windows NT 4.0, ...
    (Securiteam)
  • Re: connection options to yukon
    ... If you use TLS you can increase the security of your SQL auth ... connection but unless you're good at setting up groups/schema/logins/users, ... Windows auth is slower as the domain must ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
    ... windows user that they aren't running this code? ... > SQL Scan will scan a computer, a domain or a range of IP addresses. ... > Jerry Bryant - MCSE, ... > rights. ...
    (microsoft.public.security)
Loading