Hello All,
I have designed some Reports in RS, now i want to install it on
Production Machine (Web Server) but issue is that, production machine
doesnt have RS. Can it be possible to make any setup or package which
install required dll's to production machine without installing RS?
Please help me how to solve this.
Regards
RajeshRS is required if you wish to use RS to retrieve your report data as well as
provide report management capabilities. If you just want to display a
report on your web page you should look into using the new Report Viewer
controls that shipped with VS2005.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <kapse_rajesh@.rediffmail.com> wrote in message
news:1134627577.603210.61580@.g49g2000cwa.googlegroups.com...
> Hello All,
> I have designed some Reports in RS, now i want to install it on
> Production Machine (Web Server) but issue is that, production machine
> doesnt have RS. Can it be possible to make any setup or package which
> install required dll's to production machine without installing RS?
> Please help me how to solve this.
>
> Regards
> Rajesh
>|||Daniel,
Thanks for Instant FeedBack, but problem is that I dont have VS2005 and
i just want to display reports on web page, can it be possible that i
use RS's dll or supporting files and install it on Production Machine
and run the reports?|||No, it is not possible. You need to install RS if you want to process the
reports. The only other option you have is the one I mentioned, using the
VS controls in 2005.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <kapse_rajesh@.rediffmail.com> wrote in message
news:1134714178.861590.319450@.f14g2000cwb.googlegroups.com...
> Daniel,
> Thanks for Instant FeedBack, but problem is that I dont have VS2005 and
> i just want to display reports on web page, can it be possible that i
> use RS's dll or supporting files and install it on Production Machine
> and run the reports?
>
Showing posts with label reports. Show all posts
Showing posts with label reports. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
Installing Delphi 2005 Gives Security Exception..
After installing delphi 2005 I am getting a security exception when trying
to access the reports/report manager/web service of Reporting Services.
I think it is Borland related - the stack trace shows borland in there
now...How do I fix?
======================================================== Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the
permission of type System.Security.Permissions.EnvironmentPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 failed.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SecurityException: Request for the permission of type
System.Security.Permissions.EnvironmentPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.]
System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet
grantedSet, PermissionSet deniedSet, CodeAccessPermission demand,
PermissionToken permToken) +675
System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames,
Int32 unrestrictedOverride) +0
System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap,
StackCrawlMark& stackMark) +88
System.Security.CodeAccessPermission.Demand() +62
System.Environment.GetEnvironmentVariable(String variable) +53
Borland.DbkAsp.DbkConnModule.getInstallRoot() +27
Borland.DbkAsp.DbkConnModule.OnBeginRequest(Object sender, EventArgs e)
+191
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87Hi Wayne,
Thanks for your posting!
It seems that the security module internal reports the error message, I
will make research to see whether others meet this issue before. You are
encouraged to see whether Borland guys have solutions to this issue.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Search for 'Security Exception - Article ID : 887787'.
I uninstalled Delphi 2005 and the problem went away immediately.....
I look forward to your solution. (I imagine I just have to give rights to
some borland assembly or something for Rptsvs..)
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:JFbg9w11EHA.1512@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Thanks for your posting!
> It seems that the security module internal reports the error message, I
> will make research to see whether others meet this issue before. You are
> encouraged to see whether Borland guys have solutions to this issue.
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Unfortunately, I found the only workaround available now is uninstall
Delphi 2005.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Michael,
Exactly what did you find. What are we 'working around'? The problem
is what exactly? Isn't this an assembly rights issue, like when you install
that URL monitor DLL (security fix) from microsoft (forgot its name). You
would get these same sort of errors, until you put some magic entries into a
config file...
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Unfortunately, I found the only workaround available now is uninstall
> Delphi 2005.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Yes, you probably have to change the policy files to include some CAS (Code
Access Security) permissions for the Borland assemblies. See the following
information for more detailed information about how to set the Code Access
Security correctly
Code Access Security
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconCodeAccessSecurity.asp
Code Access Security in SQL Server 2000 Reporting Services
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/dngrfCodeAccessSecurityInSQLServer2000ReportingServices.asp
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Reinstall Delphi 2005 and press "No" when asked:
An entry needs to be added to the machine.config file to enable ASP
debugging for Delphi.
Would you like setup to add this entry for you now?
"Wayne Brantley" wrote:
> Michael,
> Exactly what did you find. What are we 'working around'? The problem
> is what exactly? Isn't this an assembly rights issue, like when you install
> that URL monitor DLL (security fix) from microsoft (forgot its name). You
> would get these same sort of errors, until you put some magic entries into a
> config file...
>
> "Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
> news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> > Hi Wayne,
> >
> > Unfortunately, I found the only workaround available now is uninstall
> > Delphi 2005.
> >
> > Thank you for your patience and corporation. If you have any questions or
> > concerns, don't hesitate to let me know. We are always here to be of
> > assistance!
> >
> >
> > Sincerely yours,
> >
> > Michael Cheng
> >
> > Online Partner Support Specialist
> > Partner Support Group
> > Microsoft Global Technical Support Center
> > ---
> > Get Secure! - http://www.microsoft.com/security
> >
> > This posting is provided "as is" with no warranties and confers no rights.
> > Please reply to newsgroups only, many thanks!
> >
>
>
to access the reports/report manager/web service of Reporting Services.
I think it is Borland related - the stack trace shows borland in there
now...How do I fix?
======================================================== Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the
permission of type System.Security.Permissions.EnvironmentPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 failed.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SecurityException: Request for the permission of type
System.Security.Permissions.EnvironmentPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.]
System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet
grantedSet, PermissionSet deniedSet, CodeAccessPermission demand,
PermissionToken permToken) +675
System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames,
Int32 unrestrictedOverride) +0
System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap,
StackCrawlMark& stackMark) +88
System.Security.CodeAccessPermission.Demand() +62
System.Environment.GetEnvironmentVariable(String variable) +53
Borland.DbkAsp.DbkConnModule.getInstallRoot() +27
Borland.DbkAsp.DbkConnModule.OnBeginRequest(Object sender, EventArgs e)
+191
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87Hi Wayne,
Thanks for your posting!
It seems that the security module internal reports the error message, I
will make research to see whether others meet this issue before. You are
encouraged to see whether Borland guys have solutions to this issue.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Search for 'Security Exception - Article ID : 887787'.
I uninstalled Delphi 2005 and the problem went away immediately.....
I look forward to your solution. (I imagine I just have to give rights to
some borland assembly or something for Rptsvs..)
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:JFbg9w11EHA.1512@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Thanks for your posting!
> It seems that the security module internal reports the error message, I
> will make research to see whether others meet this issue before. You are
> encouraged to see whether Borland guys have solutions to this issue.
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Unfortunately, I found the only workaround available now is uninstall
Delphi 2005.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Michael,
Exactly what did you find. What are we 'working around'? The problem
is what exactly? Isn't this an assembly rights issue, like when you install
that URL monitor DLL (security fix) from microsoft (forgot its name). You
would get these same sort of errors, until you put some magic entries into a
config file...
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Unfortunately, I found the only workaround available now is uninstall
> Delphi 2005.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Yes, you probably have to change the policy files to include some CAS (Code
Access Security) permissions for the Borland assemblies. See the following
information for more detailed information about how to set the Code Access
Security correctly
Code Access Security
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconCodeAccessSecurity.asp
Code Access Security in SQL Server 2000 Reporting Services
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/dngrfCodeAccessSecurityInSQLServer2000ReportingServices.asp
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Reinstall Delphi 2005 and press "No" when asked:
An entry needs to be added to the machine.config file to enable ASP
debugging for Delphi.
Would you like setup to add this entry for you now?
"Wayne Brantley" wrote:
> Michael,
> Exactly what did you find. What are we 'working around'? The problem
> is what exactly? Isn't this an assembly rights issue, like when you install
> that URL monitor DLL (security fix) from microsoft (forgot its name). You
> would get these same sort of errors, until you put some magic entries into a
> config file...
>
> "Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
> news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> > Hi Wayne,
> >
> > Unfortunately, I found the only workaround available now is uninstall
> > Delphi 2005.
> >
> > Thank you for your patience and corporation. If you have any questions or
> > concerns, don't hesitate to let me know. We are always here to be of
> > assistance!
> >
> >
> > Sincerely yours,
> >
> > Michael Cheng
> >
> > Online Partner Support Specialist
> > Partner Support Group
> > Microsoft Global Technical Support Center
> > ---
> > Get Secure! - http://www.microsoft.com/security
> >
> > This posting is provided "as is" with no warranties and confers no rights.
> > Please reply to newsgroups only, many thanks!
> >
>
>
Friday, March 23, 2012
Installing a DLL file in crystal reports 9.0
Hi guru.,
I had written a .dll file using VB 6.0 in a system.
Then i copied the dll to an another system which is having crystal reports 9.0.
here i have registered this dll in command prompt by c:\>regsvr32 "FILE".DLL
the message came as dll file successfully registered, then i placed a cop y of the dll file in
c:\programfiles\commonfiles\crystaldesicions\2.0\bin folder.
but i yet i am not able to access the function, even though i have named my dll file with "crufl" prefix.
could u suuggest me what could be the problem be...What is the error you got?
You need to create Package and deploy it in other system using Package and Deployment wizard of VB
I had written a .dll file using VB 6.0 in a system.
Then i copied the dll to an another system which is having crystal reports 9.0.
here i have registered this dll in command prompt by c:\>regsvr32 "FILE".DLL
the message came as dll file successfully registered, then i placed a cop y of the dll file in
c:\programfiles\commonfiles\crystaldesicions\2.0\bin folder.
but i yet i am not able to access the function, even though i have named my dll file with "crufl" prefix.
could u suuggest me what could be the problem be...What is the error you got?
You need to create Package and deploy it in other system using Package and Deployment wizard of VB
Wednesday, March 21, 2012
Installer for an SQL database?
Hi I have a .NET web application that embedd crystal reports and some third
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheild
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
Paul G
Software engineer.
Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
David Gugick
Imceda Software
www.imceda.com
sql
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheild
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
Paul G
Software engineer.
Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
David Gugick
Imceda Software
www.imceda.com
sql
Installer for an SQL database?
Hi I have a .NET web application that embedd crystal reports and some third
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheil
d
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
Paul G
Software engineer.Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
David Gugick
Imceda Software
www.imceda.com
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheil
d
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
Paul G
Software engineer.Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
David Gugick
Imceda Software
www.imceda.com
Installer for an SQL database?
Hi I have a .NET web application that embedd crystal reports and some third
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheild
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
--
Paul G
Software engineer.Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
--
David Gugick
Imceda Software
www.imceda.com
party dlls and this interfaces with a Microsoft SQL 2000 dbase. The dbase
contains several tables with constraints and key relationships as well as
many stored procedures. Just wondering if there is a way to use Installsheild
to automatically install the database on a new server for deployment. I have
used the built in .NET web deploy wizard that creates an MSI file (windows
starter file) that can be run from the server.
Thanks.
--
Paul G
Software engineer.Paul wrote:
> Hi I have a .NET web application that embedd crystal reports and some
> third party dlls and this interfaces with a Microsoft SQL 2000 dbase.
> The dbase contains several tables with constraints and key
> relationships as well as many stored procedures. Just wondering if
> there is a way to use Installsheild to automatically install the
> database on a new server for deployment. I have used the built in
> .NET web deploy wizard that creates an MSI file (windows starter
> file) that can be run from the server.
> Thanks.
Do you need to create the database as well? If so, I would build this
into an application and make sure to provide all the details for
database creation that are available for SQL Server. Or you can give
users the standard specs for the database and have them create it
manually. In either case, if the database is available from your
installer, you can launch your utility to allow connection to the
database and then send all the DDL scripts to the database to create the
objects and possibly data. You could also use OSQL from the command-line
to send SQL statements. They key here is whether you need to create the
database.
--
David Gugick
Imceda Software
www.imceda.com
Monday, March 19, 2012
installation trouble
ok i am working on Win2k pro.
i want to be able to develop reports and then move them to the production
server.
I can't use MSDE, or Std Edition on my machine-- so I finally settled on
Developers' edition of SQL OLTP.
The CD that I have only had a Std Edition of RS; and I couldn't get RS Std
to use SQL Developers' edition for the RS databases.
So I had to download the trial.
And now the http://127.0.0./reportServer site is failing; but it looks like
the http://127.0.0.1/reportManager site is working as expected.. with about
80% of the functionality that I remembered.
I am a local admin.
I guess that I am a lil bit confused.. When I installed; it wanted to make 2
sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
I was just confused; the report manager site-- shouldn't that be called
ReportManager? It defaulted to 'Reports' and i changed it-
People will actually naviagate to the ReportServer site in order to view
reports' Or does everyone-- from me to an end user; have to go to
http://127.0.0.1/ReportManager site now?
-aaronReportServer is the home for Web Service. You should just get a simple page
if you go there.. if your getting an error, details would be appreciated.
/Reports or /ReportManager whatever you called it is the UI for the Web
Service.
thats what your users should use.
<aaron_kempf@.hotmail.com> wrote in message
news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
> ok i am working on Win2k pro.
> i want to be able to develop reports and then move them to the production
> server.
> I can't use MSDE, or Std Edition on my machine-- so I finally settled on
> Developers' edition of SQL OLTP.
> The CD that I have only had a Std Edition of RS; and I couldn't get RS Std
> to use SQL Developers' edition for the RS databases.
> So I had to download the trial.
> And now the http://127.0.0./reportServer site is failing; but it looks
> like
> the http://127.0.0.1/reportManager site is working as expected.. with
> about
> 80% of the functionality that I remembered.
> I am a local admin.
> I guess that I am a lil bit confused.. When I installed; it wanted to make
> 2
> sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
> I was just confused; the report manager site-- shouldn't that be called
> ReportManager? It defaulted to 'Reports' and i changed it-
> People will actually naviagate to the ReportServer site in order to view
> reports' Or does everyone-- from me to an end user; have to go to
> http://127.0.0.1/ReportManager site now?
> -aaron
>
>|||thank you.
I am getting a directory listing when i browse the ReportServer site; do i
need to at least drop that perms?
I'm a local admin
"CJ Taylor" <jjackson@.jackson5.com> wrote in message
news:e7ySAIW3EHA.1400@.TK2MSFTNGP11.phx.gbl...
> ReportServer is the home for Web Service. You should just get a simple
page
> if you go there.. if your getting an error, details would be appreciated.
> /Reports or /ReportManager whatever you called it is the UI for the Web
> Service.
> thats what your users should use.
> <aaron_kempf@.hotmail.com> wrote in message
> news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
> > ok i am working on Win2k pro.
> >
> > i want to be able to develop reports and then move them to the
production
> > server.
> >
> > I can't use MSDE, or Std Edition on my machine-- so I finally settled on
> > Developers' edition of SQL OLTP.
> >
> > The CD that I have only had a Std Edition of RS; and I couldn't get RS
Std
> > to use SQL Developers' edition for the RS databases.
> >
> > So I had to download the trial.
> >
> > And now the http://127.0.0./reportServer site is failing; but it looks
> > like
> > the http://127.0.0.1/reportManager site is working as expected.. with
> > about
> > 80% of the functionality that I remembered.
> >
> > I am a local admin.
> >
> > I guess that I am a lil bit confused.. When I installed; it wanted to
make
> > 2
> > sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
> >
> > I was just confused; the report manager site-- shouldn't that be called
> > ReportManager? It defaulted to 'Reports' and i changed it-
> >
> > People will actually naviagate to the ReportServer site in order to view
> > reports' Or does everyone-- from me to an end user; have to go to
> > http://127.0.0.1/ReportManager site now?
> >
> > -aaron
> >
> >
> >
>|||If you check the URL of an actual report inside ReportManager, you'll see
that it's actually calling a ReportServer URL, so you shouldn't change
permissions on ReportServer. Whatever permissions you set via ReportManager
will be reflected in the ReportServer. ReportManager is simply a friendly
interface to the same thing, with some admin tools on top if it for
administrators.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
<aaron_kempf@.hotmail.com> wrote in message
news:%238D%23zTW3EHA.2572@.tk2msftngp13.phx.gbl...
> thank you.
> I am getting a directory listing when i browse the ReportServer site; do i
> need to at least drop that perms?
> I'm a local admin
>
>
> "CJ Taylor" <jjackson@.jackson5.com> wrote in message
> news:e7ySAIW3EHA.1400@.TK2MSFTNGP11.phx.gbl...
>> ReportServer is the home for Web Service. You should just get a simple
> page
>> if you go there.. if your getting an error, details would be
>> appreciated.
>> /Reports or /ReportManager whatever you called it is the UI for the Web
>> Service.
>> thats what your users should use.
>> <aaron_kempf@.hotmail.com> wrote in message
>> news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > ok i am working on Win2k pro.
>> >
>> > i want to be able to develop reports and then move them to the
> production
>> > server.
>> >
>> > I can't use MSDE, or Std Edition on my machine-- so I finally settled
>> > on
>> > Developers' edition of SQL OLTP.
>> >
>> > The CD that I have only had a Std Edition of RS; and I couldn't get RS
> Std
>> > to use SQL Developers' edition for the RS databases.
>> >
>> > So I had to download the trial.
>> >
>> > And now the http://127.0.0./reportServer site is failing; but it looks
>> > like
>> > the http://127.0.0.1/reportManager site is working as expected.. with
>> > about
>> > 80% of the functionality that I remembered.
>> >
>> > I am a local admin.
>> >
>> > I guess that I am a lil bit confused.. When I installed; it wanted to
> make
>> > 2
>> > sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
>> >
>> > I was just confused; the report manager site-- shouldn't that be called
>> > ReportManager? It defaulted to 'Reports' and i changed it-
>> >
>> > People will actually naviagate to the ReportServer site in order to
>> > view
>> > reports' Or does everyone-- from me to an end user; have to go to
>> > http://127.0.0.1/ReportManager site now?
>> >
>> > -aaron
>> >
>> >
>> >
>>
>
i want to be able to develop reports and then move them to the production
server.
I can't use MSDE, or Std Edition on my machine-- so I finally settled on
Developers' edition of SQL OLTP.
The CD that I have only had a Std Edition of RS; and I couldn't get RS Std
to use SQL Developers' edition for the RS databases.
So I had to download the trial.
And now the http://127.0.0./reportServer site is failing; but it looks like
the http://127.0.0.1/reportManager site is working as expected.. with about
80% of the functionality that I remembered.
I am a local admin.
I guess that I am a lil bit confused.. When I installed; it wanted to make 2
sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
I was just confused; the report manager site-- shouldn't that be called
ReportManager? It defaulted to 'Reports' and i changed it-
People will actually naviagate to the ReportServer site in order to view
reports' Or does everyone-- from me to an end user; have to go to
http://127.0.0.1/ReportManager site now?
-aaronReportServer is the home for Web Service. You should just get a simple page
if you go there.. if your getting an error, details would be appreciated.
/Reports or /ReportManager whatever you called it is the UI for the Web
Service.
thats what your users should use.
<aaron_kempf@.hotmail.com> wrote in message
news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
> ok i am working on Win2k pro.
> i want to be able to develop reports and then move them to the production
> server.
> I can't use MSDE, or Std Edition on my machine-- so I finally settled on
> Developers' edition of SQL OLTP.
> The CD that I have only had a Std Edition of RS; and I couldn't get RS Std
> to use SQL Developers' edition for the RS databases.
> So I had to download the trial.
> And now the http://127.0.0./reportServer site is failing; but it looks
> like
> the http://127.0.0.1/reportManager site is working as expected.. with
> about
> 80% of the functionality that I remembered.
> I am a local admin.
> I guess that I am a lil bit confused.. When I installed; it wanted to make
> 2
> sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
> I was just confused; the report manager site-- shouldn't that be called
> ReportManager? It defaulted to 'Reports' and i changed it-
> People will actually naviagate to the ReportServer site in order to view
> reports' Or does everyone-- from me to an end user; have to go to
> http://127.0.0.1/ReportManager site now?
> -aaron
>
>|||thank you.
I am getting a directory listing when i browse the ReportServer site; do i
need to at least drop that perms?
I'm a local admin
"CJ Taylor" <jjackson@.jackson5.com> wrote in message
news:e7ySAIW3EHA.1400@.TK2MSFTNGP11.phx.gbl...
> ReportServer is the home for Web Service. You should just get a simple
page
> if you go there.. if your getting an error, details would be appreciated.
> /Reports or /ReportManager whatever you called it is the UI for the Web
> Service.
> thats what your users should use.
> <aaron_kempf@.hotmail.com> wrote in message
> news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
> > ok i am working on Win2k pro.
> >
> > i want to be able to develop reports and then move them to the
production
> > server.
> >
> > I can't use MSDE, or Std Edition on my machine-- so I finally settled on
> > Developers' edition of SQL OLTP.
> >
> > The CD that I have only had a Std Edition of RS; and I couldn't get RS
Std
> > to use SQL Developers' edition for the RS databases.
> >
> > So I had to download the trial.
> >
> > And now the http://127.0.0./reportServer site is failing; but it looks
> > like
> > the http://127.0.0.1/reportManager site is working as expected.. with
> > about
> > 80% of the functionality that I remembered.
> >
> > I am a local admin.
> >
> > I guess that I am a lil bit confused.. When I installed; it wanted to
make
> > 2
> > sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
> >
> > I was just confused; the report manager site-- shouldn't that be called
> > ReportManager? It defaulted to 'Reports' and i changed it-
> >
> > People will actually naviagate to the ReportServer site in order to view
> > reports' Or does everyone-- from me to an end user; have to go to
> > http://127.0.0.1/ReportManager site now?
> >
> > -aaron
> >
> >
> >
>|||If you check the URL of an actual report inside ReportManager, you'll see
that it's actually calling a ReportServer URL, so you shouldn't change
permissions on ReportServer. Whatever permissions you set via ReportManager
will be reflected in the ReportServer. ReportManager is simply a friendly
interface to the same thing, with some admin tools on top if it for
administrators.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
<aaron_kempf@.hotmail.com> wrote in message
news:%238D%23zTW3EHA.2572@.tk2msftngp13.phx.gbl...
> thank you.
> I am getting a directory listing when i browse the ReportServer site; do i
> need to at least drop that perms?
> I'm a local admin
>
>
> "CJ Taylor" <jjackson@.jackson5.com> wrote in message
> news:e7ySAIW3EHA.1400@.TK2MSFTNGP11.phx.gbl...
>> ReportServer is the home for Web Service. You should just get a simple
> page
>> if you go there.. if your getting an error, details would be
>> appreciated.
>> /Reports or /ReportManager whatever you called it is the UI for the Web
>> Service.
>> thats what your users should use.
>> <aaron_kempf@.hotmail.com> wrote in message
>> news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > ok i am working on Win2k pro.
>> >
>> > i want to be able to develop reports and then move them to the
> production
>> > server.
>> >
>> > I can't use MSDE, or Std Edition on my machine-- so I finally settled
>> > on
>> > Developers' edition of SQL OLTP.
>> >
>> > The CD that I have only had a Std Edition of RS; and I couldn't get RS
> Std
>> > to use SQL Developers' edition for the RS databases.
>> >
>> > So I had to download the trial.
>> >
>> > And now the http://127.0.0./reportServer site is failing; but it looks
>> > like
>> > the http://127.0.0.1/reportManager site is working as expected.. with
>> > about
>> > 80% of the functionality that I remembered.
>> >
>> > I am a local admin.
>> >
>> > I guess that I am a lil bit confused.. When I installed; it wanted to
> make
>> > 2
>> > sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
>> >
>> > I was just confused; the report manager site-- shouldn't that be called
>> > ReportManager? It defaulted to 'Reports' and i changed it-
>> >
>> > People will actually naviagate to the ReportServer site in order to
>> > view
>> > reports' Or does everyone-- from me to an end user; have to go to
>> > http://127.0.0.1/ReportManager site now?
>> >
>> > -aaron
>> >
>> >
>> >
>>
>
Friday, March 9, 2012
Installation of SQL Server w/ Reporting Services
2 questions
1: When installing SQL Server it asks you that Visual Studio.Net needs to be
installed, but all this server will does is display reports and run
sharepoint services.
Does Visual Studio .Net need to be installed? What if I want to write the
report on a development machine and then distribute the report to SQL Server
reporting services. Not real sure. Just like to avoid having to install
development applications on production machines.
2: In the install process, it asks you if you want to use SSL. Right now the
sharepoint site is going to be for internal use only. No outside users will
have access to it. But, later on, we may have outside users in to the
website. Can I install SQL Server without SSL initially and later on if it is
decided that this would be benifical for our customers to view it, we may
open it up to users. How hard is it to reconfigure SQL Server to use SSL or
would it require a reinstall."Roger" <Roger@.discussions.microsoft.com> wrote in message
news:F0C9C36C-FD38-4758-AB5B-19873C3335BE@.microsoft.com...
>2 questions
Yeah the interface for the installer is pretty crappy.
> 1: When installing SQL Server it asks you that Visual Studio.Net needs to
> be
> installed, but all this server will does is display reports and run
> sharepoint services.
> Does Visual Studio .Net need to be installed?
No. VS.Net only needs to be installed where you are *designing* reports.
> What if I want to write the
> report on a development machine and then distribute the report to SQL
> Server
> reporting services. Not real sure. Just like to avoid having to install
> development applications on production machines.
> 2: In the install process, it asks you if you want to use SSL. Right now
> the
> sharepoint site is going to be for internal use only. No outside users
> will
> have access to it. But, later on, we may have outside users in to the
> website. Can I install SQL Server without SSL initially and later on if it
> is
> decided that this would be benifical for our customers to view it, we may
> open it up to users. How hard is it to reconfigure SQL Server to use SSL
> or
> would it require a reinstall.
Yes, this is all re-configurable later.
1: When installing SQL Server it asks you that Visual Studio.Net needs to be
installed, but all this server will does is display reports and run
sharepoint services.
Does Visual Studio .Net need to be installed? What if I want to write the
report on a development machine and then distribute the report to SQL Server
reporting services. Not real sure. Just like to avoid having to install
development applications on production machines.
2: In the install process, it asks you if you want to use SSL. Right now the
sharepoint site is going to be for internal use only. No outside users will
have access to it. But, later on, we may have outside users in to the
website. Can I install SQL Server without SSL initially and later on if it is
decided that this would be benifical for our customers to view it, we may
open it up to users. How hard is it to reconfigure SQL Server to use SSL or
would it require a reinstall."Roger" <Roger@.discussions.microsoft.com> wrote in message
news:F0C9C36C-FD38-4758-AB5B-19873C3335BE@.microsoft.com...
>2 questions
Yeah the interface for the installer is pretty crappy.
> 1: When installing SQL Server it asks you that Visual Studio.Net needs to
> be
> installed, but all this server will does is display reports and run
> sharepoint services.
> Does Visual Studio .Net need to be installed?
No. VS.Net only needs to be installed where you are *designing* reports.
> What if I want to write the
> report on a development machine and then distribute the report to SQL
> Server
> reporting services. Not real sure. Just like to avoid having to install
> development applications on production machines.
> 2: In the install process, it asks you if you want to use SSL. Right now
> the
> sharepoint site is going to be for internal use only. No outside users
> will
> have access to it. But, later on, we may have outside users in to the
> website. Can I install SQL Server without SSL initially and later on if it
> is
> decided that this would be benifical for our customers to view it, we may
> open it up to users. How hard is it to reconfigure SQL Server to use SSL
> or
> would it require a reinstall.
Yes, this is all re-configurable later.
Friday, February 24, 2012
Installation Issue of reporting services 2005
I have installed the SQL Server 2005 Developer Edition. The installation is
successful except i am unable to deploy reports from microsoft Visual Studio
2005.
It is giving following error
A connection could not be made to report server http://localhost/reportserver.
Additional Information
â'Unable to connect to Remote server (Microsoft.reporting
services.designer)â'.
The configuration of computer is
Dell NoteBook 16000,
Intel® Pentium 9(R) M Processor 1.60 GHz,
512 MB RAM
Operating System: XP with SP2
--
asharmaHi Asharma,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you have installed SQL Server 2005
Reporting Services successfully but you are not able to deploy the reports.
If I have misunderstood your concern, please feel free to point it out.
Would you please help me narrow down this with the questions below?
1. Could you connect SQL Server 2005 Reporting Services via link
http://<machine name>/Reports
http://<machine name>/ReportServer
2. Is it possible for you to upload the rdl file via Report Manager?
(http://<machine name>/Reports)
Also, please make sure your have configured your Windows XP SP2 correctly
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
http://support.microsoft.com/kb/841249/en-us
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
successful except i am unable to deploy reports from microsoft Visual Studio
2005.
It is giving following error
A connection could not be made to report server http://localhost/reportserver.
Additional Information
â'Unable to connect to Remote server (Microsoft.reporting
services.designer)â'.
The configuration of computer is
Dell NoteBook 16000,
Intel® Pentium 9(R) M Processor 1.60 GHz,
512 MB RAM
Operating System: XP with SP2
--
asharmaHi Asharma,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you have installed SQL Server 2005
Reporting Services successfully but you are not able to deploy the reports.
If I have misunderstood your concern, please feel free to point it out.
Would you please help me narrow down this with the questions below?
1. Could you connect SQL Server 2005 Reporting Services via link
http://<machine name>/Reports
http://<machine name>/ReportServer
2. Is it possible for you to upload the rdl file via Report Manager?
(http://<machine name>/Reports)
Also, please make sure your have configured your Windows XP SP2 correctly
How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server
http://support.microsoft.com/kb/841249/en-us
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Installation in Server
Hi,
I have reports which need public access.
I have a web application in 1 server which has public access.Database in 1 Server and the Reporting Services in another server(Database and Reporting Services are behind the firewall).I have links in my webapplication which will create pdf's and excels using reporting services.
Right now inside the network everything works perfectly fine.I access the databse and Reports using IP address(internal) of the servers.
When I try to access the application through the internet I cannot open the reports bcoz the IP addresses provided are internal ones and cannot be used outside firewall.I don't want to open up my database and Reporting services server to the public.
How can I go about it?
Pls help.You have to use Forms Authentication for Reporting Services to able to do
that..
Check this page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
"Sudha" <Sudha@.discussions.microsoft.com> wrote in message
news:BA8A7E9C-33F6-4FE7-B12B-6C4E93BE5E28@.microsoft.com...
> Hi,
> I have reports which need public access.
> I have a web application in 1 server which has public access.Database in 1
Server and the Reporting Services in another server(Database and Reporting
Services are behind the firewall).I have links in my webapplication which
will create pdf's and excels using reporting services.
> Right now inside the network everything works perfectly fine.I access the
databse and Reports using IP address(internal) of the servers.
> When I try to access the application through the internet I cannot open
the reports bcoz the IP addresses provided are internal ones and cannot be
used outside firewall.I don't want to open up my database and Reporting
services server to the public.
> How can I go about it?
> Pls help.
I have reports which need public access.
I have a web application in 1 server which has public access.Database in 1 Server and the Reporting Services in another server(Database and Reporting Services are behind the firewall).I have links in my webapplication which will create pdf's and excels using reporting services.
Right now inside the network everything works perfectly fine.I access the databse and Reports using IP address(internal) of the servers.
When I try to access the application through the internet I cannot open the reports bcoz the IP addresses provided are internal ones and cannot be used outside firewall.I don't want to open up my database and Reporting services server to the public.
How can I go about it?
Pls help.You have to use Forms Authentication for Reporting Services to able to do
that..
Check this page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
"Sudha" <Sudha@.discussions.microsoft.com> wrote in message
news:BA8A7E9C-33F6-4FE7-B12B-6C4E93BE5E28@.microsoft.com...
> Hi,
> I have reports which need public access.
> I have a web application in 1 server which has public access.Database in 1
Server and the Reporting Services in another server(Database and Reporting
Services are behind the firewall).I have links in my webapplication which
will create pdf's and excels using reporting services.
> Right now inside the network everything works perfectly fine.I access the
databse and Reports using IP address(internal) of the servers.
> When I try to access the application through the internet I cannot open
the reports bcoz the IP addresses provided are internal ones and cannot be
used outside firewall.I don't want to open up my database and Reporting
services server to the public.
> How can I go about it?
> Pls help.
Subscribe to:
Posts (Atom)