Submit My Question - Recent Questions - Recent Answer

Deployment Server Properties

I am just starting into using the SQL 2005 tools and was trying to run my first model. I set up the Data sources and Data Source Views and Created a decision tree mining structure.

The properties for the deployment have the server as (local) and the database name that is valid. I am running SQLServer Express on my local PC and have verified that it is up and running.

When I try and do a Build and deploy, I get the following error:

"The project could not be deployed to the '(local)' server because of the following connection problems: A connection cannot be made. Enssure the server is running...."

Any idea what I'm doing wrong? I can deploy if I change the deployment to look at the server the data is on (a remote SQL 2005 server), but I would rather have it on my local machine. Maybe that is not a good idea. If not, please tell me.

Thanks in advance.

-Frank

[960 byte] By [fenneran] at [2008-2-13]

«« WaveIn
»» USB Classes for basic communication

# 1

Your mining model and associated objects need to be deployed to an Analysis Services 2005 instance, not to the relational database server. Since SQL Server 2005 Express does not include Analysis Services, you'll need to deploy to another server that's running Standard Edition or above and has a running instance of Analysis Services.

RamanIyer at 2007-9-9 >

top of Msdn Tech,SQL Server,Data Mining...

# 2

Ahh, that makes sense. Thanks.

-Frank

fenneran at 2007-9-9 >

SQL Server

Data Mining

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech