| Groups | Blog | Home |
sql server reporting services : Delivery to FileShare on Different Domain
Hi,
I have a server with sql server 2005 reporting services and reports are running fine. Sql server service and reporting service all are configured with domain user account. Now we have to deliver a report on excel format to a file share located in a different domain. We have a different userid and password on that domain for accessing the fileshare. So i am trying to schedule a report subscription, in which i mentioned the file share and then user id and password (which is used for accesing the fileshare on different domain) and scheduled it. It is failing and giving me the following error. A logon error occurred when attempting to access the file share. The user account or password is not valid. But i am able to access this share and create/delete/update files using that userid and password. When i try to write the same file to my share on the same domain as the reporting server is located.It is running fine. I am not sure,Eventhough i specified a different domain user id and password, is it using the domain user account which is used by the service for delivering the file to this share. Any idea.. Thanks in advance. Thanks
Hope you have given in this format <domain>\<user name> at
"credentials required to access the file share". Other way is if possible create your userid in the different domain. so that it uses the same and logins in to the other domain and stores the report in a seperate folder, provided you give proper access. Amarnath, MCTS. [quoted text, click to view] "Prabhu" wrote:
> Hi, > > I have a server with sql server 2005 reporting services and reports are > running fine. > > Sql server service and reporting service all are configured with domain user > account. > > Now we have to deliver a report on excel format to a file share located in a > different domain. We have a different userid and password on that domain for > accessing the fileshare. > > So i am trying to schedule a report subscription, in which i mentioned the > file share and then user id and password (which is used for accesing the > fileshare on different domain) and scheduled it. > > It is failing and giving me the following error. > A logon error occurred when attempting to access the file share. The user > account or password is not valid. > > But i am able to access this share and create/delete/update files using that > userid and password. > > When i try to write the same file to my share on the same domain as the > reporting server is located.It is running fine. > > I am not sure,Eventhough i specified a different domain user id and > password, is it using the domain user account which is used by the service > for delivering the file to this share. > > Any idea.. > > Thanks in advance. > > Thanks >
Yes Amarnath, I have given in this format only "domain\userid".
Since both the domains don't have trusted relationship. We have the same id on the other domain also, But it is not working. My doubt is, is it taking the user account in which sql reporting service is running or is it taking the "NT AUTHORITY\NetworkService" as userid for accessing the fileshare. Is there anything i have to change in the config file.. Thanks Prabhu [quoted text, click to view] "Amarnath" wrote:
> Hope you have given in this format <domain>\<user name> at > "credentials required to access the file share". Other way is if possible > create your userid in the different domain. so that it uses the same and > logins in to the other domain and stores the report in a seperate folder, > provided you give proper access. > > Amarnath, MCTS. > > "Prabhu" wrote: > > > Hi, > > > > I have a server with sql server 2005 reporting services and reports are > > running fine. > > > > Sql server service and reporting service all are configured with domain user > > account. > > > > Now we have to deliver a report on excel format to a file share located in a > > different domain. We have a different userid and password on that domain for > > accessing the fileshare. > > > > So i am trying to schedule a report subscription, in which i mentioned the > > file share and then user id and password (which is used for accesing the > > fileshare on different domain) and scheduled it. > > > > It is failing and giving me the following error. > > A logon error occurred when attempting to access the file share. The user > > account or password is not valid. > > > > But i am able to access this share and create/delete/update files using that > > userid and password. > > > > When i try to write the same file to my share on the same domain as the > > reporting server is located.It is running fine. > > > > I am not sure,Eventhough i specified a different domain user id and > > password, is it using the domain user account which is used by the service > > for delivering the file to this share. > > > > Any idea.. > > > > Thanks in advance. > > > > Thanks > >
Infact it takes the userid which you give. Just for testing purpose try
administrator login and see whether it works. Amarnath, MCTS [quoted text, click to view] "Prabhu" wrote:
> Yes Amarnath, I have given in this format only "domain\userid". > > Since both the domains don't have trusted relationship. We have the same id > on the other domain also, But it is not working. > > My doubt is, is it taking the user account in which sql reporting service is > running or > is it taking the "NT AUTHORITY\NetworkService" as userid for accessing the > fileshare. > > Is there anything i have to change in the config file.. > > > Thanks > > Prabhu > > > "Amarnath" wrote: > > > Hope you have given in this format <domain>\<user name> at > > "credentials required to access the file share". Other way is if possible > > create your userid in the different domain. so that it uses the same and > > logins in to the other domain and stores the report in a seperate folder, > > provided you give proper access. > > > > Amarnath, MCTS. > > > > "Prabhu" wrote: > > > > > Hi, > > > > > > I have a server with sql server 2005 reporting services and reports are > > > running fine. > > > > > > Sql server service and reporting service all are configured with domain user > > > account. > > > > > > Now we have to deliver a report on excel format to a file share located in a > > > different domain. We have a different userid and password on that domain for > > > accessing the fileshare. > > > > > > So i am trying to schedule a report subscription, in which i mentioned the > > > file share and then user id and password (which is used for accesing the > > > fileshare on different domain) and scheduled it. > > > > > > It is failing and giving me the following error. > > > A logon error occurred when attempting to access the file share. The user > > > account or password is not valid. > > > > > > But i am able to access this share and create/delete/update files using that > > > userid and password. > > > > > > When i try to write the same file to my share on the same domain as the > > > reporting server is located.It is running fine. > > > > > > I am not sure,Eventhough i specified a different domain user id and > > > password, is it using the domain user account which is used by the service > > > for delivering the file to this share. > > > > > > Any idea.. > > > > > > Thanks in advance. > > > > > > Thanks > > >
Forgotten, just go to report configuration option and check for the account
used. change accordinlgy and imp check the execution account, because this is the user used for unattended operations, so you may have to change this username to the one in other domain. Amarnath MCTS [quoted text, click to view] "Amarnath" wrote:
> Infact it takes the userid which you give. Just for testing purpose try > administrator login and see whether it works. > > > Amarnath, MCTS > > > "Prabhu" wrote: > > > Yes Amarnath, I have given in this format only "domain\userid". > > > > Since both the domains don't have trusted relationship. We have the same id > > on the other domain also, But it is not working. > > > > My doubt is, is it taking the user account in which sql reporting service is > > running or > > is it taking the "NT AUTHORITY\NetworkService" as userid for accessing the > > fileshare. > > > > Is there anything i have to change in the config file.. > > > > > > Thanks > > > > Prabhu > > > > > > "Amarnath" wrote: > > > > > Hope you have given in this format <domain>\<user name> at > > > "credentials required to access the file share". Other way is if possible > > > create your userid in the different domain. so that it uses the same and > > > logins in to the other domain and stores the report in a seperate folder, > > > provided you give proper access. > > > > > > Amarnath, MCTS. > > > > > > "Prabhu" wrote: > > > > > > > Hi, > > > > > > > > I have a server with sql server 2005 reporting services and reports are > > > > running fine. > > > > > > > > Sql server service and reporting service all are configured with domain user > > > > account. > > > > > > > > Now we have to deliver a report on excel format to a file share located in a > > > > different domain. We have a different userid and password on that domain for > > > > accessing the fileshare. > > > > > > > > So i am trying to schedule a report subscription, in which i mentioned the > > > > file share and then user id and password (which is used for accesing the > > > > fileshare on different domain) and scheduled it. > > > > > > > > It is failing and giving me the following error. > > > > A logon error occurred when attempting to access the file share. The user > > > > account or password is not valid. > > > > > > > > But i am able to access this share and create/delete/update files using that > > > > userid and password. > > > > > > > > When i try to write the same file to my share on the same domain as the > > > > reporting server is located.It is running fine. > > > > > > > > I am not sure,Eventhough i specified a different domain user id and > > > > password, is it using the domain user account which is used by the service > > > > for delivering the file to this share. > > > > > > > > Any idea.. > > > > > > > > Thanks in advance. > > > > > > > > Thanks > > > >
On Mar 15, 11:43 pm, Amarnath <Amarn...@discussions.microsoft.com>
[quoted text, click to view] wrote: > Infact it takes the userid which you give. Just for testing purpose try > administrator login and see whether it works. > > Amarnath, MCTS > > > > "Prabhu" wrote: > > Yes Amarnath, I have given in this format only "domain\userid". > > > Since both the domains don't have trusted relationship. We have the same id > > on the otherdomainalso, But it is not working. > > > My doubt is, is it taking the user account in which sql reporting service is > > running or > > is it taking the "NT AUTHORITY\NetworkService" as userid for accessing the > > fileshare. > > > Is there anything i have to change in the config file.. > > > Thanks > > > Prabhu > > > "Amarnath" wrote: > > > > Hope you have given in this format <domain>\<user name> at > > > "credentials required to access the file share". Other way is if possible > > > create your userid in the differentdomain. so that it uses the same and > > > logins in to the otherdomainand stores the report in a seperate folder, > > > provided you give proper access. > > > > Amarnath, MCTS. > > > > "Prabhu" wrote: > > > > > Hi, > > > > > I have a server with sql server 2005 reporting services and reports are > > > > running fine. > > > > > Sql server service and reporting service all are configured withdomainuser > > > > account. > > > > > Now we have to deliver a report on excel format to a file share located in a > > > > differentdomain. We have a different userid and password on thatdomainfor > > > > accessing the fileshare. > > > > > So i am trying to schedule a report subscription, in which i mentioned the > > > > file share and then user id and password (which is used for accesing the > > > > fileshare on differentdomain) and scheduled it. > > > > > It is failing and giving me the following error. > > > > A logon error occurred when attempting to access the file share. The user > > > > account or password is not valid. > > > > > But i am able to access this share and create/delete/update files using that > > > > userid and password. > > > > > When i try to write the same file to my share on the samedomainas the > > > > reporting server is located.It is running fine. > > > > > I am not sure,Eventhough i specified a differentdomainuser id and > > > > password, is it using thedomainuser account which is used by the service > > > > for delivering the file to this share. > > > > > Any idea.. > > > > > Thanks in advance. > > > > > Thanks > > > > > Prabhu- Hide quoted text - > > - Show quoted text - here are the steps that I took: 1. I used the uid/pwd to make sure that I have access to the file share on the server on the other domain. 2. on the subscription I specified the domain\uid and password...and still got the error. 3. on the subscritpion, I used just the uid and password...just for fun, and still got the error. If I set the execution account to the domain\uid and password of the other server or the other domain....lots of items break. So I'm pretty sure that altering the execution account is not going to do anything. How I understand it, when a data driven subscription is triggered..it won't use the execution account. http://msdn2.microsoft.com/en-us/library/ms181156.aspx I know that my uid/pwd is correct because I supplied them to access the file share...and if I change the file path to be local and supply a local uid/pwd, then everything works. here is the entire error that I'm getting. Please let me know if I'm skipping over anything. ReportingServicesService!subscription!13!03/26/2007-14:22:08:: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider +NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. ---> System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword) at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd) --- End of inner exception stack trace --- at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd) at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData d) ReportingServicesService!library!13!03/26/2007-14:22:08:: Status: Failure writing file xxx.pdf : A logon error occurred when attempting to access the file share. The user account or password is not valid.
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |