Error 18456, State 16

T

Tara Stokes

I've recently installed Sql server 2005 along with Project Web Access 2007.
I'm having an issue with my login for sql server. Here is the error message
I'm getting. Can anyone help?
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/27/2008
Time: 10:41:21 AM
User: MARKETCRAFT\SQL_Service
Computer: TEMPEWEB
Description:
Login failed for user 'MARKETCRAFT\SQL_Service'. [CLIENT: <local machine>]

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: 09 00 00 00 54 00 45 00 ....T.E.
0010: 4d 00 50 00 45 00 57 00 M.P.E.W.
0018: 45 00 42 00 00 00 07 00 E.B.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...

This message was from my Event log. Sql server event logs states - Login
failed for user 'marketcraft\sql_service' Error 18456, Severity 14, State:
16.

HELP Please
 
T

Tara Stokes

Yes - Infact, I can make changes and it stays but it doesn't translate the
changes throughtout the system. Does that make sense?


Gaurav Wason said:
Can you login to Project Web Access?
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com



Tara Stokes said:
I've recently installed Sql server 2005 along with Project Web Access 2007.
I'm having an issue with my login for sql server. Here is the error message
I'm getting. Can anyone help?
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/27/2008
Time: 10:41:21 AM
User: MARKETCRAFT\SQL_Service
Computer: TEMPEWEB
Description:
Login failed for user 'MARKETCRAFT\SQL_Service'. [CLIENT: <local machine>]

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: 09 00 00 00 54 00 45 00 ....T.E.
0010: 4d 00 50 00 45 00 57 00 M.P.E.W.
0018: 45 00 42 00 00 00 07 00 E.B.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...

This message was from my Event log. Sql server event logs states - Login
failed for user 'marketcraft\sql_service' Error 18456, Severity 14, State:
16.

HELP Please
Click to expand...
Click to expand...
 
T

Tara Stokes

Yes. And the configs that I'm doing are saving.

Gaurav Wason said:
Can you login to Project Web Access?
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com



Tara Stokes said:
I've recently installed Sql server 2005 along with Project Web Access 2007.
I'm having an issue with my login for sql server. Here is the error message
I'm getting. Can anyone help?
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/27/2008
Time: 10:41:21 AM
User: MARKETCRAFT\SQL_Service
Computer: TEMPEWEB
Description:
Login failed for user 'MARKETCRAFT\SQL_Service'. [CLIENT: <local machine>]

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: 09 00 00 00 54 00 45 00 ....T.E.
0010: 4d 00 50 00 45 00 57 00 M.P.E.W.
0018: 45 00 42 00 00 00 07 00 E.B.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...

This message was from my Event log. Sql server event logs states - Login
failed for user 'marketcraft\sql_service' Error 18456, Severity 14, State:
16.

HELP Please
Click to expand...
Click to expand...
 
G

Gaurav Wason

Take a look at this KB

http://support.microsoft.com/kb/889646

--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com



Tara Stokes said:
Yes. And the configs that I'm doing are saving.

Gaurav Wason said:
Can you login to Project Web Access?
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com



Tara Stokes said:
I've recently installed Sql server 2005 along with Project Web Access 2007.
I'm having an issue with my login for sql server. Here is the error message
I'm getting. Can anyone help?
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/27/2008
Time: 10:41:21 AM
User: MARKETCRAFT\SQL_Service
Computer: TEMPEWEB
Description:
Login failed for user 'MARKETCRAFT\SQL_Service'. [CLIENT: <local machine>]

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: 09 00 00 00 54 00 45 00 ....T.E.
0010: 4d 00 50 00 45 00 57 00 M.P.E.W.
0018: 45 00 42 00 00 00 07 00 E.B.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...

This message was from my Event log. Sql server event logs states - Login
failed for user 'marketcraft\sql_service' Error 18456, Severity 14, State:
16.

HELP Please
Click to expand...
Click to expand...
Click to expand...
 
T

Tara Stokes

We were able to do everything except #2(I don't understand where to find this
at) in the kb but still nothing. We are still getting the error messages.
Do you have any other suggestions? Also - our active directory is not
syncing - is this because of the Sql failing?


Gaurav Wason said:
Take a look at this KB

http://support.microsoft.com/kb/889646

--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com



Tara Stokes said:
Yes. And the configs that I'm doing are saving.

Gaurav Wason said:
Can you login to Project Web Access?
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com



:

I've recently installed Sql server 2005 along with Project Web Access 2007.
I'm having an issue with my login for sql server. Here is the error message
I'm getting. Can anyone help?
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/27/2008
Time: 10:41:21 AM
User: MARKETCRAFT\SQL_Service
Computer: TEMPEWEB
Description:
Login failed for user 'MARKETCRAFT\SQL_Service'. [CLIENT: <local machine>]

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: 09 00 00 00 54 00 45 00 ....T.E.
0010: 4d 00 50 00 45 00 57 00 M.P.E.W.
0018: 45 00 42 00 00 00 07 00 E.B.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...

This message was from my Event log. Sql server event logs states - Login
failed for user 'marketcraft\sql_service' Error 18456, Severity 14, State:
16.

HELP Please
Click to expand...
Click to expand...
Click to expand...
 
T

Tara Stokes

Yes, would that be a web application pool? Should we create a completly
different one or modify one that we have?

Gaurav Wason said:
Do you have access to Sharepoint Central Administration...2 in this KB is
asking you to create an application pool.

Thanks

Gaurav

Tara Stokes said:
We were able to do everything except #2(I don't understand where to find
this
at) in the kb but still nothing. We are still getting the error messages.
Do you have any other suggestions? Also - our active directory is not
syncing - is this because of the Sql failing?


Gaurav Wason said:
Take a look at this KB

http://support.microsoft.com/kb/889646

--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com



:

Yes. And the configs that I'm doing are saving.

:

Can you login to Project Web Access?
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner
Tool)
http://projectmadeeasy.com



:

I've recently installed Sql server 2005 along with Project Web
Access 2007.
I'm having an issue with my login for sql server. Here is the
error message
I'm getting. Can anyone help?
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/27/2008
Time: 10:41:21 AM
User: MARKETCRAFT\SQL_Service
Computer: TEMPEWEB
Description:
Login failed for user 'MARKETCRAFT\SQL_Service'. [CLIENT: <local
machine>]

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: 09 00 00 00 54 00 45 00 ....T.E.
0010: 4d 00 50 00 45 00 57 00 M.P.E.W.
0018: 45 00 42 00 00 00 07 00 E.B.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...

This message was from my Event log. Sql server event logs states -
Login
failed for user 'marketcraft\sql_service' Error 18456, Severity
14, State:
16.

HELP Please
Click to expand...
Click to expand...
Click to expand...
 
T

Tara Stokes

Gaurav,
I think we figured it out. Our errors are coming from the Sql Server
Reporting Services. When we turn this service off - we don't receive any
more errors. Do you know what could cause this?
We also made sure all the creditials are matching up.

Gaurav Wason said:
Do you have access to Sharepoint Central Administration...2 in this KB is
asking you to create an application pool.

Thanks

Gaurav

Tara Stokes said:
We were able to do everything except #2(I don't understand where to find
this
at) in the kb but still nothing. We are still getting the error messages.
Do you have any other suggestions? Also - our active directory is not
syncing - is this because of the Sql failing?


Gaurav Wason said:
Take a look at this KB

http://support.microsoft.com/kb/889646

--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner Tool)
http://projectmadeeasy.com



:

Yes. And the configs that I'm doing are saving.

:

Can you login to Project Web Access?
--
Gaurav Wason
(e-mail address removed), MCP - Project Server
Project Made Easy (Project Server Archive Tool) and (Project Owner
Tool)
http://projectmadeeasy.com



:

I've recently installed Sql server 2005 along with Project Web
Access 2007.
I'm having an issue with my login for sql server. Here is the
error message
I'm getting. Can anyone help?
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 10/27/2008
Time: 10:41:21 AM
User: MARKETCRAFT\SQL_Service
Computer: TEMPEWEB
Description:
Login failed for user 'MARKETCRAFT\SQL_Service'. [CLIENT: <local
machine>]

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: 09 00 00 00 54 00 45 00 ....T.E.
0010: 4d 00 50 00 45 00 57 00 M.P.E.W.
0018: 45 00 42 00 00 00 07 00 E.B.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...

This message was from my Event log. Sql server event logs states -
Login
failed for user 'marketcraft\sql_service' Error 18456, Severity
14, State:
16.

HELP Please
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PROBLEMS WITH BCM AND SQL SERVER - PLEASE HELP 6
PROBLEM WITH BCM AND SQL SERVER 2
HELP BCM for Outlook could not connect to the shared database. 1
Project Portfolio Server 2007 - Installation Error 0
Problems with Business Contact Manager with SP4 for OUtlook 2003 4
Backup and Restore from the Central Administration 3.0 3
Excel problem when shutting down Excel 10
Project Portfolio Server 2007 - Error 26204 0

Top