sql services.
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17055
Date: 1/22/2004
Time: 2:37:21 PM
User: N/A
Computer: SMSPRIMARY
Description:
18456 :
Login failed for user 'smslab\smsadmin'.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H.....
0008: 0b 00 00 00 53 00 4d 00 ...S.M.
0010: 53 00 50 00 52 00 49 00 S.P.R.I.
0018: 4d 00 41 00 52 00 59 00 M.A.R.Y.
0020: 00 00 07 00 00 00 6d 00 .....m.
0028: 61 00 73 00 74 00 65 00 a.s.t.e.
0030: 72 00 00 00 r...
This is a SMS 2003 server.
Any info would be helpful. Thanks.Piedmont,
This is actually error 18456. It appears that smslab\smsadmin does not have
rights to login. From the BOL:
Error 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Explanation
You do not have permission to log in to the server.
Action
Contact a member of the sysadmin fixed server role to request login
permission.
Russell Fields
"Piedmont" <anonymous@.discussions.microsoft.com> wrote in message
news:26c401c3e11d$7e06ec70$a001280a@.phx.gbl...
quote:|||In enterprise manager under logins the user is listed and
> Getting the following in the event log after starting the
> sql services.
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (4)
> Event ID: 17055
> Date: 1/22/2004
> Time: 2:37:21 PM
> User: N/A
> Computer: SMSPRIMARY
> Description:
> 18456 :
> Login failed for user 'smslab\smsadmin'.
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 18 48 00 00 0e 00 00 00 .H.....
> 0008: 0b 00 00 00 53 00 4d 00 ...S.M.
> 0010: 53 00 50 00 52 00 49 00 S.P.R.I.
> 0018: 4d 00 41 00 52 00 59 00 M.A.R.Y.
> 0020: 00 00 07 00 00 00 6d 00 .....m.
> 0028: 61 00 73 00 74 00 65 00 a.s.t.e.
> 0030: 72 00 00 00 r...
>
> This is a SMS 2003 server.
> Any info would be helpful. Thanks.
has the right to login to the database.
quote:
>--Original Message--
>Piedmont,
>This is actually error 18456. It appears that
smslab\smsadmin does not have
quote:
>rights to login. From the BOL:
>Error 18456
>Severity Level 14
>Message Text
>Login failed for user '%ls'.
>Explanation
>You do not have permission to log in to the server.
>Action
>Contact a member of the sysadmin fixed server role to
request login
quote:
>permission.
>
>Russell Fields
>"Piedmont" <anonymous@.discussions.microsoft.com> wrote in
message
quote:|||Then I have no help for you, I am afraid. My only suggestions are clerical:
>news:26c401c3e11d$7e06ec70$a001280a@.phx.gbl...
the[QUOTE]
>
>.
>
-- Double check the spelling of the login that you see in SEM just in case.
-- Doube check the server you are investigating, the domain of the login is
smslab, do you have an smsprd?
Sorry,
Russell Fields
"Piedmont" <anonymous@.discussions.microsoft.com> wrote in message
news:2bd501c3e126$2c249e30$a601280a@.phx.gbl...[QUOTE]
> In enterprise manager under logins the user is listed and
> has the right to login to the database.
>
> smslab\smsadmin does not have
> request login
> message
> the|||Perhaps the SMSAdmin password was changed. Make sure you can stop n start
this account from Control panel services. Also verify that it is a member
of the Builtin admin group via the local administrators group on the
machine.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql
