I have an authentication problem. The entire setup worked fine for years
when the webserver was a domain member, but after I went to SBS2008, I moved
the webserver out of the domain and in its own workgroup and thus the start
of this problem.
Configuration: SBS 2008 domain with a member server which has SQL Server
2005 Std installed; Remote connections enabled, mixed mode, no windows
firewall, 1 NIC (192.168.16.x) to switch, then switch to Sonicwall NSA240
firewall's LAN port.
Webserver is Server 2008 Std, not a domain member, 192.168.20.x, no windows
firewall, setting on DMZ port of firewall. Port 1433 is opened from DMZ to
LAN.
I can ping both ways but there is no name resolution. Username is setup in
the webserver and the sql server, although they are different domains (one is
domain other is workgroup).

Error I receive when I try website:
Server Error in '/' Application.
--------------------------------------------------------------------------------

Login failed for user 'BI'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'BI'

Stack Trace:
[SqlException (0x80131904): Login failed for user 'BI'.]



Can anyone help get me through this please. I feel I have tried everything
although obviously not.

--
Paul Bockmann

Hi Paul,

As far as I see, you do not you Windows Authentication. Instead you use SQL
Authentication as your SQL Server server is not a Member Server.
Nevertheless, your clients can ping your SQL Server but they can not log in.

It seems that your client can reach to your SQL Server server because error
message says that you just can not log in to the SQL Server server. Did you
check your SQL Server Error Log? What are the Severity Level and other
information for the Login Failed messages? They can help to decode the
problem if you can share it with us.

--
Ekrem Önsoy - SQL Server MVP



"Paul" <paulbockmann (AT) earthlink (DOT) net> wrote