Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Security > SQL Server authentication issue

Reply
Thread Tools

SQL Server authentication issue

 
 
Bob Spear
Guest
Posts: n/a
 
      08-20-2003
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

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote aboutjav.com@gmail.com ASP .Net 0 05-03-2008 12:43 PM
SQL Server does not exist after moving to new Sql Server Geoff ASP .Net 3 01-16-2006 05:54 AM
Do the Self-Paced Training Kits: Microsoft SQL Server 2000 include Eval copy of SQL Server? Brian Whiting Microsoft Certification 2 12-29-2005 04:24 AM
sql server express vs sql server 2000 code Daves ASP .Net 1 06-13-2005 12:24 PM
Can't connect to SQL Server, using Windows Authentication users of SQL server? help =?Utf-8?B?UmV6YQ==?= ASP .Net 3 06-07-2004 06:42 PM



Advertisments