April 8, 2009 at 10:14 am
We are trying to venture into creating cubes for some statistical analysis. I am currently using Microsoft Visual Studio and SQL Server 2005. MVS is on my local PC, and the database with SQL Server is on another machine and is a test server.
I have created the data sources, created a data source view with the tables, and built the cube. However, when I try to deploy the cube, I get the following error:
The project could not be deployed to the 'CFDB1\CFDB1' 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.
I have tried changing the target server with different database server names and even using the IP address. When I run "select @@servername" and "SELECT SERVERPROPERTY('MachineName')" the result comes back as "CFDB1." I have the database target name different from anything on the server so that it doesn't overwrite any databases currently on the test server. I also believe that the SQL Browser service is running. What else would I need to check or give information on so that I can get this cube deployed? Thanks in advance.
April 8, 2009 at 5:21 pm
Can you post what your Target properties are, found under Project --> Pages. For eample mine shows
Server =
Database = ... this can be anything you need it to be.
I am running SSAS Service account using a domain account on the server. The domain account is also local admin on the machine.
I am not running SQL Server Browser
Can you log into the machine? Can you browse any existing cubes on the SSAS machine?
Post back with your settings and I will see if I can help further.
HTH
Shari
April 9, 2009 at 10:58 am
For the target, I have this:
Server = 'CFDB1\CFDB1'
Database = 'ReportCube'
This is the first cube I am trying to create on this server, and no other cubes exist on this server. I am able to log into the server without any issue as the DBA administrator login.
April 10, 2009 at 5:49 am
Try to deploy using just the Database and not the instance.
So in other words, try this
Server = 'CFDB1
Database = 'ReportCube'
Let me know if this works.
~S
April 21, 2009 at 12:46 pm
When I did what you said and try to deploy, here is what I get:
The project could not be deployed to the 'CFDB1' 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.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy