SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to set user for deploying reports?


How to set user for deploying reports?

Author
Message
Jasmine D. Adamson
Jasmine D. Adamson
Right there with Babe
Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)

Group: General Forum Members
Points: 752 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?
Jasmine D. Adamson
Jasmine D. Adamson
Right there with Babe
Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)

Group: General Forum Members
Points: 752 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.
MMartin1
MMartin1
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7277 Visits: 2033
So you deleted a local user account? Be careful this does not cause issues in other areas.

----------------------------------------------------
How to post forum questions to get the best help
Jasmine D. Adamson
Jasmine D. Adamson
Right there with Babe
Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)

Group: General Forum Members
Points: 752 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!
MMartin1
MMartin1
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7277 Visits: 2033
Sorry to hear this. I won't ask for details.
Cheers

----------------------------------------------------
How to post forum questions to get the best help
Jasmine D. Adamson
Jasmine D. Adamson
Right there with Babe
Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)

Group: General Forum Members
Points: 752 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.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)

Group: General Forum Members
Points: 216632 Visits: 41986
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jasmine D. Adamson
Jasmine D. Adamson
Right there with Babe
Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)

Group: General Forum Members
Points: 752 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.
MMartin1
MMartin1
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7277 Visits: 2033
It's good if you still have friends there that can give you a reference. So don't burn your bridges completely.
:-)

----------------------------------------------------
How to post forum questions to get the best help
Jasmine D. Adamson
Jasmine D. Adamson
Right there with Babe
Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)Right there with Babe (752 reputation)

Group: General Forum Members
Points: 752 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 Smile
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search