SQL Server authentication issue

Discussion in 'ASP .Net Security' started by Bob Spear, Aug 20, 2003.

  1. Bob Spear

    Bob Spear Guest

    I'm just learning how to incoroporate SQL Server
    databases into a Visual Basic .NET Web Forms application.

    On my development machine, I created a simple database,
    and specified Windows NT Integrated Security. I created a
    simple Visual Basic .NET Web forms application to access
    the data in this database. In Web.config, following
    <system.web>, I inserted the statement
    <identity impersonate = "true" />

    The app runs fine on that computer.

    I created a deployment project in order to distribute
    this app to another computer. I also copied the .mdf
    and .ldf files that comprise the database to the target
    computer's Program Files\Microsoft SQL
    Server\MSSQL$vsdotnet\Data folder. Then I ran the osql
    utility and attached the SQL Server database to the
    vsdotnet instance on that machine. I installed the Web
    Forms app on the target computer. In Server Explorer, I
    established a connection to the database, tested it,
    opened the database, looked at the contents of tables --
    all successful.

    Then I built the application on the target computer
    (successful), and finally ran it. The program blows up on
    the statement

    SqlDataAdapter1.Fill(DataSet11)

    The error msg reads:

    Login failed for user DAD\IUSR_DAD

    What have I forgotten to do? Any help would be
    appreciated.

    --Bob
    Bob Spear, Aug 20, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?UmV6YQ==?=
    Replies:
    3
    Views:
    17,928
    Carlos Barini
    Jun 7, 2004
  2. Daves
    Replies:
    1
    Views:
    368
  3. Geoff
    Replies:
    3
    Views:
    442
    Patrick.O.Ige
    Jan 16, 2006
  4. farseer

    SQL Server 2005 + SQL Server Express

    farseer, Aug 7, 2006, in forum: ASP .Net
    Replies:
    3
    Views:
    344
    farseer
    Aug 8, 2006
  5. Grey Alien

    SQL Server 2000 vs SQL Server Express

    Grey Alien, Jul 8, 2007, in forum: ASP .Net
    Replies:
    6
    Views:
    493
    Grey Alien
    Jul 9, 2007
Loading...

Share This Page