I have the same problem. I followed the link you provided and eventually ran
into a broken link. First, let me say I have a fresh install of
XP/VS2K5/SS2K5 using defaults and the install of Notification Services. The
app I am trying to build Setup for uses ADO.NET but not any of the SQL
namespaces. Like Alessandro, the problem exists only if you are conforming to
best practices and do you development in an account that does not have
administrative privilege.
Following the link you provided plus other research in Books Online it
appears 1) VS thinks there are some SQL Server namespaces accessed, 2) those
namespaces use Notification Services and 3) security settings must be
configured for the default Notification Services Instance on the local
machine. Needless to say there is a bug somewhere that causes items 1 and 2.
But I'll move on to #3 in search of a work around.
The default install of SQL Server 2005 with Notification Services does not
create a default Notification Instance. When you try to create one, using the
instructions in the documentation, there is an assumption a default instance
configuration file exists but it does not. Digging in the documentation
further (SQL Server Books Online) to "New Notification Services Instance" it
says "For information about creating a Notification Services application,
including creating an instance configuration file, see Building Notification
Solutions". You click on the Building Notification Solutions link and find it
is broken ("Sorry, no topics were found for the selected link").
I think the solution is to log on an account with administrative privilege,
create a default instance and configure the security settings so the Power
User who is trying to build Setup has the proper permissions. But I am stuck
at square one - how to create a default instance configuration file. Where
can I find the missing documentation?
Tom
"Luke Zhang [MSFT]" wrote:
Hello Alessandro,
When you start "Microsoft sql server 2005 Tool" and configure it, it may
need the account SQLServer2005NotificationServicesUser$ComputerName to have
enough permission to accept the configration. Here is article about
permission setting of Notification Services account
Configuring Windows Accounts for an Instance of Notification Services
http://msdn2.microsoft.com/en-us/library/ms172585.aspx
You may refer to it to see if this can resolve the problem (without grant
it as a admin).
Sincerely,
Luke Zhang
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.