Prev: Microsoft Responds to the Evolution of Online Communities
Next: install sp1 on sql 2008 r2
From: Geoff Schaller on 5 May 2010 08:32
Julia, something has changed! Try logging in with the administrator's
account.


"Julia B" <JuliaB(a)discussions.microsoft.com> wrote in message
news:0D33A118-6B2F-4269-B564-709F8903AD5A(a)microsoft.com:

> 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
> >
>
> > .
> >

First  |  Prev  | 
Pages: 1 2
Prev: Microsoft Responds to the Evolution of Online Communities
Next: install sp1 on sql 2008 r2