![]() |
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.