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 |
|
jaygup
Starting Member
6 Posts |
 Posted - 2006-04-26 : 14:23:31
|
| Im trying to deploy a cube on a yukon server. Im able to build the cube succesfully, but i cant seem to deploy it. I get the following message :Error 1 The project could not be deployed to the 'XXXXXXX' server because of the following connectivity 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 Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.Im using windows authentication and the connection works fine. Has anyone faced this problem ?. |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-04-26 : 16:05:40
|
| I solved that problem by making the "Sql Server Browser" service run under the same security account as "Sql Server" and the "Sql Server Analysis Server" services.That's how it's set up on my box atm, I ran into the same problem.rockmoose |
 |
|
|
jaygup
Starting Member
6 Posts |
Posted - 2006-05-02 : 15:19:37
|
| Thanks rockmoose,What im doing is that i read the data of a remote DB server (to create the cube), and deploy the cube on another remote DB server, which has the services running under the same security account. I still get an error :Error 1 The project could not be deployed to the 'XXXX\XXXXXX' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0ny leads ?.thanks,JayGup |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-05-02 : 18:12:20
|
| Are the services running under domain accounts or local accounts?rockmoose |
|
|
|
jaygup
Starting Member
6 Posts |
Posted - 2006-05-03 : 10:32:00
|
| They are running under domain accounts. |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-05-04 : 02:20:08
|
Make sure that the account has permissions to access the Sql Server.I think it is a permissions problem for the NT-account the Sql Browser is running under, It can't access the Sql Server / or Analysis Server._____________________________________________It was easier in the old times  (pre2005)rockmoose |
|
|
|
Mike The KID
Starting Member
1 Post |
Posted - 2010-07-26 : 23:36:39
|
| Could you provide more detail about this permission issue. I think that is was is stopping me.I have a server X that is running MSSQL2008 with analysis services. Then on my desktop i want to build a deploy a cube to that server. I am on different domain. |
|
|
|
|
|
|
|
|
error deploying cube