Hi Friends,

  I have downloaded the code for ASP.NET INstant Results chapter 7(Wrox Photo Album). I am using SQL Server 2005 standard edition. The database files are located in App_Data folder. I am not able to connect to database

"Connection to the server failed. Servername/instance cannot found"

As I have other applications in my system and are connecting well. I changed the ConnectionString in the web.config file as with my current running application changing the database name.

What could be the problem.

How can I attach the photodb.mdf file in sql server database?

Thanks in advance

To attach the database open up SQL Server and create a new query, then type in the following code (modify it for the path to your database though):

use master
CREATE DATABASE photodb
ON (FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQLData\photodb.MDF')
FOR ATTACH

Remember to alter the file path.