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

Posted by mbadawi23 on Stack Overflow See other posts from Stack Overflow or by mbadawi23
Published on 2010-05-03T16:48:51Z Indexed on 2010/05/03 16:58 UTC
Read the original article Hit count: 811

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.

© Stack Overflow or respective owner

Related posts about sql-server-express

Related posts about sql-server-2008-express