connect to sqlserver?

[Papa_K]

I want to connect from a .net web server to a sqlserver.

i read an article a while ago on how to do this but i have
since 'filed' it and no longer can i find it.

i remember that i was able to encrypt an nt password using
an asp.net exe stored on the webserver - this was an exe
that was only available on the latest version of the .net
framework - though it was avaiable as a patch.

also, the encrypted password was stored within the
framework folder within one of the .net main pages...

if this all sounds a little flakey im sorry, but i need to
use an nt login into a sqlserver, sqlserver login is not
secure enough...

thanks,

papa

 

[Cowboy \(Gregory A. Beamer\)]

There are a couple of ways of using the integrated security.

1. Restrict the application by removing anonymous access. This is great for
Intranet work, but not for Internet work, unless you set aside a new URL,
like secureapps.yourcompany.com, for these apps.

2. Assign an account to the thread that has db access whenever you need to
access the database. You are essentially "hijakcing" the principle object
and assigning the account it runs under.

3. Make your data access layer a serviced assembly and set a user account
that has rights to the COM+ application. This is done in component services.

There are probably other ways, as well.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************