July 8, 2010 at 2:06 am
Hi All
I have AdventureWorks cube on my laptop and i'm running Windows Vista Enterprise SP2 and SQL Server Dev 2008 SP1 also have admin rights on the machine
I'm trying to deploy my cube and that's the only cube i have on the machine and all the services are running, SQL Browser is running under Local System. When i deploy the cube i get the following error(s)
The project could not be deployed to the 'Fullmachinename\MSSQLSERVER' 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.00
All the configs are okay but i cant seem to get it right, from the SSMS connecting to Analysis Services i get the following error:
No connection could be made because the target machine actively refused it 127.0.0.1:2383 (System)
Any ideas
TX
It's better to fail while trying, rather than fail without trying!!!
July 8, 2010 at 4:05 am
I found the solution to my problem. Changed all the sql service accounts except Full Text to Local System and on the properties of the cube on the deployment ==> server name changed to fullpcname included the domain name, then on the windows firewall exception tab added the port for browser 2382 and AS 2383.
All is working fine:-D
It's better to fail while trying, rather than fail without trying!!!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply