Showing posts with label web. Show all posts
Showing posts with label web. Show all posts

Friday, March 30, 2012

Installing My Reports

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?
>

Wednesday, March 28, 2012

Installing MS Reporting Services Probs

Hi NG
We have a problem to install the MS Reporting Services 2000 on a Windows
2003 Server Web Edition.
IIS is propertly installed, runing, and its serves many wepages.
During the installation (System prequestites check) of RS comes the
following message:
"IIS either not installed or not configured for a server component
installation"
We have no idea, how we can configure the IIS for server component
installations.
Thx for help.
Greets TomSeems you can only install Reporting Services Developer Edition on Windows
2003 server Web edition:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Or maybe you can try setting it up as a web farm, as your database will have
to be running on a different server anyway:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp
Kaisa M. Lindahl Lervik
"news.microsoft.com" <thomas.scholtke@.rbc-is.ch> wrote in message
news:ukqWIurPGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi NG
> We have a problem to install the MS Reporting Services 2000 on a Windows
> 2003 Server Web Edition.
> IIS is propertly installed, runing, and its serves many wepages.
> During the installation (System prequestites check) of RS comes the
> following message:
> "IIS either not installed or not configured for a server component
> installation"
> We have no idea, how we can configure the IIS for server component
> installations.
> Thx for help.
> Greets Tom
>

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!
> >
>
>

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia


|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia


|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?|||

Hi

Would you kindly guide me with installing the Data Mining Web Controls. In my SQL Server 2005 installation I cannot find a way to install samples. I tried to download all the relevant SQL Server 2005 samples from Codeplex but still the c:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls folder is not created.

|||

Rbonnici,

Just a couple thoughts:

Have you tried installing the samples from your SQL Server 2005 install discs? You may have better luck. Have you tried performing searching on your box for the file? Maybe it didnt install in that location. Also, Have you verified that the installs you downloaded from CodePlex actually installed by looking in Add/Remove programs?

I have never had or heard of the samples not installing.

-Cam

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia


|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?|||

Hi

Would you kindly guide me with installing the Data Mining Web Controls. In my SQL Server 2005 installation I cannot find a way to install samples. I tried to download all the relevant SQL Server 2005 samples from Codeplex but still the c:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls folder is not created.

|||

Rbonnici,

Just a couple thoughts:

Have you tried installing the samples from your SQL Server 2005 install discs? You may have better luck. Have you tried performing searching on your box for the file? Maybe it didnt install in that location. Also, Have you verified that the installs you downloaded from CodePlex actually installed by looking in Add/Remove programs?

I have never had or heard of the samples not installing.

-Cam

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia


|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?sql

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia


|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?|||Dear friends.

The requested files are available at :
http://www.codeplex.com/MSFTASProdSamples/SourceControl/ListDownloadableCommits.aspx

Installing ASP.NET

I have looked all over microsofts website
to install a Virtual Web Server under Windows XP
It appears that it is installed under IIS. I can not
use ASP.NET in Visual Studio .Net to access it and
test programs. 9WinXP Pro)
What am I doing wrong '?You will probably get an answer if you post this in the .net programming
groups
--
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
"DW" <don@.performancefiberglass.com> wrote in message
news:01d701c4939a$3e7777c0$a401280a@.phx.gbl...
> I have looked all over microsofts website
> to install a Virtual Web Server under Windows XP
> It appears that it is installed under IIS. I can not
> use ASP.NET in Visual Studio .Net to access it and
> test programs. 9WinXP Pro)
> What am I doing wrong '?sql

Installing ASP.NET

I have looked all over microsofts website
to install a Virtual Web Server under Windows XP
It appears that it is installed under IIS. I can not
use ASP.NET in Visual Studio .Net to access it and
test programs. 9WinXP Pro)
What am I doing wrong ??
You will probably get an answer if you post this in the .net programming
groups
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
"DW" <don@.performancefiberglass.com> wrote in message
news:01d701c4939a$3e7777c0$a401280a@.phx.gbl...
> I have looked all over microsofts website
> to install a Virtual Web Server under Windows XP
> It appears that it is installed under IIS. I can not
> use ASP.NET in Visual Studio .Net to access it and
> test programs. 9WinXP Pro)
> What am I doing wrong ??

Friday, March 23, 2012

Installing a SQL Server database on a Web Host

I will be installing a SQL Server 2000 database on a Web
Server. How do I secure the database so that only my Web
application can access it? I am concerned that someone
could access it over the internet, make a copy of it, or
corrupt it. The ASP.Net web application uses stored
procedures when talking to it.
ThanksHi Joe,
There are several factors to consider when protecting SQL Server. I think
a very good guide to securing SQL Server is found at this URL:
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/ThreatCounter.asp. This URL references chapter 18 of a document titled
"Improving Web Application Security: Threats And Countermeasures".
This guide covers a lot of ground including account management for users
and services, physical protection of the data files and protection of the
server over the network.
You may want to begin your research with this guide.
Thank you.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.

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

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

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

Installed SQL Server, yet not listening on any port

Hi all,

I'm working on a school project on web and mobile applications, and had decided to use MS SQL Server for my backend database.

However, after I've installed MS SQL Server 2000, I ran a port scan and I couldn't find the server running on any ports (MySQL is running on my port 3306, but I guess it doesn't matter) Can something drop some hints on how to debug the problem?

I'm running on Athlon XP 2000+ w/ Windows XP Professional SP2

Thanks a lot!SQL Server runs on port 1433 by default, I believe. In your SQL Server group on the machine running SQL Server, there is a Client Network Utility. Go into that and ensure that TCP/IP is enabled.|||yes i went to the Enterprise Manager, under my Server Group's properties, went to Network Configuration and enabled both TCP/IP on port 1433 and Named Pipes. It still didn't work though.

Another thing I've noticed is that my server is named "(LOCAL) (Windows NT)." Could this be a hint that it's not listening for external connections?|||No, local is an alias for the machine you are on.

Are you certain that SQL Server is running? In Enterprise Manager, can you see the any databases?|||Yes I could see all the databases from the master database to the NorthWind and tempdb database.

The Distributed Transaction Coordinator, SQL Server and SQL Server Agent are all enabled.

Update: I've checked the Event Log. I think I probably know what's the problem.. Here is the message from the log:

You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with this version of Windows. To reduce your computer's vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or MSDE from http://www.microsoft.com/sql/downloads/default.asp

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I'll go patch up and reply if I had any more problems. Thanks for the help douglas.reilly!|||This is just to say that the problem is resolved after patching the SQL Server to SP3. Sorry for the trouble and thanks!sql

Installed .NET 1.1 Framework and MSDE stopped working

I just upgraded the .NET 1.0 to 1.1 today and now when I launch the Web Data Administrator for MSDE it hangs up as soon as I hit the login button.

I reinstalled MSDE and the Web Data Administrator and that didn't correct the problem.

Help!

Try this:

Cause

This problem occurs if the following registry subkey is missing:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
This issue may also occur if this registry subkey does not have valid registry entries. If this registry subkey is missing, you cannot use the ODBC tool in Control Panel to add or to create a new data source.

Resolution

To resolve this issue, copy the missing registry subkey from a computer that does not experience this problem.

Important When you copy a registry subkey from one computer to a computer that is experiencing this issue, you must verify that the system folder is the same on both computers. For example, the system folder must be C:\Windows on the source computer and on the destination computer. If the system folder is different on these computers, Setup will continue to fail.

If the issue is not resolved after you copy the registry subkey, you can reinstall the MDAC drivers on the affected computer. To do this, follow these steps.

Important To perform this procedure, you must have the Windows XP installation CD. Or, you must have access to the Windows XP source files. 1. Configure Windows to show the hidden files: a. Click Start, and then click My Computer.
b. On the Tools menu, click Folder Options.
c. Click the View tab, and then click to select the check box that is next to Show hidden files and folders in the Advanced settings list.
d. In the Advanced settings list, click to clear the check box that is next to Hide extensions for known file types, and then click OK.

2. Reinstall MDAC.

Note You may not have to perform all the following steps. a. Click Start, click Run, type %windir%\inf, and then click OK.
b. Right-click the Mdac.inf file, and then click Install.
c. If you are running Microsoft Windows XP Service Pack 2 (SP2), insert the Windows XP SP2 CD when you are prompted, and then open the following location:
Drive name:\Windows\ServicePackFiles\i386
If you are running Windows XP, insert the Windows XP CD when you are prompted, and then open the following location:
Drive name:\I386
Note In both paths, Drive name is the name of the CD drive.
d. When the installation is completed, restart the computer.

Buck Woody

Installed .NET 1.1 Framework and MSDE stopped working

I just upgraded the .NET 1.0 to 1.1 today and now when I launch the Web Data Administrator for MSDE it hangs up as soon as I hit the login button.

I reinstalled MSDE and the Web Data Administrator and that didn't correct the problem.

Help!

Try this:

Cause

This problem occurs if the following registry subkey is missing:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
This issue may also occur if this registry subkey does not have valid registry entries. If this registry subkey is missing, you cannot use the ODBC tool in Control Panel to add or to create a new data source.

Resolution

To resolve this issue, copy the missing registry subkey from a computer that does not experience this problem.

Important When you copy a registry subkey from one computer to a computer that is experiencing this issue, you must verify that the system folder is the same on both computers. For example, the system folder must be C:\Windows on the source computer and on the destination computer. If the system folder is different on these computers, Setup will continue to fail.

If the issue is not resolved after you copy the registry subkey, you can reinstall the MDAC drivers on the affected computer. To do this, follow these steps.

Important To perform this procedure, you must have the Windows XP installation CD. Or, you must have access to the Windows XP source files. 1. Configure Windows to show the hidden files: a. Click Start, and then click My Computer.
b. On the Tools menu, click Folder Options.
c. Click the View tab, and then click to select the check box that is next to Show hidden files and folders in the Advanced settings list.
d. In the Advanced settings list, click to clear the check box that is next to Hide extensions for known file types, and then click OK.

2. Reinstall MDAC.

Note You may not have to perform all the following steps. a. Click Start, click Run, type %windir%\inf, and then click OK.
b. Right-click the Mdac.inf file, and then click Install.
c. If you are running Microsoft Windows XP Service Pack 2 (SP2), insert the Windows XP SP2 CD when you are prompted, and then open the following location:
Drive name:\Windows\ServicePackFiles\i386
If you are running Windows XP, insert the Windows XP CD when you are prompted, and then open the following location:
Drive name:\I386
Note In both paths, Drive name is the name of the CD drive.
d. When the installation is completed, restart the computer.

Buck Woody

sql

Monday, March 19, 2012

Installation to Sharepoint server

Hi,
We have a question regarding the installation of RS to a WSS server. We have
used STSADM to exlcude the site, checked the web configs for session state
info present, placed the Report server web site in a separate application
pool from WSS, applied Hotfix 859, and attempted manually activate using
rsactivate.
RS fails to activate and the sites cannot be browsed.
What can we check beyond this?
Thanks
SethWe have had similar difficulties - RS seems to compete with SharePoint
in the default web site. In our situation running an IISRESET had the
effect that whichever application was accessed first (either Report
Manager or SharePoints default web site application) would work, and
the other would throw an error.
In our case, RS had been installed first, so activation was not a
problem. Interestingly, even when Report Manager was 'broken', the
underlying Reporting Services continued to work for reports that had
already been deployed.
Researching provided some updated configuration files from the MSDN web
site (sorry I don't have the link) which got Report Manager to work
(after extracting and reapplying the symmetric key), but left the
sharepoint default web site down.
Luckily we didn't need it at that point, so we never drove to a
resolution. (so I will be tracking this thread!).
I would recommend uninstalling RS, finding the new config files I
mentioned, and starting again.
A copy of 'Hitchhiker's Guide to SQL Server Reporting Services' may be
a good investment - (www.bookpool.com has good pricing, service, and
delivery) I am just starting to work through the book, and feel I got
my money's worth at about page 2...
Putting the two RS applications in the same pool is good - you should
also confirm they are both configured to work with .NET Framework 1.1.
If you have Framework 2.0 on the box, they may have been configured to
work with it instead (and they won't - they also won't work if they are
in an application pool with anything using 2.0 - the other thing will
also break...).
If you can install RS to a place other than the default web site, that
might help (though we have never gone down that road).
Also, if you can get a more recent hotfix, you will overcome some
problems that 859 introduces in the Enterprise Manager (some DDL-type
changes won't work through the GUI, although the equivalent commands
will run in Query Analyzer.)|||Seth,
Did you ever get an answer for this?
Alan
"Seth" <Seth@.discussions.microsoft.com> wrote in message
news:41B01080-6179-4BBE-A343-11F3013836ED@.microsoft.com...
> Hi,
> We have a question regarding the installation of RS to a WSS server. We
> have
> used STSADM to exlcude the site, checked the web configs for session state
> info present, placed the Report server web site in a separate application
> pool from WSS, applied Hotfix 859, and attempted manually activate using
> rsactivate.
> RS fails to activate and the sites cannot be browsed.
> What can we check beyond this?
> Thanks
> Seth

Installation Question

We have a webserver running Frontpage. We have a second server running SQL
Server. I would like to install Reporting Services on the Web Server. Will
there be a problem with this? Will I need to install Visual Studio on the
Webserver first?
ThanksHolly, have you found out anything about this.
If not, consider this a bump.
Thanks,
ViperD
"HollyylloH" wrote:
> We have a webserver running Frontpage. We have a second server running SQL
> Server. I would like to install Reporting Services on the Web Server. Will
> there be a problem with this? Will I need to install Visual Studio on the
> Webserver first?
> Thanks|||I answered her. You do not need frontpage on the web server or VS. VS is
needed for designing reports, it is not needed on the server. Just ignore
the message about VS when installing the server. I do not have VS or
frontpage running on my servers.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ViperD" <ViperD@.discussions.microsoft.com> wrote in message
news:22DE367C-EF2B-43D8-BA03-559A1E810D41@.microsoft.com...
> Holly, have you found out anything about this.
> If not, consider this a bump.
> Thanks,
> ViperD
> "HollyylloH" wrote:
>> We have a webserver running Frontpage. We have a second server running
>> SQL
>> Server. I would like to install Reporting Services on the Web Server.
>> Will
>> there be a problem with this? Will I need to install Visual Studio on the
>> Webserver first?
>> Thanks

Monday, March 12, 2012

installation Problem

:(
Hi folks,
Let me tell you about my problem. My client is in U.S.A. They have a web data base server (SQL SERVER) some where in U.S.A itself. I have to make the application in ASP. So now I'm not getting how to make a installer which will autometically register th DLLs at the server, make the virtual direstory of my application, run the data base script. and restore the backup file? It'll be a great help, if any one of you can help me out in this regard.

Thanking you.You could outsource that to the United States. :) Otherwise, have you looked at www.asp.net for installation package? I think you'll find what you need there.