can't deploy, SSRS 2K5

Hi kids:
I'm sure this is an easy one, sorry for posting a knob question...
Whenever I attempt to deploy a report, I get prompted for a login. I
don't remember setting SSRS to run as anyting except Local System, and
the configuration tool bears that out. When I click "deploy" on my
(very simple) report, it prompts me for a username & password. If I
click cancel, it declares the deployment a failure and stops. I have
tried entering my domain\user & password, user & password, sa &
password, but all fail.
Suggestions?
Thanks;
DuncanIs RS on your machine or a different one? It doesn't matter what RS uses to
run, it implements security and you have to have the correct rights to
deploy.
First, even without a report deployed you need to be able to see Report
Manager (the portal that ships with RS). Does that work for you?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Duncan A. McRae" <google.com@.mcrae.ca> wrote in message
news:1187288669.801335.68890@.q3g2000prf.googlegroups.com...
> Hi kids:
> I'm sure this is an easy one, sorry for posting a knob question...
> Whenever I attempt to deploy a report, I get prompted for a login. I
> don't remember setting SSRS to run as anyting except Local System, and
> the configuration tool bears that out. When I click "deploy" on my
> (very simple) report, it prompts me for a username & password. If I
> click cancel, it declares the deployment a failure and stops. I have
> tried entering my domain\user & password, user & password, sa &
> password, but all fail.
> Suggestions?
> Thanks;
> Duncan
>

Can't deploy report on the reporting server

Please help -
I am trying to deploy report on the server - getting following:
===================================
A connection could not be made to the report server
http://169.35.137.96/ReportServer/. (Microsoft Report Designer)
===================================
The server committed a protocol violation. Section=ResponseStatusLine
(Microsoft.ReportingServices.Designer)
--
Program Location:
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
Item)
at
Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at
Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String
url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
--
Regadrs,
Andyhello,
Can you connect to RS and Report Manager without any problems in your web
browser using this addresses
http://169.35.137.96/ReportServer/
http://169.35.137.96/Reports/
'
And if so can you deploy any files and create folders in Report Manager?
Regards,
Radoslaw Lebkowski
U¿ytkownik "andys" <asichevoy@.gmail.com.(donotspam)> napisa³ w wiadomo¶ci
news:8A5B8E82-44F9-4FE8-90EB-00F38FB6DB5D@.microsoft.com...
> Please help -
> I am trying to deploy report on the server - getting following:
> ===================================> A connection could not be made to the report server
> http://169.35.137.96/ReportServer/. (Microsoft Report Designer)
> ===================================> The server committed a protocol violation. Section=ResponseStatusLine
> (Microsoft.ReportingServices.Designer)
> --
> Program Location:
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String
> Item)
> at
> Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String
> item)
> at
> Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
> at
> Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String
> url)
> at
> Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()
>
>
> --
> Regadrs,
> Andy

Can't deploy my project

DTS is a sysadmin, serveradmin. It still can't deploy SSAS project, why? the error is "Error 1 Either the 'WCSQL1\DTS' user does not have permission to create a new object in 'WCSQL1', or the object does not exist. 0 0 "

Thanks!

Katie

When you say "sysadmin", "serveradmin" - I think you mean that he has these permissions on SQL Server. You need to grant this user permissions on Analysis Services - go to Management Studio, and then on Server Properties -> Security tab, add WCSQL1\DTS user into server role.

Can''t deploy managed assembly to Katmai

Hi!

When I create a managed assembly database project inside Visual Studio 2005 and want to change the database connection to a Katmai server, I get the following error message:

"This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later."

Is this a bug inside Katmai or Visual Studio 2005?

Thanks

Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

Hi Klaus!

That is a bug/feature/something in the VS deployment project :-). You can either deploy manually or use my deployment project from inside VS.

Niels

Can''t deploy managed assembly to Katmai

Hi!

When I create a managed assembly database project inside Visual Studio 2005 and want to change the database connection to a Katmai server, I get the following error message:

"This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later."

Is this a bug inside Katmai or Visual Studio 2005?

Thanks

Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

Hi Klaus!

It's a VS thing. You can either deploy manually, or use my deployment project from within VS to deploy.

Niels
|||

Hi Klaus,

This is a known issue with Visual Studio 2005 / 2008 beta. This will be fixed in a future release of Visual Studio.

As suggested by Neils, you can build your assembly through Visual Studio and deploy it using CREATE ASSEMBLY/CREATE FUNCTION statements from management studio.

Let me know if you need more information.

Thanks,

-Vineet

Can't deploy from local machine

Can anyone help me. I work in a workgroup environment as opposed to domain
controlled. The minute I do anything with reporting services or analysis
services that is between machines I get problems.
I can't deploy to SSAS or SSRS from my machine unless I log into my machine
with a username and account that is the same as the machine being deployed
to. How do I tell BIDS what credentials to use.
Can anyone give me an overview of how credentials are passed in a non domain
environment.On Sep 25, 2:47 pm, "Fresno Bob" <nos...@.nospam.com> wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
This article is off topic; however, gives a general explanation
similar to your scenario. http://msdn2.microsoft.com/en-us/library/ms252507(VS.80).aspx
It seems that this is more of an OS security level/authentication
issue. As far as I know, you may not be able to control the BIDS
credentials. At a Report Server level, you should be able to change
credentials once the report is deployed in the Report Mgr. You might
try looking in the ReportProjectName.rptproj.user file to see if you
can possibly modify something there. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||SSAS Requires Windows Authentication to work and does not accept SQL
Authentication. If you are in a workgroup the only way to get your scenario
to work is to create identical local accounts on both machines. When I say
identical I mean has the same name and password. Since you are not in a
domain there isn't a way for the remote server to validate your credentials
and will therefore always get a user of "null".
--
SQL Server Developer Support Engineer
"Fresno Bob" wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
>
>

Can''t Deploy Cube SSAS step by step

Hi,

This is extremely frustrating, I really hope someone can give me a hand.

I've just completed all the steps from the book and clicked deploy. I was asked for a password and since it wouldn't accept blank I entered a string.

This apparently was a big mistake as i got the

"Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty."

message. Now I don't know what to do next.

2 questions:

1. How do I change the fake password I entered?

2. What do I need to do to make the process work.

Thanks,

Y.

in visual studio AS, right-click in the datasource and there is options relatite to this subject, like using the service account or a specific user to deploy the cube...

helped? if not, I could give you more specific answer!

Regards!

|||

hanks Pedro,

I managed to change the password using your instructions.

Best,

Yaniv.

Can't Deploy AdventureWorks Database

Hi All,

I created a named instance of SQL SERVER 2005 (Evaluation version) on Windows XP pro, attached the AdventureWorks and AdventureWorks DW databases to the database engine, and tried to deploy the AdventureWorks DW (Enterprise and Standard) database in Analysis Services using SQL SERVER Business Intelligence Development Studio.

For some reason, I encountered the following error (after deployment during processing):

Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [2]. ; 08001. 0 0

Please note that I used the configuration manager to enable named pipes and allow remote connections. I also, renamed the target server (to the named server instance instead of the localhost), disabled my Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Raj

Hi,

We also experienced a similar problem deploying the AdventureWorks DW using the Business Intelligence Development Studio. Our error is as follows:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

This error occurred after we had dropped and uninstalled the sample databases from a previous install. Please note we downloaded the samples from Microsoft and used the AdventureWorks Data Warehouse Database and Analysis Services Project to install the databases.

Brad

|||

We are having the exact same error. Did you all find a solution?

|||

I'm moving this post to the Tools forum since this isn't a setup or upgrade issue.

G'luck.

|||Hi everyone!
I just had the same problem and solved it. What you have to do is:
1) Right-click the project name, and choose properties
2) In the deployment tab change the server name from localhost to your instance name
3) Double-click the data source in solution explorer
4) In General tab click Edit to change the connection string
5) Choose Native OLE DB\Microsoft OLE DB Provider for SQL Server
6) Type in your server name
7) Select the AdventureWorksDW as database name and click OK
Now the deployment should be successfull...|||

Try:

Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

Can't Deploy AdventureWorks Database

Hi,

We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Brad

I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||

To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:

- go to "Impersonation Information" tab

- choose to use "Specific User Name & Password"

- enter an NT user name and password that you know has read rights to the DB

Then try to redeploy and process.

Thanks

Paul Sanders (MSFT)

|||

Great...!

Thanks...! It worked for me too.

|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||

To: Chu Xu

"and right click on "Adventure Works DW.ds""

Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.

Regards

Can't Deploy AdventureWorks Database

Hi,

We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Brad

I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||

To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:

- go to "Impersonation Information" tab

- choose to use "Specific User Name & Password"

- enter an NT user name and password that you know has read rights to the DB

Then try to redeploy and process.

Thanks

Paul Sanders (MSFT)

|||

Great...!

Thanks...! It worked for me too.

|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||

To: Chu Xu

"and right click on "Adventure Works DW.ds""

Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.

Regards

Can't Deploy AdventureWorks Database

Hi,

We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Brad

I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||

To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:

- go to "Impersonation Information" tab

- choose to use "Specific User Name & Password"

- enter an NT user name and password that you know has read rights to the DB

Then try to redeploy and process.

Thanks

Paul Sanders (MSFT)

|||

Great...!

Thanks...! It worked for me too.

|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||

To: Chu Xu

"and right click on "Adventure Works DW.ds""

Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.

Regards

Can't Deploy AdventureWorks Database

Hi,

We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Brad

I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||

To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:

- go to "Impersonation Information" tab

- choose to use "Specific User Name & Password"

- enter an NT user name and password that you know has read rights to the DB

Then try to redeploy and process.

Thanks

Paul Sanders (MSFT)

|||

Great...!

Thanks...! It worked for me too.

|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||

To: Chu Xu

"and right click on "Adventure Works DW.ds""

Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.

Regards

Can't Deploy AdventureWorks Database

Hi,

We attempted to reload the Adventure Works DW in Analysis Services 2005 after a previous install. We first dropped and uninstalled the sample OLTP databases, then removed the previous install using the add/remove programs tool. We then installed the samples again using the AdventureWorks Data Warehouse Database and Analysis Services Project, attached the two databases to the database engine, and then attempted to deploy the Adventure Works. sln project using the Business Intelligence Development Studio. We encountered the following error when we processed the AdventureWorks DW Standard Edition database in Analysis Services:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

Please note that we used the configuration manager to enable named pipes and allow remote connections. We also, renamed the target server (to the named server instance instead of the localhost), disabled any Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Brad

I also ran into this problem (can't deploy lesson4 Analysis Services Tutorial) but I was able to solve it by opening the project in Developement Studio and right click on "Adventure Works DW.ds" under "Data Sources" . Then click "View Designer" and fix the connection string to use my named instance and Windows Authentication.|||

To assist with troubleshooting, could you please try editing the data source in the project, and in the dialog:

- go to "Impersonation Information" tab

- choose to use "Specific User Name & Password"

- enter an NT user name and password that you know has read rights to the DB

Then try to redeploy and process.

Thanks

Paul Sanders (MSFT)

|||

Great...!

Thanks...! It worked for me too.

|||Thanks everyone above. I wasted some 4 crucial hours for figuring this out. Thanks. It worked for me too.|||

To: Chu Xu

"and right click on "Adventure Works DW.ds""

Actually a left click. At least in my version of VS. Took me so much time to figure out something so obvious.

Regards

Can't Deploy AdventureWorks Database

Hi All,

I created a named instance of SQL SERVER 2005 (Evaluation version) on Windows XP pro, attached the AdventureWorks and AdventureWorks DW databases to the database engine, and tried to deploy the AdventureWorks DW (Enterprise and Standard) database in Analysis Services using SQL SERVER Business Intelligence Development Studio.

For some reason, I encountered the following error (after deployment during processing):

Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [2]. ; 08001. 0 0

Please note that I used the configuration manager to enable named pipes and allow remote connections. I also, renamed the target server (to the named server instance instead of the localhost), disabled my Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Raj

Hi,

We also experienced a similar problem deploying the AdventureWorks DW using the Business Intelligence Development Studio. Our error is as follows:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

This error occurred after we had dropped and uninstalled the sample databases from a previous install. Please note we downloaded the samples from Microsoft and used the AdventureWorks Data Warehouse Database and Analysis Services Project to install the databases.

Brad

|||

We are having the exact same error. Did you all find a solution?

|||

I'm moving this post to the Tools forum since this isn't a setup or upgrade issue.

G'luck.

|||Hi everyone!
I just had the same problem and solved it. What you have to do is:
1) Right-click the project name, and choose properties
2) In the deployment tab change the server name from localhost to your instance name
3) Double-click the data source in solution explorer
4) In General tab click Edit to change the connection string
5) Choose Native OLE DB\Microsoft OLE DB Provider for SQL Server
6) Type in your server name
7) Select the AdventureWorksDW as database name and click OK
Now the deployment should be successfull...|||

Try:

Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

Can't Deploy AdventureWorks Database

Hi All,

I created a named instance of SQL SERVER 2005 (Evaluation version) on Windows XP pro, attached the AdventureWorks and AdventureWorks DW databases to the database engine, and tried to deploy the AdventureWorks DW (Enterprise and Standard) database in Analysis Services using SQL SERVER Business Intelligence Development Studio.

For some reason, I encountered the following error (after deployment during processing):

Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [2]. ; 08001. 0 0

Please note that I used the configuration manager to enable named pipes and allow remote connections. I also, renamed the target server (to the named server instance instead of the localhost), disabled my Windows and Norton firewalls, and changed the deployment server edition to the Evaluation version in the Adventure Works DW Property page.

Nothing seems to work. Any help would be greatly appreciated!

Thanks,

Raj

Hi,

We also experienced a similar problem deploying the AdventureWorks DW using the Business Intelligence Development Studio. Our error is as follows:

Error 1 OLE DB error: OLE DB or ODBC error: Communication link failure; 08S01; Shared Memory Provider: The system cannot open the file. ; 08S01; Login failed for user 'NT AUTHORITY\SYSTEM'.; 28000; Cannot open database requested in login 'AdventureWorksDW'. Login fails.; 42000. 0 0

This error occurred after we had dropped and uninstalled the sample databases from a previous install. Please note we downloaded the samples from Microsoft and used the AdventureWorks Data Warehouse Database and Analysis Services Project to install the databases.

Brad

|||

We are having the exact same error. Did you all find a solution?

|||

I'm moving this post to the Tools forum since this isn't a setup or upgrade issue.

G'luck.

|||Hi everyone!
I just had the same problem and solved it. What you have to do is:
1) Right-click the project name, and choose properties
2) In the deployment tab change the server name from localhost to your instance name
3) Double-click the data source in solution explorer
4) In General tab click Edit to change the connection string
5) Choose Native OLE DB\Microsoft OLE DB Provider for SQL Server
6) Type in your server name
7) Select the AdventureWorksDW as database name and click OK
Now the deployment should be successfull...|||

Try:

Double click on AdvantureWork.ds from DataSource (From Solution Explorer). and in Impersonation Information Select the Use the Service Account.

Can''t Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

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

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

|||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.|||

Wolfgang W. wrote:

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

Can''t Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

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

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

|||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.|||

Wolfgang W. wrote:

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

Can''t Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

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

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

|||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.|||

Wolfgang W. wrote:

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

Can't Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

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

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

|||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.|||

Wolfgang W. wrote:

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

Can't Deploy AdventureWorks AS Database using Instances of SQL and AS

Hi all,

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 FacklerJust 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 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

|||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.|||

Wolfgang W. wrote:

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.