I have SQL Server 2008 R2 Express installed on a PC.
I have some other PCs that are connected to this PC on a local network.
Currently, those PCs connect to SQL Server using SQL Authentication, however I want them to connect to SQL Server using Windows Authentication.
We don't have an Active Directory domain. All PCs are part of the "WORKGROUP" workgroup.
Best Answer
If none of the machines involved have Active Directory authentication enabled via Kerberos, which precludes using an online-based Microsoft Account (Windows 8 and higher), you should be able to connect to SQL Server using Windows Authentication assuming you follow these points:
You create logins in SQL Server for those user accounts, i.e.:
The client machines may need to connect to the server using the server's IP address instead of it's name. If the server's IP address is 192.168.0.100, and it is listening on port 33333 then they would use this as the server name to connect to:
If you follow all the above advice, then receive the following error when connecting, then the client PC is using Kerberos authentication, and nothing will help you connect.