Reply

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Jun 29, 2011 07:05 AM|LINK

Hi Matin :

Thank for the reference. Allow me to correct my problem.

Actually my Web App has now been revised to use only MicrosoftReport,
it is not using CrystalReport anymore.

And I had also removed those lines in web.config, that are required for CrystalReport
and this has also cleared off Source Error #1 & Source Error #3 as shown in above post.

But Source Error #2, that is meant for MicrosoftReport is still exist.

I need advise on how to solve for the MicrosoftReport,
where and how to install patches update for MicrosoftReport into the IIS on WinXP.

~.~

Edited by mythioslow on Jun 29, 2011 07:20 AM

Reply

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Jun 29, 2011 07:19 AM|LINK

Hello,

So now you have shifted to Reports Viewer for Visual Studio 2008.

Then download the Reports Viewer from Microsoft Download Center

http://www.microsoft.com/download/en/details.aspx?id=3841 this is the Service Pack 1 version.

Martin

Windows and Linux work Together IT-Pros
Community Member Award 2011

Marked as answer by Lloydz on Jul 03, 2011 04:23 AM

Reply

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Jun 29, 2011 07:35 AM|LINK

Hey, My MicrosoftReport problem solved.

But now I got another error appearing with SQL Server.
Any update/patches to be install for SQL server into the IIS on WinXP?

It seems that when one problem solve, another problem appear.. :<

See below Screen:
=============================================================================================

Server Error in '/FSTrack' Application.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

Line 7579: dataTable.Clear();

Line 7580: }

Line 7581: int returnValue = this.Adapter.Fill(dataTable);

Line 7582: return returnValue;

Line 7583: }

Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\fstrack\96dd1eec\ae4085a3\App_Code.pf5dhy5o.2.cs Line: 7581

Edited by mythioslow on Jun 29, 2011 07:36 AM
Edited by mythioslow on Jun 29, 2011 07:36 AM
Edited by mythioslow on Jun 29, 2011 07:37 AM

Reply

HCamper

8048 Posts

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Jun 29, 2011 08:26 AM|LINK

Hello,

Since you have not included information for

SQL Server Version Edition details the answer is both yes and no.

For your currrent Problem check http://social.msdn.microsoft.com/forums/en-US/sqlgetstarted/thread/9354bf59-15a2-49f4-bc1f-f45371e054fc/

post from SQL Server Forums that describes the steps to allow connections to the SQL Server.

You may need to make modifications to the connection string in the web.config to match the current location of the \\ server InstanceName .

You may also need to check the permissions for the Account and User for where the *.mdf *.ldf files are located.

HTH

Martin

Windows and Linux work Together IT-Pros
Community Member Award 2011

Reply

MythiosLow

15 Posts

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Jun 30, 2011 02:15 AM|LINK

Hello Martin:

There is actually no SQL Server in the deployment IIS Server(WinXP).
It is merely a SQL database file (dbSystem.mdf & dbSystem.LDF) that is
reside in the sub-folder "App_Data" under the entire Project root folder.

(D:\project\ChemicalTrackSite\App_Data\..... )

The Connection to this "dbSystem.mdf" in the Web.config is as follow:
=============================================================
<connectionStrings>

<add name="dbSystemConnectionString"
connectionString="Data Source = .\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbSystem.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>
=============================================================

The connectionString work perfectly fine in my Development PC when launched with VS2008. But when deployed over to the deployment IIS Server(WinXP). The error occur.

Edited by mythioslow on Jun 30, 2011 02:29 AM
Edited by mythioslow on Jun 30, 2011 02:49 AM

Reply

MythiosLow

15 Posts

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Jun 30, 2011 02:52 AM|LINK

And next thing I did was to downloaded the SQL Server 2005 Express Edition and installed to the Deployment IIS Server.

Then it seems to be able to detect the SQL Server files. But there is a versioning error appear as follows?

I need advise on what is version 661 and version 611?
What do I need to install to make SQL work for the correct version?

:<

=================================================================

Server Error in '/FSTrack' Application.

The database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF' cannot be opened because it is version 661. This server supports version 611 and earlier. A downgrade path is not supported.
Could not open new database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Project\FlammableSubstanceTrack\ver 1.4.3x\App_Data\dbSystem.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF' cannot be opened because it is version 661. This server supports version 611 and earlier. A downgrade path is not supported.
Could not open new database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Project\FlammableSubstanceTrack\ver 1.4.3x\App_Data\dbSystem.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Source Error:

Line 7579:                dataTable.Clear();

Line 7580:            }

Line 7581:            int returnValue = this.Adapter.Fill(dataTable);

Line 7582:            return returnValue;

Line 7583:        }

=================================================================

Reply

MythiosLow

15 Posts

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Jun 30, 2011 02:52 AM|LINK

And next thing I did was to downloaded the SQL Server 2005 Express Edition and installed to the Deployment IIS Server.

Then it seems to be able to detect the SQL Server files. But there is a versioning error appear as follows?

I need advise on what is version 661 and version 611?
What do I need to install to make SQL work for the correct version?

:<

=================================================================

Server Error in '/FSTrack' Application.

The database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF' cannot be opened because it is version 661. This server supports version 611 and earlier. A downgrade path is not supported.
Could not open new database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Project\FlammableSubstanceTrack\ver 1.4.3x\App_Data\dbSystem.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF' cannot be opened because it is version 661. This server supports version 611 and earlier. A downgrade path is not supported.
Could not open new database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Project\FlammableSubstanceTrack\ver 1.4.3x\App_Data\dbSystem.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Source Error:

Line 7579:                dataTable.Clear();

Line 7580:            }

Line 7581:            int returnValue = this.Adapter.Fill(dataTable);

Line 7582:            return returnValue;

Line 7583:        }

=================================================================

Reply

MythiosLow

15 Posts

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Jun 30, 2011 02:55 AM|LINK

(SORRY TO SPAM POST the SAME Message 3 times here. I did it with the EDIT functions here, but somehow it got posted up as 3 reply POSTS. ~.~)

And the next thing i did was downloaded SQL Server 2005 Express Edition to the Deployment IIS Server (WinXP).

Then it seems to be able to recognize my MDF file in the App_Data folder. But now it seems to have some versioning error, as shown below

I need advise on what is version 661 and version 611?
What SQL edition do i need to install to make it work with the correct version?

================================================================

Server Error in '/FSTrack' Application.

The database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF' cannot be opened because it is version 661. This server supports version 611 and earlier. A downgrade path is not supported.
Could not open new database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Project\FlammableSubstanceTrack\ver 1.4.3x\App_Data\dbSystem.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF' cannot be opened because it is version 661. This server supports version 611 and earlier. A downgrade path is not supported.
Could not open new database 'C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Project\FlammableSubstanceTrack\ver 1.4.3x\App_Data\dbSystem.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Source Error:

Line 7579:                dataTable.Clear();

Line 7580:            }

Line 7581:            int returnValue = this.Adapter.Fill(dataTable);

Line 7582:            return returnValue;

Line 7583:        }

================================================================

Edited by mythioslow on Jun 30, 2011 02:55 AM
Edited by mythioslow on Jun 30, 2011 02:56 AM
Edited by mythioslow on Jun 30, 2011 02:59 AM

Reply

HCamper

8048 Posts

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Jun 30, 2011 03:14 AM|LINK

Hello,

mythioslow

A) There is actually no SQL Server in the deployment IIS Server(WinXP).

B) The connectionString work perfectly fine in my Development PC when launched with VS2008.

C) But when deployed over to the deployment IIS Server(WinXP).

D) The error occur.

For A) that is ok but you will need to modify the connectionString

to use the Remote SQL Server on the Developement machine or install SQL Server Express on the Deployment machine

and use as a local SQL Server.

For B) Yes the connectionString worked and you have SQL Server on the Developement PC.

For C) When you Deploy a Database Driven Web Site you need to ask your self where is the SQL Server located.

For D) Sorry but true a learning portion for deploment of Database Driven Web Projects and Web Sites.

The Developers Dilemma I know it Works:

It worked on the Development System then fails on the Client or Target system.

Count this issue as part of the curve and be happy your not dealing with a less understanding client.

I think at this stage you have IIS Server operational.

So for additional development steps the ASP.NET and SQL Server Forums are your next resource.

Martin

Windows and Linux work Together IT-Pros
Community Member Award 2011

Edited by HCamper on Jun 30, 2011 03:17 AM

Reply

MythiosLow

15 Posts

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Jun 30, 2011 03:24 AM|LINK

Hi Martin : Thanks.

I just upgraded the SQLServer 2005 Express Edition to SQLServer 2008 Express Edition, now it give me another error
"....APP_DATA\DBSYSTEM.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported....."

I need to know what is SQL version 661 and version 611 and versioon 655?
And what do i need to install to make SQL work for the correct version in my target server?

very Confused with various SQL version. :<

Edited by mythioslow on Jun 30, 2011 03:40 AM

Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP RSS

29 replies

MythiosLow

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

HCamper

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

MythiosLow

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

HCamper

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

MythiosLow

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

MythiosLow

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Server Error in '/FSTrack' Application.

MythiosLow

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Server Error in '/FSTrack' Application.

MythiosLow

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

Server Error in '/FSTrack' Application.

HCamper

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP

mythioslow

MythiosLow

Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP