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
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