Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP/SQL Server - Connecting using Service Account
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01364638
Message ID:
01364646
Views:
23
If you're sending the username/password, you're not using Windows authentication. What type of application is it?

>I'm developing a client/server application in VFP9SP2 with a SQL Server 2005 database backend using ODBC. The UI,business, and data access layers are logically separated but physically all currently reside in a single EXE.
>
>The customer requires windows authentication and wants to use a service account for database access in SQL Server.
>
>I am currently storing encrypted copies of the User ID/Password for the service account and using api calls to LogonUser(), ImpersonateLoggedOnUser(), and RevertToSelf() wrapped around the call to SQLStringConnect().
>
>What other options do I have for making the connection using the service account's credentials?
>
>Also, are there any negative side effects/consequences of the method I am currently employing?
>
>Thanks,
>Scott
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform