Intranet/Internet and Reporting Services

We have a situation where we are going to have our IIS server with two NIC
cards. One for the internet and one for the intranet. We are planning to have
our SQL Server connected to the IIS server via the intranet.
My question is... if a user on the internet requests a report and we render
it programmatically via visual basic/visual C# (Using a reporting services
object in ASP) on the web will they have access to the report even though
they do not have direct access to the SQL Reporting Services server? Will I
be able to take what is returned to that object and display it on the
Intranet?
TIA,
PatrickYes. You can use the Response.BinaryWrite() method to direct the report
content to a webform or ASP page. There are limitations, however, with
images and interactive report features when using this approach.
"Patrick Allmond" <PatrickAllmond@.discussions.microsoft.com> wrote in
message news:EDC55557-ECE5-4F21-B07B-583896BDE7D5@.microsoft.com...
> We have a situation where we are going to have our IIS server with two NIC
> cards. One for the internet and one for the intranet. We are planning to
> have
> our SQL Server connected to the IIS server via the intranet.
> My question is... if a user on the internet requests a report and we
> render
> it programmatically via visual basic/visual C# (Using a reporting services
> object in ASP) on the web will they have access to the report even though
> they do not have direct access to the SQL Reporting Services server? Will
> I
> be able to take what is returned to that object and display it on the
> Intranet?
> TIA,
> Patrick
>

Intranet, windows authentication, Sql Server Login Failed for user (null)

Hi--

I am building an intRAnet website using windows authentication for website access and SQL Server access ( Trusted_Connection = true ).

In IIS I have these settings:

Allow Anonymous = unchecked (false)Windows Authentication = Checked (true)Digest windows = checked (true)

In my Web.Config file:

authentication="windows"impersonate="true"allowusers="*"

When I pull up the page these are my credentials:

Security.Principal.Windows: mydomain\myuserid (this is correct what it shows on my page)

Me.User.Identity: mydomain\myuserid (this is correct what it shows on my page)

Threading.currentThread.currentUser mydomain\myuserid (this is correct what it shows on my page)

So the ASP.NET page recognizes it is me and my domain. However, when i click a button to pull some data from a database I get the error message: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

My data access on SQL Server works fine. The weird thing is when I debug on my machine it pulls data fine. but when I copy the files to the windows 2003 server it doesn't work.

Do i have to do something with delegation?

some guys and i did some research and we think that kerberos delegation is not enabled on our domain in active directory.

When i take off digest, and select basic authentication the credentials pass...but i don't want that.

Intranet Set up with SQL server and ASP

Dear all,

I am trying to make a Intranet connection with SQL 2000 and ASP,
but a serious problem in connection string. Please can you help me in this issue

I am using following connection string.

(windows authontication)

Set conn=Server.CreateObject("ADODB.Connection")

conn.Mode=adModeReadWrite
conn.Open="PROVIDER=SQLOLEDB;Integrated Security=SSPI;Initial cataloge =nrth;DataSource=server"

System dsn =nrth
server name =server

This string makes following error

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Invalid connection string attribute

//global.asa, line 17

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Invalid connection string attribute

/test2.asp, line

can you correct this or suggest a valid connection string

Thank youThe DSN probably only exists on the one server. Try replacing it with
Server=servername.|||Originally posted by Satya
The DSN probably only exists on the one server. Try replacing it with
Server=servername.

still having error,

I am checking it in server itself

Intranet CAL license

Hello,
I know that you need a SQL Server license for the reporting services server
installation but what about the report viewers/developers?... just a couple
of questions:
1) Do you need a SQL Server CAL license for every report developer using
visual studio .NET?
2) Do ALL report viewers need a CAL license? Or does this depend upon how
you deploy the reports?
Any advice would be appreciated.
Thanksif you are developing reports using vs.net then you will need a client license
if people are accessing the reports over the web then i'm not aware that
you need a licence (for a start it would be impossible to monitor)
"Basil" wrote:
> Hello,
> I know that you need a SQL Server license for the reporting services server
> installation but what about the report viewers/developers?... just a couple
> of questions:
> 1) Do you need a SQL Server CAL license for every report developer using
> visual studio .NET?
> 2) Do ALL report viewers need a CAL license? Or does this depend upon how
> you deploy the reports?
> Any advice would be appreciated.
> Thanks|||The licensing for RS is the same as for SQL Server. For instance, if
internet users are access the reports it would be the same as internet users
accessing SQL Server. I believe MS has special per processor licensing for
internet use. For intranet, every client that would access the report server
needs to have a CAL. Either per client or you can do the per processor. At
least that is my understanding of how the licensing works. The important
thing is RS licensing and SQL Server licensing is the same thing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"adolf garlic" <adolfgarlic@.discussions.microsoft.com> wrote in message
news:B22B84CB-CFD8-40F1-A6BB-4CF868DD1685@.microsoft.com...
> if you are developing reports using vs.net then you will need a client
> license
>
> if people are accessing the reports over the web then i'm not aware that
> you need a licence (for a start it would be impossible to monitor)
> "Basil" wrote:
>> Hello,
>> I know that you need a SQL Server license for the reporting services
>> server
>> installation but what about the report viewers/developers?... just a
>> couple
>> of questions:
>> 1) Do you need a SQL Server CAL license for every report developer using
>> visual studio .NET?
>> 2) Do ALL report viewers need a CAL license? Or does this depend upon how
>> you deploy the reports?
>> Any advice would be appreciated.
>> Thanks