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 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 a cube project to the Analysis Server using BIDS

I am working through the Microsoft SQL Server 2005 Analysis Services Step by Step book and I can't deploy the first cube project to my Analysis Server from my workstation.

I have a server running Windows 2000 Server SP4 and a laptop running Windows 2000 Pro SP4. On the server I am running SQL Server 2005 SP2 complete installation, including workstation components. On my laptop I am running SQL Server 2005 SP2 workstation components.

I have used the Cube Wizard to create a cube without a Data Source (as described in Chapter 3) and then used the Schema Generation Wizard to create the schema which I then populated with data.

When I go to Deploy the cube using BIDS I see the status bar message Build started... and then Deploy started... and then I get an error that says The connection either timed out or was lost.

If I perform the same actions on the server so that BIDS is running on the server and all connections are to localhost the deploy works and I can then browse the cube.

From my laptop I can see all the AS objects on the server through SSMS, including the AS database I created from the server.

Thinking that there maybe some incompatability between the software on my laptop and the server, I did a clean install of the workstation components to a new machine, created a new project and I still get the same error.

I have followed all the advice from Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios (http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/cisql2005ascs.mspx) but I have not found any solution yet. I also tried increasing the connection and query timeout properties in BIDS (Tools/Options/BI Designers/AS Designers) - that didn't work either.

Really stuck now and any help would be greatly appreciated.

TIA
Caryl Wills
Hi,

U need to test the connectivity. Once u pass this test, u will be able to deploy the cube. On the deployment configuration window, make sure u properly give the name of the Server where u want to deploy. Else create the script file and execute it from the Management Studio..

Hope this will help

--Imran|||Hi Imran,
Thanks for your suggestions. I am trying to test connectivity and now seem to have a problem creating an Analysis Services database from my client computer. In SSMS Object Explorer I have the Analysis Services server. If I right click the 'Databases' node and select 'New Database' and then fill in the dialog with a unique database name and Impersonation set to 'Use the service account' and click OK the progress wheel just goes forever. Restarting the Analysis Services service is required to stop the process.

How do I trace the process and do you have any idea what might be preventing it from working?

Thanks for your help.
Caryl
|||Thanks for your help folks - all problems now solved by shutting down ZoneAlarm on server. For some reason ZoneAlarm will not allow connections to Analysis Services over my LAN even though the firewall is turned OFF for the trusted zone.

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 create new datasource

I installed analysis services this last week and now when I try to add a new
data source in reporting services I get an error that says The OLE DB
provider SQLOLEDB has not been installed or is not valid. Do you wan tto
reset the connect string? It has a cancel and an OK button but no matter
which one you push it does nothing. It was working before I did the install
and when I did the install I just took the defaults and loaded up the latest
service pack. Any suggestions?
Thanks,
MelissaMy guess is that MDAC is messed up. One thing you might try is re-installing
the service pack for SQL Server. Either that or try re-installing the
appropriate version of MDAC.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Melissa" <Melissa@.discussions.microsoft.com> wrote in message
news:70F08879-5220-4681-9E31-852F7D542D4D@.microsoft.com...
> I installed analysis services this last week and now when I try to add a
new
> data source in reporting services I get an error that says The OLE DB
> provider SQLOLEDB has not been installed or is not valid. Do you wan tto
> reset the connect string? It has a cancel and an OK button but no matter
> which one you push it does nothing. It was working before I did the
install
> and when I did the install I just took the defaults and loaded up the
latest
> service pack. Any suggestions?
> Thanks,
> Melissa

Can''t connect to Analysis Services Cube using Excel 2007

Hi, i made a cube using Analysis Services 2005, but when i try to connect to Analysis Services using Excel 2007, i got the following error: (excuse me but i had the spanish version of Microsoft Office 2007, y hope you understand):

"El asistente para conexión de datos no puede obtener una lista de las bases de datos del origen de datos especificado"

i got that error when i put the name of the server and the authentication. Previously i made a report on excel 2007 using other cube with exactly the same configuration of server an credentials, but i erase that cube and made a new one, i only change the structure of the cube, the credentials, even the names, are the same as the old one.

i don't know what happens or what i'm missing out this time.

i had sql server 2005 with sp2 installed.

i'm working on Windows Vista. i applied all the patches to make sql server 2005 and visual studio 2005 work perfect on vista. I GOT ALL THE PATCHES FOR VISTA.

i also started all the services for Sql Server 2005 (Analysis Services, etc etc.)

I hope you can help me.

Thanks.

Guillo.

I found the solution for my problem:

Because of the securities of windows vista, it's necesary to delegate the right permissions to the current user you are working with.

In my case, i delegate the permissions when i installed SQL Server 2005, but it seems that for some unknown reason they were erased. So, i open "Configuración de superficie de SQL Server" (sorry, i'm using sql server 2005 spanish), then i re-delegate the right permissions to my current user in windows, and i made the report on excel 2007 with my cube.

That easy.

Can''t connect to Analysis Services Cube using Excel 2007

Hi, i made a cube using Analysis Services 2005, but when i try to connect to Analysis Services using Excel 2007, i got the following error: (excuse me but i had the spanish version of Microsoft Office 2007, y hope you understand):

"El asistente para conexión de datos no puede obtener una lista de las bases de datos del origen de datos especificado"

i got that error when i put the name of the server and the authentication. Previously i made a report on excel 2007 using other cube with exactly the same configuration of server an credentials, but i erase that cube and made a new one, i only change the structure of the cube, the credentials, even the names, are the same as the old one.

i don't know what happens or what i'm missing out this time.

i had sql server 2005 with sp2 installed.

i'm working on Windows Vista. i applied all the patches to make sql server 2005 and visual studio 2005 work perfect on vista. I GOT ALL THE PATCHES FOR VISTA.

i also started all the services for Sql Server 2005 (Analysis Services, etc etc.)

I hope you can help me.

Thanks.

Guillo.

I found the solution for my problem:

Because of the securities of windows vista, it's necesary to delegate the right permissions to the current user you are working with.

In my case, i delegate the permissions when i installed SQL Server 2005, but it seems that for some unknown reason they were erased. So, i open "Configuración de superficie de SQL Server" (sorry, i'm using sql server 2005 spanish), then i re-delegate the right permissions to my current user in windows, and i made the report on excel 2007 with my cube.

That easy.

Can't connect to / see cube

Need some input please.
I have a development domain, with one server running SQL Server 2000 sp
3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
REporting Services.
I used to be able to connect to my databases in Analysis Services, but
today I updated one of them, and now I can't connect to it. I can log
into the server, and see my Foodmart demo base. But I can't see my new
database.
I restored the database from a cab-file, and it restored OK. I can
prosess 2 out of 4 individual cubes. If I right-click the database and
choose "Process the Database", it fails to process. There seems to be a
problem with the database.
Is this why I can't connect to the database / cubes from other
computers? I can log on using http and the right username and password,
and I get to see Foodmart, but not the database / cubes I want to work
with.
Please advise, or at least give a hint on where I can find more info.
Kaisa
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Two possibilities typically occur:
1) either you have an old version of PTS on your client machine (run
ptslite.exe from the SP3 Analysis Services distribution), or
2) you don't have security rights to the cube, i.e. if you've not included
the everyone role. Foodmart has such a role, and thus you can see it.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kaisa" <kaisaremoveml@.hotmail.com> wrote in message
news:%23QRcNQpuEHA.2804@.TK2MSFTNGP14.phx.gbl...
> Need some input please.
> I have a development domain, with one server running SQL Server 2000 sp
> 3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
> REporting Services.
> I used to be able to connect to my databases in Analysis Services, but
> today I updated one of them, and now I can't connect to it. I can log
> into the server, and see my Foodmart demo base. But I can't see my new
> database.
> I restored the database from a cab-file, and it restored OK. I can
> prosess 2 out of 4 individual cubes. If I right-click the database and
> choose "Process the Database", it fails to process. There seems to be a
> problem with the database.
> Is this why I can't connect to the database / cubes from other
> computers? I can log on using http and the right username and password,
> and I get to see Foodmart, but not the database / cubes I want to work
> with.
> Please advise, or at least give a hint on where I can find more info.
> Kaisa
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message news:<O8F#B6ruEHA
.684@.TK2MSFTNGP10.phx.gbl>...
> Two possibilities typically occur:
> 1) either you have an old version of PTS on your client machine (run
> ptslite.exe from the SP3 Analysis Services distribution), or
> 2) you don't have security rights to the cube, i.e. if you've not included
> the everyone role. Foodmart has such a role, and thus you can see it.
> --
Hey Dave!
Thanks a lot! I added the Everyone role and now I can use my database.
I'm so happy right now!
:D
Kaisa M. Lindahl

Can't connect to / see cube

Need some input please.
I have a development domain, with one server running SQL Server 2000 sp
3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
REporting Services.
I used to be able to connect to my databases in Analysis Services, but
today I updated one of them, and now I can't connect to it. I can log
into the server, and see my Foodmart demo base. But I can't see my new
database.
I restored the database from a cab-file, and it restored OK. I can
prosess 2 out of 4 individual cubes. If I right-click the database and
choose "Process the Database", it fails to process. There seems to be a
problem with the database.
Is this why I can't connect to the database / cubes from other
computers? I can log on using http and the right username and password,
and I get to see Foodmart, but not the database / cubes I want to work
with.
Please advise, or at least give a hint on where I can find more info.
Kaisa
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Two possibilities typically occur:
1) either you have an old version of PTS on your client machine (run
ptslite.exe from the SP3 Analysis Services distribution), or
2) you don't have security rights to the cube, i.e. if you've not included
the everyone role. Foodmart has such a role, and thus you can see it.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kaisa" <kaisaremoveml@.hotmail.com> wrote in message
news:%23QRcNQpuEHA.2804@.TK2MSFTNGP14.phx.gbl...
> Need some input please.
> I have a development domain, with one server running SQL Server 2000 sp
> 3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
> REporting Services.
> I used to be able to connect to my databases in Analysis Services, but
> today I updated one of them, and now I can't connect to it. I can log
> into the server, and see my Foodmart demo base. But I can't see my new
> database.
> I restored the database from a cab-file, and it restored OK. I can
> prosess 2 out of 4 individual cubes. If I right-click the database and
> choose "Process the Database", it fails to process. There seems to be a
> problem with the database.
> Is this why I can't connect to the database / cubes from other
> computers? I can log on using http and the right username and password,
> and I get to see Foodmart, but not the database / cubes I want to work
> with.
> Please advise, or at least give a hint on where I can find more info.
> Kaisa
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message news:<O8F#B6ruEHA.684@.TK2MSFTNGP10.phx.gbl>...
> Two possibilities typically occur:
> 1) either you have an old version of PTS on your client machine (run
> ptslite.exe from the SP3 Analysis Services distribution), or
> 2) you don't have security rights to the cube, i.e. if you've not included
> the everyone role. Foodmart has such a role, and thus you can see it.
> --
Hey Dave!
Thanks a lot! I added the Everyone role and now I can use my database.
I'm so happy right now!
:D
Kaisa M. Lindahl