| Groups | Blog | Home |
sql server reporting services : PLEASE HELP!!!! Unable to connect to SQL Database from Report Man
I am working with SQL Reporting services 2000.... The report is unable to connect to a remote datasource as I try to preview it. The database uses both SQL and Windows Auth. 1. Created a shared datasource in my project 2. Deployed it on the server. Used OverwriteDataSource = false 3. Create a new shared datasource on the server. Gave a connection string with no username and password. 4. Selected "Credentials stored securely in the report server" and then entered the SQL server login and passoword there. 5. Changed the report properties in the manager to use this datasource. 6. While trying to "View" via report manager, I am getting the error message An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection) Get Online Help SQL Server does not exist or access denied.
I too had this problem. The way that I fixed it was by making sure that I
could connect to the SQL server in question from the server that hosted the reporting services website. It was the that I realized two very important things. 1. The user profile that reporting services uses to run as a service needs SQL server access. 2. The user profile that I entered as the login for the report needed to be qualified with a domain name if it was a windows account. These may not be your problem, but they were mine. I hope this helps [quoted text, click to view] "PV" wrote:
> Hi, > I am working with SQL Reporting services 2000.... The report is unable to > connect to a remote datasource as I try to preview it. The database uses both > SQL and Windows Auth. > > 1. Created a shared datasource in my project > 2. Deployed it on the server. Used OverwriteDataSource = false > 3. Create a new shared datasource on the server. Gave a connection string > with no username and password. > 4. Selected "Credentials stored securely in the report server" and then > entered the SQL server login and passoword there. > 5. Changed the report properties in the manager to use this datasource. > 6. While trying to "View" via report manager, I am getting the error message > > An error has occurred during report processing. (rsProcessingAborted) Get > Online Help > Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection) > Get Online Help > SQL Server does not exist or access denied. > >
I confirmed this... Found out that I could connect from the Reporting
services machine to my SQL Server using the same SQL credentials.... Also gave access to the DB to the user that the Report Manager runs under... But this still occurs. [quoted text, click to view] "Nikolai Sonin" wrote:
> I too had this problem. The way that I fixed it was by making sure that I > could connect to the SQL server in question from the server that hosted the > reporting services website. It was the that I realized two very important > things. > 1. The user profile that reporting services uses to run as a service needs > SQL server access. > 2. The user profile that I entered as the login for the report needed to be > qualified with a domain name if it was a windows account. > These may not be your problem, but they were mine. I hope this helps > > > "PV" wrote: > > > Hi, > > I am working with SQL Reporting services 2000.... The report is unable to > > connect to a remote datasource as I try to preview it. The database uses both > > SQL and Windows Auth. > > > > 1. Created a shared datasource in my project > > 2. Deployed it on the server. Used OverwriteDataSource = false > > 3. Create a new shared datasource on the server. Gave a connection string > > with no username and password. > > 4. Selected "Credentials stored securely in the report server" and then > > entered the SQL server login and passoword there. > > 5. Changed the report properties in the manager to use this datasource. > > 6. While trying to "View" via report manager, I am getting the error message > > > > An error has occurred during report processing. (rsProcessingAborted) Get > > Online Help > > Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection) > > Get Online Help > > SQL Server does not exist or access denied. > > > >
I'm having a very similar problem, but I have two reports using the
datascource and rendering no problem and a third that gets the rsErrorOpeningConnection error. This report previews just fine in VS, but when not when deployed to the server. Anyone know if RS is does some sort of credential caching? [quoted text, click to view] "PV" wrote:
> I confirmed this... Found out that I could connect from the Reporting > services machine to my SQL Server using the same SQL credentials.... > > Also gave access to the DB to the user that the Report Manager runs under... > > But this still occurs. > > > > "Nikolai Sonin" wrote: > > > I too had this problem. The way that I fixed it was by making sure that I > > could connect to the SQL server in question from the server that hosted the > > reporting services website. It was the that I realized two very important > > things. > > 1. The user profile that reporting services uses to run as a service needs > > SQL server access. > > 2. The user profile that I entered as the login for the report needed to be > > qualified with a domain name if it was a windows account. > > These may not be your problem, but they were mine. I hope this helps > > > > > > "PV" wrote: > > > > > Hi, > > > I am working with SQL Reporting services 2000.... The report is unable to > > > connect to a remote datasource as I try to preview it. The database uses both > > > SQL and Windows Auth. > > > > > > 1. Created a shared datasource in my project > > > 2. Deployed it on the server. Used OverwriteDataSource = false > > > 3. Create a new shared datasource on the server. Gave a connection string > > > with no username and password. > > > 4. Selected "Credentials stored securely in the report server" and then > > > entered the SQL server login and passoword there. > > > 5. Changed the report properties in the manager to use this datasource. > > > 6. While trying to "View" via report manager, I am getting the error message > > > > > > An error has occurred during report processing. (rsProcessingAborted) Get > > > Online Help > > > Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection) > > > Get Online Help > > > SQL Server does not exist or access denied. > > > > > >
There is no credential caching between data sources. Often this is some sort
of network name resolution issue. -- Brian Welcker Group Program Manager Microsoft SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Leef" <Leef@discussions.microsoft.com> wrote in message news:D69B9ED5-00A6-4ECF-9501-C269709E90B8@microsoft.com... > I'm having a very similar problem, but I have two reports using the > datascource and rendering no problem and a third that gets the > rsErrorOpeningConnection error. This report previews just fine in VS, but > when not when deployed to the server. Anyone know if RS is does some sort > of > credential caching? > > "PV" wrote: > >> I confirmed this... Found out that I could connect from the Reporting >> services machine to my SQL Server using the same SQL credentials.... >> >> Also gave access to the DB to the user that the Report Manager runs >> under... >> >> But this still occurs. >> >> >> >> "Nikolai Sonin" wrote: >> >> > I too had this problem. The way that I fixed it was by making sure >> > that I >> > could connect to the SQL server in question from the server that hosted >> > the >> > reporting services website. It was the that I realized two very >> > important >> > things. >> > 1. The user profile that reporting services uses to run as a service >> > needs >> > SQL server access. >> > 2. The user profile that I entered as the login for the report needed >> > to be >> > qualified with a domain name if it was a windows account. >> > These may not be your problem, but they were mine. I hope this helps >> > >> > >> > "PV" wrote: >> > >> > > Hi, >> > > I am working with SQL Reporting services 2000.... The report is >> > > unable to >> > > connect to a remote datasource as I try to preview it. The database >> > > uses both >> > > SQL and Windows Auth. >> > > >> > > 1. Created a shared datasource in my project >> > > 2. Deployed it on the server. Used OverwriteDataSource = false >> > > 3. Create a new shared datasource on the server. Gave a connection >> > > string >> > > with no username and password. >> > > 4. Selected "Credentials stored securely in the report server" and >> > > then >> > > entered the SQL server login and passoword there. >> > > 5. Changed the report properties in the manager to use this >> > > datasource. >> > > 6. While trying to "View" via report manager, I am getting the error >> > > message >> > > >> > > An error has occurred during report processing. (rsProcessingAborted) >> > > Get >> > > Online Help >> > > Cannot create a connection to data source 'xxxx'. >> > > (rsErrorOpeningConnection) >> > > Get Online Help >> > > SQL Server does not exist or access denied. >> > > >> > > >> > > CAN SOMEONE PLEASE HELP ME!!!!!!
Thanks! I finally figure it out.
It was a permissions problem, but was masked because I thought it was using the shared datasource. Instead it was using a report specific datasource that had the same name. The way I discovered this was by going and taking a look at the XML code of the problem report. [quoted text, click to view] "Brian Welcker [MSFT]" wrote:
> There is no credential caching between data sources. Often this is some sort > of network name resolution issue. > > -- > Brian Welcker > Group Program Manager > Microsoft SQL Server Reporting Services > > This posting is provided "AS IS" with no warranties, and confers no rights. > > "Leef" <Leef@discussions.microsoft.com> wrote in message > news:D69B9ED5-00A6-4ECF-9501-C269709E90B8@microsoft.com... > > I'm having a very similar problem, but I have two reports using the > > datascource and rendering no problem and a third that gets the > > rsErrorOpeningConnection error. This report previews just fine in VS, but > > when not when deployed to the server. Anyone know if RS is does some sort > > of > > credential caching? > > > > "PV" wrote: > > > >> I confirmed this... Found out that I could connect from the Reporting > >> services machine to my SQL Server using the same SQL credentials.... > >> > >> Also gave access to the DB to the user that the Report Manager runs > >> under... > >> > >> But this still occurs. > >> > >> > >> > >> "Nikolai Sonin" wrote: > >> > >> > I too had this problem. The way that I fixed it was by making sure > >> > that I > >> > could connect to the SQL server in question from the server that hosted > >> > the > >> > reporting services website. It was the that I realized two very > >> > important > >> > things. > >> > 1. The user profile that reporting services uses to run as a service > >> > needs > >> > SQL server access. > >> > 2. The user profile that I entered as the login for the report needed > >> > to be > >> > qualified with a domain name if it was a windows account. > >> > These may not be your problem, but they were mine. I hope this helps > >> > > >> > > >> > "PV" wrote: > >> > > >> > > Hi, > >> > > I am working with SQL Reporting services 2000.... The report is > >> > > unable to > >> > > connect to a remote datasource as I try to preview it. The database > >> > > uses both > >> > > SQL and Windows Auth. > >> > > > >> > > 1. Created a shared datasource in my project > >> > > 2. Deployed it on the server. Used OverwriteDataSource = false > >> > > 3. Create a new shared datasource on the server. Gave a connection > >> > > string > >> > > with no username and password. > >> > > 4. Selected "Credentials stored securely in the report server" and > >> > > then > >> > > entered the SQL server login and passoword there. > >> > > 5. Changed the report properties in the manager to use this > >> > > datasource. > >> > > 6. While trying to "View" via report manager, I am getting the error > >> > > message > >> > > > >> > > An error has occurred during report processing. (rsProcessingAborted) > >> > > Get > >> > > Online Help > >> > > Cannot create a connection to data source 'xxxx'. > >> > > (rsErrorOpeningConnection) > >> > > Get Online Help > >> > > SQL Server does not exist or access denied. > >> > > > >> > > > >> > > CAN SOMEONE PLEASE HELP ME!!!!!! > >
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 |