But Now, I getting 2 more problems, at my deployment IIS Server, all the WebPages does not displaying correctly: a) All graphics does not appear b) My CSS Web Menu does not get formatted and displayed
All graphics, supporting CSS files and JQuery are stored together in subfolders in the ASP.NET main Project Folder.
I need advise how to fix this to work in deployment IIS Server.
Anyone has gone to similar problem , pls help.
~.~
*I hope this cld be the last error I need to fix to get it App to function as what i had programmed it to work
on my development PC..
And so far after this last bit, I have not face any further error as yet. Hope no further tricky error appear along the way during deployment to user .
I am sorry that I have to write back on here, seeking on further help here on the same WebApp.
Now the WebApp is successfully deployed, the database can be read and displayed info, as well as login and logout working fine.
However, whenever there is a need to update or write into the database, it will give me a "failed to update database....." error msg as below :-
I had ensure that the WebSharing for the application has been enable for Read/Write permission, but still the App does not seems to have write permission to the db.
Failed to update database "C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF" because the database is read-only.
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: Failed to update database "C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF" because the database is read-only.
Source Error:
Line 7660: int returnValue;
Line 7661: try {
Line 7662: returnValue = command.ExecuteNonQuery();
Line 7663: }
Line 7664: finally {
this is most definitely related to your connectionstring, had something similar recently try changing your connectionstring in the web.config and only put the server name as the datasource parameter if SQL server was installed with Default instance option
or Server name\instance name if named instance was used
HCamper
8048 Posts
Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP
Jun 30, 2011 03:44 AM|LINK
Hi,
Well spoke too soon for being up for the SQL server portion.
Well AFAIK the different numbers are for Builds and Versions of SQL Server and they are different for commands and structure.
You can on the Development PC using SQL Server Management Studio
attach the database and script to a new database to use one of the SQL 2005 SQL 2008 schema that may work
and also prevents data loss.
There is documentation for moving converting databases in the SQL Server Online Books
If you do not have a local copy of the Online Books now is the time to download
from Microsoft Download Center and have it for reference.
Martin
Community Member Award 2011
MythiosLow
15 Posts
Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP
Jun 30, 2011 07:45 AM|LINK
Hey Martin: I got it work once again.
For information of those who may face the same problem again:
--> Server 611 support by SQL Server 2005
--> Server 655 support by SQL Server 2008
--> Server 661,support by SQL Server 2008 Release 2
============================================================================
But Now, I getting 2 more problems, at my deployment IIS Server, all the WebPages does not displaying correctly:
a) All graphics does not appear
b) My CSS Web Menu does not get formatted and displayed
All graphics, supporting CSS files and JQuery are stored together in subfolders in the ASP.NET main Project Folder.
I need advise how to fix this to work in deployment IIS Server.
Anyone has gone to similar problem , pls help.
~.~
*I hope this cld be the last error I need to fix to get it App to function as what i had programmed it to work
on my development PC..
HCamper
8048 Posts
Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP
Jun 30, 2011 01:17 PM|LINK
Hi,
Yes, You have hit a common problem for Deployment and it likely permissions related.
Good job on getting the SQL server problems resolved and the SQL Server Build and Version information great research.
Please read this http://support.microsoft.com/kb/271071/en-us Microsoft Article for the default permissions for IIS 5.1 Server.
If you look at the table of permissions and the ASP.NET IWAM_MACHINE_NAME IUSR_MACHINE_NAME NETWORK
accounts users add them to the IIS Server and Web Site Project folders the Execute,Read,List level permissions
should work to allow access to the files.
You may find it of use to add or modfiy the ASP.NET account in IIS Server to have the Modify permissions to allow
access for changing files after the Web Site is up and running.
Check that the accounts users also have access to the C:\Windows\Temp folder along with write to allow creating temp files.
Since your using SQL Server add the account to the Web Site with standard permissions (Execute,Read,List)
and then add the write permission for the SQL Server account for the APP_DATA or location where the Database files are stored.
You can find the SQL Server accounts:
with the command-line prompt and> net commands for local groups or
the Administrator Tools and Local Users section your choice.
Modify the folders and permissions as needed for the IIS Server and Web Site.
HTH
Martin
Community Member Award 2011
HCamper
8048 Posts
Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP
Jul 04, 2011 10:39 AM|LINK
Hi,
Just checking have you
fixed the last bits?
Martin
Community Member Award 2011
MythiosLow
15 Posts
Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP
Jul 07, 2011 02:07 AM|LINK
Hello Martin . sorry , i was away on vacation for couple of days.
I manage to get it work, after reading articles you posted.
here is how i get it works (for future reference) :
> At IIS Server machine :
========================================================
And so far after this last bit, I have not face any further error as yet. Hope no further tricky error appear along the way during deployment to user .
Many thank to your contribution , Martin. :>
HCamper
8048 Posts
Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP
Jul 07, 2011 02:15 AM|LINK
Hi,
Cool beans now you can back to doing development :>.
Martin
Community Member Award 2011
MythiosLow
15 Posts
Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP
Jul 29, 2011 06:01 AM|LINK
Dear Martin:
I am sorry that I have to write back on here, seeking on further help here on the same WebApp.
Now the WebApp is successfully deployed, the database can be read and displayed info, as well as login and logout working fine.
However, whenever there is a need to update or write into the database, it will give me a "failed to update database....." error msg as below :-
I had ensure that the WebSharing for the application has been enable for Read/Write permission, but still the App does not seems to have write permission to the db.
anyone, pls help?
===========================================================
Server Error in '/FSTrack' Application.
Failed to update database "C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF" because the database is read-only.
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: Failed to update database "C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF" because the database is read-only.
Source Error:
===========================================================
HCamper
8048 Posts
Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP
Jul 29, 2011 06:20 AM|LINK
Hi,
Go to this "C:\PROJECT\FLAMMABLESUBSTANCETRACK\VER 1.4.3X\APP_DATA\DBSYSTEM.MDF" location
and use Windows Explorer and add ASP.NET SQL Server Network Account(s) and allow Write in the Security tab.
I think that should work.
FYI: SQL Server Security and user instance http://support.microsoft.com/kb/2002980 and connection settings changes.
Martin
Community Member Award 2011
MythiosLow
15 Posts
Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP
Aug 01, 2011 07:52 AM|LINK
it works. I did the followings to get it work..
Many thanks again .. cheers
caouellet
3 Posts
Re: Upgrade of IIS 5.1 to IIS 6 or 7 in WinXP
Aug 02, 2011 01:16 PM|LINK
this is most definitely related to your connectionstring, had something similar recently try changing your connectionstring in the web.config and only put the server name as the datasource parameter if SQL server was installed with Default instance option or Server name\instance name if named instance was used