473,785 Members | 2,283 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

trusted connection

Hi-
Is it possible to do a trusted connection for a web server not on
the same physical machine. By this I mean can I make a remote
connection from a web server to a sql server using a trusted connection.
If so, how?

Thanks,
Dave

Jul 20 '05 #1
2 7063

"bigDWK" <ne*******@dave wking.com> wrote in message
news:e2R9b.4783 02$YN5.326092@s ccrnsc01...
Hi-
Is it possible to do a trusted connection for a web server not on
the same physical machine. By this I mean can I make a remote
connection from a web server to a sql server using a trusted connection.
If so, how?

Thanks,
Dave


One of these links may help, assuming you're using IIS/ASP (you didn't
mention your web server):

http://support.microsoft.com/default...b;EN-US;176379
http://support.microsoft.com/default...b;EN-US;176377

Simon
Jul 20 '05 #2
Thanks for the Reply. I'm using Windows 2003 Web with IIS 6 and
Windows 2003 Enterprise with MS SQL Server 2000. Both have the most
up to date patches and service releases. Basically what I'm trying to
do is from the Web Server Box to the SQL Box without putting the
username and password in my ASP code. I read somewhere that this is
bad and should be avoided. It said to use a trusted connection
instead. Any ideas on how to do this?

Thanks

"Simon Hayes" <sq*@hayes.ch > wrote in message news:<3f******* ***@news.bluewi n.ch>...
"bigDWK" <ne*******@dave wking.com> wrote in message
news:e2R9b.4783 02$YN5.326092@s ccrnsc01...
Hi-
Is it possible to do a trusted connection for a web server not on
the same physical machine. By this I mean can I make a remote
connection from a web server to a sql server using a trusted connection.
If so, how?

Thanks,
Dave


One of these links may help, assuming you're using IIS/ASP (you didn't
mention your web server):

http://support.microsoft.com/default...b;EN-US;176379
http://support.microsoft.com/default...b;EN-US;176377

Simon

Jul 20 '05 #3

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

Similar topics

2
2462
by: C.O.Jones | last post by:
Hi, I've got SQL2000 Evaluation edition running on my own Windows XP Pro computer. I've installed it fine, and created some sample databases. It works fine. I can connect using Windows authentication. But when I try to connect with username & password I get the error message: "Login failed for user sa Reason: not associated with a trusted SQL Server connection.
2
16494
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 sqladapter to my SQL Server - Northwind - which I dragged from Server Explorer. I generate a dataset, and Preview Data in the da, works fine. I then enter vb code on Page_Load event: SqlDataAdapter1.Fill(ds) DataGrid1.DataSource =...
2
31133
by: Blake Versiga | last post by:
I am pulling my hair out..... I am trying to put a bound data grid on a webform... I have 4 data connections in my server explorer, all of which connect successfully. But when I run the web page I get the error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. I use a connection string in my application in several other pages with no
4
2082
by: Brian Henry | last post by:
I an trying to connect to a sql server in asp.net with the sql connection object, and every time i try to open the connection i get this Server Error in '/' Application. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. why am i getting this? and how do i get around it? I am logged into the domain on the machine that the asp.net system is on, the sql server is a
7
2166
by: Ray Valenti | last post by:
I am able to preview this data in the development environment, but when I run the application the error below shows up. How do I set up a Trusted Connection? -Ray Server Error in '/WebApplication2' Application. ---------------------------------------------------------------------------- ----
2
1629
by: Paul M | last post by:
Hi, I've just implemented my first application onto a test web server. When the code comes to creating a connection object it throws an error saying the "Login failed for user '(null)'. Reason : Not associated with a trusted connection". I'm using integrated security and it works from the IIS server I have set up on my local machine. The connection string I'm using is
2
1772
by: Paul M | last post by:
Hi folks, Just want to make sure I've got this right. I've got an application I want to authenticate to the domain i.e. an intranet app. I've set this up (all the web.config items are in place and everythings tickety boo) and I can get the username and various other bits of info from a WindowsIdentity object. So far so good. When I try and connect to my SQL 2K server however using a trusted
3
5764
by: Mad Scientist Jr | last post by:
I am getting the following error when trying to access a database with a trusted connection: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." My connection string is: "Server=MyServer; Database=MyCatalog; Trusted_Connection=True;"
4
12092
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 running on Windows 2003. If I use SQL authentication, all is fine and dandy. If I want to use windows authentication it gives the above error. My SQL server is set to allow both methods (first thing I checked) and is part of the domain (2nd...
0
9643
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
9480
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
10315
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...
0
10147
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9946
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7494
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
6737
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
3645
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2877
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.