Have just installed June CTP on a new laptop build and am having problems getting the AdventureWorks AS database deployed. Using a named instance of SQL Server 2005 (which houses the AdventureWorksDW database) and a named instance of Analysis Services 2005 (which should be getting the deployed database).
After opening the sample solution in BIDS, I changed the data source definition to point to my SQL Server 2005 instance (laptop\sql2005). Tested fine. Then modified the project properties to use the Analysis Services 2005 instance as the deployment location (also laptop\sql2005). Everything looks fine, but when I try to deploy, I get the following three errors:
Error 1: Errors in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'localhost' server.
Error 2: Errors in the OLE DB provider. An error occurred while named instance information was being retrieved from the SQLBrowser service on the 'localhost' server.
Error 3: Either a connection cannot be made to the localhost\SQL2005 server, or Analysis Services is not running on the computer specified.
So, it looks as if the deployment process is somehow trying to connect to "localhost" instead of my machine name and it also seems as if there's a problem with the SQLBrowser service. I've checked and the service is running.
Probably something silly that I'm either forgetting or overlooking. Anyone?
Thanks,
Dave Fackler
Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue.
Dave Fackler
|||Hi,
I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:
"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' 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 0"
There are no data mining objects in my project. I modified already the deployment properties in the project.
Best regards,
Wolfgang
|||I was having the same problem yesterday and found that the Analysis Services service was stopped. No idea on how, but after starting it my connection-related deployment problem went away.|||Dave Fackler wrote:
Just to close the loop, I was able to deploy after removing all of the data mining objects from the project (sorry DM team!) When I get a chance to review it more closely later on, I'll try to figure out what was causing the problem. But for now, a workaround exists in case anyone else runs into a similar issue. Dave Fackler
|||Hi, I have the a similar problem. I can't deploy an AdventureWorks cube in analysis services. I got the following error message:
"Error 1 The project could not be deployed to the 'Computer\SQL_SERVER_2005' 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 0"
There are no data mining objects in my project. I modified already the deployment properties in the project.
Best regards,
Wolfgang
Dave Fackler
Just out of curiosity has anyone resolved this one as I have the same problem with NO MINING.
regards Steve
|||Hi,
I also faced same issue while trying to deploying AdvantureWords Analysis service.
I changed the following setting and after that i am able to deploy successfully.
1) Change the SQL server Browser service running Account to Local System Account
2) Create My Login Account in SQL >Security->Login
3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.
after apply all these steps i am able to deployed analysis services.
thanks
AVNISH KUMAR SHARMA
|||Hi
Thanks a million. I shall try it and let you know. very much appreciated.
regards Steve
|||Hi
You were spot on.. Thanks ever so much for your help. It worked. :)
For others folks...re point 2 in Avnish's note. He is referring to the login id of the machine that hosts SQL Server.
In my case it was Adminstrator.
regards Steve
|||Hi AVNISH
Thanks very much. That solved the problem. Very much appreciated.
regards Steve
|||Still I am facing the same problem.
Create my login account mean ?
|||Hi Stefaan,
Still i am facing the same problem. can you help me out.
i have done the following steps:
=======================
1) Change the SQL server Browser service running Account to Local System Account
2) Create My Login Account in SQL >Security->Login
I have server name : EZ\SQLExpress and i have created login for ramki i.e. EZ\Ramki and pointed to adventurework database too
3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.
Please can you help me out.
Regards
Ramki
|||Ramki
Firstly go to Start, SQL Server 2005/Express and then goto 'configuration tools'
Click on the SQL Server Browser and then right click to bring up the context menu and select PROPERTIES.
Ensure that "Built-in Account" is set to local system.
Then
USE any Login with sysadmin rights for AdventureworksDW or (Create any SQL Server Login using MASTER).
Now if you are working standalone you may have another ID to use such as sa. I prefer NOT to use sa for obvious reasons.
If you choose to create a new Login ID, it too MUST have SYSADMIN rights.
Change databases to AdventureworksDW and now 'attach' i.e. add the login to the database.
I am running under windows 2003 server and therefore utilize windows authentication and have an ID in SQL Server 2005 called 'Administrator' which has been allocated sysadmin rights and has sysadmin rights on database AdventureworksDW.
The important thing is that the ID has sysadmin rights in the database that you are trying to connect to.
In this case AdventureworksDW.
THEN
Within your Visual Studio 2005 environment (where you created your project and where you created a data source to link to the ADVENTUREWORKSDW database),double click on the DataSource (in your Solution Explorer) and select the "Impersonation Tab". Select the "Use the Service Account".
This should be all that you need to do. It worked for me.
I hope that this helps.
Hi All,
I tried all that is mentioned in this thread but still facing the problem.
The error
Error 1 The project could not be deployed to the '172.24.185.73\SQL2K5' 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 0
1. SQL Browser service is running under local system account and tried after restarting as well.
2. New Login created (with Sysadmin) on my database using Administrator win account
3. All the settings done mentioned above under impersonation tab
4. Built in Account is set to Local Account.
Any idea/suggestion would be of great help.
Thank
Atgos
|||
Hi Atgos
When I posted my solution I was working with SQL Server 2005 Standard Edition on Windows 2003 Server.
Are you by any chance using Vista?
This is what I did and did you remember the impersonation?
1) Change the SQL server Browser service fAccount to Local System Account
2) Login: sa is fine as long as it has sysadmin rights.
From within Visual Studio .NET 2005 ensure ....
3) Double click on "AdventureWork.ds" from DataSource (From Solution Explorer).
and in Impersonation Information Select the Use the Service Account.
Please let us know how you fare
No comments:
Post a Comment