June 12, 2014 at 8:51 am
Hi
I get an error when I'm trying to deploy my Project. I get this message:
"The Project could not be deployed to 'localhost' server because of the following connection problems: A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in the Solution Explorer. . . "
My server is running, and my .ds it is also fine, Test connection succeeded also. I don't know what seems to be a problem. please help.
June 12, 2014 at 10:25 am
Is your service installed as an instance, or the default instance?
Steve.
June 13, 2014 at 1:41 am
Hi Steve
I don't understand what do you mean by that. Service being installed as an instance or the default instance.
I installed BIDS 2008 R2. anything further than that, I'm not clued up.
June 13, 2014 at 3:01 am
hoseam (6/13/2014)
Hi SteveI don't understand what do you mean by that. Service being installed as an instance or the default instance.
I installed BIDS 2008 R2. anything further than that, I'm not clued up.
What are you trying to deploy? SSIS or SSAS?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 13, 2014 at 3:03 am
SSAS
June 13, 2014 at 3:04 am
hoseam (6/13/2014)
SSAS
OK, did you install SSAS on the computer?
If yes, did you install it under the default instance, or did you use a named instance?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 13, 2014 at 3:09 am
I installed SQL Server 2008R2 it has BI tools, and I started SSAS Project, by that I'm thinking SSAS was installed?? that's what I thought
June 13, 2014 at 3:10 am
hoseam (6/13/2014)
I installed SQL Server 2008R2 it has BI tools, and I started SSAS Project, by that I'm thinking SSAS was installed?? that's what I thought
You need to install the SSAS service itself as well.
You only installed the development tools, not the actual server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 17, 2014 at 1:44 am
Can you provide me with the link to download SSAS, I have googled it and downloaded what I believed to be it, but I still get the same error. I followed this link here: http://www.idevelopment.info/data/SQLServer/DBA_tips/Installation/INSTALL_10.shtml
so can you maybe help me with the link to SSAS Server.
June 17, 2014 at 1:53 am
Those are samples.
You install SSAS with the SQL Server installation media.
Just like you installed SQL Server itself. It's the same set-up, just a different checkbox.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 17, 2014 at 2:07 am
Well in that case, Installation that I have doesn't have SSAS as a Check Box. All I have is
Database Engine Services
- SQL Server Replication
- Full-Text Search
Reporting Services
Shared Features
- BIDS
- Management Tools - Basic
- SQL Client Connection SDK
- Microsoft Sync Framework
This SQL Server 2008 R2
SQL Server 2008 R2 Express with Advanced Services just includes SQL Server Reporting Services (SSRS), not SSAS
June 17, 2014 at 2:23 am
What version of SQL Server do you have? Express?
In attachment is a screenshot of a 2012 installation (which is pretty much the same as for SQL Server 2008R2).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 17, 2014 at 2:24 am
hoseam (6/17/2014)
This SQL Server 2008 R2SQL Server 2008 R2 Express with Advanced Services just includes SQL Server Reporting Services (SSRS), not SSAS
Well, if you cannot install SSAS, it is pretty obvious you cannot deploy it to a server.
Try to get the development edition of SQL Server, it has the same features as Enterprise.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 17, 2014 at 2:28 am
which version is this 2012 installation, maybe I can download it and start working with it.
June 17, 2014 at 2:29 am
Koen Verbeeck (6/17/2014)
What version of SQL Server do you have? Express?In attachment is a screenshot of a 2012 installation (which is pretty much the same as for SQL Server 2008R2).
which version is this 2012 installation, maybe I can download it and start working with it.
Viewing 15 posts - 1 through 15 (of 21 total)
You must be logged in to reply to this topic. Login to reply