Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server Login error

Posted on 2008-10-15
7
Medium Priority
?
416 Views
Last Modified: 2008-10-15
Hello,

I have a PC running Vista Home Premium.

I have an ASP application that is trying to access a local SQL Server 2000 database.

The database is registered to use Windows authentication (don't know if that authentication exists in Vista Home Premium).

In the file DSN, used by the ASP application, it is registered in ODBC "With Windows NT authentication using the network login ID".

I get an error when my ASP application tries to access the database:

"Login failed for user "NT AUTHORITY/IUSR"

Any advice?

Thanks in advance,

Steve
0
Comment
Question by:skbohler
  • 4
  • 3
7 Comments
 
LVL 2

Expert Comment

by:tree33
ID: 22723611
You probably only have to grant access to the database for IUSR_%MACHINENAME%.
When this doesn't help, can you please give us more details on the connection string you're using.
0
 

Author Comment

by:skbohler
ID: 22723675
How do I grant access to the SQL Server database to that account?

The connection string is just: "FILEDSN="c:\users\{dir}\application.dsn"
0
 
LVL 2

Expert Comment

by:tree33
ID: 22723797
Use SQL Enterprise Manager to add the user IUSR_%MACHINENAME% to the SQL Server in the security node.
Then go to the database's Logins node and add the login to the DB and set the needed permissions for that login.
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:skbohler
ID: 22723875
OK, I tried to add the login.

For Windows Authentication, In the Domain drop-down, I chose the computer name. That auto-filled the login name, but when I tried to OK it, it tells me that:

{MachineName}\IUSR_{MachineName} not found. Check the name again.

What am I doing wrong?

Thanks!

Steve
0
 

Author Comment

by:skbohler
ID: 22724030
I added the login:

NT AUTHORITY\IUSR and it took that.

Now, the error I get:

"Cannot open database requested in login '{database}'. Login fails.

??
0
 
LVL 2

Accepted Solution

by:
tree33 earned 2000 total points
ID: 22724089
Did you also add a role to that login for the database? Depending on the access that user needs you can try with datareader and/or datawriter.

Only adding the login the the SQL Server is not enough, you also have to assign this login to a database.
0
 

Author Comment

by:skbohler
ID: 22724116
OK, I see I didn't add it to the database. Fixed. Thanks!!!!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A phishing scam that claims a recipient’s credit card details have been “suspended” is the latest trend in spoof emails.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

782 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