Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 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 August 15th, 2007, 04:28 AM
Friend of Wrox
Join Date: May 2006
Posts: 107
Thanks: 1
Thanked 8 Times in 7 Posts
Default Upgrade SQL Express to SQL Server

Are there any implications I should be aware of when upgrading SQL Server Express to more sophisticated editions of SQL Server?

Can you let me know what problems I may encounter or describe any issues you may have encountered?


Try our latest project www.nobanx.com Currency Exchange for members
Old August 15th, 2007, 11:18 AM
planoie's Avatar
Friend of Wrox
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts

To my knowledge, the only thing that a full-blown SQL Server does not support is the dynamic attaching of database files. You need to explicitly create/attach a database to a full SQL Server instance. Otherwise the full server supports all the stuff the express one does plus loads more.

Old August 27th, 2007, 02:37 PM
Registered User
Join Date: May 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts

Hi Peter or others,

I am using the WROX book "Beginning ASP.NET 2.0 with C#", and am referring to the bottom of page 663 in Appendix B.

I am a real newbie, but trying to use the SQL Server 2005, which I downloaded, rather than the SQL Express. On this page, it mentions steps to connect the database to the ASPNET server for the Wrox United training website. The steps are unclear to me. For step 1, it says to add (my machine)/ASPNET and NT AUTHORITY/NETWORK SERVICE as logins. Where do I do this, the WROX site, SQL SERVER 2005 or the VWD 2005 (Express)? I tried several different ways of doing this, but it did not work. I was able to add Network Service account, as it says in the book, but I could not add another account.

Thanks for any help you can give.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Upgrade to SQL Server 2005 from 2000 srotondo SQL Server 2005 2 February 14th, 2008 02:26 PM
SQL SERVER EXPRESS rht886 SQL Server 2005 1 March 21st, 2007 08:44 AM
i have a problem in SQL server express saif44 SQL Language 1 March 1st, 2006 06:25 PM
VB Express and SQL server on remote server questio HoosierDaddy61 Visual Basic 2005 Basics 0 February 22nd, 2006 11:27 AM
Accessing a SQL Server Express DB thru VB Express djelavic SQL Server 2005 2 February 21st, 2006 07:53 PM

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