August 17, 2009 at 7:51 pm
Hi folks
Being new to SQL server et al, I need some advice/confirmation.
I've installed SQL Server 2008 Express, with Advanced Services.
I have a database (a mart with facts and dimensions) and need to perform some data mining. I'm familiar with all these concepts, so started visual studio to create a plan/solution, a data source (my database), data source views, and finally cubes. On trying to deploy the cubes, which I understand is necessary to browse them, I receive the following message: "The project could not be deployed to the "name" server because of the following connectivity problems: A connection cannot be made to the redirector. Ensure that the SQL Browser service is running.
Everything is local (my laptop). The SQL Browser service IS running. I've tested all connections, can see data in the data sources, data source views, and I can even explore the data in the facts/dimensions of the cubes.
After some digging I discovered that SQL Analysis Service is missing - verified in SQL Server Configuration Manager. An article on the web claims that this is essential to deploy the cubes - is this true? Am I at a dead-end because SSAS is not installed as part of SQL Server Express?
How much of Visual Studio's functionality can I use with SS Express - what are these "advanced services"?
I'm at a bit of a loss, as I don't want to waste time troublshooting only to discover that the root cause is some functionality not available to me.
Thanks in advance,
Wayne
August 17, 2009 at 9:10 pm
Sorry, SSAS is only available with Standard and Enterprise 🙁 Details of features in each edition are here.
The "Advanced Features" in Express Advanced are:
- Basic installation of SQL Server Management Studio, a graphical management tool that makes it easy to manage and administer SQL Server Express databases.
- Reporting Services.
- BI Development Studio. This provides an integrated report creation and design environment to create reports.
- Full-text Search, a powerful search engine for searching text-intensive data.
Full details on express features are here.
Steve.
August 18, 2009 at 6:02 am
Thanks Steve. I guess I'll have to figure out how to do the mining with T-SQL and then look into using the reporting services to produce reports.
Wayne
August 18, 2009 at 6:21 am
One last thing...
I've just noticed that SS 2008 Developer Edition has ALL the functionality. Given that I'm building this for myself, and intend being the only user, this could work. And, it's "almost" free.
Appreciate your thoughts - thx,
Wayne
August 18, 2009 at 7:34 am
Wayne (8/18/2009)
One last thing...I've just noticed that SS 2008 Developer Edition has ALL the functionality. Given that I'm building this for myself, and intend being the only user, this could work. And, it's "almost" free.
Appreciate your thoughts - thx,
Wayne
The developer edition is used by both developers and DBA for all none production work because it comes with a no deployment restriction. So yes you can use the developer edition, note it is almost like the Express edition most features are disabled by default. So some user configuration is needed before use.
Kind regards,
Gift Peddie
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply