SQL Error Log: Login Failed for User ''

[#1]

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

[Former Member]

Hi Frederik,

how did you fix it?

regards,

Fabio

[Former Member]

It had something to do with the server.

Server is a server 2012, and there is/was something wrong with the "bridge" part of the server.

Disabling solved the issue, and clients could log in.

Regards

Frederik

[Former Member]

Hi Frederik,

please could you give us more details about bridge part of the server?

I have the same issue and i would to solve it because the SQL server log is full of these messages

Regards

Luca

[Former Member]

hi Luca,

Im not fully aware any more of the correct solution, but in one of my mails i found following;

In my case I had several additional real & virtual NICs. (hamachi, VPN, wireless, Ethernet, vmware, virtualbox...)

I followed the advice to disable everything except one of them, in my case everything except the ethernet adapter and then I have restarted Windows (Win 7 x64).

Everything started to work smoothly. (the hamachi virtual NIC was automatically enabled on restart whithout my request)

and

In windows Server 2008 there is a option to choose whether IPv6 or IPv4, but we all use IPv4 normally, so we have to deactivate the IPv6 completely and it resolves the problem.

Regards

Frederik