Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 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
  #1 (permalink)  
Old April 22nd, 2007, 03:55 PM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default installing sql server 2005 with visual studio

I have been using web matrix with Access 2003 to develop a database driven web application with the guidance of wrox asp.net 1.1 and then onto wrox professional asp.net 2.0 and have been very happy with the results. I have been making the natural transition from web matrix to visual studio and from Access to sql server 2005.

I have recently purchased sql server 2005 developer edition and would like to install it on my laptop which runs windows xp. I am unsure of how to install sql server 2005. Should I simply upgrade the sql server express which comes with visual studios or install sql server 2005 as the default. Clearly this may seem obvious to many but I'm hoping to avoid some frustration and get up to speed with working both sql server 2005 in the visual studio environment.

Much thanks ahead of time.

Lucy

Reply With Quote
  #2 (permalink)  
Old April 23rd, 2007, 09:07 AM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

In my opinion you should uninstall the sql server express edition ( save your databases) then first install the SQL 2005 and then Visual Studio 2005 after. During Visual Studio 2005 installation the Express Edition will not install correctly as the default, therefore use the name instance.

Jaime E. Maccou
Reply With Quote
  #3 (permalink)  
Old April 23rd, 2007, 06:46 PM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for your response.

I have actually already installed visual studio and the sql express version installs automatically with it. I would now like to install the developer version of sql. My options if I remember are to update the express version which would maintain the name instance of the express version which installed with visual studio. The other option is to install the developer version of sql as the default. I was worried about problems with visual studio automatically using the express version installed. I could uninstall the express version first and then install the developer version or have both or just upgrade the express version. I guess it boils down to whether it is important to have a default versus a name instance associated with visual studio. What do you think.

I apologize for the elementary nature of this discussion. I have read of problems with the installation process and was hoping to avoid them. Much of this may become obvious once I get my hands dirty.

Thank again

Lucy

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
Installing msxml in visual studio 2005 nilay.rathod Visual C++ 2005 0 February 15th, 2008 01:18 AM
Visual Studio 2005 App_Data DB to SQL Chuck_aa ASP.NET 2.0 Basics 5 August 30th, 2006 07:10 PM
Visual Studio 2003 vs. Visual Studio 2005 eitanbarazani C# 2005 4 May 9th, 2006 01:34 AM
date in sql server and in visual studio saif44 ASP.NET 2.0 Professional 3 March 22nd, 2006 04:02 PM
Visual Studio .net2003 and Visual Studio 2005 Gert Visual C++ 1 January 24th, 2006 04:10 AM



All times are GMT -4. The time now is 08:05 AM.


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