Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP .Net Security (http://www.velocityreviews.com/forums/f62-asp-net-security.html)
-   -   SQL Server authentication issue (http://www.velocityreviews.com/forums/t764910-sql-server-authentication-issue.html)

Bob Spear 08-20-2003 09:05 PM

SQL Server authentication issue
 
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



All times are GMT. The time now is 09:14 PM.

Powered by vBulletin®. Copyright ©2000 - 2013, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.