Visual Studio 2008 Professional edition - Which SQL version I should download?

Question

User259881276 posted

Hello:
Can someone tell me what is the latest version of SQL I can use or is recommended that I use with Visual Studio 2008? I have Windows 10 (64 bit.) OS.

I saw that SQL Express that came with that version (2005) will not work properly with Windows 10. I am going to re-create my website project and database and will

download whichever SQL free edition is best. But I don't want to get a version that will not work with my old Visual Studio. I am not sure if that is a possible issue.

Thank you in advance,

Rachel

Answer 1

User475983607 posted

Simply, read the SQL system requirements for the version of SQL you wish to use.

https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-2017

Answer 2

User259881276 posted

Thank you. My operating system will work with most of those SQL versions, but my question was about Visual Studio 2008?

Answer 3

User475983607 posted

Thank you. My operating system will work with most of those SQL versions, but my question was about Visual Studio 2008?

Visual Studio is not relevant unless your are referring to data tools SSIS in which case the versions of SSMS/VS data tools must match the SQL version.  Are you experiencing some kind of issue or error message?

By the way, VS 2019 community is a free download.  

Answer 4

User259881276 posted

Yes.

When I try to click build in my program, I get one error and build fails.
It opens a web.config file from: windows\Microsoft.Net\Framework\v.2.0.50727\config\web

ERROR: Unrecognized configuration section system.serviceModel File: web.config

The web.config file it opens is highlighted at:

<system.serviceModel>
<serviceHostingEnvironment>
<add name="net.tcp" transportConfigurationType="System.ServiceModel.Activation.TcpHostedTransportConfiguration, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="net.pipe" transportConfigurationType="System.ServiceModel.Activation.NamedPipeHostedTransportConfiguration, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="net.msmq" transportConfigurationType="System.ServiceModel.Activation.MsmqHostedTransportConfiguration, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="msmq.formatname" transportConfigurationType="System.ServiceModel.Activation.MsmqIntegrationHostedTransportConfiguration, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
</serviceHostingEnvironment>
</system.serviceModel>
</configuration>

(My system info:
Windows 10 Pro
Version 1809
Build 17763.557)

Answer 5

User475983607 posted

You've changed subjects and are now asking about WCF?  system.serviceModel came  to existence in .NET 3.X.

What are you trying to do?

Answer 6

User259881276 posted

Trying to get my project to build.

I know its not same subject. But you asked if I was having a problem.

I don't currently have a SQL version installed. I wanted to know which one to install.

Answer 7

User475983607 posted

I don't currently have a SQL version installed. I wanted to know which one to install.

Visual Studio is an editor for building code.  VS 2008 integrates with SQL 2008 data tools like SSIS.  These versions must match VS 2008 to SQL 2008 in order to use integration services from VS.  Or you can use SSMS but that same rule applies.  The versions must match.  SSMS 2016 to SQL 2016.

If you are not using Integration services (SSIS) then it does not matter.  You should be able to write code in VS 2008 that connects to SQL 2016.  I support a classic asp application that connects to SQL 2012 and 2016.

Answer 8

User259881276 posted

Ok. Thank you very much. I'll get the latest SQL free edition & SSMS

(Any clue about that error when I try to build?)

Answer 9

User475983607 posted

(Any clue about that error when I try to build?)

WCF and system.serviceModel came to existence in .NET 3.0.  The error message seems you might be is targeting .NET 2.0?  Perhaps change the project target to 3.0 or later. 

Did this project ever build?  What version of .NET are you targeting?

Answer 10

User259881276 posted

This was an old copy I had. I had what I thought was same copy of the project in another folder but when I tried using VS 2019, it upgraded that working version and now I can no longer open it in VS 2008 which is why I am trying to now use this other copy. I don't know why its trying to use NET 2. Apparently I got the other copy / location working but don't remember how. They are both on my computer - two copies of same program but with different paths and locations.

How do I change the project to target to 3.0 or later?

Answer 11

User475983607 posted

How do I change the project to target to 3.0 or later?

Right click the project and select properties.  The application tab has the Target Framework.

Answer 12

User259881276 posted

I can't find that. If I right click on my solution, it doesn't show any tab to allow me to change Target Framework.

When my mouse hovers over the little red hammer & globe it shows the name ASP.NET but nothing happens when I right click on it. If I click it, it shows:

(same message error I get when trying to build):

Server Error in '/asp.netwebadminfiles' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Unrecognized configuration section system.serviceModel.

Source Error:

Line 374: </webParts> Line 375: </system.web> Line 376: <system.serviceModel> Line 377: <serviceHostingEnvironment> Line 378: <add name="net.tcp" transportConfigurationType="System.ServiceModel.Activation.TcpHostedTransportConfiguration, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

Source File: C:\Windows\Microsoft.NET\Framework\v2.0.50727\Config\web.config    Line: 376
Version Information: Microsoft .NET Framework Version:2.0.50727.9040; ASP.NET Version:2.0.50727.9031

Answer 13

User475983607 posted

I can't find that. If I right click on my solution, it doesn't show any tab to allow me to change Target Framework.

I wrote, right click the project not the solution.

Answer 14

User259881276 posted

I don't have a project file.

I didn't create as a project file.

Answer 15

User475983607 posted

I don't have a project file.

I didn't create as a project file.

Every solution in Visual Studio has a single solution file which tracks one or more projects.  

Answer 16

User259881276 posted

All I see in that folder is the .SLN file.

Answer 17

User475983607 posted

All I see in that folder is the .SLN file.

I have no idea what you are looking at or what "that folder" means.  My best guess is you opened the a web site project from the file system. 

Answer 18

User259881276 posted

Thank you for your patience.

I opened my website 'project' solution with visual studio 2008 and I looked in my files in the right side under properties window. There is file at top: "solution properties" and then another file under that again with name of my project but called 'website properties' . In the solution properties window, (very first file) it shows name of my solution and then in parenthesis  (1 project) . If I right click that, a white box opens up : (don't know how to post that image here)

Then in very second file, it has name of solution too and then states after name "website properties". If I right click on that one, I get another white box with various places to change settings.  That one does has a list of items on left side of box:

References
Build
Accessiblity
Start Options
MSBuild Options

If I select BUILD then the box at right changes information. In there it states Target Framework. The dropdown box has options for .NET 2, 3 or 3.5.

3.5 is the one that is already selected. I'm not sure what other checks/options to change.