Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

You might try adding the user as pc2\username, however I believe that without a domain it won't work. This article (Choosing an Authentication Mode) seems to confirm that:

"Advantages of SQL Server Authentication

  • Allows SQL Server to support older applications and applications provided by third parties that require SQL Server Authentication.

    Allows SQL Server to support environments with mixed operating systems, where all users are not authenticated by a Windows domain."

share|improve this answer
    
I tried PC2\Username, but it just says it can't find the account. –  Brandon Nov 9 '11 at 15:45

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.