Interview Question in Visual Studio 2005


 

Interview Question :: Problem encountered when I run WEBSITE through IIS but not in VS2005 environment. Could you tel me please why

Hello All
I am developing a site in ASP.Net2, C#.Net and SQLServer. It is running when I run this website from the Visual Studio 2005 environment. It uses inbuilt ASP.Net Server

But I am trying to run from the IIS it giving an error "System.Data.SqlClient.SqlException: Login failed for user 'ABCD\ASPNET'."

It shows when try to create connection with the SQLServer2000. Code is as follow

Dim myCon as new SQLConnection

myCon.ConnectionString=strConnectionst...
myCon.Open ---> Here giving error.

I am using
Database=SQLServer2000
Operating System=WinXP
Framework=2
Visual Studio 2005

thanks
by ksk