Showing posts with label selecting. Show all posts
Showing posts with label selecting. Show all posts

Monday, March 26, 2012

Mining Structures

I am using the wizard to create a new mining structure and getting the error at the time of selecting the datamining technique like either microsoft decision tree or microsoft timeseries etc.,

"Unable to retrieve a list of supported data mining algorithms. Make sure you are connected to the correct Analysis Services server instance and the Analysis Services server named localhost is running and configured properly. You can continue with a default list of data mining algorithms."

What is that means?

Thanks in advance,

Got it. I need to start the AS from Control Panel/Administrative tools etc etc., before doning this.

I think the default is Manual to start the service.

|||Right-click on the Analysis Service project and select Properties - under Configuration Properties->Deployment, check what you have under Target->Server. The value of the Server property should be the name of the Analysis Services instance that you want the project to connect/deploy to. When you try to select a data mining technique, we try to connect to the Target Server to fetch the list of supported techniques. If you have "localhost" in this property, check Control Panel->Administrative Services->Services to confirm that the "SQL Server Analysis Services" service is running. If you specified a named instance (servername\instancename), check that the corresponding instance (SQL Server Analysis Services (instancename)" as well as the "SQL Server Browser" service is running.sql

Monday, February 20, 2012

Migrating to 2005

Im trying to move from a 2000 server to 2005 server. However when I try to d
o
the import there is no option for selecting UDF's or stored procedures, just
tables and views...is there a way to get these over?..thanks
-JimI would detach the database(s) and then attach it on the 2005 instance, or
use backup/restore unless you have a specific reason for
exporting/importing.
See the Books Online topic "How to: Upgrade a Database Using Detach and
Attach (Transact-SQL) " for more info if you need it.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:693C6609-EA67-4130-8EF8-024FD5318AAC@.microsoft.com...
> Im trying to move from a 2000 server to 2005 server. However when I try to
> do
> the import there is no option for selecting UDF's or stored procedures,
> just
> tables and views...is there a way to get these over?..thanks
> -Jim