Greetings all,

i am trying to connect to a sql database from an asp.net app. we have created a specific user on the domain to do this. i can log in as this user, and hit the database using enterprise manager/query analyzer no problem. but when i try it with my code, using an olddb.connection object, i keep getting a 'login failed for user cof\ouruser' error. is there a setting that i am missing, or is there another user object (like the aspnet user) that needs to be given rights somewhere down the line?

any ideas would be appreciated.

thanks

use either enterprise or query analyser to do the following:
if you are using windows integrated authentication ->
give this windows user a login to the sql then give it access to the needed database

Ahmed Ali
Software Developer

Thanks, but we are using mixed mode, and the user already has rights to the database. that's what makes it confusing. it seems like this should be working.

Are you sure the connection string doesn't have any errors?

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

It's been checked several times. We have had this problem before with other apps, and always just ended up creating a SQL user to connect (a better solution in my opinion, but i ain't the boss around here). everything i read indicates that what i am doing is correct, it just doesn't work. time to work on the dba, i think

You give the syntax what you r using for connect the SQL Server 2000 srver, may we problemm with that.
Regards,
Nagen111

"Hell, there are no rules here , we are here accomplish something.

kittu

use sqlconnection method.
try this.It might help u
sqlclient.sqlconnection("connection string")
bye
[blue]"Hell, there are no rules here, we are here to accomplish something"[/bue]
carlos