Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to set user for deploying reports? Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2013 4:55 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140
When I deploy my report from BIDS (2008) it doesn't ask me for a user name, it picks a user and tries to use that user to do the upload, but that user doesn't have permissions. So, how to set the user which is used for deployment?

Basically, it's the opposite of this question - he wants to get rid of the login box and I want to see it at least one more time...
http://www.sqlservercentral.com/Forums/Topic523146-147-1.aspx


This is the output I get...
------ Deploy started: Project: VeriservReports, Configuration: Debug ------
Deploying to http://MYSERVER/ReportServer
Deploying data source '/Data Sources/DS_Veriserv'.
Error rsAccessDenied : The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.
Deploying data set '/Datasets/ValidCaseIDs'.
Cannot deploy the report because the shared data source '/Data Sources/DS_Veriserv' that the report references does not exist on the report server.
Deploying data set '/Datasets/ValidServiceIDs'.
Cannot deploy the report because the shared data source '/Data Sources/DS_Veriserv' that the report references does not exist on the report server.
Deploying report '/VeriservReports/Footer'.
Error rsAccessDenied : The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.
Cannot deploy the report because the shared data source '/Data Sources/DS_Veriserv' that the report references does not exist on the report server.
Cannot deploy the report because the shared data source '/Data Sources/DS_Veriserv' that the report references does not exist on the report server.
Cannot deploy the report because the shared data source '/Data Sources/DS_Veriserv' that the report references does not exist on the report server.
Publishing report parts in report 'C:\Users\dadamson\Documents\Visual Studio 2008\Projects\VeriservReports\VeriservReports\bin\Debug\Summary.rdl'
Publishing report part 'Image2' to '/Report Parts'...
Error : Failed to deploy report part 'Image2': 'The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.'.
Publishing report part 'serviceId' to '/Report Parts'...
Error : Failed to deploy report part 'serviceId': 'The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.'.
Publishing report part 'caseId' to '/Report Parts'...
Error : Failed to deploy report part 'caseId': 'The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.'.
Publishing report part 'Tablix9' to '/Report Parts'...
Error : Failed to deploy report part 'Tablix9': 'The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.'.
Publishing report parts complete -- 0 succeeded, 4 failed, 0 skipped


Question is... how to change the "MyDomain\MyUserName" to a legit user?
Post #1413797
Posted Thursday, January 31, 2013 12:55 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140
I found out how to fix it. It's in the Control Panel->User Accounts->Manage Your Credentials

One of the things in the "Vault" was the user it was picking for deployment. Deleting that user allowed me to click "Deploy" in BIDS and have it ask for the login again. Then I could enter a login which works.
Post #1414297
Posted Wednesday, April 17, 2013 10:32 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:20 PM
Points: 220, Visits: 695
So you deleted a local user account? Be careful this does not cause issues in other areas.
Post #1443375
Posted Wednesday, April 17, 2013 11:24 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140
Well I hope it doesn't cause any "issues" because I don't have that job any more and I'm never speaking to them again!
Post #1443395
Posted Wednesday, April 17, 2013 11:41 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:20 PM
Points: 220, Visits: 695
Sorry to hear this. I won't ask for details.
Cheers
Post #1443404
Posted Wednesday, April 17, 2013 12:05 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140
LOL, better things come up and sometimes you have to irritate someone in order to take advantage. I left in an unprofessional way, but I had to do it that way for my own good.
Post #1443419
Posted Wednesday, April 17, 2013 6:53 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 10:30 PM
Points: 35,959, Visits: 30,251
It's not meant as a criticism... just some advice because I've seen what has happened to others when they do such a thing. It's a very small world and even if you're absolutely correct in your reasons for doing such a thing, it can follow you in a very bad way.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

"Change is inevitable. Change for the better is not." -- 04 August 2013
(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1443568
Posted Wednesday, April 17, 2013 9:52 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140
Oh yeah I know that, I've been doing this stuff for over 20 years. It isn't maybe as bad as I made it sound. I just didn't like the place. I had good reasons.
Post #1443587
Posted Thursday, April 18, 2013 10:30 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:20 PM
Points: 220, Visits: 695
It's good if you still have friends there that can give you a reference. So don't burn your bridges completely.

Post #1443991
Posted Thursday, April 18, 2013 10:47 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140
I only worked there for two months, and I didn't do anything and didn't get to know anybody - they all hated me for some reason. It really was weird. I've never been hired for a job before, and basically been told to sit there and do nothing all day. When I tried to go find some work to do, I accidentally stepped over some weird cultural boundary and offended someone. I've never encountered that before, but someone I spoke to about it said they thought it was a case of "I violated the caste system" and since 90% of the staff was straight from India, that kind of made sense. I am a take charge kind of person, and I made that clear in the interview, and if they didn't want someone who could take charge and get things done, they should have hired someone else. So, I had problems with the job assignment itself, problems with the people, and they didn't really need me in the first place. So, when I say I quit in an unprofessional way, what I mean is I walked into my supervisor's office at 4pm on a Friday and said "today is my last day here" because it really was the last day I could mentally handle, and I felt like I was wasting their money.

And when I say I didn't do anything, I mean the report this question is about, and some minor web site bug fixes are the only things I did for TWO MONTHS. You don't hire someone with over 20 years of experience and my salary requirements to post on Facebook all day. I need a challenge, and I'm worth it :)
Post #1444001
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse