Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3
This is the forum to discuss the Wrox book Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars; ISBN: 9780470187593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #11 (permalink)  
Old January 12th, 2012, 03:20 PM
Registered User
Points: 49, Level: 1
Points: 49, Level: 1 Points: 49, Level: 1 Points: 49, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Default

actually i didn't installed the sql server on my laptop by myself.but my friend installed that and he told that was the sql server 2005 express only..(using windows 7) still i m getting error.

when i drag PlanetWrox.mdf and PlanetWrox_Log.ldf form resources of ch-11 to new website NOT THAT SITE which used throughout in book . then when i double click the PlanetWrox.mdf i get following error:

Required Component Missing
Connection to SQL Server files(*.mdf) require SQL Server Express 2005 to function properly.Please verify the installation of the component or download from the URL:
http://go.microsoft.com/fwlink/?LinkID=49251

even when i add new database to SITE website by add new item ->sql database but when i click add button i get same error as above.

when i click start->All Programs i get following folders
1)Microsoft SQL Server 2005
-SQL Server Business Intelligence Development Studio
-SQL Server Management Studio

2)Analysis Services
-Deployment Wizard

3)Configuratin Tools0
-Notification Services Command Prompt
-Reporting Services Configuration
-SQL Server Configuration Manager
-SQL Server Error and Usage Reporting
-SQL Server Surface Area Configuration

4)Documentation and Tutorials
-SQL Server Books Online
4a)Tutorials
-SQL Server Mobile Edition Tutorials
-SQL Server Tutorials

5)Performance Tools
-Database Engine Tuning Advisor
-SQL Server Profiler

and i have following component installed in control panel:-
Microsoft SQL Server 2005
Microsoft SQL Server 2005 Backward compatibility
Microsoft SQL Server 2005 Books Online(English)
Microsoft SQL Server Compact 3.5 Design Tools ENU
Microsoft SQL Server Compact 3.5 ENU
Microsoft SQL Server Compct 3.5 for Devices ENU
Microsoft SQL Server Database Publishing Wizard 1.2
Microsoft SQL Server Native Client
Microsoft SQL Server Setup Support Files(English)
Microsoft SQL Server VSS Writer

i also checked out the enabling remote conection
when i select SQL Server 2005 Network Configuration(32bit) i got following protocols:
Protocols for MSSQLSERVER
Protocol Name Status
Shared Memory Enabled
Named Pips Disabled
TCP/IP Disabled
VIA Disabled
when i change Named Pips ans TCP/IP TO Enabled and restart my sql server management studio
i get the following error :
Unable to stop service MSSQLSERVER on server USER-VAIO(USER-VAIO is my server name)

what should i do ..i stop on ch-11 - cant go to further chapters TRY IT OUT..

One more thing whenever i start sql server management studio and start connection to server i use server authentication(server name-USER-VAIO, login-sa password-sa)
can i change it to window authentication?
my server name is-USER-VAIO(SQL Server 9.0.1399 - sa) this is only my instance right?
Reply With Quote
  #12 (permalink)  
Old January 12th, 2012, 05:06 PM
Imar's Avatar
Wrox Author
Points: 67,755, Level: 100
Points: 67,755, Level: 100 Points: 67,755, Level: 100 Points: 67,755, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,287
Thanks: 66
Thanked 1,439 Times in 1,419 Posts
Default

Hi there,

When you log in to SQL Server using Management Studio, what's the name of your SQL Server you log in to? Does it work when you log in to . (just a dot)?

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #13 (permalink)  
Old January 13th, 2012, 03:17 AM
Registered User
Points: 49, Level: 1
Points: 49, Level: 1 Points: 49, Level: 1 Points: 49, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Default

When I select start-> SQL Server Management Studio,

I get connect to server dialog box of Microsoft SQL Server 2005

Server type : Database Engine
Server name : USER-VAIO
Authentication : Sql Server Authentication
Login : sa
Password : sa

in this dialog box i just enter password and then click connect button .
i get connected to sql server.ya its work.
left side in object Explorer pane its also shows the name of server that is:
USER-VAIO(SQL Server 9.0.1399 - sa)

but when in connect to server dialog box if i choose window Authentication from Authentication dropdown list and the click connect button i get following error.
Cannot connect to USER-VAIO

can i change setting from SQL Server authentication to window authentication??

M I using sql server 2005 express only?or its sql server 2005 commecial version?i m confused about it.that why in previous reply i added all the installed component.but my friend told its the sql server 2005 express only.
so i dont understand why i m getting error when i do try it out of book in ch-11 and further.
Reply With Quote
  #14 (permalink)  
Old January 13th, 2012, 06:17 AM
Imar's Avatar
Wrox Author
Points: 67,755, Level: 100
Points: 67,755, Level: 100 Points: 67,755, Level: 100 Points: 67,755, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,287
Thanks: 66
Thanked 1,439 Times in 1,419 Posts
Default

Looks like you are using Express, but with an unnamed instance. E.g. your server can be reached using just a dot (.) and not .\SqlExpress

Take another look at my earlier replies and the thread I linked to for more background, and then clear the instance name field in Tools | Options as described earlier.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #15 (permalink)  
Old January 13th, 2012, 01:14 PM
Registered User
Points: 49, Level: 1
Points: 49, Level: 1 Points: 49, Level: 1 Points: 49, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Default

i read the earlier thread again and in visual studio 2008 i cleared the sql server instance field by following steps.

tools-->option-->Database tools-->SQL Server Instance Name
in this text box( SQL Server Instance Name) by default SQLEXPRESS was there and i cleared that textbox

then also i m getting same error when i attach resource database PlanetWrox.mdf

error :
Required Component Missing
Connection to SQL Server files(*.mdf) require SQL Server Express 2005 to function properly.Please verify the installation of the component or download from the URL:
http://go.microsoft.com/fwlink/?LinkID=49251
Reply With Quote
  #16 (permalink)  
Old January 13th, 2012, 02:53 PM
Imar's Avatar
Wrox Author
Points: 67,755, Level: 100
Points: 67,755, Level: 100 Points: 67,755, Level: 100 Points: 67,755, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,287
Thanks: 66
Thanked 1,439 Times in 1,419 Posts
Default

Hi there,

Then maybe you don't have the Express edition? Try this:

1. Start SQL Server Management Studio
2. Log in
3. Open a new Query Window, type SELECT @@VERSION and execute the query (F5)

My SQL Server 2005 Express returns something like this:


Quote:
Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)
whereas a standard version (2008 in my case) returns something like this:

Quote:
Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
If you version does not contain a mention of the Express edition, you can use the Web Platform Installer to install it, side by side to the version you already have. If it is SQL Server 2005, I don't know what's going on... ;-)

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #17 (permalink)  
Old January 14th, 2012, 12:45 AM
Registered User
Points: 49, Level: 1
Points: 49, Level: 1 Points: 49, Level: 1 Points: 49, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Default

hi

i tried the steps u mentioned in earlier reply
and i got following result:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 6.1 (Build 7600: )

so its Developer Edition means STANDARD SQL SERVER 2005 right?

so from where i can install Web Platform Installer ?can I install it on windows 7?if i install it it will work properly for book's try it out.
or should I uninstall current sql server 2005 and again install sql server 2005 express ?
Reply With Quote
  #18 (permalink)  
Old January 14th, 2012, 05:43 AM
Imar's Avatar
Wrox Author
Points: 67,755, Level: 100
Points: 67,755, Level: 100 Points: 67,755, Level: 100 Points: 67,755, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,287
Thanks: 66
Thanked 1,439 Times in 1,419 Posts
Default

Well, it means the Developer Edition, not the Standard Edition which is yet another version. But if by Standard you mean "not Express", then yes, this is the standard edition. ;-)

Quote:
from where i can install Web Platform Installer
Google knows these kind of things. It's the number 1 result:

http://www.microsoft.com/web/downloads/platform.aspx

Quote:
can I install it on windows 7?if i install it it will work properly for book's try it out.
or should I uninstall current sql server 2005 and again install sql server 2005 express ?
Yes. It should install a new instance called .\SqlExpress which is what the Try It Outs assume. No need to uninstall the existing installation although you could if you don't need it anymore (although it's a developer edition, you still need a paid license for it; the Express edition is entirely free).

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #19 (permalink)  
Old January 14th, 2012, 05:51 AM
Registered User
Points: 49, Level: 1
Points: 49, Level: 1 Points: 49, Level: 1 Points: 49, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2012
Posts: 13
Thanks: 1
Thanked 0 Times in 0 Posts
Default

if I want to again install sql server 2005 express then which one should i install ?

Microsoft SQL Server 2005 Express Edition Service Pack 1 or service pack 2,3,4
there r many options..
but which one support window 7 and also the try it out of book
Reply With Quote
  #20 (permalink)  
Old January 14th, 2012, 06:01 AM
Imar's Avatar
Wrox Author
Points: 67,755, Level: 100
Points: 67,755, Level: 100 Points: 67,755, Level: 100 Points: 67,755, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,287
Thanks: 66
Thanked 1,439 Times in 1,419 Posts
Default

See my previous psot: if you want to follow along with the book you need the Express 2005 edition. For other purposes you may have, you could intall other version of you have the need.

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET 1.1,VB.NET,crystal reports, SQl server gvi Crystal Reports 1 September 11th, 2008 03:55 AM
send MASS Emails in ASP.NET 2 with VB.NET 2005 alexdcosta ASP.NET 2.0 Basics 1 July 17th, 2006 01:31 AM
Parse XML doc using VB.NET into ASP.NET page kwilliams Classic ASP XML 17 November 11th, 2005 10:42 AM
Beginning ASP.Net Databases Using VB.Net ISBN 6195 tlamazares SQL Server ASP 1 December 15th, 2003 01:28 PM



All times are GMT -4. The time now is 04:39 AM.


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