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.

[Peter Bromberg [C# MVP]]

Try switching to SQL Server authentication:

server=myserver;database=mydatabase;uid=username;p wd=password;

Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Carlos" wrote:

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.