SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Deployment Issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ditkar
Starting Member

4 Posts

Posted - 06/17/2013 :  08:25:52  Show Profile  Reply with Quote
I am trying to deploy reports to deployment server.

Server has 2008 report services running. Server is not in domain and is in Workgroup. My system is in domain.

When I click on Deploy it says:
"The permission granted to user dplyment\usrnm are insufficient to perform this operation"

I tried entering following credentials
1. User created on deployment server
2. my domain user and pwd

Any suggestions???

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 06/17/2013 :  09:18:09  Show Profile  Reply with Quote
whats the role to which credential is mapped in report server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

ditkar
Starting Member

4 Posts

Posted - 06/17/2013 :  09:37:57  Show Profile  Reply with Quote
Both System Admin and User.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 06/17/2013 :  09:45:38  Show Profile  Reply with Quote
is the user dplyment\usrnm a member of local administrator group of the server?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

ditkar
Starting Member

4 Posts

Posted - 06/17/2013 :  10:04:19  Show Profile  Reply with Quote
Yes, the user is member of local administrator group on the deployment server.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 06/18/2013 :  00:48:36  Show Profile  Reply with Quote
You could be better off adding the server also to domain and then using your dplyment\usrnm for reporting server authentication/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

ditkar
Starting Member

4 Posts

Posted - 06/18/2013 :  03:03:11  Show Profile  Reply with Quote
Is there any other alternative???
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 06/19/2013 :  01:11:56  Show Profile  Reply with Quote
quote:
Originally posted by ditkar

Is there any other alternative???


Not anything as far as i know as AS supports windows authentication

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000