Re: Impersonation with VB.net 2.0 and SQL 2000 help needed

What type of you app is, Win form or ASP.NET?

In either case, if the DBA only allows Windows Security on the SQL Server,
then you have to know which Windows user account is running your app. If it
is Win form app, the logged in use is the user account that runs your app
(unless you use "RUNAS" command and supply different user credential). So,
if that user has appropriate access to the SQL Server, your app would run as
expected. If he does not have sufficient access, that is good, this is what
security is meant to. Have someone else who has access privilege to run the
app, not the ones who are not supposed to. Also, with .NET Configuration
applet, you can manipulate .NET app/code security on the computer where your
app runs


If it is ASP.NET, the user account running your ASP.NET app may not be (by
default) the user who open a web browser and navigate to your app on a web
server. You must know, as developer, which account is used to run the
ASP.NET app in order to give the account proper access to required resource,
such as SQL Server. Impersonation is one of the option.

However, for some reason, you have to use SQL Server security, not Windows
security, while the DBA does not accept it, then it is only between you two
to make compromise, nothing can help.

"Backwards" <Andrew@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1145762811.962778.113820@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hey everybody

I'm having a little trouble getting access to a few commands in our 65
odd SQL databases.
Have had a chat to our DBA's and they wont give my windows account
access and they also wont give me a SQL login in order to run these
tasks. :-(

The good news is that i do have access to run these certian tasks as
another NT user.

The bad news is i cant add this to my connection string.

The lovely people at Microsoft talked about using Impersonation?

Would this work and how would i go about using this with VB.net 2.0
(visual studio 20005)

Any help on this would be great,

Andy



.

Relevant Pages

  • Re: Sygate Free PFW
    ... security holes won't be fixed. ... switch to the windows XP SP2 firewall? ... Windows firewall does not inform user when an apps tries to connect ... This arrives, of course, when app is installed in a session where user has ...
    (comp.security.firewalls)
  • Re: Anybody Have any Problems With AceUpdater for Addons and Vista?
    ... admin of our own machine and all programs have been run as administrator. ... Vista pc into a winXP machine <security wise> ... coding one that way can actually reduce the security of the app, ... windows believes the app when it says it only needs security at those ...
    (alt.games.warcraft)
  • ADO.NET 2.0 & MSDE & Win98
    ... Framework 2.0 which must be deployed on Windows 98 platform. ... The MSDE will ... be installed on Win98 as the SQL Server to which the app will connect. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlExpress distribution and access rights
    ... Is this app with SQL Server Epxress a server app or a desktop app? ... Since you want useraccess the SQL Server with Windows integrated security, and you, of course, do not know what user account the user is using when developing the app. ... you can also incorporate the Windows local user group setup into your installation package. ...
    (microsoft.public.sqlserver.msde)
  • Re: Applications developed with VS2005 do not running under Window
    ... Security, security, security. ... > Most users do probably have Windows 95 or higher regardless. ... > VB.NET app, it might be a good idea to think about moving your product ... > money and training than upgrading all their machines. ...
    (microsoft.public.vsnet.general)