Installing new performance dashboard for SQL Server 2005 SP2

Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.
Did you run the sql script that came with the download?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegr oups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>
|||
> GUEST wrote:
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not
exist
> or you do not have permission.
I am getting the same error.
What is the fix for this if the server is on sp2?
|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
> exist
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?

Installing new performance dashboard for SQL Server 2005 SP2

Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||
> GUEST wrote:
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not
exist
> or you do not have permission.
I am getting the same error.
What is the fix for this if the server is on sp2?|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
>
> exist
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?sql

Installing new performance dashboard for SQL Server 2005 SP2

Hi All,
I tried to install the new performance dashboards on 2005 sp2 on
windows 2003 and received the following error messages.
Has anyone seen these before? I know it is quite new...
Thanks
Peter
Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'usp_GetPageDetails', because it does not exist
or you do not have permission.Did you run the sql script that came with the download?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||The fact that you get an error about 'object_schema_name' suggests SP2 is
not installed on the instance since this is a new function added by SP2. Try
(re)applying SP2 to the instance to see if that resolves the issue.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"Peter Nolan" <peter@.peternolan.com> wrote in message
news:1177505070.696147.173040@.n35g2000prd.googlegroups.com...
> Hi All,
> I tried to install the new performance dashboards on 2005 sp2 on
> windows 2003 and received the following error messages.
> Has anyone seen these before? I know it is quite new...
> Thanks
> Peter
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
> 'object_schema_name' is not a recognized built-in function name.
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
> Incorrect syntax near the keyword 'as'.
> Msg 15151, Level 16, State 1, Line 1
> Cannot find the object 'usp_GetPageDetails', because it does not exist
> or you do not have permission.
>|||> GUEST wrote
> Hi All
> I tried to install the new performance dashboards on 2005 sp2 o
> windows 2003 and received the following error messages
>
> Has anyone seen these before? I know it is quite new..
>
> Thank
>
> Pete
>
>
> Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 2
> 'object_schema_name' is not a recognized built-in function name
> Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 4
> Incorrect syntax near the keyword 'as'
> Msg 15151, Level 16, State 1, Line
> Cannot find the object 'usp_GetPageDetails', because it does no
exis
> or you do not have permission
I am getting the same error
What is the fix for this if the server is on sp2|||On May 22, 6:54 pm, stacey.do...@.shawinc-dot-com.no-spam.invalid
(sdoran) wrote:
> > GUEST wrote:
> > Hi All,
> > I tried to install the new performance dashboards on 2005 sp2 on
> > windows 2003 and received the following error messages.
> >
> > Has anyone seen these before? I know it is quite new...
> >
> > Thanks
> >
> > Peter
> >
> >
> > Msg 195, Level 15, State 10, Procedureusp_GetPageDetails, Line 27
> > 'object_schema_name' is not a recognized built-in function name.
> > Msg 156, Level 15, State 1, Procedureusp_GetPageDetails, Line 42
> > Incorrect syntax near the keyword 'as'.
> > Msg 15151, Level 16, State 1, Line 1
> > Cannot find the object 'usp_GetPageDetails', because it does not
> exist
> > or you do not have permission.
> I am getting the same error.
> What is the fix for this if the server is on sp2?
Same error here - SQL 2005 SP2 Latest hotfixes, etc. Any fix for
this?

Installing MSDE??

Ok I installed the MSDE and after following the steps the last message box says to go to the control panel and install and configure the components.

I'm not sure what to do once I'm in the control panel.

Thank you.Somewhere along the way did you try to install MSDE but were unsuccessful? What is the exact wording of the message you are receiving?

Terri|||I am also having a problem with the installation of MSDE. About 2/3's the way through the installation the process froze. I cannot uninstall or re-install. The message I am receiving is that the installation was tampered with and needs to be uninstalled and re-installed. When I go to My Computer, Install/Uninstall Software, SQL Server is not listed.

Any suggestions?|||Well, searching the SQL Server and MSDE Forum here for posts from others who have experienced the same thing is a good start. And then starting a new thread with your own particular situation with the exact error messages would be the next step.

Terri|||i have the same probleme.
in my case it was an error of directory\subdirectory

c:\sql2ksp3\MSDE>

don't forget the MSDE subdirectory !! ;)

then type the command : setup SAPWD=xxxx SecurityMode=SQL

i hope it can help you.sql

Installing Microsoft MS SQL Server with Microsoft Framework .NET

Hello,
i need help to following Question :
Can i install a Microsoft MS SQL Server 2k with a
Microsoft .NET Framework on one Server ?
Are there known Performance Problems ?
What are the Main Points i must look for ?
Can i install this in a MS Cluster 2k ?
Thanks for help ....Joern,
Yes they can be installed on the same server - just like you can install Excel
and Word on the same pc and run them concurrently.
But what are you trying to achieve? Do you want to call SQL Server from
VB.NET? Do you want to call .NET framework code/assemblies from inside SQL
Server?
> i need help to following Question :
> Can i install a Microsoft MS SQL Server 2k with a
> Microsoft .NET Framework on one Server ?
> Are there known Performance Problems ?
> What are the Main Points i must look for ?
> Can i install this in a MS Cluster 2k ?
> Thanks for help ....
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

Installing Microsoft Dynamics 10.0 with Microsoft SQL Server 2008 "Katmai"

Hi,

I'm trying to install Microsoft Dynamics 10.0 with SQL 2008 Dev but when launching the utilities this returns the following error message:

******************************************************************

Your current SQL Server is not a supported version.

Req: Microsoft SQL Server 8.0

Act: Microsoft SQL Server code name "Katmai" (CTP) - 10

You need to upgrade to SQL Server 8.0 before continuing.

******************************************************************

Any ideas could help or has this if anyone knows been desinged not to work with GP10 currently?

Assad

Well, not supported.

http://www.microsoft.com/dynamics/gp/using/10systemrequirements.mspx

Database

One of the following:

?

SQL Server 2005 SP2 Standard Edition 32-bit, Workgroup Edition, or Express Edition

?

SQL Server 2000 SP4 Standard Edition or Workgroup Edition

?

MSDE 2000 SP4

In this phase nothing is designed to work with a beta :-)

Jens K. Suessmeyer

http://www.sqlserver2005.de

Installing MDAC 2.5 on W2k sp3

I have tried installing MDAC 2.5 on a w2k sp3 machine and it fails with the following error:

Microsoft Data Access components 2.5 is already installed on the version of windows you are running. Setup cannot update the system. For more information .....

BUT, Mdac 2.5 is not installed on the machine and VB applications using it do not work.

Any ideas?

ThankQ1 Any ideas?

A1 Yes.

1 Check your MDAC component status with the compatibility checking tool. See:

http://www.microsoft.com/data/download.htm#CCinfo

http://download.microsoft.com/download/dasdk/CC/2.7/WIN98MeXP/EN-US/cc.exe

2 See MDAC Installation Notes at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/data_mdacinstall.asp|||Thanks DBA,

This has let me discover that the latest PCs with W2k have sp3 installed by default which includes MDAC 2.6. It is therefore not possible to install MDAC 2.5 - it physically stops you.

It just means I have to change the references to the ADO 2.5 objects to 2.6...|||You are most welcome.

Hopefully 2.6 is otherwise fully compatible with your applications. Newer (and sometimes corrupt or third party) dll issues are not an uncommon source of spurious "already installed" and similar MDAC errors.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?

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 Certificate on SQL Server 2005

Hi -

I'm trying to implement encryption using a 3rd party certificate. I'm following Uncle Bill's documentation on how to install a cert on the server using MMC... I can import the cert into the certificate store just fine. However, when I go to the SQL Server Configuration Manager and bring up the properties window for "Protocols for <Servername>" there are no certs in the dropdown list on the "Certificate" tab.

My certificate is valid... has a good date, etc. What could I be doing wrong? I thought I might have it in the wrong spot in the certificate store, but have moved it all around with no change in result...

Any help would be greatly appreciated!

Chris

Hi, Chris

SQL Server 2005 only displays certificates that are valid for usage with SQL 2005 encryption. So it verifies the following things:

1. Enhanced Key Usage section of cert contains:

Server Authentication (1.3.6.1.5.5.7.3.1)

2. Certificate has private key, and mark private key as exportable when generating it.

3. Certificate is in correct store (should be in Local Computer store under Personal Certificates for SQL running under localsystem or network service). .

4. Your sql service should run under admin account, otherwise it has no permissing to the private key and thus the cert would not show up in the drop down list of SSCM for you to choose the cert.

5. SQL Server 2005 has a new kind cert called self-signed certificate, which means when server can not find a good cert to load in the cert store, it will load such a self-signed cert,check your server errorlog, you could find key word "self-signed". In another word, you always can make encryption connection if you force server encryption, but, if you force client encryption, you will get error"certificate was not trusted" unless you specify trusting server cert through configuration,search more information in Books online.

BTW, you can refer following blog to gain more info about certificate in SQL Server 2005:

http://blogs.msdn.com/sql_protocols/archive/2005/12/30/508311.aspx

HTH

Ming.

Installin sqlserver 2005 error

I get the following error message when I install sqlserver 2005.

TITLE: Microsoft SQL Server 2005 Setup

The installer has encountered an unexpected error. The error code is 2380. Error opening file for write: 5. GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=2380&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroup%40Do_sqlGroup%40x5

BUTTONS:

&Retry
Cancel

Anybody got an idea?

Thanks

Hi ttfo,

Are you remotely installing SQLExpress? If so please see this article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;896613
You cannot connect to Visual Studio SQL Server Express on a remote Windows XP Service Pack 2-based computer

HTH

Jeremy

|||

Jeremy,

Thanks for the reply.

I am not remotely installing.

ttfo

|||does the directory have write permission?|||

ahmedilyas,

Not sure which directory it is trying to update.

Thanks,

Tony

|||

Hi Tony,

Thanks for the update.

TITLE: Microsoft SQL Server 2005 Setup

The installer has encountered an unexpected error. The error code is 2380. Error opening file for write: 5. GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=2380&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroup%40Do_sqlGroup%40x5

1. Regarding the error message when you install sqlserver 2005. Can you confirm the following points, cheers:
a. Operating System? (XP?)

b. OS Service Pack level? (SP2?)

c. What flavour of SQL? (Express?)

c. Is this a second instance of SQL or the default one thats failing? (first based on the registry key error?)

d. Have you logged on as local administrator, cleared the temp directory, copied the files onto to the C:\ and tried to install from harddisk?

2. Should you continue to experience problems with this machine, is it possible to test with another PC or rebuild the problematic one?

I've encountered this issue on one PC, yet I was able to install SQL Express successfully on another PC via RDP at the same site but not on another PC that was producing the error your seeing. To cut a long story short, we got onsite staff to reboot the (WinXP SP2) Pc and it started showing symptoms seen in this KB article:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;826955
"Virus alert about the Blaster worm and its variants"

3. If you can NOT get another PC to rule-out virus, hardware, media &/or etc related issues as the root cause and would like to pursue troubleshooting.. Can you please run FileMon & RegMon traces (and provide the SQL SETUP LOGS) on the PC while your installing SQL?

Based on the error message, the problem stems from "Error opening file for write: 5." and the API for GetLastError reports a Registry key is to blame: "GetLastError: SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup." - hence the FileMon and Regmon traces are needed to aid troubleshooting,

To get a FileMon & RegMon traces

goto www.SysInternals.com (I believe the company and its tools were recently purchased by Microsoft - Mark Russinovich and Bruce Cogwell)

Search for FileMon/Regmon
Scroll to bottom of pages
Download the Programs

0. Remote in as Admin and clear the Temp directory.

1. Save Filemon and Regmon to the PC
2. Get ready to start the SQL Express install
3. Launch open Filemon and Regmon. - To start with I recommend stopping the traces and clearing the logs (with tool bar buttons) because when you launch open the programs they quickly start tracing out Disk and Registry Activity
4. When you get very close to the problem occurring start FileMon/RegMon together - tracing out all the activity in real-time.
5. After you encounter the problem, stop the FileMon/Regmon traces
6. Zip up ALL the traces INCLUDING ALL THE SQL SETUP LOGS YOU CAN FIND - hehe and also RUN THE "mps reports" -sql flavour, on the pc - and post them online!!

Regarding the error messages link: setup.rll 2380 error, try looking in your application event log for the events leading up to the problem and cross reference them with www.EventID.net

HTH

PS the tip to analysing these Regmon/FileMon files is (off the top of my head) > Excel > Data menu > Filter item > Auto Filter item. Then select the combobox with Success, Path not found > and set it to DEVICE DATA ERROR or ACCESS DENIED & hunt down those leads!!

|||

Thanks for the reply, although I am a little late in responding. I ended up formating the disk and starting over. It worked ok then.

Thansk for the help.

|||

Thanks for the update Tony,

Good move reformatting the HDD... as your dont want a production system thats potentially been corrupted.

Cheers,

Jeremy

Installation woes

Hello all,
I am attempting to install RS onto the following machine:
Win2k3 Domain Controller
SQL Standard
I have installed RS successfully, however at the end of the installation it
instructs me that it could not be activated.
I run rsactivate without success...
When I type http://ipaddress/reports I recieve an error Http 404 file not
found...
What have I done wrong?
Cheers
AshThis is the MS docs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
This may help more
http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
A Google search should also render a whole bunch.
"AshVsAOD" <.> wrote in message
news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> Hello all,
> I am attempting to install RS onto the following machine:
> Win2k3 Domain Controller
> SQL Standard
> I have installed RS successfully, however at the end of the installation
it
> instructs me that it could not be activated.
> I run rsactivate without success...
> When I type http://ipaddress/reports I recieve an error Http 404 file not
> found...
> What have I done wrong?
> Cheers
> Ash
>|||I have read and re-read both of these documents, I perhaps should have
specified that in my previous post.
Still it doesn't work.
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> This is the MS docs:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> This may help more
> http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
> A Google search should also render a whole bunch.
> "AshVsAOD" <.> wrote in message
> news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> > Hello all,
> >
> > I am attempting to install RS onto the following machine:
> >
> > Win2k3 Domain Controller
> > SQL Standard
> >
> > I have installed RS successfully, however at the end of the installation
> it
> > instructs me that it could not be activated.
> >
> > I run rsactivate without success...
> >
> > When I type http://ipaddress/reports I recieve an error Http 404 file
not
> > found...
> >
> > What have I done wrong?
> >
> > Cheers
> >
> > Ash
> >
> >
>|||You are right, you should get 401 access denied for a security issue.
Here is what I would have attempted with my knowledge.
1. Check that the virtual directory exists in IIS.
2. The default page on the Reports directory is called Home.aspx, ensure it
is there.
From your example try http://ipaddress/reports/Home.aspx
3. Maybe IIS is blocking aspx pages, so put "aaa.htm" and a "aaa.txt" on the
virtual directory, see if you can get to them.
4. Create a test virtual directory, allow anonymous access, and put some
test pages there, txt, htm, aspx and see if you can get to them. Take the
anonymous access off, see what happens.
"AshVsAOD" <.> wrote in message
news:#iFR2CJZEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I have read and re-read both of these documents, I perhaps should have
> specified that in my previous post.
> Still it doesn't work.
> "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > This is the MS docs:
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> >
> > This may help more
> > http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
> >
> > A Google search should also render a whole bunch.
> >
> > "AshVsAOD" <.> wrote in message
> > news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> > > Hello all,
> > >
> > > I am attempting to install RS onto the following machine:
> > >
> > > Win2k3 Domain Controller
> > > SQL Standard
> > >
> > > I have installed RS successfully, however at the end of the
installation
> > it
> > > instructs me that it could not be activated.
> > >
> > > I run rsactivate without success...
> > >
> > > When I type http://ipaddress/reports I recieve an error Http 404 file
> not
> > > found...
> > >
> > > What have I done wrong?
> > >
> > > Cheers
> > >
> > > Ash
> > >
> > >
> >
> >
>|||Chris,
1. The virtual directory exists
2. The page is there and is accessable
3. Following the "Instructions" you pointed to in your previous post I
shouldn't need to do anything when installing on a brand new Win2k3 Domain
Controller, however I thought along these lines also before coming up empty.
4. I am running other Web applications fine off the server. CRM for one.
The whole reason I posted here was that I had exhausted all avenues. I
appreciate the time you have put into this.
Any other ideas anyone? I am at a loss here, I have installed RS
successfully many times on Win2k, this is my first experience with Win2k3.
I am leaning towards CRM having something to do with it. I will continue
the search for answers.
Ash
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:OQRZG$JZEHA.2544@.TK2MSFTNGP10.phx.gbl...
> You are right, you should get 401 access denied for a security issue.
> Here is what I would have attempted with my knowledge.
> 1. Check that the virtual directory exists in IIS.
> 2. The default page on the Reports directory is called Home.aspx, ensure
it
> is there.
> From your example try http://ipaddress/reports/Home.aspx
> 3. Maybe IIS is blocking aspx pages, so put "aaa.htm" and a "aaa.txt" on
the
> virtual directory, see if you can get to them.
> 4. Create a test virtual directory, allow anonymous access, and put some
> test pages there, txt, htm, aspx and see if you can get to them. Take the
> anonymous access off, see what happens.
> "AshVsAOD" <.> wrote in message
> news:#iFR2CJZEHA.2816@.TK2MSFTNGP11.phx.gbl...
> > I have read and re-read both of these documents, I perhaps should have
> > specified that in my previous post.
> >
> > Still it doesn't work.
> > "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> > news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > > This is the MS docs:
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> > >
> > > This may help more
> > > http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
> > >
> > > A Google search should also render a whole bunch.
> > >
> > > "AshVsAOD" <.> wrote in message
> > > news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> > > > Hello all,
> > > >
> > > > I am attempting to install RS onto the following machine:
> > > >
> > > > Win2k3 Domain Controller
> > > > SQL Standard
> > > >
> > > > I have installed RS successfully, however at the end of the
> installation
> > > it
> > > > instructs me that it could not be activated.
> > > >
> > > > I run rsactivate without success...
> > > >
> > > > When I type http://ipaddress/reports I recieve an error Http 404
file
> > not
> > > > found...
> > > >
> > > > What have I done wrong?
> > > >
> > > > Cheers
> > > >
> > > > Ash
> > > >
> > > >
> > >
> > >
> >
> >
>|||hi,
try this... but i prepared this for installing with share
point server..it may be helpful to u ..
***************
To configure a server running share point portal server,
sql server , analysis services and reporting services
Software Requirements:
1. windows 2003 server enterprise edition.
1.1. Configure application server (enable both front page
extensions and asp.net ) to install IIS.
1.2. Install smtp server
1.3. Configure DNS giving appropriate IP address.
2. SQL Server 2000 Enterprise Edition with Analysis
Services (if reqd) and service packs for both SQL server
and Analysis services.
3. Visual Studio .net Enterprise Architecture
4. Share Point Portal Server
Install share point portal server with out
desktop engine if u r using sql server on the same
machine.
while configuring share point portal server it
will ask to remove front page server extensions at the
time of creating a portal. remove the front page server
extensions and then restart the machine and after that
create a portal site.
5. Reporting services
While installing reporting services it will
check the system and gives a warning message that share
point is also installed in the system and we need to
manually configure reporting services.
leave it and go for the next tab.
Specify a domain/user account where ever asked.
unckeck the ssl certification if u dont have
any and check direct to default
website.
Then continue installing.
After installation
1. go to IIS
right click on reports--> properties--
>configuration -->extensions-->edit
and then uncheck if "Verify that the file exists" is
checked.
and then click OK
close IIS.
2. open E:\Inetpub\wwwroot\webconfig file.
2.1. in <http Modules>
include the third line also.
<add name="Session"
type="System.Web.SessionState.SessionStateModule"/>
and change the below line as follows
pages enableSessionState="true" enableViewState="true"
enableViewStateMac="true" validateRequest="false" />
3. In cmd prompt go to
E:\Program Files\Common Files\Microsoft Shared\web server
extensions\60\BIN
type
stsadm -o addpath -url http://localhost/reportserver -type
exclusion
and
stsadm -o addpath -url http://localhost/reports -type
exclusion
4. in cmd prompt go to
E:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer
type
rsactivate -c "rsreportserver.config"
Then restart the machine
ur configuration is complete now.
********************
>--Original Message--
>Chris,
>1. The virtual directory exists
>2. The page is there and is accessable
>3. Following the "Instructions" you pointed to in your
previous post I
>shouldn't need to do anything when installing on a brand
new Win2k3 Domain
>Controller, however I thought along these lines also
before coming up empty.
>4. I am running other Web applications fine off the
server. CRM for one.
>The whole reason I posted here was that I had exhausted
all avenues. I
>appreciate the time you have put into this.
>Any other ideas anyone? I am at a loss here, I have
installed RS
>successfully many times on Win2k, this is my first
experience with Win2k3.
>I am leaning towards CRM having something to do with it.
I will continue
>the search for answers.
>Ash
>"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote
in message
>news:OQRZG$JZEHA.2544@.TK2MSFTNGP10.phx.gbl...
>> You are right, you should get 401 access denied for a
security issue.
>> Here is what I would have attempted with my knowledge.
>> 1. Check that the virtual directory exists in IIS.
>> 2. The default page on the Reports directory is called
Home.aspx, ensure
>it
>> is there.
>> From your example try
http://ipaddress/reports/Home.aspx
>> 3. Maybe IIS is blocking aspx pages, so put "aaa.htm"
and a "aaa.txt" on
>the
>> virtual directory, see if you can get to them.
>> 4. Create a test virtual directory, allow anonymous
access, and put some
>> test pages there, txt, htm, aspx and see if you can get
to them. Take the
>> anonymous access off, see what happens.
>> "AshVsAOD" <.> wrote in message
>> news:#iFR2CJZEHA.2816@.TK2MSFTNGP11.phx.gbl...
>> > I have read and re-read both of these documents, I
perhaps should have
>> > specified that in my previous post.
>> >
>> > Still it doesn't work.
>> > "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com>
wrote in message
>> > news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
>> > > This is the MS docs:
>> > >
>> >
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/rsinstall/htm/gs_installingrs_v1_8k82.asp
>> > >
>> > > This may help more
>> > >
http://weblogs.asp.net/taganov/archive/2004/03/23/94514.asp
x
>> > >
>> > > A Google search should also render a whole bunch.
>> > >
>> > > "AshVsAOD" <.> wrote in message
>> > > news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
>> > > > Hello all,
>> > > >
>> > > > I am attempting to install RS onto the following
machine:
>> > > >
>> > > > Win2k3 Domain Controller
>> > > > SQL Standard
>> > > >
>> > > > I have installed RS successfully, however at the
end of the
>> installation
>> > > it
>> > > > instructs me that it could not be activated.
>> > > >
>> > > > I run rsactivate without success...
>> > > >
>> > > > When I type http://ipaddress/reports I recieve an
error Http 404
>file
>> > not
>> > > > found...
>> > > >
>> > > > What have I done wrong?
>> > > >
>> > > > Cheers
>> > > >
>> > > > Ash
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>
>.
>

Installation Queries

I am new to SQL Server RS so apologies for these questions.
Can someone please answer the following:
Do I install RS on the same server as SQL Server resides? I am assuming
YES.
Do i need to install anything on my web server which is a separate machine,
or does RS and SQL Server need to be on the webserver?
Do i need to install anything on my Development PC that has visual studio
2003 installed?
Many thanks in advance.
SerghiosDo I install RS on the same server as SQL Server resides?
Not necessarily.
Do i need to install anything on my web server which is a separate machine,
or does RS and SQL Server need to be on the webserver?
SQL Server and IIS can be on different machines.
Do i need to install anything on my Development PC that has visual studio
2003 installed?
The only requirement for installing report designer is VS .NET 2003 (or
later) and MDAC 2.6 or higher.
Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_8jom.asp
for details.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Serghios" <Serghios.Florides@.elthion.com> wrote in message
news:uc9AQtYbEHA.1732@.TK2MSFTNGP09.phx.gbl...
> I am new to SQL Server RS so apologies for these questions.
> Can someone please answer the following:
> Do I install RS on the same server as SQL Server resides? I am assuming
> YES.
> Do i need to install anything on my web server which is a separate
machine,
> or does RS and SQL Server need to be on the webserver?
> Do i need to install anything on my Development PC that has visual studio
> 2003 installed?
> Many thanks in advance.
> Serghios
>
>

installation problem-SQL server 2005 Express Edition

While installing SQL server 2005 Express edition following message is encountered every time I have tried. My system(PC) meets all the pre-requisites.

TITLE: Microsoft SQL Server 2005 Setup

setup.exe - Unable to Locate Component.

"This application has failed to start because XOLEHLP.dll was not found. Re-installing the application may fix this problem"

Failed to load SqlSpars.dll

I had tried to install lot of time. Also I had followed all the steps to manually uninstall the software. And again tried to install it.
Still I am getting same error message.

Am I installing correct installatoin file?

or something else is required to be installed/configured as pre-requisites.

Hi Vikash,

Did you ever get this fixed? I am now having the same problem with katmai.

What OS were you installing on? I am on Windows Server 2003, running on Virtual PC.

Thanks

Jamie

|||

Hi Jamie,

I have got a fix. I had installed another file.

Filename was "SQL Server 2005 Express Edition with Advanced Services SP2" and its size is 256MB.

I was using windows XP SE.

Thanks

vikash

installation problem-SQL server 2005 Express Edition

While installing SQL server 2005 Express edition following message is encountered every time I have tried. My system(PC) meets all the pre-requisites.

TITLE: Microsoft SQL Server 2005 Setup

setup.exe - Unable to Locate Component.

"This application has failed to start because XOLEHLP.dll was not found. Re-installing the application may fix this problem"

Failed to load SqlSpars.dll

I had tried to install lot of time. Also I had followed all the steps to manually uninstall the software. And again tried to install it.
Still I am getting same error message.

Am I installing correct installatoin file?

or something else is required to be installed/configured as pre-requisites.

Hi Vikash,

Did you ever get this fixed? I am now having the same problem with katmai.

What OS were you installing on? I am on Windows Server 2003, running on Virtual PC.

Thanks

Jamie

|||

Hi Jamie,

I have got a fix. I had installed another file.

Filename was "SQL Server 2005 Express Edition with Advanced Services SP2" and its size is 256MB.

I was using windows XP SE.

Thanks

vikash

installation problem-SQL server 2005 Express Edition

While installing SQL server 2005 Express edition following message is encountered every time I have tried. My system(PC) meets all the pre-requisites.

TITLE: Microsoft SQL Server 2005 Setup

setup.exe - Unable to Locate Component.

"This application has failed to start because XOLEHLP.dll was not found. Re-installing the application may fix this problem"

Failed to load SqlSpars.dll

I had tried to install lot of time. Also I had followed all the steps to manually uninstall the software. And again tried to install it.
Still I am getting same error message.

Am I installing correct installatoin file?

or something else is required to be installed/configured as pre-requisites.

Hi Vikash,

Did you ever get this fixed? I am now having the same problem with katmai.

What OS were you installing on? I am on Windows Server 2003, running on Virtual PC.

Thanks

Jamie

|||

Hi Jamie,

I have got a fix. I had installed another file.

Filename was "SQL Server 2005 Express Edition with Advanced Services SP2" and its size is 256MB.

I was using windows XP SE.

Thanks

vikash

Installation problems

I am installing SQL server 2005 in a different location than the default one specified. Half way through the installation I get the following error:

The file %CommonDir%\dte80a.olb could not be loaded. An attempt to repair this condition failed because the file could not be found. Please reinstall the program.

There are also other similar errors regarding files with .olb extensions.

Can anyone explain what can be done in this case?

Thanks,

Hemant

I've heard of people hitting these issues when the libraries get unregistered on the machine somehow. Can you try to manually register it using regsvr32 and kick it off again? That should do the trick.

Thanks,
Sam Lester (MSFT)