From: Julia B on 5 May 2010 05:16 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 5 May 2010 06:39 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 5 May 2010 06:39 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 5 May 2010 07:16 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 5 May 2010 07:21 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 > > . >
|
Next
|
Last
Pages: 1 2 Prev: Microsoft Responds to the Evolution of Online Communities Next: install sp1 on sql 2008 r2 |