473,659 Members | 3,592 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Can trusted_connect ion, use a different user than ASPNET?

I can't use ASPNET user, is there any way to maipulate the system to connect with a different user on a trusted connection

Falvi
Nov 18 '05 #1
1 991
The easiest is to make objects that use Enterprise Services and place the
compiled assembly in Component Services (COM+). Here you can declaratively
assign a user for the component to run under. One caveat. If the assembly
calls other .NET assemblies, you will likely be sticking them in the GAC.

With threads, you have the ability to spawn a thread with proper
permissions. You will have to set up a WindowsIdentity object, assign it to
the property of the WindowsPrincipa l object, which is assigned to the
CurrentPrincipa l property of the thread you are running data access under.

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

*************** *************** *************** ***
Think Outside the Box!
*************** *************** *************** ***
"Flavio" <an*******@disc ussions.microso ft.com> wrote in message
news:E5******** *************** ***********@mic rosoft.com...
I can't use ASPNET user, is there any way to maipulate the system to connect with a different user on a trusted connection?
Falvio

Nov 18 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
4762
by: DC Gringo | last post by:
Using latest SP Win2k and .NET versions, I have a .NET application running on server1 with a SQL Server database running on server2. I have the Windows user account passwords sync'd for server1\aspnet (installed by .NET Framework and server2\aspnet (created by me--this machine has no .NET Framework on it). The aspnet user on the database server (server2) has access to the database. I still get: Login failed for user '(null)'. Reason:...
0
2092
by: Roald Oines | last post by:
I've implemented Doug Steele's code ( http://members.rogers.com/douglas.j.steele/DSNLessLinks.html ) to create a dsn-less connection to a SQL Server database from Access 2003 under XP Pro. I was given a userid and password for the database I'm connecting to, so I put them in the connection string and changed Trusted_Connection from yes to no. However, when I close the database and reopen, I get a logon failure, the SQL Server logon box,...
4
2686
by: Ian | last post by:
Can anyone help I have a web server on the internet with and ASP.NET application on it, the application is set to allow Anonymous Access and Integrated Windows. The Web.config is set to use Forms authentication. On the server side, where the web server is I have set IIS to disable Anonymous access and allow Integrated Windows. I have sync'd both the APSNET account on the web servers and application server so that access will be...
2
1964
by: Bruce Whitehouse | last post by:
I need to be able to run the aspnet_wp.exe process under a domain user, rather than the ASPNET user. I've tried changing the impersonation settings in the web.config and machine.config files, but that doesn't seem to do change anything. How do I configure my machine to get this process to run under a different user account? Many thanks,
4
1681
by: Dan Walls | last post by:
Hi, I am deploying an ASP.Net web app into the following scenario: Internet --> Firewall --> WebServer (IIS) --> --> However I am not sure what sort of authentication options are available to me in gettingthe application to talk to the SQL server. How do I talk between the web app and the database server - if TCP/IP then
7
1657
by: Spsk | last post by:
How to run EXE in webserver on different user credential other than ASPNET. I'm trying to execute EXE in webserver and its runns under ASPNET NT account but I want to run the EXE in different user creadential how do i achive.... Thanks in advace... -Senthil
3
2405
by: Kim | last post by:
After installing MSDE2000 on my WIN XP machine, I created the database from Access using the upsizing wizard. Although the tables can be seen from the server explorer, I keep on encountering problem in building my web application. The error message is "Login failed for user\ASPNET". I've tried to supply/not supply a username and password at the SQL server login but both methods could not work. I did not create a username and password...
1
1767
by: bindurajeesh | last post by:
I am using the following code and it works when I have aspnet as a bona fide user in the sql server database. Why doesn't the use of trusted connection allow me as logged in user and dbo of database to access dbase. If I do not have aspnet on the sql side I get login failed machinename/aspnet?? Dim myConnString As String = "SERVER=fcstestbox;Trusted_Connection=yes;DATABASE=sex_offender_group;" Dim myconnection As New...
11
2274
by: =?Utf-8?B?UGF0Qg==?= | last post by:
Is there a way in ASP.NET 2.0 to have different connection strings settings in a web.config files that are dynamically used based upon the server that the web application is running on? For example, you have have two test web servers (TEST1 and TEST2) and a production web server (PROD1). Each of these connection to a different database for general data access and for membership/role providers. <connectionStrings> <add name="Test1DB"...
0
8428
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8337
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8851
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8531
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6181
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4175
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4335
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1978
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1739
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.