Click here to Skip to main content
14,451,428 members
Rate this:
Please Sign up or sign in to vote.
See more:
--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
Updated 9-Jan-19 8:44am
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.
Gerry Schmitz 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

Rate this:
Please Sign up or sign in to vote.

Solution 1

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.
   

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100