p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning ASP.NET 2.0 AJAX ISBN: 978-0-470-11283-0 (http://p2p.wrox.com/forumdisplay.php?f=343)
-   -   Web Site Admin Tool SQL Problem (http://p2p.wrox.com/showthread.php?t=65385)

PeteC January 20th, 2008 07:03 PM

Web Site Admin Tool SQL Problem
 
Hello,
I'm at page 16 of the book and when I click on Security I get the message "Cannot connect to SQL Server Database".

I run two instances of SQL Server:
  1- SQL Server 2000 Developer Edition
  2- SQL Server 2005 MSDN Standard Edition

The database aspnetdb is properly attached to the SQL Server 2005, which it's instance name is not the default name.

There is probably a config file somewhere that I can modify to enter the SQL Server 2005 instance but I cannot find it.

Any help, please?

Thanks!
Pierre

dgrieser July 29th, 2008 12:48 PM

This is because you started the project via File->New->Project which doesn't add the App_Data folder to the project. If you create the project as File->New->Website you won't have this issue.

To add the App_Data folder click the "Show All Files" and then right-click the App_Data folder and add it to the project.

In addition, if you stay with the project, you will have issues with adding the Data Access Layer since it will not place the Roles.xsd into the App_Code folder which will cause problems with building the Roles manager. You could fix this as well, but at this point I gave up and switched to a Website instead of Project.


All times are GMT -4. The time now is 06:05 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.