Thread: Logging onto server

  1. #1
    Registered User
    Join Date
    May 2004
    Posts
    215

    Logging onto server

    Im trying to do a simple SQL database application using C# ASP.NET, and Im using SQL Server 2000, but it wont work because of this error:


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

    that happens when i do this

    Code:
    sqlConnection1.Open();

  2. #2
    Banned nickname_changed's Avatar
    Join Date
    Feb 2003
    Location
    Australia
    Posts
    986
    Quote Originally Posted by osal
    Im trying to do a simple SQL database application using C# ASP.NET, and Im using SQL Server 2000, but it wont work because of this error:


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

    that happens when i do this

    Code:
    sqlConnection1.Open();
    Show more code. Where are you setting the connection string? The error says your login is invalid - either you're connecting to the wrong database, using the wrong username or using Windows authentication (ASP.NET sites run by default as ComputerName\ASPNET, so if you try and connect to SQL Server, that's the username it uses. You need to tell it to use another name or add access to the SQL Server for ROOM\ASPNET. Do this by opening SQL Server Enterprise Manager, going to your database, and going to the Users page).

  3. #3
    Registered User
    Join Date
    May 2004
    Posts
    215
    Login failed for user 'ROOM\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 'ROOM\ASPNET'.

    Thats the entire error message. I dont know how to add it. Ive been looking around, I just got SQL Server 2000 yesterday.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. server client application - (i really need your help)
    By sarahnetworking in forum C Programming
    Replies: 3
    Last Post: 03-01-2008, 10:54 PM
  2. Server Architecture
    By coder8137 in forum Networking/Device Communication
    Replies: 2
    Last Post: 01-29-2008, 11:21 PM
  3. Where's the EPIPE signal?
    By marc.andrysco in forum Networking/Device Communication
    Replies: 0
    Last Post: 12-23-2006, 08:04 PM
  4. IE 6 status bar
    By DavidP in forum Tech Board
    Replies: 15
    Last Post: 10-23-2002, 05:31 PM
  5. socket question
    By Unregistered in forum C Programming
    Replies: 3
    Last Post: 07-19-2002, 01:54 PM