Click here to Skip to main content
14,421,109 members
Rate this:
Please Sign up or sign in to vote.
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:

<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
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.

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)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100