sqlserver 2005 login problem

[Carlos]

Hi all,

I just wrote an asp .net 2.0 sample app intending to connect to
a database (in sql server 2005). I provided the mixed mode access
authentication in the sql server, and provided to the aspnet account
user access with the dbo role. I also configured IIS to get integarted
windows authentication, and not anonymous access. After all this... ufff..!
I still have
access problems, the exception says:

Login failed for user ''. The user is not associated with a trusted SQL
Server connection

my conection string reads:

server=<servername>;Database=<dbname>;Integrated Security=true"

thanks in advance for any help,



Carlos.

 

[Guest]

Try switching to SQL Server authentication:

server=myserver;database=mydatabase;uid=username;pwd=password;

Peter