SQL Server authentication issue

B

Bob Spear

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
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,902
Latest member
Elena68X5

Latest Threads

Top