Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Installing SQL Server support files in a Visual Studio 2008 Installer project

Posted on 2010-08-26
1
268 Views
Last Modified: 2013-11-27
I have creating a .NET 3.5 application using Visual Stuido 2008.  I have made use of some features contained in the Microsoft.sqlserver.Smo Dll and want to ensure that my application will run on the target machine which may or may not have SQL Server 2008 installed (most likely it will not as these are client PCs).

I have created a Visual Studio 2008 Installation project which correctly lists the dependancies and installs the product correctly however I am not sure if just because the dependancy is listed in the installation project that the relelvant SQL server files are being installed.

Can anyone tell me if this is the case or if not how I can ensure that correct version of these files can be included in my setup project and installed along with the application.

In a similar way, my application uses .NET 3.5 and this is listed as a dependancy - will the installer install .NET 3.5 if required.

Sorry about the basis questions but I have always used InstallShield previously but no longer have a license so am trying to see if the in-built installer is sufficient for my requirements.
0
Comment
Question by:ChrisMDrew
1 Comment
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 33544531
>>which may or may not have SQL Server 2008 installed (most likely it will not as these are client PCs).<<
My understanding is that you will require a SQL Server license installed on any workstation that uses SMO.

You can download the distributable package here:
Microsoft SQL Server 2008 Feature Pack, August 2008
http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
bound data table problem 2 33
Import MySQL data into MS Access using VB.Net interface 5 29
VS 2017 18 44
SQL trigger 5 22
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question