IIS 6.0 Error on Server 2003

Question

1.00/5 (1 vote)

See more:

I just added a ASP.NET web project to my 2003 server that has IIS 6.0. I add a Virtual Directory and everything works so far. When I browse to the VD it comes up with the login page I made so I login using the username and password that is in the SQL database of the project and I get this error:

CSS

Login failed for user 'MASTER-PC\COCWEB$'.
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: Login failed for user 'MASTER-PC\COCWEB$'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

What did I do wrong? Will this happen every when I make a link on the current web site to connect users to the newapp site for them to login? Whatis the best way to fix this? This will part of the current website that I have up already. So I have it as: www.newdeal.com/newapp.

C#

<configuration>
  <connectionstrings>
    <add name="PasswordConnectionString" connectionstring="Data Source=COCSQL;Initial Catalog=Password;Integrated Security=True" providername="System.Data.SqlClient"></add>
  </connectionstrings></configuration>

Posted 20-Sep-13 4:47am

Computer Wiz99

Updated 20-Sep-13 7:55am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2013-09-20T06:39:00

Solution 1

It is saying that you can't login to SQL using the account MASTER-PC\COCWEB$. You just need to use an account that has permissions.

Posted 20-Sep-13 6:39am

ZurdoDev

Comments

Computer Wiz99 20-Sep-13 13:28pm

RyanDev, do you think it will work if I add MASTER-PC\COCWEB to the SQL server as a user?

ZurdoDev 20-Sep-13 13:41pm

Yes. Whatever is in your web.config (I assume you are using one).

Computer Wiz99 20-Sep-13 13:44pm

Ok, Thanks. One more question, I have over 5000 users that is going to use this system. They can connect to it through my current website. Is there a way to set them up without inputting all of them?

ZurdoDev 20-Sep-13 13:50pm

In web.config you should have a connection string and in that connection string will be a username and password. Any Sql code that you write should use that connection string so that all Sql access uses that same account. That is how most websites will work.

Computer Wiz99 20-Sep-13 13:53pm

Ok. Can you show me an example so I will know that I am on the right page with you in web.config? What should that connection look like? This is what I have: (Code in Improve Question).

ZurdoDev 20-Sep-13 13:59pm

Integrated Security means it will use Windows authentication against SQL so each user's windows account will need access to SQL. Sometimes people do it this way. It all depends on what you are doing and is something you have to decide.

Computer Wiz99 20-Sep-13 14:13pm

So does this mean that every user will be able to login without them being added to the web.config file?

ZurdoDev 20-Sep-13 14:27pm

Login and accessing the database are not the same thing. For logging in I would recommend you research FormsAuthentication.

Computer Wiz99 20-Sep-13 14:27pm

Ok. I added the computer to the SQL server. I ran the website on the web and it came up. I tried to log in but I get a run time error. Why is that?

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customerrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customerrors> tag should then have its "mode" attribute set to "Off".



<configuration>
<system.web>
<customerrors mode="Off">

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customerrors> configuration tag to point to a custom error page URL.



<configuration>
<system.web>
<customerrors mode="RemoteOnly" defaultredirect="mycustompage.htm">

ZurdoDev 20-Sep-13 14:28pm

I don't know why you have an error because there are no error details. Look in the event viewer or do what the message suggests. I think you are jumping into this very unprepared and would be better off reading up on ASP.Net first.