Can't Get a Hidden Parameter to Work

I am running 2000 with SP1.
Here's what I've tried so far.
I specified no prompt in the designer (put a blank) and deployed the report.
I got the following error: Parameter validation failed. It is not possible
to provide valid values for all parameters.
I then deleted the prompt in the Report Manager and tried again. It did not
work. I then unchecked the Prompt User box, and it still did not work. In
fact, it kept filling in the prompt field with the name of the parameter.
Therefore, I had to leave the Prompt User box checked. However, for both
scenarios, I got the following error: This report requires a default or
user-defined value for the report parameter 'EmployeeId'. To run or subscribe
to this report, you must provide a parameter value.
Here is the query string I used (not using SSL yet; still testing on my own
machine):
http://<computer
name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
The EmployeeId is a string so I was not sure how to denote that. I have
tried this with quotes and without quotes around the EmployeeId value, and
neither works.
The employee id is the third parameter. Does it need to be the first one?
Any help would be greatly appreciated.
LizMy suggestion is to first get it working without being hidden.
Your URL is wrong. Don't use /reports use reportserver like this. It will
pull up the report but it will not if I remember correctly fill in your
parameters for you. /reports is reportmanager, the portal that ships with
RS. reportserver is the actual Reporting Services asp.net application.
http://server/reportserver?/Sales/Northwest/Employee Sales
Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter name
matches your case exactly, it is (unfortunately) case sensitive.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Liz" <Liz@.discussions.microsoft.com> wrote in message
news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
>I am running 2000 with SP1.
> Here's what I've tried so far.
> I specified no prompt in the designer (put a blank) and deployed the
> report.
> I got the following error: Parameter validation failed. It is not possible
> to provide valid values for all parameters.
> I then deleted the prompt in the Report Manager and tried again. It did
> not
> work. I then unchecked the Prompt User box, and it still did not work.
> In
> fact, it kept filling in the prompt field with the name of the parameter.
> Therefore, I had to leave the Prompt User box checked. However, for both
> scenarios, I got the following error: This report requires a default or
> user-defined value for the report parameter 'EmployeeId'. To run or
> subscribe
> to this report, you must provide a parameter value.
> Here is the query string I used (not using SSL yet; still testing on my
> own
> machine):
> http://<computer
> name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
> The EmployeeId is a string so I was not sure how to denote that. I have
> tried this with quotes and without quotes around the EmployeeId value, and
> neither works.
> The employee id is the third parameter. Does it need to be the first
> one?
> Any help would be greatly appreciated.
> Liz
>|||Yippee! That worked!!
Where can I get some more information on hidden parameters? I looked at the
Books Online but there is almost nothing on Reporting Services. I also have
"The Hitchhiker's Guide" which is a great book, but it doesn't have enough on
hidden parameters. I will, however, go and look at it again. I might get
more out of it this time:-)
Thanks so much!
Liz
"Bruce L-C [MVP]" wrote:
> My suggestion is to first get it working without being hidden.
> Your URL is wrong. Don't use /reports use reportserver like this. It will
> pull up the report but it will not if I remember correctly fill in your
> parameters for you. /reports is reportmanager, the portal that ships with
> RS. reportserver is the actual Reporting Services asp.net application.
> http://server/reportserver?/Sales/Northwest/Employee Sales
> Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter name
> matches your case exactly, it is (unfortunately) case sensitive.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Liz" <Liz@.discussions.microsoft.com> wrote in message
> news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
> >I am running 2000 with SP1.
> >
> > Here's what I've tried so far.
> >
> > I specified no prompt in the designer (put a blank) and deployed the
> > report.
> > I got the following error: Parameter validation failed. It is not possible
> > to provide valid values for all parameters.
> >
> > I then deleted the prompt in the Report Manager and tried again. It did
> > not
> > work. I then unchecked the Prompt User box, and it still did not work.
> > In
> > fact, it kept filling in the prompt field with the name of the parameter.
> > Therefore, I had to leave the Prompt User box checked. However, for both
> > scenarios, I got the following error: This report requires a default or
> > user-defined value for the report parameter 'EmployeeId'. To run or
> > subscribe
> > to this report, you must provide a parameter value.
> >
> > Here is the query string I used (not using SSL yet; still testing on my
> > own
> > machine):
> > http://<computer
> > name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
> >
> > The EmployeeId is a string so I was not sure how to denote that. I have
> > tried this with quotes and without quotes around the EmployeeId value, and
> > neither works.
> >
> > The employee id is the third parameter. Does it need to be the first
> > one?
> >
> > Any help would be greatly appreciated.
> >
> > Liz
> >
> >
>
>|||I suggest searching 2005 books on-line on the microsoft site. For things
like url integration absolutely nothing has changed between 2000 and 2005.
How you do hidden parameters I believe has changed. There are some new
features (multi-select parameters, end user sorting) but that does not
affect URL integration. They have lots of good documentation on URL
integration (was not there in the 2000 docs).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Liz" <Liz@.discussions.microsoft.com> wrote in message
news:E328C5E9-1894-4C6F-AB8A-20904F1527D6@.microsoft.com...
> Yippee! That worked!!
> Where can I get some more information on hidden parameters? I looked at
> the
> Books Online but there is almost nothing on Reporting Services. I also
> have
> "The Hitchhiker's Guide" which is a great book, but it doesn't have enough
> on
> hidden parameters. I will, however, go and look at it again. I might get
> more out of it this time:-)
> Thanks so much!
> Liz
> "Bruce L-C [MVP]" wrote:
>> My suggestion is to first get it working without being hidden.
>> Your URL is wrong. Don't use /reports use reportserver like this. It will
>> pull up the report but it will not if I remember correctly fill in your
>> parameters for you. /reports is reportmanager, the portal that ships with
>> RS. reportserver is the actual Reporting Services asp.net application.
>> http://server/reportserver?/Sales/Northwest/Employee Sales
>> Report&rs:Command=Render&EmployeeID=1234Also make sure your parameter
>> name
>> matches your case exactly, it is (unfortunately) case sensitive.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Liz" <Liz@.discussions.microsoft.com> wrote in message
>> news:FB6DFF78-8495-44E0-91C5-E16D81F3BF57@.microsoft.com...
>> >I am running 2000 with SP1.
>> >
>> > Here's what I've tried so far.
>> >
>> > I specified no prompt in the designer (put a blank) and deployed the
>> > report.
>> > I got the following error: Parameter validation failed. It is not
>> > possible
>> > to provide valid values for all parameters.
>> >
>> > I then deleted the prompt in the Report Manager and tried again. It
>> > did
>> > not
>> > work. I then unchecked the Prompt User box, and it still did not work.
>> > In
>> > fact, it kept filling in the prompt field with the name of the
>> > parameter.
>> > Therefore, I had to leave the Prompt User box checked. However, for
>> > both
>> > scenarios, I got the following error: This report requires a default
>> > or
>> > user-defined value for the report parameter 'EmployeeId'. To run or
>> > subscribe
>> > to this report, you must provide a parameter value.
>> >
>> > Here is the query string I used (not using SSL yet; still testing on my
>> > own
>> > machine):
>> > http://<computer
>> > name>/Reports/Pages/Report.aspx?ItemPath=/Emileage/Emileage_Aging_Report_ByEmployee&EmployeeId=0000103518
>> >
>> > The EmployeeId is a string so I was not sure how to denote that. I
>> > have
>> > tried this with quotes and without quotes around the EmployeeId value,
>> > and
>> > neither works.
>> >
>> > The employee id is the third parameter. Does it need to be the first
>> > one?
>> >
>> > Any help would be greatly appreciated.
>> >
>> > Liz
>> >
>> >
>>

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.

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.

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.

Can't create report model on Analysis Database

Hi,
Help!!
I have created and deployed my Analysis Database using SQL Server 2005.
Next, I intend to create a report model based on this database, so that can
perform ad-hoc reporting via Report builder.
But, I can't seem to be able to create report model based on the Analysis
database data source. FYI, I am using BI Development Studio to create report
model.
Also, I have tried to use the Generate Model from report manager
(http://localhost/reports) and SQL Server Management Studio, but the option
seem not available !! I just couldn't find the option.
Please advise.
rgds,
tkCreating a Analysis model is different - here's a link.
http://msdn2.microsoft.com/en-us/library/ms345292.aspx
"tk" wrote:
> Hi,
> Help!!
> I have created and deployed my Analysis Database using SQL Server 2005.
> Next, I intend to create a report model based on this database, so that can
> perform ad-hoc reporting via Report builder.
> But, I can't seem to be able to create report model based on the Analysis
> database data source. FYI, I am using BI Development Studio to create report
> model.
> Also, I have tried to use the Generate Model from report manager
> (http://localhost/reports) and SQL Server Management Studio, but the option
> seem not available !! I just couldn't find the option.
> Please advise.
> rgds,
> tk

Can't connect to SeptCTP x64

I've built and deployed cubes on a x64 server, with x64 SQL2005 SeptCTP.

Works pretty much fine. I can run 32 bit Excel on the server, and browse the cubes no problem.

However, if I fire up 32 bit Excel on my 32 bit client machine, and go through the MultiDimensional data source wizard to connet to the cubes, after I put the server name in, it throws this error:

"The peer prematurely closed the connection"

Then this error:

"An error was encountered in the transport layer"

Like a fool, I went from 32 bit to 64 bit and from JunCTP to SeptCTP at the same time, so I don't know which is to blame.

I'm aware of the classic "re-register msolap90.dll on the client" fix, and I've tried it, and it aint that.

Any ideas?

Some more info on this:

If I open up SeptCTP Management Studio on a 32 bit client machine, connect to the Analysis Server on the 64 bit server, it connects. I can see the database on teh x64 machine, and below that, I can see the Data Source, DSVs, Cubes etc.

BUT

When I right click on cube, and try to browse, it fails with the following error:

Cannot show requested dialog.

ADDITIONAL INFORMATION:

Deserialization failed: The 'EditionID' element in the 'http://schemas.microsoft.com/analysisservices/2003/engine' namespace is unexpected. (Microsoft.AnalysisServices)

Exactly the same error presents whether I try to get the properties of a cub, data source, dsv, whatever.

I do not understand this at all.

|||I got the same error on deploying my project. It works fine on Jun CTP but got the error in Sep CTP and the MSSQL 2005 evaluation copy. Any advise? Thanks in advance!

Can't connect to SeptCTP x64

I've built and deployed cubes on a x64 server, with x64 SQL2005 SeptCTP.

Works pretty much fine. I can run 32 bit Excel on the server, and browse the cubes no problem.

However, if I fire up 32 bit Excel on my 32 bit client machine, and go through the MultiDimensional data source wizard to connet to the cubes, after I put the server name in, it throws this error:

"The peer prematurely closed the connection"

Then this error:

"An error was encountered in the transport layer"

Like a fool, I went from 32 bit to 64 bit and from JunCTP to SeptCTP at the same time, so I don't know which is to blame.

I'm aware of the classic "re-register msolap90.dll on the client" fix, and I've tried it, and it aint that.

Any ideas?

Some more info on this:

If I open up SeptCTP Management Studio on a 32 bit client machine, connect to the Analysis Server on the 64 bit server, it connects. I can see the database on teh x64 machine, and below that, I can see the Data Source, DSVs, Cubes etc.

BUT

When I right click on cube, and try to browse, it fails with the following error:

Cannot show requested dialog.

ADDITIONAL INFORMATION:

Deserialization failed: The 'EditionID' element in the 'http://schemas.microsoft.com/analysisservices/2003/engine' namespace is unexpected. (Microsoft.AnalysisServices)

Exactly the same error presents whether I try to get the properties of a cub, data source, dsv, whatever.

I do not understand this at all.

|||I got the same error on deploying my project. It works fine on Jun CTP but got the error in Sep CTP and the MSSQL 2005 evaluation copy. Any advise? Thanks in advance!

Can't connect to Report Server Model

I've created and successfully deployed a Report Server Model. However, when I try to use it as a data source to write reports against, I can't connect to it. When I create a new shared data source, the option of Report Server Model appears in the Type: dropdown, but there's no way for me to add/edit the connection string. That option is grayed out.

Is this a security issue? I've checked all the permission options in Management Studio and I should have access to everything. I'm not sure what he problem is here.

Any help is appreciated.

BTW, I can create reports using Report Builder (web interface), but not in BIDS.

Anyone?