Hello All:

I am experiencing a problem with SQL Express (VS 2005) (mdf file) and
IIS 6 deployment issue. There is an application that is developed by
me on ASP.NET C# and needs to be deployed on IIS 6 server.

The application:
The application prompts to enter the username password which is
checked in the SQL Express (mdf file), I'm not using the ASPNET.DB.
This works perfectly fine on my laptop that has IIS 5.1, VisualStudio
2005; with localhost, 127.0.0.1 & IP address. Also, it works on the
network that are in. However, the same application does not work on
IIS 6.0 on another network.

The issue:
While trying to login using the credentials (which are checked for
correctness), submitting the details comes back to the login page
without any errors. The code flow is fairly simple and straight
forward.

Once you click the login page.
1. Check username and password in the table
2. If it is a valid user, point to the users folder which has the
default.aspx
3. else load the login page with error stating "incorrect login or
password"

I am unable to replicate this problem on my laptop or my systems that
are on my network. Everything seems to be okay.

Somehow, I feel the connection to the SQL Express is not happening. I
tried loading the users/default.aspx page directly after removing the
validation condition. The page loads up but without any details about
the user content.

Has anyone faced this issue of circular reference on IIS 6.0 SQL
Express. I need to deploy this next week. The issue of not being to
replicate makes it even harder to get to the solution.

Any is appreciated.

Thanks
Suresh R Kumar

You really did not say it clear that what exactly happens when it seems not
working, any error message? If you suspect the connection to SQL Server
Express is not established, you could write a simple test page (assume you
could not directly do debugging on that IIS6 server) to verify it, rather
than use your Loggin page, which may missed something so it does not catch
the exception when it does not work as expected.

Some like this simple page, such as the deafault.aspx (you can comment out
all existing code): place a Label in the web form and then some code similar
to this:

private void Page_Load(...)
{
if (!Page.IsPostBack)
{
//make sure you know the ASP.NET app's running account hace access
permission with corresponing
//Windows account, or if you use SQL Server security, include
correct username/password
string connectionString="server=.....;database=....;..... .";

using (SqlConnection cn=new SqlConnection(connectionString))
{
try
{
cn.Open();
cn.Close()
Label1.Text="Connection to SQL Server database
established!";
}
catch(Exception ex)
{
Label1.Text-"Cannot connection SQL Server database: " +
e.Message;
}
}
}
}

Simply run this page on the IIS server would tell you if the APS.NET app
could connect to the SQL Server or not.

I strongly suspect that the problem is you did not configure your ASP.NET
app and SQL Server Express correctly, which can hardly just because of the
using of IIS6.0 and SQL Server Express together.

<skumarrk@gmail.com> wrote in message
news:d08fcfd5-29f0-4a4a-9ac6-f950a7c81d18@w4g2000prd.googlegroups.com...
> Hello All:
>
> I am experiencing a problem with SQL Express (VS 2005) (mdf file) and
> IIS 6 deployment issue. There is an application that is developed by
> me on ASP.NET C# and needs to be deployed on IIS 6 server.
>
> The application:
> The application prompts to enter the username password which is
> checked in the SQL Express (mdf file), I'm not using the ASPNET.DB.
> This works perfectly fine on my laptop that has IIS 5.1, VisualStudio
> 2005; with localhost, 127.0.0.1 & IP address. Also, it works on the
> network that are in. However, the same application does not work on
> IIS 6.0 on another network.
>
> The issue:
> While trying to login using the credentials (which are checked for
> correctness), submitting the details comes back to the login page
> without any errors. The code flow is fairly simple and straight
> forward.
>
> Once you click the login page.
> 1. Check username and password in the table
> 2. If it is a valid user, point to the users folder which has the
> default.aspx
> 3. else load the login page with error stating "incorrect login or
> password"
>
> I am unable to replicate this problem on my laptop or my systems that
> are on my network. Everything seems to be okay.
>
> Somehow, I feel the connection to the SQL Express is not happening. I
> tried loading the users/default.aspx page directly after removing the
> validation condition. The page loads up but without any details about
> the user content.
>
> Has anyone faced this issue of circular reference on IIS 6.0 SQL
> Express. I need to deploy this next week. The issue of not being to
> replicate makes it even harder to get to the solution.
>
> Any is appreciated.
>
> Thanks
> Suresh R Kumar
>
>

<skumarrk@gmail.com> wrote in message
news:d08fcfd5-29f0-4a4a-9ac6-f950a7c81d18@w4g2000prd.googlegroups.com...
> Hello All:
>
> I am experiencing a problem with SQL Express (VS 2005) (mdf file) and
> IIS 6 deployment issue. There is an application that is developed by
> me on ASP.NET C# and needs to be deployed on IIS 6 server.
>
> The application:
> The application prompts to enter the username password which is
> checked in the SQL Express (mdf file), I'm not using the ASPNET.DB.
> This works perfectly fine on my laptop that has IIS 5.1, VisualStudio
> 2005; with localhost, 127.0.0.1 & IP address. Also, it works on the
> network that are in. However, the same application does not work on
> IIS 6.0 on another network.
>
> The issue:
> While trying to login using the credentials (which are checked for
> correctness), submitting the details comes back to the login page
> without any errors. The code flow is fairly simple and straight
> forward.
>
> Once you click the login page.
> 1. Check username and password in the table
> 2. If it is a valid user, point to the users folder which has the
> default.aspx
> 3. else load the login page with error stating "incorrect login or
> password"
>
> I am unable to replicate this problem on my laptop or my systems that
> are on my network. Everything seems to be okay.
>
> Somehow, I feel the connection to the SQL Express is not happening. I
> tried loading the users/default.aspx page directly after removing the
> validation condition. The page loads up but without any details about
> the user content.
>
> Has anyone faced this issue of circular reference on IIS 6.0 SQL
> Express. I need to deploy this next week. The issue of not being to
> replicate makes it even harder to get to the solution.
>
> Any is appreciated.
>
> Thanks
> Suresh R Kumar
>
Hi

I assume this is not the same database instance that you have successfully
connected to?

It is not clear what the error is you are getting, or whether there has been
a connection to the database and it is failing the forms based
authentication you are using?

I would assume that you are getting a server not found problem, in which
case check that you have remote connections set in the Surface Area
Configuration Tool (SQLSAC.exe). Also check what the account that is being
used to login to the database server and make sure that it has been granted
a login. You may also use SQLCMD to check connectivity and rule out IIS.

John