ASP.NET

12-Feb-09 18:30

hi , when i run my asp.net page from IIS, it shows the following configuration error

how could to resolve..?

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

Source Error:

Line 43: ASP.NET to identify an incoming user.
Line 44: -->
Line 45:authentication mode="Windows"
Line 46:

Vimalsoft(Pty) Ltd12-Feb-09 19:50

12-Feb-09 19:50

Explain the Steps you took when deploying your application

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswam@its.co.za

MS Lee12-Feb-09 20:01

12-Feb-09 20:01

previously i went to IIS tree, right-click the Default Web Site item and choose New -> Virtual Directory
gave alias name,then physical directory path,and gave virtual directory access path,and finished.

then i delete the virtual directory
and configure again with the same process, i dont know how the things went wrong previously,

now my index page is working, here am getting user name and login,
when i give signin button am getting error as

Server Error in '/MySweethomes' Application.
Cannot open database "test" requested by the login. The login failed.
Login failed for user 'SOFTWARE\ASPNET'.--------------> here my database name is 'SOFTWARE\test'

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: Cannot open database "test" requested by the login. The login failed.
Login failed for user 'SOFTWARE\ASPNET'.

Source Error:

Line 23: {
Line 24: SqlConnection conn = new SqlConnection(ConnStr);
Line 25: conn.Open();
Line 26: string MyQuery = "SELECT USERNAME,PASSWORD FROM LoginDB " + "WHERE USERNAME = '" + UName + "' AND PASSWORD = '" + Pass + "'";

Line 27: SqlDataAdapter Sda = new SqlDataAdapter(MyQuery, conn);

Source File: F:\SweetHomes\SweetHomes\Login.cs Line: 25

self confidence+hard work=SUCCESS

Vimalsoft(Pty) Ltd12-Feb-09 20:15

12-Feb-09 20:15

This tells me that your Connection string in your web.config is poiting to an incorrect database or path.

Post your Connection String in your Web.Config and let us see

MS Lee12-Feb-09 20:21

12-Feb-09 20:21

do you want all lines from that,,?
i coded only as
appsettings
add key="MyConnection"
value="Data Source=SOFTWARE;Initial Catalog=test;Integrated Security=True;" />
add/appsettings
authentication mode="Windows"

self confidence+hard work=SUCCESS

Vimalsoft(Pty) Ltd12-Feb-09 20:32

12-Feb-09 20:32

Where is the Username and Password ?

That is why it gives errors, try to write it like this

XML

<add key="MyConnection" value="User id = sa;Password=mypass;Server=SOFTWARE;Database= test" />

If you are working with SQL Server you must always pass the username and password

MS Lee12-Feb-09 20:39

12-Feb-09 20:39

there is no user name and password..
and i execute
exec
sp_grantdbaccess N'SOFTWARE\ASPNET', N'ASPNET'
exec
sp_addrolemember N'db_owner', N'ASPNET'
this commands and now its working,

self confidence+hard work=SUCCESS

Vimalsoft(Pty) Ltd12-Feb-09 20:42

12-Feb-09 20:42

You execute this in SQL ?

If yes, then before you execute this, you must first login in order to run Commands, so that user name and password that you use to log in there , is what is needed.

MS Lee12-Feb-09 20:34

12-Feb-09 20:34

i solve this problem
i execute the following query and now its working
exec
sp_grantdbaccess N'SOFTWARE\ASPNET', N'ASPNET'
exec
sp_addrolemember N'db_owner', N'ASPNET'

and .... !!

after successfully login am showing a page and in that am updating a content of text in to text file,
now when i try to update the text content am getting as

Could not find a part of the path 'C:\windows\system32\SweetHomes\Documents\SweetHomes.txt'.
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.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\windows\system32\SweetHomes\Documents\SweetHomes.txt'.

Source Error:

Line 43: string fname = "SweetHomes\\Documents\\SweetHomes.txt";
Line 44: string readcontent;
Line 45: StreamReader Srdr = new StreamReader(fname);
Line 46: readcontent = Srdr.ReadToEnd();
Line 47: Srdr.Close();

Source File: F:\SweetHomes\SweetHomes\AdminInfo.aspx.cs Line: 45

self confidence+hard work=SUCCESS

MS Lee12-Feb-09 21:10

12-Feb-09 21:10

actually
i create a folder in my application and create a text file in that,
through the coding am showing content and updating the contents to the file.
now when i run this page from IIS and try to show the contents
it shows the cannot find the path
it takes the path from C:\windows\system32\SweetHomes\Documents\SweetHomes.txt
but mine in F:\SweetHomes\Documents\SweetHomes.txt

i could not find solution to change the path !!

self confidence+hard work=SUCCESS

MS Lee12-Feb-09 23:51