Alex Chang's WebLog - All Comments

re: How to use Trusted Connection when SQL server and web Server are on two separate machines.

chel — Fri, 09 Oct 2009 13:12:13 GMT

this site is very useful...

re: How to use Trusted Connection when SQL server and web Server are on two separate machines.

jon80 — Sat, 14 Mar 2009 21:14:46 GMT

I would like to configure a trusted connection between two machines, the database server running on Windows Server 2008 Standard.

Sorry if it sounds basic, but how do I go about this?

re: How to use Trusted Connection when SQL server and web Server are on two separate machines.

leploep — Mon, 24 Nov 2008 10:28:54 GMT

I followed the steps in this article:

msdn.microsoft.com/.../ms998320.aspx

(for SQL start way below)

And gave the computeraccount acces to SQL-server.

Just as easy as running on local sql

re: How to use Trusted Connection when SQL server and web Server are on two separate machines.

Smita — Wed, 12 Nov 2008 06:13:45 GMT

The information provided here helped me understand authentication to SQL Server concepts well.

re: A fix for when Visual Studio .NET is slow in starting up/opening

at2000_zm — Sat, 07 Jun 2008 13:36:55 GMT

VS can load the app very slow if you have set many breakpoints. i have come across a link that provides excellent solution to this problem. it can also be used for other purpose also.

saurabhramya.googlepages.com/save%26loadbreakpointsinvisualstudio

re: How to use Trusted Connection when SQL server and web Server are on two separate machines.

Thangavignesh — Thu, 28 Feb 2008 12:18:26 GMT

this site is very useful for me

How to use Trusted Connection when SQL server and web Server are on two separate machines.

Vincent Yang — Fri, 22 Feb 2008 03:16:33 GMT

(Ref:weblogs.asp.net/.../113866.aspx)Recently,inourconsiderationt...

Top 10 Best Practices for Production ASP.NET Applications

Kyle Beyer — Wed, 13 Feb 2008 06:05:10 GMT

In no particular order, here are the top ten things I've learned to pay attention to when dealing

re: How to use Trusted Connection when SQL server and web Server are on two separate machines.

Kirill S — Fri, 25 Jan 2008 22:33:32 GMT

Alex,

I am so glad I ran into your web page. Your advice worked for me.

I experienced only minor differences, probably because I am working on Windows 2003 server.

To get the single sign on to work I had to disable Anonymous access and check Basic Authentication check box in IIS manager. I also had to add few lines in the web.config file:

Thanks,

Kirill

re: How to use Trusted Connection when SQL server and web Server are on two separate machines.

Sudip Purkayastha — Wed, 23 Jan 2008 04:20:36 GMT

Hi all,

I am facing one typical problem. my web server and DB server (which also having IIS server) are on different PC. i have configured ASP.net password on both the PCs. Now, once i try to connect the DB on trusted connection, giving IMPERSONATION=false, i get the same error.

But if i write IMPERSONATION=true USERNAME="xyz" PASSWORD="xyz" it works fine. i am having IIS 5.6

Please help.