Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coorgun
Starting Member
10 Posts |
 Posted - 2009-10-13 : 09:08:53
|
| hi all,a created a sample ssas project and tried to deploy it to my ms sql server 2005 but i always get the err msg "Unable to connect to myServerName: A connection cannot be made. Ensure that the server is running."i tried it out from the business intelligence development studio and via deployment wizard, but ...server runs since i use it as the data source ...thx, best regards,coorgun |
|
|
coorgun
Starting Member
10 Posts |
Posted - 2009-10-13 : 11:32:38
|
| one more silly question:how do i know whether the analysis services are installed?if go start->programs->ms sql server 2005->analysis services-> there is a "deployment wizard" - does it mean that i have analysis services installed? but on my local machine i only have an express edition installed, so there may not be analysis services installed?...help! |
 |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-14 : 08:27:24
|
| In the designer, right click the project solution name in upper right and select properties. Make sure the TargetServerURL is filled in and correct.John |
|
|
|
coorgun
Starting Member
10 Posts |
Posted - 2009-10-14 : 11:20:52
|
| thank you John, but this was correct from the beginning ...at the moment, i'm trying to install sp2 for ms sql server - may be this will help ... :-) |
|
|
|
learntsql
524 Posts |
Posted - 2010-01-21 : 07:25:34
|
quote:
Originally posted by JCirocco
In the designer, right click the project solution name in upper right and select properties. Make sure the TargetServerURL is filled in and correct.John
Thanks JCirocco,I am working on my client machine and i have to deploy on server.can you please tell me the TargetServerURL format from client machine.For report server project i am using targetserverURL as http://servername/reportserverWhen i try to use same for Analysis project deployment,am unable to deploy.please guide me. |
|
|
|
|
|
|
SSAS: newbee: deploying fails