VS 2017 setup deployment package failing

Question

0.00/5 (No votes)

See more:

VS2017

--Trying to build a setup project with VS 2017. I'm getting 3 dialog boxes showing,

Microsoft SQL Server 2008 Management studio
Please Wait While Windows Configures Microsoft SQL Server Management Studio 2008

--Then this dialog flashed up

Microsoft SQL Server 2008 Management studio
0:Watson 1:1304 2 Stream SupportFiles
3:streamBinary ToDisk 4.5
5:e\sql10_main\sqlsetup\darwin\sqlcastsub\streamca.cpp
6:238:7:sqlcastsub.dll 8:sqlrun.msi

-- And finally I get this dialog.

Microsoft SQL Server 2008 Management studio
Error writing to file. Access is denied
Verify you have access to that directory.

-- When I click on Ok, another dialog pops open stating

Preparing to install. Then everything hangs. After 4-5 mins I have to get task manager to kill it off.

-- I'm not trying to install SQLServer 2008 Management Studio. Just trying to build a setup/deploy package

What I have tried:

I was going to uninstall the SQL Server 2008 Setup support files but it's telling me SQL Server 2016 is dependent on it. I'm running a SQL Server 2016 back end on this project

Posted 7-Jan-19 8:12am

danash

Updated 9-Jan-19 7:44am

Add a Solution

Comments

Richard MacCutchan 7-Jan-19 15:23pm

The deployment obviously thinks that it needs to install these packages. You need to check your project settings.

danash 8-Jan-19 13:07pm

Hi, Richard, I've gone through every menu I can find to try to see where VS is getting the thought to install it. Can't find it anywhere so far.

Richard MacCutchan 9-Jan-19 4:07am

Sorry, but it is impossible for anyone here to guess what is going on on your system. It may be that you have a corruption somewhere in Visual Studio.

[no name] 8-Jan-19 0:15am

SQL Server 2008 is being "retired". Time to upgrade.

danash 8-Jan-19 13:06pm

Hi Gerry, I'm running SQL Server 2016 and the same with the management studio. The project back end is Sql Server 2016. I haven't told it to use anything else. I cant see m to find where VS2017 is getting it's direction to incorporate it in the deploy build

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

danash · Answer 1 · 2019-01-09T07:44:00

The Solution. I went ahead and uninstalled every mention of SQL Server 2008 from my system. After scratching my head for a loooong time I noticed the one dialog box that stated.

Microsoft SQL Server 2008 Management studio
0:Watson 1:1304 2 Stream SupportFiles
3:streamBinary ToDisk 4.5
5:e\sql10_main\sqlsetup\darwin\sqlcastsub\streamca.cpp
6:238:7:sqlcastsub.dll 8:sqlrun.msi

It looks like wrapped line numbers 1 through 8. Line 5 is showing a path on an "e:" drive. My system doesn't have an "e:" drive. I figured VS2017 was giving me a generic "Error writing to file. Access is denied Verify you have access to that directory." Error.

So I figured I'd remove all references to SQL server 2008 from my system. Once I did that I rebooted, ran the deploy package and it assembled perfectly the first time.