I am trying to connect to a SQL Server 2000 database, running on Windows Ser
ver 2003, from my development PC, running Windows XP Pro, using ASP.NET. My 
ASP.NET application runs fine until I try to connect to the database, at whi
ch point I get the followin
g error message:

----------------------------------------------------------------------------
--------------------------------
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server
 connection.
Description: An unhandled exception occurred during the execution of the cur
rent web request. Please review the stack trace for more information about t
he error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
 'sa'. Reason: Not associated with a trusted SQL Server connection.
----------------------------------------------------------------------------
--------------------------------

The SQL Server is set to use SQL Server and Windows Authentication, and I ha
ve a vaild username & password.

If I copy the files onto the deployment server, running Windows Server 2003 
and IIS 6.0, without making any changes, the application can connect to the 
SQL database without any problems. All 3 machines are running on the same do
main.

This is where it gets interesting. I have a Windows VB.NET application which
 connects to the same SQL database as the ASP.NET application. The Windows a
pplication uses exactly the same connection code, including username and pas
sword, as the Web applicati
on. The Windows application can connect to the SQL database without any prob
lems.

Does anyone have any ideas why this might be happening and how I might solve
 this problem?

Thanks in advance,
Alistair Gillespie

[ Post a follow-up to this message ]

What does your connection string look like?

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

[ Post a follow-up to this message ]

I have changed the username and taken the password out for security.

data source=BECKS;initial catalog=TheNAB;user id=sa;password=

I have tried adding: Trusted_Connection=Yes and it makes no difference.

Thanks again,
Alistair

[ Post a follow-up to this message ]

Verify that you can connect using the same username and password using
Query Analyser.

If this fails, then odds are you changed the security, but didn't restart
SQL Server service.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

[ Post a follow-up to this message ]

Hello,

set sa password and login into sa user id and pwd which you will define.

Thanks.

Warm Regards,

Ayaz Ahmed
Software Engineer & Web Developer
Creative Chaos (Pvt.) Ltd.
"Managing Your Digital Risk"
http://www.csquareonline.com
Karachi, Pakistan
Mobile      +92 300 2280950
Office      +92 21 455 2414

*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

[ Post a follow-up to this message ]