From: Julia B on
Hi all

I've got a SQl server instance on my local pc which I use for development
before transferring to test/production servers. I have full administrative
rights. I've been using it for about a year with no problems until yesterday.

I tried opening SQL server management studio and got the message "Login
failed for user 'myid'". I've checked my event viewer from Control Panel |
Administrative Tools and there's not much further information other than
Event ID 18456, Ctegory 4. I've googled and the only help out there indicates
that the error should show a State and Severity which I can't see.

I can't think of anything I've done that would cause login problems. Has
anyone any ideas?

Thanks
Julia
From: John Bell on
On Wed, 5 May 2010 02:16:01 -0700, Julia B
<JuliaB(a)discussions.microsoft.com> wrote:

>Hi all
>
>I've got a SQl server instance on my local pc which I use for development
>before transferring to test/production servers. I have full administrative
>rights. I've been using it for about a year with no problems until yesterday.
>
>I tried opening SQL server management studio and got the message "Login
>failed for user 'myid'". I've checked my event viewer from Control Panel |
>Administrative Tools and there's not much further information other than
>Event ID 18456, Ctegory 4. I've googled and the only help out there indicates
>that the error should show a State and Severity which I can't see.
>
>I can't think of anything I've done that would cause login problems. Has
>anyone any ideas?
>
>Thanks
>Julia

I am assuming that this is a SQL Server login, so have you disabled
SQL logins? Is this the correct password or has it changed?
Can you log in with Windows Authentication

Which version of SQL Server is this?

John
From: Geoff Schaller on
So you need to think of what you did different to yesterday.
Something has changed. Could the login have expired?
Can you use authenticated login?
Do you know the sa password?

Geoff Schaller
Software Objectives


"Julia B" <JuliaB(a)discussions.microsoft.com> wrote in message
news:2B34F371-5D63-4F75-BB8F-16A1093B2584(a)microsoft.com:

> Hi all
>
> I've got a SQl server instance on my local pc which I use for development
> before transferring to test/production servers. I have full administrative
> rights. I've been using it for about a year with no problems until yesterday.
>
> I tried opening SQL server management studio and got the message "Login
> failed for user 'myid'". I've checked my event viewer from Control Panel |
> Administrative Tools and there's not much further information other than
> Event ID 18456, Ctegory 4. I've googled and the only help out there indicates
> that the error should show a State and Severity which I can't see.
>
> I can't think of anything I've done that would cause login problems. Has
> anyone any ideas?
>
> Thanks
> Julia

From: Julia B on
John, my apologies for not making this clear! I'm logging in using Windows
Authentication and it's SQL Server 2005.

Julia

"John Bell" wrote:

> On Wed, 5 May 2010 02:16:01 -0700, Julia B
> <JuliaB(a)discussions.microsoft.com> wrote:
>
> >Hi all
> >
> >I've got a SQl server instance on my local pc which I use for development
> >before transferring to test/production servers. I have full administrative
> >rights. I've been using it for about a year with no problems until yesterday.
> >
> >I tried opening SQL server management studio and got the message "Login
> >failed for user 'myid'". I've checked my event viewer from Control Panel |
> >Administrative Tools and there's not much further information other than
> >Event ID 18456, Ctegory 4. I've googled and the only help out there indicates
> >that the error should show a State and Severity which I can't see.
> >
> >I can't think of anything I've done that would cause login problems. Has
> >anyone any ideas?
> >
> >Thanks
> >Julia
>
> I am assuming that this is a SQL Server login, so have you disabled
> SQL logins? Is this the correct password or has it changed?
> Can you log in with Windows Authentication
>
> Which version of SQL Server is this?
>
> John
> .
>
From: Julia B on
Geoff, as far as I know nothing's changed. I'm logging on using Windows
Authentication. Unfortunately I don't know the sa password.

Julia

"Geoff Schaller" wrote:

> So you need to think of what you did different to yesterday.
> Something has changed. Could the login have expired?
> Can you use authenticated login?
> Do you know the sa password?
>
> Geoff Schaller
> Software Objectives
>
>
> "Julia B" <JuliaB(a)discussions.microsoft.com> wrote in message
> news:2B34F371-5D63-4F75-BB8F-16A1093B2584(a)microsoft.com:
>
> > Hi all
> >
> > I've got a SQl server instance on my local pc which I use for development
> > before transferring to test/production servers. I have full administrative
> > rights. I've been using it for about a year with no problems until yesterday.
> >
> > I tried opening SQL server management studio and got the message "Login
> > failed for user 'myid'". I've checked my event viewer from Control Panel |
> > Administrative Tools and there's not much further information other than
> > Event ID 18456, Ctegory 4. I've googled and the only help out there indicates
> > that the error should show a State and Severity which I can't see.
> >
> > I can't think of anything I've done that would cause login problems. Has
> > anyone any ideas?
> >
> > Thanks
> > Julia
>
> .
>