.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

How to let a non admin business user run a replication snapshot job?

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
According to the msdn library, I would have to give the non admin user (User1) SQLAgentUserRole privileges. But it also says that it has to be a local job and not a multi server job. Is the snapshot agent job a local or multi server job? Considering the snapshot agent is a local job and i make USER1 the owner of that job. He should be able to run the job rite? I need to give USER1 the ability to run sp_start_job to start the snapshot agent ONLY! (and not any other jobs). So what are the steps to do this? I also read that the only way to achieve this is by creating a proxy account? Is there an article somewhere that best describes this?  

View Complete Post

More Related Resource Links

How to determine if current SQL User is admin or owner?

I wish to determine, from my C# application, if the current user has admin or owner rights to the database they are connected to. I beleive I have all the information required: Servername Database name Windows/Database auth username (If database auth) password (if database auth) I'm trying to find a way that using the smo objects (smo.user), but as of yet I cant quite work it out: - How to get the appropriate user - How to determine if that user is an admin/owner. Any tips would be appreciated. If I have posted to the wrong forum, let me know - I couldnt find one that was obviously more appropriate. Thanks.

Data Mining - Business User's view

Using BIDS, when I create a Mining model solution I can see lot's of useful utilities like Mining Model viewer, Mining Model Prediction etc that comes with lot's of graphs' etc. What would be the best approach to display these graph's to business users. Can I do this efficiently using SSRS or Do I need to use PowerPivot etc..

Mining Model - Business user's view

Using BIDS, when I create a Mining model solution I can see lot's of useful utilities like Mining Model viewer, Mining Model Prediction etc that comes with lot's of graphs' etc. What would be the best approach to display these graph's to business users. Can I do this easily using SSRS/PowerPivot etc..

Merge Replication: How to give read access on snapshot share to a sql account

Hello All, I want to give read access to an sql account(not windows account). Can it be given or not. Someone please tell. Thanks saandii777

How to check if a given user is local admin or not

Hi, How to check if a user (may be domain user also) is part of local administrators group or not? Note I am NOT talking about checking of current logged in user. I should send the username & passowrd of any user (may or may not be domain user) & that should flag me whether that user is local admin or not. Please help.

Merge Replication, Push Subscription : The snapshot takes centuries to apply

Well, not centuries, except that the users are storming the gate. I'm trying to find how to get the snapshot moved to the subscriber and applied in a reasonable time. Last time was successful, but took 2 1/2 days to build the subscriber database from the snapshot. Hillary responded: Something is very wrong here. You should be able to generate your snapshot, copy it manually over to the subscriber - using the altsnapshotfolder parameter and then apply it there. So now I have my snapshot, a folder with lots of .cft .bcp .dri .prc .sch  and .trg files. Getting this to the subscriber computer shouldn't take long. Once I get it there, how do I use it to get the subscriber set up?  You can't be successful at this unless you're at least 1/2 a bubble off level.

change snapshot agent user (Agent security)

Hi, we have replicated dbon sql server 2008 (transaction replication) now we want to change the user used for the snapshot agent, from sql Managment studio go to publication property and then agent security and then snapshot agent (now we are using domain user) here we want to use the other option which is " to be run under sql server agent service account" but I couldnt choose this option because its unactive so how we can activate this option for existing replication without restarting the replication (i can use this option for the new replication wizard) Thanks

A query in Snapshot replication ---- Please help !!!!!

Hi,     I have a SQL Database with different roles and users,depends upon their roles,permissions,they can see some table,views and etc.     Now,I am going to replicate (Snapshot) the same Database into different server.    My query is, in the source database incase if they do some changes in the roles,permissions,adding roles/updation of users happens, the same will be replicated in the  destination databsase as well? One of my friend told that ,snapshot replication just deals with records inside the Database and does not deal with users/roles/permissions...Is that so?

which is best Snapshot Replication or Transaction Replication for my requirement?

Hi,    We have a main transaction database where all the live data is there.Now, to run a reporting application,we need a  different database, but the data is as EXACTLY as the live database.So,probaly every noght aroung 1 0'clock,we want to sync these two databases.   In this scenario,which is better, Snapshot replication or Transaction Replication? what are the pros and cons of using them? As I am new to this things,ur answers would be very much helpful..

Merge Replication Compressed Snapshot

Hi, How do I go about compressing my snapshot files? I am unable to find a tutorial explaining how to do it.

Problem binding business objects to custom user control properties

I have created a user control (supplierPicker) intended to allows a supplier database to be searched and a supplier selected. I want to be able to use this control in a number of other user controls, by binding the suppplierID property of the supplierPicker to a supplierID property in a business object, which is set as the datacontext of the parent user control. When I do this, and there is a supplierID specified in the business ofbject, the binding sets the supplierID in the supplierPicker control and it shows the correct supplier name in the textbox. However when the supplierID DependencyProperty is changed from within the supplierPicker the newly selected supplier name is shown in the TextBox, but the SupplierID does not propogate back to the business object. Other controls on the parent form work fine, so the binding to the business object seems to be ok. Any pointers as to what I'm doing wrong here would be grately appreciated.  This one has been driving me nuts for days! Snipped code for the supplier picker:         public partial class SupplierPicker : UserControl, INotifyPropertyChanged     {         public static DependencyProperty SupplierIDProperty;         public event PropertyChangedEventHandler PropertyChan

How to add colleagues to a user profile without admin priviliges programatically ...

Hi,I am working on a kind of a social networking site and the use case is as follows.1. User A sends a friendship request to User B.2. User B accepts.3. User A is added as a colleague in User B's Profile.4. User B is added as a colleague in User A's Profile.Step 2-4 are done using User B's login. Step 2 and 3 go fine but in step 4 I get the following error "This operation requires you to be managing your own data or have administrator privileges.". The API being used is UserProfile.Colleagues.Create (...);What is required is obvious but not possible in this scenario. SPSecurity.RunWithElevatedPrivileges does not help.  Any other way of accomplishing this.Thanks.

Can't replicate few tables in Snapshot replication SQL 2005 in two different domain


I am not able to replicate few tables of a database using snapshot replication.Both publisher and subscriber are in different network and domain.Although I am able to replicate 950 tables but facing problem in some 30 tables.I am using push replication and I can telnet 1433 port from A server to B server but vice versa not happening.When I am replicating few records of that few tables it is replicating properly but not able to replicate complete table. I tried Verbose history too but I didn't get complete error.

Please help me out.....

MSSQL Merge Replication User Accounts


Running SQL Server 2008 (not R2) Enterprise, and merge replication via web.  I am using a domain account for the Agent Process Account on the subscriber, and it only seems to pull the subscription when the user is logged in! Anyone seen this before? Do I need to create a new account to run this under?  I've tried using system accounts but it says bad password or no access.



transactional replication - no initial snapshot generated


When I try to set up a transactional replication, setting it up works fine, but then I get an error from the snapshot assistant: the execution stops at the table sysdiagrams with the error message that the filed „definition“ uses the type varbinary(max).

There was no specific error code, i.e. the error code displayed was '0'

If I try to set up a snapshot replication the sysdiagrams table is not included and it runs through just fine.


SQL Server 2008 merge replication snapshot hangs on filtered articles


I have a publication on SQL Server 2008 Standard Edition using merge replication.  When I attempt to generate the initial snapshot, the snapshot agent appears to hang on the step "Setting up the publication for filtered articles."  I get a long (over 4 hour) series of messages: "The process is running and is waiting for a response from the server."  I know something is happening server-side, as SQL Server and the snapshot agent use a lot of memory and max out one core's processing capacity.

This has me confused as the publication is not doing any filtering.

Even more confusing:  I backed up the database and restored it onto my development-test system.  I created the snapshot there, and it took under 10 minutes every time.

Any suggestions for investigating and resolving this?

GoDaddy.Com is a negligent parent, so can somebody help this newbie set up admin/user logins?


I'm becoming increasing frustrated with the lack of support at GoDaddy.Com.  Today they're not even answering their phones!

All I'm trying to do is set up an admin and several user accounts on my site so I and several users can log on. I'm not even trying to do it remotely, but on their SQL server.

1. Using Query Analyzer I created a few users:

INSERT INTO aspnet_Users(ApplicationID,  UserName, LoweredUserName,  LastActivityDate).... That worked.

2. Next, I created a couple of roles:

INSERT INTO aspnet_Roles(ApplicationID, RoleName, LoweredRoleName).... That worked.

3. I then put the users in these roles:

INSERT INTO aspnet_UsersInRoles(UserID, RoleID)....  That, too, worked.

4. But then I tried to put those users, roles, and UsersInRoles into aspnet_Membership according to their own documentation--Activating ASP.NET 2.0 Personal Web Site User Account  http://help.godaddy.com/topic/216/article/885 using  UPDATE aspnet_Membership SET IsApproved = 1 WHERE UserId = 'MyUserId'

Nothing.  Although Query Analyzer tells me the command executed successfully, the aspnet_Membership table shows no entries.

It's my understanding that getting entries into this table is critical for the login procedure. So can somebod

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend