473,322 Members | 1,188 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Not associated with a trusted SQL Server connection

We are running SQL server 2000 on MS Windows Server 2000. We have web based
database (ASP.net and SQL Server 2000). When I run this page with 'sa'
account, It works but when I change it to Window autointoxication I am
getting the following error massage.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I don't want to use 'sa' account. Please let me know how to solve this
problem.
Nov 17 '05 #1
3 4309
Hello vlad !

Try to search for "impersonation" in the web.config, its responsible for the
behaviour of SQL Server and your Web Server.

Jens Süßmeyer
"vlad" <st*********@stampsworld.net> schrieb im Newsbeitrag
news:er**************@TK2MSFTNGP09.phx.gbl...
We are running SQL server 2000 on MS Windows Server 2000. We have web based database (ASP.net and SQL Server 2000). When I run this page with 'sa'
account, It works but when I change it to Window autointoxication I am
getting the following error massage.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I don't want to use 'sa' account. Please let me know how to solve this
problem.

Nov 17 '05 #2
The other poster recommended impersonation. However a few 'Gotchya' there
1) The requesting user must have authenticated on the web server before the
SQL request
2) This prevents using connection pooling as the connection string changes,
and therefore slows execution
3) The calling user must be an user on the SQL Box.

I suggest that you add ASPNET as a user on the SQL Box, set the permissions
to what the server will need, and use that account. This side steps the
issues above.

Tom
--
==========================================
= Tom Vande Stouwe MCSD.net, MCAD.net, MCP
= 45Wallstreet.com (www.45wallstreet.com)
= (803)-345-5001
==========================================
= If you are not making any mistakes
..= ..you are not trying hard enough.
==========================================
"vlad" <st*********@stampsworld.net> wrote in message
news:er**************@TK2MSFTNGP09.phx.gbl...
We are running SQL server 2000 on MS Windows Server 2000. We have web based database (ASP.net and SQL Server 2000). When I run this page with 'sa'
account, It works but when I change it to Window autointoxication I am
getting the following error massage.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I don't want to use 'sa' account. Please let me know how to solve this
problem.

Nov 17 '05 #3
I don't have impersonation in my web.config. So all I have to do just create
one?
"dave" <da********@hotmail.com> wrote in message
news:06****************************@phx.gbl...
just set impersonation = true and give it an account login
and password
-----Original Message-----
Hello vlad !

Try to search for "impersonation" in the web.config, its responsible for thebehaviour of SQL Server and your Web Server.

Jens Süßmeyer
"vlad" <st*********@stampsworld.net> schrieb im Newsbeitragnews:er**************@TK2MSFTNGP09.phx.gbl...
We are running SQL server 2000 on MS Windows Server 2000. We have web
based
database (ASP.net and SQL Server 2000). When I run this

page with 'sa' account, It works but when I change it to Window autointoxication I am getting the following error massage.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I don't want to use 'sa' account. Please let me know how to solve this problem.

.

Nov 17 '05 #4

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

Similar topics

2
by: TBone | last post by:
Anyone, I have a user "john" whose machine is part of the "job" domain. He is trying to establish an odbc connection to an MS SQL 2000 server on the "school" domain. He uses Windows...
2
by: DMS | last post by:
am new to ASP.NET and IIS web applications, but not to SQL databases. I can successfully build Windows apps using Visual Studio that use ADO. However, for Web Forms, I created data connection and...
2
by: epaetz | last post by:
I'm getting Not associated with a trusted SQL Server connection errors on a .Net windows service I wrote, when it's running on my application server. It's not a problem with mixed mode...
1
by: Mark | last post by:
We are using impersonation so that a user on our domain will login into our SQL Server using their own domain login and/or associated domain groups. To do this, we've added: <authentication...
4
by: rrober07 | last post by:
Hello, My Setup is I have a Web Server machine(Devweb01), Database SQL Machine(Devsql01), a Client Machine(local machine) I have configured the SQL machine as follows: 1) Added local Aspnet...
5
by: Mythran | last post by:
I have a test server and a development machine. I have SQL Server installed on both, the installations are pretty much identical. Both servers are in the same domain. When I run my application...
1
by: jerminator | last post by:
Ok I need some help. Up until Tuesday my application was working fine. It is an asp.net application written in VB. It is very data heavy and makes multiple calls to a database. The application...
3
by: Newbie19 | last post by:
I'm having an issue with viewing my ASP/SQL application in Internet Explorer. I get the error from my Server (located on my PC using IIS 5.0) stating: Login failed for user '(null)'. Reason:...
4
by: eruth | last post by:
There are loads of post on this, but nothing that seems to cover my exact problem ;) I have an ASP.Net 1.1 web application running on my local machine. I want to connect to an SQL 2005 server...
2
by: gnewsgroup | last post by:
OK, I know this has been a popular question from newbies. But, please don't haste to reply yet. I've googled and tested for a few hours, and cannot have this problem resolved. I have...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.