SQL Error Log: Login Failed for User ''

Comment

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?

but no real solution there.

Regards

Frederik

Former Member · ‎2013 Jan 11

Hi Frederik,

You have two options:

1. Change SQL Server authentication type to allow both Windows and SQL authentication.

2. Give user Windows authentication to the server.

Thanks,

Gordon