sql server 2005 tools configuration starts when I build a distribution project (VB 2005)

  • Thread starter Thread starter Alessandro
  • Start date Start date
A

Alessandro

When I build a setup project under vb2005, starts "Microsoft sql server 2005
Tool" showing "Please wait while windows configures Microsoft sql server
2005 tools"
Then it stop with this message: Failure setting security rights on users
account SQLServer2005NotificationServicesUser$M2

If I give the user administrator rights it does not happen and buid goes
right. I I remove the user from administrators the message is showed again.

I have Sql 2005 for developer installed.
What is wrong?

Alessandro Belli
 
Hi Alessandro,

From the error message, we can see that the building process is granting
permission on the user SQLServer2005NotificationServicesUser$M2. It is
adding this user to certain group. This action requires Administrator's
rights and a normal user cannot do that. So we have to give the user
administrator's rights.

Kevin Yu
Microsoft Online Community Support

============================================================================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
============================================================================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
If I grant admin permission to the user, the message does not appear.
I can give admin right just to solve the problem, but after this I have to
remove the user from administrators group
I don't understand why the bulding process needs to grant permission to the
notification service.
How can I manually starts the configuration tool and finish the
installation?
Bye
Alex
 
No, i does not use any database. I also tryed to make a setup project
without add any dependance, and I have the same error
By
Alex
 
Hi Alex,

This is really weird. I suspect this has something to do with the VS.NET
environment on your machine. Have you tried to build this on another
machine? If you don't have another machine for testing, could you please
send me your setup project so that I can try to repro it on my machine?

Kevin Yu
Microsoft Online Community Support

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Sorry, remove 'online' from the no spam alias is my real email.

Kevin Yu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.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/subscriptions/support/default.aspx.
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
I had the same problem on two different pc, with similar configuration,
visual studio 2005 and sql 2005 developer edition.
On one pc I've solved giving the user administrators right, then run the
setup project and finish sql tool set up. Then I remove the user from admin
group.
On the second pc I had to reinstall vs and then do the same.


About this I'm not happy about microsoft that always speak about security,
but it does not take care to test vs with non admin privileges.
I've posted the same question to different italian microsoft newsgroup (and
also english), nobody except you answer me, this mean then probably all
users uses vs with admin privileges.

Bye
Alessandro Belli
 
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/subscriptions/managednewsgroups/default.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/subscriptions/support/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
 
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
 
Back
Top