rsErrorOpeningConnection. Can't find the specified SQL Server <<na

I'm new on the newsgroup, so Hi every body. I'm from Argentina and probably
my English is not very good but I Will try.
I have this problem, in the design environment of Visual Studio Net, I get
success creating a shared data source, I Preview my reports without any
trouble.
But when I Implement my report on the Report Server, when I run it I got
this error:
"rsErrorOpeningConnection. Can't find the specified SQL Server <<sql server
name>>"
The server name is 'sql-01-us.wavenet.com.ar', I don't know why it is
happening. Somebody can help me?
Thanks to all ;)
--
Fernando Moyano
Coordinador de Proyectos
Power Solution S.A.
ArgentinaAfter publishing your report and its data source to Report Manager, locate
the data source in Report Manager, then open it by clicking on it. Check that
the Connection String is set correctly. If not, set it correctly and do not
forget to click Apply. (the Apply button can be hidden at the bottom on some
screens).
If you still have a problem, then check that you can communicate with the
SQL Server using a different tool from the Report Server computer. Try using
Query Analzer if it is installed. Or you can use odbcping.exe.
I also notice that you have hyphens in your server name, and can't remember
whether that would cause an issue.
Charles Kangai, MCT, MCDBA
"Fernando Moyano" wrote:
> I'm new on the newsgroup, so Hi every body. I'm from Argentina and probably
> my English is not very good but I Will try.
> I have this problem, in the design environment of Visual Studio Net, I get
> success creating a shared data source, I Preview my reports without any
> trouble.
> But when I Implement my report on the Report Server, when I run it I got
> this error:
> "rsErrorOpeningConnection. Can't find the specified SQL Server <<sql server
> name>>"
> The server name is 'sql-01-us.wavenet.com.ar', I don't know why it is
> happening. Somebody can help me?
> Thanks to all ;)
> --
> Fernando Moyano
> Coordinador de Proyectos
> Power Solution S.A.
> Argentina|||Hi Charles, it seems to be the firewall (ISA Server), I dont know what port
is using the SQL Server en my hosting, but the ISA was blocking it. Now it
works ok.
Thanks for your answer
"Charles Kangai" wrote:
> After publishing your report and its data source to Report Manager, locate
> the data source in Report Manager, then open it by clicking on it. Check that
> the Connection String is set correctly. If not, set it correctly and do not
> forget to click Apply. (the Apply button can be hidden at the bottom on some
> screens).
> If you still have a problem, then check that you can communicate with the
> SQL Server using a different tool from the Report Server computer. Try using
> Query Analzer if it is installed. Or you can use odbcping.exe.
> I also notice that you have hyphens in your server name, and can't remember
> whether that would cause an issue.
> Charles Kangai, MCT, MCDBA
> "Fernando Moyano" wrote:
> > I'm new on the newsgroup, so Hi every body. I'm from Argentina and probably
> > my English is not very good but I Will try.
> >
> > I have this problem, in the design environment of Visual Studio Net, I get
> > success creating a shared data source, I Preview my reports without any
> > trouble.
> >
> > But when I Implement my report on the Report Server, when I run it I got
> > this error:
> > "rsErrorOpeningConnection. Can't find the specified SQL Server <<sql server
> > name>>"
> >
> > The server name is 'sql-01-us.wavenet.com.ar', I don't know why it is
> > happening. Somebody can help me?
> >
> > Thanks to all ;)
> >
> > --
> > Fernando Moyano
> > Coordinador de Proyectos
> > Power Solution S.A.
> > Argentina

rsErrorOpeningConnection with Oracle

Hi ,
I have SQL Server in my computer whereas SQL Server server is installed in
an other computer.
I have problem to see my raport in the reporting server when the datasource
comes from the Oracle database.
The following error is generated :
Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'datasource1'.
rsErrorOpeningConnection)
Get Online Help
?
----
The tnsnames.ora is ok in my computer and in the server. Link to oracle with
other programs like TOAD works fine in my computer. Moreover, in my computer,
I can see the preview in Visual Studio.NET without problem.
Thanks for any advice.Most likely, this problem occurs because some Oracle files and directories
must have additional security settings so that the Oracle data provider can
be loaded from inside ASP.NET (Report Server). Suggested steps on the report
server machine:
1. Locate the Oracle\Oracle version\bin directory, right-click the
directory, and then click Properties.
2. Click the Security tab, and then click Add.
3. Under Enter object names to select, type network service, and then click
OK.
4. In the Group or user names box, click NETWORK SERVICE.
5. Under Permissions for Network Service, click to select the Read & Execute
check box.
6. Click Advanced.
7. Click the Allow inheritable permissions from the parent to propagate to
this object and all child objects. Include these with the entries explicitly
defined here box, and then click OK.
8. Click OK.
9. Locate the Oracle\Oracle version\network\admin directory, right-click the
directory, and then click Properties.
10. Repeat steps 2 through 8.
11. run iisreset
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"r388042" <r388042@.discussions.microsoft.com> wrote in message
news:3E3EB098-5E69-44EB-ABE2-0D55240A2C7A@.microsoft.com...
> Hi ,
> I have SQL Server in my computer whereas SQL Server server is installed
> in
> an other computer.
> I have problem to see my raport in the reporting server when the
> datasource
> comes from the Oracle database.
> The following error is generated :
> Reporting Services Error
> ----
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'datasource1'.
> rsErrorOpeningConnection)
> Get Online Help
> ?
> ----
> The tnsnames.ora is ok in my computer and in the server. Link to oracle
> with
> other programs like TOAD works fine in my computer. Moreover, in my
> computer,
> I can see the preview in Visual Studio.NET without problem.
> Thanks for any advice.
>
>
>|||Hi! I tried your suggestions but it still doesnt work. I also tested the
Oracle connection from within the server and I can connect fine. I welcome
any suggestions. Thanks!
Teresa
"Robert Bruckner [MSFT]" wrote:
> Most likely, this problem occurs because some Oracle files and directories
> must have additional security settings so that the Oracle data provider can
> be loaded from inside ASP.NET (Report Server). Suggested steps on the report
> server machine:
> 1. Locate the Oracle\Oracle version\bin directory, right-click the
> directory, and then click Properties.
> 2. Click the Security tab, and then click Add.
> 3. Under Enter object names to select, type network service, and then click
> OK.
> 4. In the Group or user names box, click NETWORK SERVICE.
> 5. Under Permissions for Network Service, click to select the Read & Execute
> check box.
> 6. Click Advanced.
> 7. Click the Allow inheritable permissions from the parent to propagate to
> this object and all child objects. Include these with the entries explicitly
> defined here box, and then click OK.
> 8. Click OK.
> 9. Locate the Oracle\Oracle version\network\admin directory, right-click the
> directory, and then click Properties.
> 10. Repeat steps 2 through 8.
> 11. run iisreset
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "r388042" <r388042@.discussions.microsoft.com> wrote in message
> news:3E3EB098-5E69-44EB-ABE2-0D55240A2C7A@.microsoft.com...
> > Hi ,
> >
> > I have SQL Server in my computer whereas SQL Server server is installed
> > in
> > an other computer.
> > I have problem to see my raport in the reporting server when the
> > datasource
> > comes from the Oracle database.
> > The following error is generated :
> >
> > Reporting Services Error
> > ----
> > An error has occurred during report processing. (rsProcessingAborted)
> > Get Online Help
> > Cannot create a connection to data source 'datasource1'.
> > rsErrorOpeningConnection)
> > Get Online Help
> > ?
> > ----
> >
> > The tnsnames.ora is ok in my computer and in the server. Link to oracle
> > with
> > other programs like TOAD works fine in my computer. Moreover, in my
> > computer,
> > I can see the preview in Visual Studio.NET without problem.
> >
> > Thanks for any advice.
> >
> >
> >
> >
> >
>
>

rserroropeningconnection SQL RS 2000

I have configured a user as content manager in security settings for a data source and trying to execute the report under his credentials, but i keep getting the error

RSErrorOpeningConnection login failed for user <domain>\<username>

I have set windows authentication for the data source

Can anyone please help...

have u selected the checkbox in your datasource like this....

Use as Windows credentials when connecting to the data source..

|||

I selected the last but one option --

Windows NT Integrated Security

rsErrorOpeningConnection

Hi,
I really really need some help with the problem below. I

am having problems trying to run reports from a VB.Net application. The problem

is as follows:

SQL Server 2005, SQL Server Reporting Services and the VB

.NET application called ‘risk-op’ are on a server.

A user tries to access the application from a remote

computer. The application is displayed and the user is able to do everything.

However when the user tries to click ‘Go’ for one of the reports the following

error is displayed:

An

error has occurred during processing (rsProcessingAborted)
Cannot

create a connection to data source ‘risk-op’ (rsErrorOpeningConnection)

This error occurs

because the user is not a user on the SQL server database. However if I add the

user to the database the user is able to then view the report.

The

reason for this is because reporting services is configured to use windows

authentication as shown below. As a result when the user presses ‘Go’ to view a

report, reporting services tries to connect to the database using windows authentication

and if that user is not setup as a user on the database the user is then not

able to view the report.

I need to get around this problem. I don’t want to have to

manually add users to the database every time (that maintenance for a couple of

hundred people would be a disaster!)

I believe that a way around this would be to use ‘Credentials

stored securely in the report server’ in SQL Server Reporting Services. Is this

the way to do it and if so, where do I add these credentials to the report

server?

I came across an article that said “Credentials are stored in

reversible encryption in the report server database. You can specify one set of

stored credentials for each data source used in a report. The credentials you

provide retrieve the same data for every user who runs the report.”

How do I add these credentials and is this the answer to my

problem?

Do I have to change something in the RSreportserver.config

file?
Any help would be much appreciated, thanks!
Ian

No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

If you want to do that on a server level and you want to use Windows authentication rather than SQL Server authentication, you could use one Windows User for Reporting Services, enable Anynomous authentication on the Web Server and specify the use under the IIS context for Anonymous Authentication.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

Thanks for your reply.
You said,
“No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

If you want to do that on a server level and you want to use Windows authentication rather than SQL Server authentication, you could use one Windows User for Reporting Services, enable Anynomous authentication on the Web Server and specify the use under the IIS context for Anonymous Authentication.”

Ok so in the web front end of SQL Server Reporting Services I just untick Windows auth and tick SQL Server auth instead? I tried doing this but it didn’t work. (presumably because I hadn’t created the SQL Server user to authenticate? Is it just a case of creating a user on the database?)

You then say “you could use one Windows User for Reporting Service”, how do I do this?

“enable Anynomous authentication on the Web Server” – I have that done in IIS on the web server for the folder ‘risk-op’ which is where my application is but do I actually have to allow anonymous access somewhere else?
Thanks again, your help is much appreciated,
Ian

|||Has there ever been a final resolution to this? I am having a similar problem.

rsErrorOpeningConnection

Hi,
I really really need some help with the problem below. I am having problems trying to run reports from a VB.Net application. The problem is as follows:

SQL Server 2005, SQL Server Reporting Services and the VB .NET application called ‘risk-op’ are on a server.

A user tries to access the application from a remote computer. The application is displayed and the user is able to do everything. However when the user tries to click ‘Go’ for one of the reports the following error is displayed:

An error has occurred during processing (rsProcessingAborted)
Cannot create a connection to data source ‘risk-op’ (rsErrorOpeningConnection)

This error occurs because the user is not a user on the SQL server database. However if I add the user to the database the user is able to then view the report.

The reason for this is because reporting services is configured to use windows authentication as shown below. As a result when the user presses ‘Go’ to view a report, reporting services tries to connect to the database using windows authentication and if that user is not setup as a user on the database the user is then not able to view the report.

I need to get around this problem. I don’t want to have to manually add users to the database every time (that maintenance for a couple of hundred people would be a disaster!)

I believe that a way around this would be to use ‘Credentials stored securely in the report server’ in SQL Server Reporting Services. Is this the way to do it and if so, where do I add these credentials to the report server?

I came across an article that said “Credentials are stored in reversible encryption in the report server database. You can specify one set of stored credentials for each data source used in a report. The credentials you provide retrieve the same data for every user who runs the report.”

How do I add these credentials and is this the answer to my problem?

Do I have to change something in the RSreportserver.config file?
Any help would be much appreciated, thanks!
Ian

No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

If you want to do that on a server level and you want to use Windows authentication rather than SQL Server authentication, you could use one Windows User for Reporting Services, enable Anynomous authentication on the Web Server and specify the use under the IIS context for Anonymous Authentication.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi Jens,

Thanks for your reply.
You said,
“No you can simply switch that in the data source section by specifying a custom data source for the report. By switching, you will use SQL Server Authentication instead of Windows Authentication.

If you want to do that on a server level and you want to use Windows authentication rather than SQL Server authentication, you could use one Windows User for Reporting Services, enable Anynomous authentication on the Web Server and specify the use under the IIS context for Anonymous Authentication.”

Ok so in the web front end of SQL Server Reporting Services I just untick Windows auth and tick SQL Server auth instead? I tried doing this but it didn’t work. (presumably because I hadn’t created the SQL Server user to authenticate? Is it just a case of creating a user on the database?)

You then say “you could use one Windows User for Reporting Service”, how do I do this?

“enable Anynomous authentication on the Web Server” – I have that done in IIS on the web server for the folder ‘risk-op’ which is where my application is but do I actually have to allow anonymous access somewhere else?
Thanks again, your help is much appreciated,
Ian

|||Has there ever been a final resolution to this? I am having a similar problem.sql