?
Solved

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

Posted on 2004-10-29
6
Medium Priority
?
1,942 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
  • 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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 

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

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
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…

588 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