Connection (reporting services)

[mary555]

I finally got reporting services to work with visual studio.net. i've created a report and then deployed it to the report server. when i go to view the report from the Reports page, i get the error:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'SANDO'. (rsErrorOpeningConnection)
SQL Server does not exist or access denied.

i have installed reporting services on my machine and the database is on my machine. but the report server is on another server that i have to access...

can anyone help me fix this problem?

 

[mary555]

this is the code for my data source definition named SAndO

- <DataSourceDefinition>
<Extension>SQL</Extension>
<ConnectString>data source=SSM-1988;initial catalog=SANDO</ConnectString>
<CredentialRetrieval>Prompt</CredentialRetrieval>
<WindowsCredentials>True</WindowsCredentials>
<Prompt>Enter a user name and password to access the data source:</Prompt>
<Enabled>True</Enabled>
</DataSourceDefinition

 

[mary555]

anyone??

 

[unclerico]

have you tried to use a shared datasource??

 

[xlbo]

Have a look at the properties of the DataSource in the web based gui - when you deploy your DataSource, you sometimes need to reset some properties...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[mary555]

yes i've tried a shared datasource and that doesn't work either...
i have it so that 'overwritedatasources' is true in visual studio.net so when it is deployed, they will be overwritten.

 

[mary555]

are there certain steps i can follow? i really don't knwo why it says the sql server doesn't exist or access denied. i can connect to the sql server from my asp page perfectly fine...

 

[unclerico]

if you change it from "The credentials supplied by the user running the report" and instead select "credentials stored securely in the report server" and supply a valid SQL username and password does it work that way??

 

[mary555]

where do i go to change this?

 

[unclerico]

create a shared datasource, under the credentials tab choose the option labeled "Use a specific username and password"...or if you upload the shared datasource, you can edit it and then choose "credentials stored securely in the report server" and plug in the SQL username and password. You can view the report just fine in your development environment, correct??

 

[mary555]

ok ill try that. and yes i can view it fine in my development environment. what does that mean?
also should i be using for connection type, sql server, or odbc or ole db?

 

[mary555]

ok i used sql server for connection type and did everything you said and it still doesn't work. i get the exact same error. i think i've tried everything! i really don't understand why it can't access or find the sql server, i have it running right here on my machine at ssn-2929...

 

[unclerico]

ok, so you say that you have the following setup:
Box1:
Sql Server - source data
VS.Net

Box2:
Sql Server - report services databases

If you log into Box2 that has your SSRS installed, can you open Enterprise Manager and add the Sql Server on Box1 as a new registration (right-click (local) (Windows NT) and select New SQL Server Registration)...I just want to make sure that you are able to at least connect to the source Sql sever from the Reporting services Sql server

 

[mary555]

ok well on box1 ( my machine) i have vs.net, my sql server stuff and i have reporting services (well something for reporting services but not hte server)

then on box 2 i have the report server and manager...thats what you said right?

so how would i open enterprise manager on box 2?

 

[unclerico]

that's correct...either log directly onto box2 or terminal into it, find Enterprise Manager under the start menu

 

[mary555]

ok ill try that thanks

 

[mary555]

is there gonna be enterirpise manager on it even tho only reporting services is on it and not the sql server?

 

[mary555]

ok after i find enterprise manager, then what am i gonna do? i have to get someone to do that for me so if you tel lme all the steps then ill do it all at once

 

[unclerico]

this is going to sound like a stupid question, but where are the ReportServer and the ReportServerTempDB databases installed?? These are different than the ReportServer and ReportManager are they on Box2??

 

[mary555]

hmm, i think they are on box 2. i installed reporting services on my machine, box 1, but when i go to start sql server, reporting services on my computer, box 1, all that is there is BooksOnline and Reporting Services Samples...so I'm assuming thats all i have on my machine...