Thursday, March 22, 2012

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

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

Ahh, that makes sense. Thanks.

-Frank

No comments:

Post a Comment