not able to access sql server using trusted connection.

[Ramesh]

I am trying to access a remote sql server from an ASP.Net application
using ADO.Net. I want to use trusted connection and so set the
connection string as

Dim strConn As String = Network
Library=DBMSSOCN;server=ServerName;database=DatabaseName;Trusted_Connection=true

Also in the web.config file I set
<authentication mode="Windows" />
and <identity impersonate="true" />
settings.

In the IIS I set it to use Integrated Windows Authentication.

If I login to the machine that has the IIS and run the application of
the browser, I am able to access the sql server. How ever If I access
the page from a remote machine. I am getting this error.
System.Data.SqlClient.SqlException: Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection.

Hope this explanation is good enough for u guys to understand the
problem. Thanks in advance.

 

[Trevor Benedict R]

See if this discussion helps

http://dotnetjunkies.com/Newsgroups/microsoft.public.dotnet.framework.as
pnet.security/2004/3/22/74067.aspx

Trevor Benedict R
MCSD

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Trevor Benedict R]

Or you could also try basic authentication if you are not setup to use
AD

Trevor Benedict R
MCSD

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Ramesh Gummadi]

Sorry for the late reply. I will try it out. thnaks a lot.

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!