Sql Server...Error for login into the database...(?) 1

[Ovatvvon]

Hello, I have been using Microsoft Access for my databases for quite some time now. I just got Sql Serve 7, and am attempting to learn it. So far I've imported an access database into it, and have started using it on a generic site for practicing. However, once the sql database needs to be accessed, it gives me this error:

Login failed for user 'WEBSERVER\IUSR_WEBSERVER'.

where IUSR_WEBSERVER is the generic internet user ID. I have tried setting that to an actual userID on the system, but it doesn't make a difference.

See what I mean:

http://jim.jwdinfo.com

Anyone know what I'm doing wrong that is keeping it from being able to be accessed?

-Ovatvvon

 

[foxdev]

Crank up the SQLS Enterprise Manager (EM), then drill down to the Security section and see if there is an entry for the Windows user WEBSERVER\IUSR_WEBSERVER. If there is not, add the user as an NT user (not standard user). In either case, ensure they have database permissions on the desired database. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[Ovatvvon]

That was the problem, then all I had to do was give that user systemadmin properties within too. (that was correct, right?) It wouldn't work (would give access to the table in the DB) until I did that so the user had read/write permissions from what I could tell.

Does that sound correct to you?

Either way, it works now. Thank you!

-Ovatvvon

 

[foxdev]

Generally, I would recommend against giving that account Sysadmin rights (its just too risky for me). The simplest way to do what you want to do is to give them dbdatareader and dbdatawriter permissions in the database (you can do this with Enterprise Manager). This gives them generic read/write access to all the tables in the database, without allowing them to change permissions, create tables, etc. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com/

http://www.agrainofhope.org

 

[scotth4v]

I am getting a similar problem, except it is returning the error:

[04/05/2001 14:47:38:401 CDT] DatabaseServlet: DatabaseServlet error: Cannot connect to jdbcdbc:Bug_Tracker_Test, reason:java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.


I have specified a UserID and Password in the DSN setup, (and the connection test passes there) however, it seems not to see the specified user when I call the DSN in my connection string... any ideas? I did tell it not to ust the NT authentication as well...

Thanks,
-Scott

 

[foxdev]

If you are using a connection string, add the following:

TRUSTED_CONNECTION=NO
Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com