Hi :) Im opening a database conn

[Fursten]

Hi

Im opening a database connection like this:

con.Open "Provider=SQLOLEDB;" & _
"Data Source=EST40;" & _
"Initial Catalog=XMLTeste;" & _
"user id=internet;" & _
"Password=teste"

I had already defined the user "internet" with the password "teste" in the security folder of SQL Server enterprise manager.

However, when I try to load my asp page i get this error:


"Microsoft OLE DB Provider for SQL Server error '80004005'

Login failed for user 'internet'. Reason: Not associated with a trusted SQL Server connection.

/ProjectoUltimo_Local/ASP Page1.asp, line 17 "


The question is: How can I make a trusted connection to that user? I already give him all the permissions I could give... The only way I think to solve this was putting in the connection string "Trusted_connection=yes". However I would like to control the connection in the SGBD...

I´m using win2000 professional; SQL Server 7.0; IIS5.0

Thank you for your help.

Sergio Oliveira

 

[link9]

Has to be permissions on the actual table you are trying to access... Have you triple checked the table permissions for user, 'internet'????? Check them on the actual table, not just the database.

The only time I've ever seen that error is is I've forgotten to set up permissions properly, and you don't need to say anything like 'Trusted_connection=yes'

 

[Fursten]

Hi again,

I already gave all the permissions to that user in:

# the security folder of SQL Server enterprise manager;
# on the database XMLTeste;
# on the table I´m trying to access;

Is there anything left?

I run SQL profiler to see what is appening and I see that:
NT User Name=IUSR_EST40 and SQL User Name=internet
I think this is correct, is´n it?

Any ideias?

Sergio Oliveira

 

[link9]

Hmmmm.... I don't know what else to try other than this...

Try setting up a brand new user with a brand new password on that table, and then try with that new user info...

That would be my next avenue

And if that doesn't work, I would suggest posting over in the SQL Server forum. I think they would be better informed to help you out of this jam.


Paul Prewett