2-tier app and db arrangement, where to install RS?

Running a .NET web app on a web app server, while SQL 2000 (standard) runs on
a separate DB server behind it.
Question is, can I install RS on the DB server and still serve reports from
the web/app server? So as to avoid an extra SQL license for installing RS on
that box?
I noticed RS install requests IIS and ASP.NET installed and running, would
have avoided this otherwise on the DB server but if it means I can somehow
serve reports to the web/app server and ultimately to the
application-end-user, all without installing and licensing RS on the other
machine, I'm considering it.
Kind of a RS newb, thx in advance.
--
mjsReally, has no one done this?
--
mjs|||I have not done this but people definitely have. The issue comes down to
security integration. There is an issue called double hop.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sds/sds/troubleshooting_authentication_problems_on_asp_pages.asp
So, you will have to decide if the time and effort is worth the savings of
the license messing with security is worth it. When RS is on the same box as
your app, none of this happens.
People have definitely gotten this to work, but it is something to consider.
For more on it google: double hop IIS
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mjs" <mjs@.discussions.microsoft.com> wrote in message
news:03BA6336-E99D-41C4-8E10-7C8731F97179@.microsoft.com...
> Running a .NET web app on a web app server, while SQL 2000 (standard) runs
> on
> a separate DB server behind it.
> Question is, can I install RS on the DB server and still serve reports
> from
> the web/app server? So as to avoid an extra SQL license for installing RS
> on
> that box?
> I noticed RS install requests IIS and ASP.NET installed and running, would
> have avoided this otherwise on the DB server but if it means I can somehow
> serve reports to the web/app server and ultimately to the
> application-end-user, all without installing and licensing RS on the other
> machine, I'm considering it.
> Kind of a RS newb, thx in advance.
> --
> mjs|||Ignoring the issue of double hop, is there any links on how to make this work?
"Bruce L-C [MVP]" wrote:
> I have not done this but people definitely have. The issue comes down to
> security integration. There is an issue called double hop.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sds/sds/troubleshooting_authentication_problems_on_asp_pages.asp
> So, you will have to decide if the time and effort is worth the savings of
> the license messing with security is worth it. When RS is on the same box as
> your app, none of this happens.
> People have definitely gotten this to work, but it is something to consider.
> For more on it google: double hop IIS
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "mjs" <mjs@.discussions.microsoft.com> wrote in message
> news:03BA6336-E99D-41C4-8E10-7C8731F97179@.microsoft.com...
> > Running a .NET web app on a web app server, while SQL 2000 (standard) runs
> > on
> > a separate DB server behind it.
> >
> > Question is, can I install RS on the DB server and still serve reports
> > from
> > the web/app server? So as to avoid an extra SQL license for installing RS
> > on
> > that box?
> >
> > I noticed RS install requests IIS and ASP.NET installed and running, would
> > have avoided this otherwise on the DB server but if it means I can somehow
> > serve reports to the web/app server and ultimately to the
> > application-end-user, all without installing and licensing RS on the other
> > machine, I'm considering it.
> >
> > Kind of a RS newb, thx in advance.
> >
> > --
> > mjs
>
>|||setspn and 'trust for delegation'
I think that Microsoft does a HORRIBLE job of describing this
functionality to real enterprise customers.
2/3rds of the companies (that is a big number-- like 20 companies out
of 30) that I've worked for in the past 5 years STILL USE SQL
AUTHENTICATION-- merely because Microsoft won't teach people how to
configure double-hop authentication
-Aaron
Loon wrote:
> Ignoring the issue of double hop, is there any links on how to make this work?
> "Bruce L-C [MVP]" wrote:
> > I have not done this but people definitely have. The issue comes down to
> > security integration. There is an issue called double hop.
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sds/sds/troubleshooting_authentication_problems_on_asp_pages.asp
> >
> > So, you will have to decide if the time and effort is worth the savings of
> > the license messing with security is worth it. When RS is on the same box as
> > your app, none of this happens.
> >
> > People have definitely gotten this to work, but it is something to consider.
> > For more on it google: double hop IIS
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "mjs" <mjs@.discussions.microsoft.com> wrote in message
> > news:03BA6336-E99D-41C4-8E10-7C8731F97179@.microsoft.com...
> > > Running a .NET web app on a web app server, while SQL 2000 (standard) runs
> > > on
> > > a separate DB server behind it.
> > >
> > > Question is, can I install RS on the DB server and still serve reports
> > > from
> > > the web/app server? So as to avoid an extra SQL license for installing RS
> > > on
> > > that box?
> > >
> > > I noticed RS install requests IIS and ASP.NET installed and running, would
> > > have avoided this otherwise on the DB server but if it means I can somehow
> > > serve reports to the web/app server and ultimately to the
> > > application-end-user, all without installing and licensing RS on the other
> > > machine, I'm considering it.
> > >
> > > Kind of a RS newb, thx in advance.
> > >
> > > --
> > > mjs
> >
> >
> >

2147467259 ongoing headache

I am receiving the -2147467259 error randomly when building a large temp
table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
I'm using MSDE SP4, all forms known to me of security, virus protection etc
have been shut down or removed Error log includes:
Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
Any comments would be appreciated
Message posted via http://www.droptable.com
This is probably a bug. Since you are on the most current service pack, you
should probably open a call to PSS...($249, but not charged if they confirm
the bug.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rod via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:3263c6b7795a4036a2614c3c8878758a@.droptable.co m...
>I am receiving the -2147467259 error randomly when building a large temp
> table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
> anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
> I'm using MSDE SP4, all forms known to me of security, virus protection
> etc
> have been shut down or removed Error log includes:
> Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
> Any comments would be appreciated
> --
> Message posted via http://www.droptable.com

2147467259 ongoing headache

I am receiving the -2147467259 error randomly when building a large temp
table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
I'm using MSDE SP4, all forms known to me of security, virus protection etc
have been shut down or removed Error log includes:
Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
Any comments would be appreciated
Message posted via http://www.droptable.comThis is probably a bug. Since you are on the most current service pack, you
should probably open a call to PSS...($249, but not charged if they confirm
the bug.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rod via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:3263c6b7795a4036a2614c3c8878758a@.SQ
droptable.com...
>I am receiving the -2147467259 error randomly when building a large temp
> table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
> anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
> I'm using MSDE SP4, all forms known to me of security, virus protection
> etc
> have been shut down or removed Error log includes:
> Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
> Any comments would be appreciated
> --
> Message posted via http://www.droptable.com

2147467259 ongoing headache

I am receiving the -2147467259 error randomly when building a large temp
table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
I'm using MSDE SP4, all forms known to me of security, virus protection etc
have been shut down or removed Error log includes:
Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
Any comments would be appreciated
--
Message posted via http://www.sqlmonster.comThis is probably a bug. Since you are on the most current service pack, you
should probably open a call to PSS...($249, but not charged if they confirm
the bug.)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rod via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:3263c6b7795a4036a2614c3c8878758a@.SQLMonster.com...
>I am receiving the -2147467259 error randomly when building a large temp
> table in a VB / SQL app. Sometimes it finishes...sometimes it makes it
> anywhere from 5 to 90% then bombs. This started when I installed XP Pro.
> I'm using MSDE SP4, all forms known to me of security, virus protection
> etc
> have been shut down or removed Error log includes:
> Spid 55 Exception Oxc0000005 Exception_Access_Violation at 0x000004B8
> Any comments would be appreciated
> --
> Message posted via http://www.sqlmonster.com

2147217887 Error when sending to SQL 2005

I have a Visual Basic 6.0 app that I developed initially using MS SQL Server
7, then MS SQL
Server 2000 and now MS SQL Server 2005. I seem to get this error more often
in 2005 that the older versions. Googling does not seem to give any help.
What are the causes of this error? What can I do to avoid it?
The error happens when I use a command like:
DataRecord3.Fields("PSI_Fifteen") = CStr(PSI_Fifteen)
If I resend the command after the error it always works.
Thanks,
Bob HillerBob and Sharon Hiller (aoklans@.tir.com) writes:
> I have a Visual Basic 6.0 app that I developed initially using MS SQL
> Server 7, then MS SQL Server 2000 and now MS SQL Server 2005. I seem to
> get this error more often in 2005 that the older versions. Googling does
> not seem to give any help. What are the causes of this error? What can I
> do to avoid it?
> The error happens when I use a command like:
> DataRecord3.Fields("PSI_Fifteen") = CStr(PSI_Fifteen)
> If I resend the command after the error it always works.
That seems to be very informative message "Multiple-step OLE DB operation ge
nerated errors. Check each OLE DB status value, if available. No work was do
ne."
That is, there are several possible reasons for the error, or more
exactly, it can be about anything.
One problem may be that the input data is too long for the field. Another
might that there is no metadata available to make it possible to assign
the field a value. The fact that you say that you get this more often
with SQL 2005 indicates this. See
http://lab.msdn.microsoft.com/produ...59-17b0073cfa26
for such a case.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

2005 WebService credentials

We have an app that was running against RS 2000 and we call the web
services for (1) rendering a report and (2) creating subscriptions.
I've changed the web references to look at the ReportExecution2005 and
ReportService2005 web services.
Right now the report renders ok, but when I try to create a
subscription, I get:
"...user data source credentials that are required to execute this
report are not stored in the report server database"
We use impersonation and
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
in each case.
We set rs.url to
http://myserver/ReportServer/ReportExecution2005.asmx
for rendering the report
http://myserver/ReportServer/ReportService2005.asmx
for creating the subscription
I've tried changing the user without effect. The impersonated user has
all possible roles granted in Report Manager.
I have not changed any code going from 2000 to 2005.
Any ideas welcome.
TIA,
JimOk, I'm a bit further.
I went into the data source in Report Manager, and by changing the
credentials
I could save a subscription (although I could not retrieve it with the
guid that resulted).
Right now I'm trying to fing the right setup to allow both the report
execution and the saving of subscriptions.|||Were you able to figure this out?
I am having the same problem. Any help would be greatly appreciated.
"jhcorey@.yahoo.com" wrote:
> We have an app that was running against RS 2000 and we call the web
> services for (1) rendering a report and (2) creating subscriptions.
> I've changed the web references to look at the ReportExecution2005 and
> ReportService2005 web services.
> Right now the report renders ok, but when I try to create a
> subscription, I get:
> "...user data source credentials that are required to execute this
> report are not stored in the report server database"
> We use impersonation and
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> in each case.
> We set rs.url to
> http://myserver/ReportServer/ReportExecution2005.asmx
> for rendering the report
> http://myserver/ReportServer/ReportService2005.asmx
> for creating the subscription
> I've tried changing the user without effect. The impersonated user has
> all possible roles granted in Report Manager.
> I have not changed any code going from 2000 to 2005.
> Any ideas welcome.
> TIA,
> Jim
>|||If anyone from Microsoft (or just has the answer to this) is listening...
this is a REAL problem with 2005 reporting services. Storing credentials as
documented does not work and returns an login failure when being used.
These to individuals seemed to be seeing the same problem I'm running into
and no one has offered a suggestion on correction of the issue.
My setup has SQL 2005/RS/IIS on one server so the database is local to RS.
When ever is store the login credentials for the data source, which seems to
be a requred methodology for dynamic subscriptions the result will be a login
failure when attempting to run the report.
"Jessie" wrote:
> Were you able to figure this out?
> I am having the same problem. Any help would be greatly appreciated.
> "jhcorey@.yahoo.com" wrote:
> > We have an app that was running against RS 2000 and we call the web
> > services for (1) rendering a report and (2) creating subscriptions.
> > I've changed the web references to look at the ReportExecution2005 and
> > ReportService2005 web services.
> >
> > Right now the report renders ok, but when I try to create a
> > subscription, I get:
> > "...user data source credentials that are required to execute this
> > report are not stored in the report server database"
> >
> > We use impersonation and
> > rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> > in each case.
> >
> > We set rs.url to
> > http://myserver/ReportServer/ReportExecution2005.asmx
> > for rendering the report
> > http://myserver/ReportServer/ReportService2005.asmx
> > for creating the subscription
> >
> > I've tried changing the user without effect. The impersonated user has
> > all possible roles granted in Report Manager.
> >
> > I have not changed any code going from 2000 to 2005.
> >
> > Any ideas welcome.
> >
> > TIA,
> > Jim
> >
> >

2005 Fastest communications

Hey,

We do 99.9% inserts. We have a C++ app that communicates with the DBs via ODBC.

Using Sql 2000, it works well. We have another faster server to test with Sql 2005. For some reason, 2005 does not come close to handling the inserts as well as 2000. I've done the statistics and other 2005 config changes. Both boxes are quads with hyper threading. I know it's not the box b/c the 2005 box ran great with Sql 2000.

Is there any reason Sql 2005 would not communicate with our app as well as Sql 2000 would? I'm running out of things to consider. I've done the MAX DOP, etc, it has not mattered. It doesn't compare. We do very rapid inserting.

Thanks!

If you are using same client stack against different servers (2005 vs. 2000), engine guys might find an answer to your question.

2005 Endpoints question.........

We have a in house web app that will need to consume a web service via
javascript, so using 2005's new feature, I created an endpoint &
exposed a stored procedure to use the Native XML web service
functionality. The procedure works fine, and I've tested behind our
firewall. But the database sits in a highly protected domain, behind a
firewall. The web app will sit outside the firewall, in the DMZ. My
questions are...
A) I'm assuming we'll need to open the firewall to communication on the
port specified in the endpoint for the web app to communicate with?
Any security risks here?
B) Who do I grant connect on the endpoint to? The web app is not in
the same domain, so I can't give the connect permission to a domain
user.'
C) More javascript related than SQL....Javascript runs on the client
right? So will all the web browsers out there be attempting to execute
this web service call? Or is it my web server trying to execute the
web service call?Sorry to repost, but what do folks think?
CoreyB wrote:
> We have a in house web app that will need to consume a web service via
> javascript, so using 2005's new feature, I created an endpoint &
> exposed a stored procedure to use the Native XML web service
> functionality. The procedure works fine, and I've tested behind our
> firewall. But the database sits in a highly protected domain, behind a
> firewall. The web app will sit outside the firewall, in the DMZ. My
> questions are...
> A) I'm assuming we'll need to open the firewall to communication on the
> port specified in the endpoint for the web app to communicate with?
> Any security risks here?
> B) Who do I grant connect on the endpoint to? The web app is not in
> the same domain, so I can't give the connect permission to a domain
> user.'
> C) More javascript related than SQL....Javascript runs on the client
> right? So will all the web browsers out there be attempting to execute
> this web service call? Or is it my web server trying to execute the
> web service call?|||You will have to open the firewall on the port that is specified for your
HTTP endpoint. The only security risk is in being able to execute the
procedures you are exposing as well as Denial of Service. Other than that,
users can not get to anything else...provided you have ensured things are
locked down otherwise.
You grant connect authority to the user that will be connecting to the
endpoint. That can be a physical user or done via certificate exchange.
I have no idea on the Javascript question.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"CoreyB" <unc27932@.yahoo.com> wrote in message
news:1144370588.206677.316450@.j33g2000cwa.googlegroups.com...
> We have a in house web app that will need to consume a web service via
> javascript, so using 2005's new feature, I created an endpoint &
> exposed a stored procedure to use the Native XML web service
> functionality. The procedure works fine, and I've tested behind our
> firewall. But the database sits in a highly protected domain, behind a
> firewall. The web app will sit outside the firewall, in the DMZ. My
> questions are...
> A) I'm assuming we'll need to open the firewall to communication on the
> port specified in the endpoint for the web app to communicate with?
> Any security risks here?
> B) Who do I grant connect on the endpoint to? The web app is not in
> the same domain, so I can't give the connect permission to a domain
> user.'
> C) More javascript related than SQL....Javascript runs on the client
> right? So will all the web browsers out there be attempting to execute
> this web service call? Or is it my web server trying to execute the
> web service call?
>

2005 Endpoints question.........

We have a in house web app that will need to consume a web service via
javascript, so using 2005's new feature, I created an endpoint &
exposed a stored procedure to use the Native XML web service
functionality. The procedure works fine, and I've tested behind our
firewall. But the database sits in a highly protected domain, behind a
firewall. The web app will sit outside the firewall, in the DMZ. My
questions are...
A) I'm assuming we'll need to open the firewall to communication on the
port specified in the endpoint for the web app to communicate with?
Any security risks here?
B) Who do I grant connect on the endpoint to? The web app is not in
the same domain, so I can't give the connect permission to a domain
user.'
C) More javascript related than SQL....Javascript runs on the client
right? So will all the web browsers out there be attempting to execute
this web service call? Or is it my web server trying to execute the
web service call?Sorry to repost, but what do folks think?
CoreyB wrote:
> We have a in house web app that will need to consume a web service via
> javascript, so using 2005's new feature, I created an endpoint &
> exposed a stored procedure to use the Native XML web service
> functionality. The procedure works fine, and I've tested behind our
> firewall. But the database sits in a highly protected domain, behind a
> firewall. The web app will sit outside the firewall, in the DMZ. My
> questions are...
> A) I'm assuming we'll need to open the firewall to communication on the
> port specified in the endpoint for the web app to communicate with?
> Any security risks here?
> B) Who do I grant connect on the endpoint to? The web app is not in
> the same domain, so I can't give the connect permission to a domain
> user.'
> C) More javascript related than SQL....Javascript runs on the client
> right? So will all the web browsers out there be attempting to execute
> this web service call? Or is it my web server trying to execute the
> web service call?|||You will have to open the firewall on the port that is specified for your
HTTP endpoint. The only security risk is in being able to execute the
procedures you are exposing as well as Denial of Service. Other than that,
users can not get to anything else...provided you have ensured things are
locked down otherwise.
You grant connect authority to the user that will be connecting to the
endpoint. That can be a physical user or done via certificate exchange.
I have no idea on the Javascript question.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"CoreyB" <unc27932@.yahoo.com> wrote in message
news:1144370588.206677.316450@.j33g2000cwa.googlegroups.com...
> We have a in house web app that will need to consume a web service via
> javascript, so using 2005's new feature, I created an endpoint &
> exposed a stored procedure to use the Native XML web service
> functionality. The procedure works fine, and I've tested behind our
> firewall. But the database sits in a highly protected domain, behind a
> firewall. The web app will sit outside the firewall, in the DMZ. My
> questions are...
> A) I'm assuming we'll need to open the firewall to communication on the
> port specified in the endpoint for the web app to communicate with?
> Any security risks here?
> B) Who do I grant connect on the endpoint to? The web app is not in
> the same domain, so I can't give the connect permission to a domain
> user.'
> C) More javascript related than SQL....Javascript runs on the client
> right? So will all the web browsers out there be attempting to execute
> this web service call? Or is it my web server trying to execute the
> web service call?
>