Re: SQL.Net connection in VS2005 from local IIS to local SQLExpres

I can connect easily using C# & ADO.NET on standalone programs.

I am trying to connect from a web site program under .NET 1.1 VS 7 and
always get

Login failed for user 'LANDON\ASPNET'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user
'LANDON\ASPNET'.

Source Error:


Line 46: private void Page_Load(object sender, System.EventArgs e)
Line 47: {
Line 48: sqlConnection1.Open();
Line 49: ds = new DataSet();
Line 50: daAttendees = new SqlDataAdapter(


Source File: c:\inetpub\wwwroot\pcswebapp2\webform1.aspx.cs Line: 48

having signed in under IE6 using:
http://localhost/PCSWebApp2/WebForm1.aspx
I've tried everything to fix the problem;




"Sue Hoegemeier" wrote:

Make sure the user is not orphaned and has a valid account
in the database you are specifying in the connection string.

-Sue

On Wed, 12 Apr 2006 11:19:35 -0400, "harry"
<mackey@xxxxxxxx> wrote:

Suddenly my trusted connection no longer works in VS. I try to create a new
one and recieve this:

"Database schema could not be retrieved for this connection. Please make
sure the connection settings are correct and the database is online
Login failed for user ''. The user is not associated with a trusted SQL
server connection."

1. I changed IIS to use a domain\user instead of IUSR_XX and still recieve
this error.
2. The firewall has been disabled for now.
3. SQL has named pipes and TCP/IP open, SQL is in mixed mode.
4. I can browse the connection if I am in SQL Authentication using 'sa', but
need to use WinAuth.

I cannot connect using Window Authentication.

Data Source=POLYP\SQLEXPRESS;Initial Catalog=HR15328;Integrated
Security=True
*Win2K3RC2

Suggestions?
Thanks
Harry




.

Relevant Pages

  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: User not associated with trusted SQL Server connection
    ... > using the osql utility. ... > associated with a trusted SQL Server connection. ... > database or is it just for that instance. ...
    (microsoft.public.sqlserver.security)
  • RE: Manipulating MS Access records with excel VBA + ADO
    ... While I cannot see how a working example of a connection to a database is ... Select the control button view dataor edit query. ... Look for SQL button to get the SQL ...
    (microsoft.public.excel.programming)
  • Re: Is it just me or are there BIG problems with SQLCE 3.0?
    ... has been done with parameterised SQL, ... bit of code into my test which closes and reopens the database ... opening and closing the DB connection is not a good idea. ... // Display all error messages ...
    (microsoft.public.sqlserver.ce)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... What version of SQL CE are you using? ... Are you accessing the database from an app written in C++? ... then opens his work forms and it's in those ... It wouldn't seem to me that you'd need a new connection to ...
    (microsoft.public.sqlserver.ce)
Loading