April 25, 2005 at 3:57 am
hi,
i have my application running as a service and there is SQL Server on another machine. Both the SQL Server service and my application service are started using Local System acount. Both the machines are not in a domain, they are in a work group. Can my application connect to the SQL Server using Windows authentication.
Regards
Prasanna
April 25, 2005 at 5:58 am
I would initially state NO however, IF the SAME account is on BOTH machines THEN you should be able to (as long as the passwords are the same)...
i.e. PC1\UserA and PC2\UserA
Good Hunting!
AJ Ahrens
webmaster@kritter.net
April 26, 2005 at 1:07 am
If you can't setup the service to use a domain account, then Pass Through authentication should work. You need to have the same user name and password on both boxes, just as AJ suggested above.
Its dodgy but due to a bit of (imho) bad security design it works.
Julian Kuiters
juliankuiters.id.au
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply