I'm not even sure if this is possible, but I figured I'd ask.
I have two computers, these computers are not part of a domain, but they are on the same network. On each computer, the local administrator account is set up the exact same way (has the same username/password). The two computers can see each other on the network, and are each part of a workgroup with the same name.
PC1 has SQL Server installed and an application that uses Windows Authentication to connect to SQL. This works fine.
PC2 just has the application running. How can it authenticate against the SQL server on PC1? I keep getting access denied.
I can't change the application to use an SQL user login. It has to be Windows Authentication, and I can't change the application itself. Is there any way to do this or a step I've missed somewhere?