Wrox Programmer Forums
|
BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio
This is the forum to discuss the Wrox book ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solution by Vincent Varallo; ISBN: 9780470396865
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 30th, 2010, 01:35 PM
Registered User
 
Join Date: Sep 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database Permission

I'm unable to create the data source connection in Visual Studio 2008.
Step 4 says, “Select the HRPaidTimeOff database from the list of databases.

"You do not have permission to open this file
Contact the file owner or administrator to obtain permission."

How do I correct error?

Note: I later found an article that helped fix the problem...

Last edited by NetWorld; October 14th, 2010 at 01:36 PM.. Reason: simplified
 
Old September 30th, 2010, 04:59 PM
Registered User
 
Join Date: Sep 2010
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Smile Point to SQL Server

This article helped me solve the problem.

Which data source do you choose in the Add Connection window? From your description, I think you chose Microsoft SQL Server Database File, right? Please change it to "Microsoft SQL Server".

If the database files are attached using the SQL Server Management Studio, we need to use "Microsoft SQL Server" then specify the server name and database name. Please first make sure the connection information is valid.

If we want to connect to a SQL Server database without attaching it first, we need to use "Microsoft SQL Server Database File" and locate the database files. In this case, the database will be attached and connected using user instance.

User instance is a feature of SQL Server Express. It is not supported by other editions of SQL Server (such as Developer or Enterprise). SQL Server Express is usually installed as a named instance called "SQLEXPRESS", so ".\SQLEXPRESS" is specified automatically.

References:

Add/Modify Connection (Microsoft SQL Server)
http://msdn.microsoft.com/en-us/library/dxb6fxah.aspx

Add/Modify Connection (Microsoft SQL Server Database File)
http://msdn.microsoft.com/en-us/library/tk2tbfb5.aspx

Working with User Instances
http://msdn2.microsoft.com/en-us/library/ms254504.aspx

Last edited by NetWorld; October 14th, 2010 at 01:40 PM.. Reason: clarification and solution to problem





Similar Threads
Thread Thread Starter Forum Replies Last Post
its urgent,write permission to database(mdb). shanwaj ASP.NET 1.0 and 1.1 Basics 2 January 10th, 2008 12:40 PM
Permission Ruman29 Access 2 July 1st, 2006 07:09 AM
(0x800A0046) Permission denied,not IIS permission! David Hay Classic ASP Basics 3 April 30th, 2006 10:47 PM
ASP Database Connection-File permission problem goljazoran Classic ASP Databases 4 November 29th, 2003 05:09 PM
ASP Database Connection-File permission problem goljazoran BOOK: Beginning ASP 3.0 0 November 10th, 2003 10:09 AM





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