 |
BOOK: Beginning ASP.NET 4.5.1 : in C# and VB
 | This is the forum to discuss the Wrox book Beginning ASP.NET 4.5.1: in C# and VB by Imar Spaanjaars; ISBN: 978-1-118-84677-3 |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the BOOK: Beginning ASP.NET 4.5.1 : in C# and VB 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
|
|
|
|
|
November 26th, 2015, 05:56 PM
|
|
Authorized User
|
|
Join Date: Nov 2014
Posts: 91
Thanks: 2
Thanked 1 Time in 1 Post
|
|
Chapter 12: Creating the SQL Server Sample Database
I rewrote my earlier post to correctly indicate the correct chapter in the title and to provide more information. Hopefully, so I can get some response to allow me to continue on and finish the rest of the book. I am presently dead in the water.
My computer runs on Windows 10. I have been using Microsoft Visual Studio 2013 Professional up to Chapter 11 with no problems. I installed Microsoft SQL Server Management Studio 2012, the Express Edition.
I followed the steps 3, 4, and 5 of the Try It Out exercise. After I clicked OK, a error message appears.
Create failed for Database "PlanetWroxTemp" (Microsoft.SqlServer.Smo)
Additional Information:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo).
Directory lookup for the file "C:\Databases\PlanetWroxTemp.mdf" failed with the Operating System error 2(The system cannot find the file specified)
CREATE DATABASE failed. Some file names listed could not be created. Check related errors(Microsoft SQL Server, Error:5133)
Please help me to fix this problem.
Last edited by phztfte1; November 26th, 2015 at 05:57 PM..
Reason: Deleted extraneous information
|
|
November 27th, 2015, 01:10 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Is this fixed now as per your other post? If not, can you supply the *exact* steps that lead to this error?
Imar
|
|
November 27th, 2015, 03:03 PM
|
|
Authorized User
|
|
Join Date: Nov 2014
Posts: 91
Thanks: 2
Thanked 1 Time in 1 Post
|
|
Chapter 12: Creating the SQL Server Sample Database
I followed Steps 1 through 5 of the Try It Out. When I clicked OK to create the database, that is when I got the error message.
|
|
November 27th, 2015, 03:41 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Did you create the folder c:\Databases first? And to which version of SQL Server are you logging in (what do see / enter in the Server name field in Fifue 12-3?)
If the folder exists, this may be a permissions issue. Try granting the Everyone account to the folder with full permissions (temporarily) to rule out permission errors. Chapter 19, section NTFS Settings for Planet Wrox at page 742 has more details.
Cheers,
Imar
|
|
November 27th, 2015, 04:08 PM
|
|
Authorized User
|
|
Join Date: Nov 2014
Posts: 91
Thanks: 2
Thanked 1 Time in 1 Post
|
|
Chapter 12: Creating the SQL Server Sample Database
Yes, I created the Database folder first as instructed in Step 1 before I started SQL Server Management Studio. The version of SSMS I have is 11.0.3000.
I think I need to start all over again with "C:\BegASPNET\Site" as you indicated in my other post.
Thank you.
|
|
November 27th, 2015, 04:12 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
>> Yes, I created the Database folder first as instructed in Step 1 before I started SQL Server Management Studio.
Database or databases?
Imar
|
|
November 27th, 2015, 04:26 PM
|
|
Authorized User
|
|
Join Date: Nov 2014
Posts: 91
Thanks: 2
Thanked 1 Time in 1 Post
|
|
Chapter 12: Creating the SQL Server Sample Database
Sorry, Databases.
|
|
November 27th, 2015, 04:30 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Did you try granting the Eveyone account full control? This is SQL Server only and thus doesn't have much to do with the source for the chapter itself.
Cheers,
Imar
|
|
November 27th, 2015, 06:03 PM
|
|
Authorized User
|
|
Join Date: Nov 2014
Posts: 91
Thanks: 2
Thanked 1 Time in 1 Post
|
|
Chapter 12: Creating the SQL Server Sample Database
Not yet. I think I will start with "C:\BegASPNET\Site" first.
Thank you very much.
|
|
|
|
button below this post to show your appreciation!
