Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

login failed for user 'Domain\MachineName$' ASP.NET app.

Posted on 2004-10-29
6
Medium Priority
?
1,915 Views
Last Modified: 2012-06-27
WILL CROSS POST ON ASP.NET

Hi,

We are trying to deploy an asp.net app. to a Windows Server 2003 running SQL Server.  When we try to access the DB we receive the following error :-

Login failed for user 'Domain\MachineName$'

We "think" we have set all correct user logins but can't be 100% sure as we cannot find any finite documentation on this and what we have found seems to apply to "NetWork security" users and ASPNET users but nothing relating directly to the machine account.

Any thoughts would be much appreciated.

James.
0
Comment
Question by:JAMES
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 11

Accepted Solution

by:
rdrunner earned 2000 total points
ID: 12442510
Hello

How are you accessing the DB? Please post the connection string. If you are using integrated Security then you need to add the ASP-User to the users which can access the DB (IUsr_YourPC........)

THis user must be added to your DB so you can use logins with integrated security.
0
 

Author Comment

by:JAMES
ID: 12442527
Hi,

Here is the connection string.

workstation id="JAMES-X31";packet size=4096;user id=sa;data source=R2D2;persist security info=True;initial catalog=Reality;password=MyPassword

JAMES-X31 is the name of the development machine (does this matter that it's different to the live server) and R2D2 is the name of the DB server (which is also the local web server in this instance)

James.
0
 
LVL 11

Expert Comment

by:rdrunner
ID: 12442552
Is the SQL Server configured to use SQL-Authentication? (or mixed) or is it "Windows only"

0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:JAMES
ID: 12442556
Mixed.
0
 
LVL 11

Expert Comment

by:rdrunner
ID: 12442636
Hmmm....

Can sa with mypassword login from a different computer?
0
 

Author Comment

by:JAMES
ID: 12442644
Havent tried that.  Im confused on who I should give login rights to in SQL Server for the ASP.NET process - is it ASPNET, NetworkSecurity etc

Once I am clear on this it will hopefully allow me to narrow the problem, at the moment I have too many variables.

James.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question