SQL Server 2005 Tools Configuration Issue on Building Setup Project
John
think is a rather strange issue. When I attempted to build or rebuild
a project I had converted from Visual Studio 2005, windows opened as
follows:
Windows Installer
Preparing to install...
[Cancel]
Followed by:
Microsoft SQL Server 2005 Tools
Please wait while Windows configures Microsoft SQL Server 2005 Tools
[Cancel]
Followed by:
Microsoft SQL Server 2005 Tools
0:Watson 1:1304 2:StreamSupportFiles 3:streamBinaryToDisk 4:5 5:e:
\sql9_sp2_t\sql\setup\darwin\sqlcastub\streamca.cpp 6:238
7:sqlcastub.dll 8:sqlrun.msi
[OK]
On pressing OK:
Microsoft SQL Server 2005 Tools
Error writing to file: Access is denied. Verify that you have access
to that directory.
[OK]
The setup project still seemed to build or rebuild successfully and
these messages seemed only to appear on the first attempt to build or
rebuild after starting Visual Studio.
Eventually, it occurred to me to look at the application event log. I
found the following entries in the following order:
Detection of product '{1DD463C0-A50A-4394-B7E4-5895C02F9E0D}', feature
'SQL_Tools90', component '{D3E32604-7137-4A2B-B8B0-A20590637B94}'
failed. The resource 'c:\Program Files\Microsoft SQL Server
\90\NotificationServices\9.0.242\Bin
\microsoft.sqlserver.notificationservices.rules.dll' does not exist.
Detection of product '{1DD463C0-A50A-4394-B7E4-5895C02F9E0D}', feature
'SQL_Tools90' failed during request for component
'{FD153241-37EC-11D2-8892-00A0C981B015}'
Product: Microsoft SQL Server 2005 Tools -- Error 1304. Error writing
to file: Access is denied.
. Verify that you have access to that directory.
Product: Microsoft SQL Server 2005 Tools -- Configuration failed.
I've been developing as an unprivileged user for a couple of years and
the access denied statement immediately suggested checking an
unprivileged user's access to notification services on the local
instance of Microsoft SQL Server 2005. Of course, it turns out that
unprivileged users have no permissions on C:\Program Files\Microsoft
SQL Server\90\NotificationServices. Apparently a special group,
SQLServer2005NotificationUsers$(servername), is created when SQL
Server 2005 is installed to grant Read & Execute, List Folder
Contents, and Read permissions. When I added my development user to
this group, the messages ceased to appear.
I'm at a loss to imagine why I need access to SQL Server Notification
Services to build a setup project for my application. The application
does access data on a couple of SQL Server instances but certainly is
doing nothing with Notification Services of which I am aware and, yes,
I am disturbed by the idea of granting special permissions to my
supposedly unprivileged user.
My intention for this post is to save others some effort should they
run into the same experience, make the matter know to Microsoft, and
perhaps have an explanation.
Thanks.