IIS and SQL Server 2008 r2 Windows Authentication in an ASP.NET application

0.00/5 (No votes)

See more:

I created a very simple application in ASP.Net application hosted in the IIS VM that opens a database connection in the SQL Server VM. I've set the web site to authenticate via Windows Authentication only. Here is my connection string:

SQL

<add name="sqlconnInt" connectionString="Server=IBSPL_H-219-PC\SQLEXPRESS;database=.;Trusted_Connection=True" />

Code behind :-

SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlconnInt"].ConnectionString);

but data not able to see in our application in iss but when i am run my project from VS2010 all data came correct as per requirement pls help us if some know it

Posted 30-Jan-14 1:41am

Arjunwalmiki

Add a Solution

Comments

ZurdoDev 30-Jan-14 7:53am

Perhaps specify the database name in the connection string.

Prasad Khandekar 30-Jan-14 7:57am

Hello Arjun,

Since you are also specifying Trusted Connection as True, ensure that the ASP_NET user also has appropriate privileges in Database.

Regards,

Arjunwalmiki 30-Jan-14 23:59pm

dear prasad

i am already host my project in IIS 7.5 but due to Windows Authentication data not retrieve from server so i need solution of it

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Andre Oosthuizen	45
Pete O'Hanlon	25
goldli88	10
Rob Philpott	10
KarstenK	10

Richard Deeming	230
Pete O'Hanlon	105
OriginalGriff	100
Richard MacCutchan	70
M-Badger	50

IIS and SQL Server 2008 r2 Windows Authentication in an ASP.NET application

Add your solution here

Preview 0

IIS and SQL Server 2008 r2 Windows Authentication in an ASP.NET application

Add your solution here

Preview 0

Existing Members

...or Join us