Howto use Windows Authentication with SQL Server 2008 Express on a workgroup network?

Question

I have two computers running SQL Server 2008 Express: c01 and c02, I setup both for remote connection using windows authentication. Worked fine for c02 but not for c01.

This is the error message I'm getting:

TITLE: Connect to Server

Cannot connect to ACAMP001\SQLEXPRESS.

---

ADDITIONAL INFORMATION:

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)

For help, click: http://go.microsoft.com/fwlink?>ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476

---

BUTTONS:

OK

I don't know if I'm missing something, here is what I did:

1. Enabled TCP/IP protocol for client from Sql Server Configuration Manager.
2. Modified Windows firewall exceptions for respective ports.
3. Started the Sql Browser service as a local service
4. Added Windows user to this group: "SQLServerMSSQLUser$c01$SQLEXPRESS"
5. From Management Studio, I added "SQLServerMSSQLUser$c01$SQLEXPRESS" to SQLEXPRESS instance's logins under security folder, and I granted sysadmin permissions to it.
6. Restarted c01\SQLEXPRESS
7. Restarted Sql Browser service.
8. There is no domain here. It's only a workgroup.

Please any help is appreciated, Thank you.

Answer 1

Whatever username you are using on the "remote" machine must be set up on the "server" machine.

So, if you are logged-in to "remote" as "John," there must be a "John" user on the machine that is hosting SQL Server 2008 Express, and unless you are going to provide different credentials, it should have the same password, too.