SQL Error Log: Login Failed for User ''

[Former Member]

I installed SQL server 2008 r2, and SAP B1 8.82 pl 09

The client on the server works fine.

When i try to login into SAP from workstation, the application hangs and crashes.

The SQL tracer gives following error:

Login failed for user ''

Named pipes are enabled, sa user is being used in licence server.

Firewall is off, restarted server, sql, etc several times

Any ideas on how to solve this?

I checked this message as well: http://scn.sap.com/thread/1905985

but no real solution there.

Regards

Frederik

[KennedyT21]

Hi Frederik Lootens

542000  - Messages "Error:18456".."Login failed for user 'xx'" appear

Symptom

1. Connection failed.. SQL server error: 18456
2. Login failed for user 'XX'

Cause

1.Failure in attempt to connect to server due to a false login ID or a incorrect password.
2. A certain bug exists in SQL that corrupts the System Administrator
password.

Solution

To solve this problem please perform the following steps:

1. Ensure the System Administrator user was entered in the Login field  (or any other user defined by the system administrator)

2. Ensure the correct password was entered in the Password field

3. In case the customer did not define a password for the SA user or  for any other user defined by him, delete the content of the Password field.

In case a password was not defined for the SA user please perform the following procedure, which must be approved by the system administrator or by the general manager:

1. Go to the taskbar "Start -> Programs -> Microsoft SQL Server -> Enterprise Manager"

2. In your SQL Server click on the folder Security

3. click on Logins

4. Double click the SA user

5. In the pop up window use the General tab to delete the Password

6. Press "OK"

7. Go to the Console in your menu and click on "Exit"

1. In the taskbar click "Start -> Programs -> Microsoft SQL Server -> Enterprise manager"

2. Right click the SQL server

3. Select Properties

4. In the pop up window click on the Security tab

5. In the Authentication field, make sure that both, "Windows and SQL" are checked instead of "Windows only".

Other terms

SQL, Server, connection failed, error, error 18456, login, user

Regards

Kennedy

[Former Member]

Hi Kennedy,

I looked trough your note, but cannot fix it

full error:

2013-01-11 14:00:40.42 Logon	Error: 18456, Severity: 14, State: 58.
2013-01-11 14:00:40.42 Logon	Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: xx]

Any other idea's?

Regards

Frederik