SQL Server - SQL Server 2008 Standard and Visual Studio 2008 Professonal
Asked By Gofer0
02-Nov-08 01:15 AM
I have retailed copies VS 2008 Pro and SQL 2008 Standard. While in VS 2008 I
tried to create a SQL database in a ASP.Net 3.51 Web application.
I'm getting an error saying I need to install SQL Server 2005 Express Edition.
I have all the current patches and upgrades to both programs. I don't want
to down grade my SQL Server. I spent good money on the SQL Server 2008. Is
there a work around option where I can use VS 2008 and SQL Server 2008
together?
SQL Server 2005 standard came with Visual Studio 2008 Professional but I
didn't install that program.
Windows SharePoint Services
(1)
SQL Server 2008
(1)
SQL Server 2005
(1)
Virtual PC
(1)
Visual Studio 2008
(1)
SharePoint
(1)
Silverlight
(1)
Office
(1)
Aaron Bertrand [SQL Server MVP] replied...
Have you installed SP1 (RTM) for Visual Studio?
FWIW, I have never created a database from within Visual Studio, but I know
that VS2008 came out before SQL Server 2008, so all of the hooks may not be
there to support the new SQL Server version, unless you get VS up to date.
On 11/2/08 1:15 AM, in article
1DDBEB88-901C-4FC6-967F-ADDF24F2EEED@microsoft.com, "Gofer01"
Gofer0 replied...
I copy and paste all the updates Visual Studio Pro here
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1
Installed Edition: Professional
Microsoft Silverlight Projects 2008 91605-141-0277525-60796
Microsoft Silverlight Projects 2008
Version 9.0.30729.143
Microsoft Visual Basic 2008 91605-141-0277525-60796
Microsoft Visual Basic 2008
Microsoft Visual C# 2008 91605-141-0277525-60796
Microsoft Visual C# 2008
Microsoft Visual C++ 2008 91605-141-0277525-60796
Microsoft Visual C++ 2008
Microsoft Visual Studio 2008 Tools for Office 91605-141-0277525-60796
Microsoft Visual Studio 2008 Tools for Office
Microsoft Visual Web Developer 2008 91605-141-0277525-60796
Microsoft Visual Web Developer 2008
Crystal Reports AAJ60-G0MSA4K-68000CF
Crystal Reports Basic for Visual Studio 2008
Extensions for SharePoint Svcs 1.2
Visual Studio 2008 extensions for Windows SharePoint Services 3.0 (version
1.2)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB944899)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB945282)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB946040)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB946308)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB946344)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB946581)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB947171)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB947173)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB947180)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB947540)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB947789)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB948127)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB950633)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB952241)
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB953256)
Microsoft Visual F# 1.0
Microsoft Visual F# for Visual Studio 2008
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1
(KB945140)
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1
(KB947888)
Popfly Explorer 1.0 Beta
Microsoft Popfly Explorer 1.0 Beta
Version 1.0.30318.0
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB947520)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB949325)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB950630)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB950631)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB950632)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB951455)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB951456)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB951457)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB951458)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB951459)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB951460)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB951461)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB955211)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB955212)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB955213)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB955214)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB955215)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB955216)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB955217)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB955219)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB955220)
Update for Microsoft Visual Studio 2008 Professional Edition - ENU
(KB956453)
I got this information in About menu from Visual Studio Professional, I
don't see any thing that mentions RTM
Sylvain Lafontaine replied...
Possibly because you are trying to create the database as a Database Project
instead of creating it as a new database on SQL-Server 2008.
Open the Server Explorer window then right click on Data Connections and
chose "Create a New SQL-Server Database. Choose the server, the mode of
authentication and the new database name.
Instead of creating a new database from VS2008, you can also chose to create
it using SQL-Server 2008 and from the Server Explorer window | Data
Connections, chose "Add Connection..." instead of "Create a New SQL-Server
Database".
Creating a new database as a Database Project is an advanced feature.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
Gofer0 replied...
If you have the SR1 beta and Sulverlight beta installed in Visual Studio Pro.
Before you run the SR1 non beta patch for Visual Studio you have to run the
SR1 prep tool for Visual Studio 2008. Well I didn't do this.
Futhermore you have to install Visual Studio 2008 before you install SQL
Server 2008. Stupid me I installed SQL Server 1st.
I messed around with SQL Server 2008 and Visual Studio 2008 so much that I
wiprd out SQL server completely. I justed spend a good part of 3 days of
formating my HD and putting my system back togeter. I just got back online
Visual Studio 2008 and SQL 2008 is working well together now.
MSDE on Windows 2003 R2 box, new DL385G6 - Install Fails during SQL Services SQL Server I have been finding that I am having trouble with the Crystal Reports Server XI installation failing when it is dealing with SQL. So, as a thought and in case there was something wrong with my SQL portion of the isntall. I thought ok, I will try installing the actual MSDE application
Why_can’t_recursive_queries_contain. . .? SQL Server hi I hope I didn = 92t put too many questions 1) Why can = 92t recursive queries also be unioned together with UNION operator ( instead they must use UNION ALL )? thanx SQL Server Programming Discussions SQL Server 2008 (1) SQL Server 2005 (1) SQL Server 2000 (1) SQL Server (1) Oracle (1) Ruby (1) MichaelcoAToptonlineDOTnet
SQL Express: Failed Reinstall SQL Server Dear Setup Experts: I am trying to reinstall SQL Express after playing with it some. I uninstalled it, and now, it refuses to reinstall in the face. Any ideas what this log file means and how I can get SQL Express installed? I really do not want to have to reinstall my whole system. * ** ** Start of Log File Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup. Exit code (Decimal): -2068643839 Exit facility code: 1203
Sql Remote Connection issue SQL Server I am trying to setup Sql Server 2000 to handle remote connections from the web. I have setup the firewall to allow port 1433 to be redirected back to the internal Sql Server which I know is working. To verify the connection I am using telnet to verify 1433: Connect Failed Any ideas or solutions to the above problem would be greatly appreciated. SQL Server Connect Discussions SQL Server 2005 (1) SQL Express (1) SQL Server (1) Windows XP
Bulk Insert Help SQL Server Hi Guys, Just trying to complete a Bulk Insert and am getting an error: Incorrect quotes and column delimiter of coma. Can anyone advise how I can correct this. Thanks SQL Server New Users Discussions SQL Server 2005 (1) SQL Server 2000 (1) SQL Server (1) CREATE TABLE (1) Exception (1) NOT NULL (1) Nvarchar