Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-11 : 07:18:52
|
| Diederik writes "HelloI'm creating a VB6 component that has to query a MSSQL 2000 (running under Win2000) database. The component is to run on an application server (no user interaction). The MSSQL server is configured as Windows only authentication. How can I make sure that my component is able to succesfully login at the SQL Server? I do not want to rely on the user (if any) currently logged on in the application server. Is this possible? Thanks for any help!Diederik" |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-03-11 : 08:44:15
|
| Code your own security component ? Other than that, I don't think you can - the Mixed Mode authentication is a server setting... not a session setting.*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-03-11 : 08:56:21
|
| A comment from over my shoulder - if you can get component to run as a service, you might be ok ... Just don't ask me what you'd need to do that....*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
|
|
|
Windows only authentication