Groups | Blog | Home
all groups > visual studio .net setup > october 2005 >

visual studio .net setup : Problems Installing Visual Studio 2005 / SQL Express


Al Christoph
10/29/2005 4:53:03 PM
1. If this is a repeat posting, please forgive me. My single continuing
complaing about MS is that they don't have an industrial strength (i.e. as
capable and fast as google) search engine either on the web sites or in the
IDE. I use google so much more than the Help button - MS lurkers take note.

2. I had repeated problem with the beta, the rc and now the production
releases of VS 2005 getting SQL Express to install - but only on one
particular PC. I chalked it up to the preliminary nature of the stuff. NOT SO.

I solved the problem today by downloading SQL Express as a standalone
install. Ran it. And found out exactly what was wrong.

I'm going to shout this because of the consequences and the stupidity of it:

SQL EXPRESS 2005 WILL NOT INSTALL ON A COMPRESSED OR AN ENCRYPTED DRIVE.

Words to that effect came out of the stand alone install. I put up a
non-compressed folder for it and it installed hunky dorry. (I didn't fire up
VS 2005 install again. That just takes to agonizingly long.)

NOW HERE IS WHY I'M SHOUTING.

I think we are being encouraged to use SQL Express as part of our
distributable products. Can you imagine what a real small business user will
do to my trial if he has that kind of XPerience on the install??????

This is really very unacceptable. If a non-compressed/unencrypted directory
is needed then do whatever it takes to make the user experience trouble free.
For example, at least with compression it is possible to make an uncompressed
subdirectory and install it there. The install program should do this
semi-automatically in the same way that it queries (used to query) about
making a new directory.
Logic should be
1. dectect can't install in user specified directory (or the default
directory)
2. find a name in that user specified directory that is unique and reasonable
3. make sure that in can be created
4. propose to the user to do it
Alternatively, tell t he user to specify the name of a new directory and let
him know that you will be able to create it uncompressed / unencrypted. I.E.
make it clear that user does not need to go out and try creating the
directory on his own.

Now it may very well be that the latter would work with the present install.
In that case the error message needs to be revamped to make it MUCH MORE
HELPFUL.

3. With respect to the VS2005 install. I"m sure it's been heard repeatedly
here. It needs to be much friendlier about its complaints when things fail.
Be specific. I don't remember if i had the option of where it tried to put
SQL Expresss but if the message had been in a nice place and not bured in 50
MB of log even if it is there) then I could have easily rigged things so that
the necessary folder was not compressed.

4. More to the point, i'd strongly suggest an industrial strength file and
registry cleaning tool be made avialable. Something just short of a
reformat:-))) VS knows what it needs to setup. The tool should use that info
to produce a list of all registry entries, files and folders that should be
blown away for the install to be successful. User generated files could be
backed up. The tool that is currently available off the release notes DID NOT
HACK IT on one of my boxes. I'm hand cleaning the registry. (The MSDN 2005
Beta shows up in list of installed programs in add / remove but apparently
ain't there anymore.)

Enough already.

Now if we'd just get print form back.

--
Regards,
Al Christoph
Senior Consultant and Proprietor
Three Bears Software, LLC
yhhuang NO[at]SPAM online.microsoft.com
10/31/2005 12:33:55 PM
Hello Al,

Thanks very much for your detailed post. This is Yanhong from Microsoft
Community Support Group and I am the manager of MSDN Newsgroup Support
Team.

Our engineers raised the issue to me and I look into it carefully. We
discussed it with senior SQL support engineers and found the following
information:
"INF: SQL Server Databases Not Supported on Compressed Volumes"
http://support.microsoft.com/kb/231347/en-us

So SQL Server databases are not supported on NTFS or FAT compressed
volumes. A compressed volume does not guarantee sector-aligned writes,
which is needed to ensure transactional recovery in some circumstances. In
addition, performing a SQL Server database backup to disk files on
compressed volumes is not recommended.

Specially for SQL 2005, we found the following info: (It is in
setupErrors.xml, If you have SQL 2005 (not express version), please search
your installation folders of SQL 2005 to see whether you can find it)
"SQL Server Setup cannot install files to the compressed or encrypted
folder:. To continue, make sure that your installation directories are not
compressed or encrypted, or specify a different directory, and then run SQL
Server Setup again."

I think that is why we get the error when installing into a compressed
folder.

For your suggestion about the logic, I agree that an informative error
message would make things much easier. The help information is not enough
now, but keep an eye out for it in the future. We are looking at continual
improvement, and it's this kind of feedback that let's us know what things
you're trying to do, that we haven't yet exposed for you. This also applies
to the feedback of search enginee and file/registry cleaning tool. We are
taking it seriously and doing our best to improve it.

Thanks again for your feedback. We appreciate it very much.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://msdn.microsoft.com/subscriptions/managednewsgroups/

This posting is provided "AS IS" with no warranties, and confers no rights.
Al Christoph
11/2/2005 12:23:08 PM
Great response. Makes the technical matter clear.

But to reenforce the message, just think of the consequences of a simple
minded install of the new accounting package which uses SQL Express. The
product would be returned in a hurry! I trust that the install engineers for
the accounting package took this all into account. They should try installing
onto a compressed drive and see what happens:-)

A quick and dirty white paper on recommendations for those of us who want to
use SQL Express in end products on how to do the install would be very
helpful.

There goes the notion of XCOPY install:-(
-
Regards,
Al Christoph
Senior Consultant and Proprietor
Three Bears Software, LLC
just right software @ just right prices @3bears.biz


[quoted text, click to view]
yhhuang NO[at]SPAM online.microsoft.com
11/7/2005 9:14:34 AM
Hi Al,

Agree with you very much. I understand your concern very much. In fact,
that is also one of the reasons that we opened MSDN managed newsgropu. We
want to hear from you and improve the quality of products.

I will go ahead to forward your suggestion to our product group. They will
judge that and make decison of the action items. At the same time, if you
have any questions later, please feel free to post in the newsgroup. We are
here to support you at your convenience.

Thanks very much for your patience and understanding.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://msdn.microsoft.com/subscriptions/managednewsgroups/

This posting is provided "AS IS" with no warranties, and confers no rights.
AddThis Social Bookmark Button