Another simple SQL query (MS Access)

Hi. I'm having trouble doing another SQL query. It needs to compare a height against the average height of a group. If it is larger, than it is shown. I can create the sub query but it returns an error when going to the outer query.

Select avg(height)
from Materials
group by MCode

What is an outer query that would compare a single height against that groups average height and display the rows if the single height is greater?oh yeah, another thing. My outer query select can only have 2 columns (material, height)|||select material
, height
from Materials ZZ
where height
> ( select avg(height)
from Materials
where MCode = ZZ.MCode )

another backup question

why are 'transaction log' and 'file and file group' dimmed (not available)
on the general tab of the backup window? (right-click on database, all
tasks, backup database)
I am backing up to a file device and need to set a schedule of 1 daily full
backup and backup of the transaction logs every 1/2 hour.
any help is appreciated.
Because the database is in simple recovery mode.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> why are 'transaction log' and 'file and file group' dimmed (not available)
> on the general tab of the backup window? (right-click on database, all
> tasks, backup database)
> I am backing up to a file device and need to set a schedule of 1 daily full
> backup and backup of the transaction logs every 1/2 hour.
> any help is appreciated.
>
|||Thank you!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uWjcUB%23UEHA.1048@.tk2msftngp13.phx.gbl...
> Because the database is in simple recovery mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
available)[vbcol=seagreen]
full
>

another backup question

why are 'transaction log' and 'file and file group' dimmed (not available)
on the general tab of the backup window? (right-click on database, all
tasks, backup database)
I am backing up to a file device and need to set a schedule of 1 daily full
backup and backup of the transaction logs every 1/2 hour.
any help is appreciated.Because the database is in simple recovery mode.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"djc" <noone@.nowhere.com> wrote in message news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> why are 'transaction log' and 'file and file group' dimmed (not available)
> on the general tab of the backup window? (right-click on database, all
> tasks, backup database)
> I am backing up to a file device and need to set a schedule of 1 daily full
> backup and backup of the transaction logs every 1/2 hour.
> any help is appreciated.
>|||Thank you!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uWjcUB%23UEHA.1048@.tk2msftngp13.phx.gbl...
> Because the database is in simple recovery mode.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "djc" <noone@.nowhere.com> wrote in message
news:ucbsl59UEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > why are 'transaction log' and 'file and file group' dimmed (not
available)
> > on the general tab of the backup window? (right-click on database, all
> > tasks, backup database)
> >
> > I am backing up to a file device and need to set a schedule of 1 daily
full
> > backup and backup of the transaction logs every 1/2 hour.
> >
> > any help is appreciated.
> >
> >
>

Announcing - SQL Server Database Publishing Wizard CTP 1

The SQL Server group at Microsoft has just launched theSQL Server Hosting Toolkit with the release of theDatabase Publishing Wizard Community Technology Preview 1.

The objective of the SQL Server Hosting Toolkit is to enable a great experience around hosted SQL Server. The Database Publishing Wizard works toward this mission by making it easy to upload a database from a development box up to a shared hoster. In its first incarnation, the Database Publishing Wizard is a command line tool that generates a T-SQL script designed to be executed in the script execution windows provided by most hosters in their database management consoles. In the coming months we'll be adding a GUI and building seamless integration between the tool and an upload service we'll provide to hosters for deployment.

Details on the Database Publishing Wizard as well as the download can be found athttp://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard.

We plan to be releasing advances in the Toolkit frequently so check out this first CTP and give us your feedback!

Thanks,

Dan Winn

Senior Program Manager, Microsoft SQL Server

Does the SQL Server Hosting Toolkit work alongside Visual Web Developer ?
Will it transfer ASPNETDB.MDF across to a shared SQL 2005 server - without having to write stacks of code ?
Will new ASP users be able to use it ?

Good to see that Microsoft is responding, otherwise you are going to frustrate a lot of VWD newbies ...

Just seen that DiscountASP.NET have a SQL 2005 Attach MDF Tool ... it seems they have recognised that thousands of new VWD user are having real problems moving databases from local to server.

|||

this is a great little tool, thanks for making it available! I've been looking for a utility to pull an image of a hosted database for some time but had no luck finding it. This tool actually works to pull data of a remote SQL 2000 Server.

Whatever you add in the future, please keep the command line available. That will enable this tool for backup purposes.

For a moment I was confused when I could not open the result file in vim. Apparently the format is unicode or whatever 2 byte character encoding is called. I think it would be useful if there was an option to generate plain-simple 1 byte character text files. If only because the size gets cut in half :)

|||

Thanks for your feedback Nocturnal. We'll definitely be keeping the command line. Interesting idea on the single byte text output. The problem would be potential data loss, but we might be able to detect that and throw an error...

By the way, check out the new CTP we just released athttp://www.codeplex.com/sqlhost

Thanks,
Dan

|||darn! a perfect tool for me... only if the source database supports sql server 2000. I'm pushing it the other way around, 2000 to 2005. :(|||I use it with SQL 2000. Did you try and did it not work?|||

Yeah, it didn't.

My source table is 2000, targe is 2000 as well, publish schema only. Get an error while in Gathering list of objects to script. says need 2005 or later. :( had to use the Red Gate sql compare instead.

|||

Very Very Good efforts by the team.

This tools are very much appreciated and welcomed.

I think backup, restore facilities should be included in future versions they are a must. I think dotnet panel is utilising them very smoothly.This could be a disadvantage for users if their host is providing some panels and this is a common scenerio.

----------------------------------------
A little information required here...

What if i upload a new data from my local SQL2005 to remote SQL2005. I just want my local sql2005 to be along with remote sql2005, i do not want to over write the remote sql2005. Is it possible...?

e.g:- my remote has 10 datas. I want to add 2 datas more from my local sql2005 to remote sql2005 to make it 12 datas on remote.
If i over write it will become 2 on remote, i will looose 10 datas.

I hope i have cleared. Thi facility if not added to day, should be considered for future
--------------------------------------------

I was surprised no one has mentioned the links for great tutorials for this tool by Mr. Scott Guthrie.

Any how its here...

Tutorial 1

and

Tutorial 2

Cheers!

|||thank you!|||I would like to be able to select which tables, views, functions, and stored procedures to move.|||

We are currently using the Team Edition for Database Pros plug in for VS Team Suite, along with Web Deployment Projects and Team Build for Team Foundation Server.

Do you think this new utility has a place in that kind of environment? Currently, the database project generates a SQL deployment script when we do a team build, and we can also use the database project's Schema Compare and Data Compare to sync our live databases.

|||;) Good to hear. Very appreciated. I will have a look at it|||

Same problem tried with Sql 2000 and failed :(

|||

I tried with SQL 2000 but got an errors.

DBMaster

MyBlog

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy need to put a Or with different expressions, like "pruductId< 100 or quantity>10"....
Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.

|||Put '=True' as the value (without the single quotes).|||it only work with the expression:
=IIf((productId >100 or quantity<200), "True"," False")

Many thanks.

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy

need to put a Or with different expressions, like "pruductId< 100 or

quantity>10"....

Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.|||Put '=True' as the value (without the single quotes).|||it only work with the expression:

=IIf((productId >100 or quantity<200),

"True"," False")

Many thanks.

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy

need to put a Or with different expressions, like "pruductId< 100 or

quantity>10"....

Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.|||Put '=True' as the value (without the single quotes).|||it only work with the expression:

=IIf((productId >100 or quantity<200),

"True"," False")

Many thanks.

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy

need to put a Or with different expressions, like "pruductId< 100 or

quantity>10"....

Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.|||Put '=True' as the value (without the single quotes).|||it only work with the expression:

=IIf((productId >100 or quantity<200),

"True"," False")

Many thanks.

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy

need to put a Or with different expressions, like "pruductId< 100 or

quantity>10"....

Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.|||Put '=True' as the value (without the single quotes).|||it only work with the expression:

=IIf((productId >100 or quantity<200),

"True"," False")

Many thanks.

And/or filter field not enabled in the group filter tab

Howdy,

I have a table that has a group. In this group, I want to filter by 2 different expressions, concatenated with an OR. BUT I can't change the "And/Or" column value for the first entry because it is grayed out. The column will automatically change to an OR value if both my expression column fields are the same (which I don’t want) but if I put any other value in to the expression field of the second row, the "And/Or" field of the first row automatically changes to an AND.

PLEASE! How do I get the And/Or field "ungrayed" so I can change it to what I want?

The 2 filters I and using check the UserID = to the user, and the other is checking a count to get the Top N 1. (So just showing the current user and the top producer)

The OR gets only enabled if the filter expressions of two filters are identical.

Note: another option is to use OR directly in your filter expression. Example:
Filter expression: =(condition1 OR condition2)
Filter type: =
Filter value: =True

-- Robert

|||

Ok,

Is there any plans to make it a changeable field? a couple online articles made it sound like you could choose, rather than it auto populating.

|||Check the Product Feedback Center

http://lab.msdn.microsoft.com/productfeedback/|||Nathan,

Please corrobate the issue here:

file:///C:/Documents%20and%20Settings/chauvinr/Desktop/MSDN%20Product%20Feedback%20Center.URL

|||

"The OR gets only enabled if the filter expressions of two filters are identical."

Who's idea was this?

What is the logic behind making this kind of decision?

I just can't comprehend someone deisgning an application like RS and saying... "lets ONLY give them an OR if the fields used in the field expression is identical"

|||I couldnt imaginge it too having only identical field to use OR.|||

But I realy need to put a Or with different expressions, like "pruductId< 100 or quantity>10"....
Isn’t it possible?

|||

Yes, it is possible. Take a look at Robert's reply post on this thread.

Jarret

|||Sorry but I can't understand....

Filter expression: =(pruductId< 100 or quantity>10)
Filter type: =
Filter value: = ?

But what I have to put on value?

I will apreciate your help.
Thanks.

|||Put '=True' as the value (without the single quotes).|||it only work with the expression:
=IIf((productId >100 or quantity<200), "True"," False")

Many thanks.

Analysis Services Calculations

Is it possible to group/ arrange Analysis Services Calculations in cubes into separate Folders? In other words similart to measures which can be grouped in to folders I would want to know if we can group these calculated meassures into folders.

Thanks

In the calculations tab you can see a very small properties button, called calculation properties, that you can click on.

This is in BI-Dev Studio.

HTH

Thomas Ivarsson

|||

Great, thanks..

Now how can I control the security of these calculated members. meaning, I do not want the calculated field to be available to a pariculat role?

I can control it at the Measure level that makes this calculated field. in other words I do not want one of the calculated field not visible to a particular Role Member..

|||

Now how can I control the security of these calculated members. meaning, I do not want the calculated field to be available to a pariculat role?

This is not possible in AS2005.

|||

Thanks Mosha, Is there any other work around with which I can make the caluclated fields available/ visible only to a set of users.

I have a calculated field of $'s which I do not want to be visible to all the memebers. It should be visible only to Managers who are members of Managers Role.

|||You should define it as a real member of the dimension then. Since the fact table won't have keys related to that member - after processing it will be empty - so you are not paying anything in the space. Then inside MDX Script you can overwrite it with any MDX expression you want, just like you do with the calculated members. But now since it is a real member, you can secure it in a role.|||

Another option is to add Cell Data security to the measure. The following article shows details of how to add security to only allow users to use a specific measure.

http://msdn2.microsoft.com/en-us/library/aa933600(SQL.80).aspx

This works for calculated members as well.

In the Cell Data tab of the Role editor, tick 'Enable read permissions', and add a statement referring to the measures the user IS allowed to use. This will then disallow access to any other measures.

e.g.

If we have 3 measures:

MemberCount
SalesCount
MemberPay

And want to diallow access to the MemberPay measure for a specific role, we could use the following statement in the Cell Data page:

Measures.CurrentMember.Name = "MemberCount" or Measures.CurrentMember.Name = "SalesCount"

Analysis Services Admin access to one database only

On a given Analysis Server the machine level OLAP Administrators group controls which users have admin access to AS Databases and Cubes on that machine. From everything I have read, if you are in the OLAP Administrators group you have full access to administer ALL the databases and cubes.

We have a need to create a OLAP database and grant a few users (a role) full admin access to create and maintain datasouces and cubeswithin that database but NOT allow them admin access to the other existing databases and cubes on the server. This seems like such a common requirement. Has anyones else encountered and resolved this issue.

Thanks,

Tony

How about add the users to 'dbo' role in that OLAP database?|||The concept of "dbo role" does not exist for AS databases

Analysis Services 64-bit clustering

In an article in another usenet group, a few months ago, it was
mentioned that MS were developing an updated document for the steps to
cluster the 64-bit
version of Analysis Services.
I'm the tech lead in one of my countries first implementations of
64-bit SQL,
and this has been an issue for us. We've put time into getting the
clustering going, but didn't want to proceed to far down the path
until MS released a supported procedure.
Can anyone tell me if this document has been finalised, and if so when
it will be released?
Cheers,
Reece.
Post a follow
Reece,
A knowledge base article has been written for the clustering Analysis Services 64-bit. Currently it is being reviewed. I don't know when it will become public. I am trying to find out the release date.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Reece,
Guess what? The KB is public today. Here is the link
How to cluster SQL Server 2000 Analysis Services in Windows 2000 and Windows Server 2003
http://support.microsoft.com/?kbid=308023
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Uttam,
Thanks for this, but I've already seen this article. I'm after one
which explains how to do the clustering with 64-bit Analysis Services.
As this uses SQL Server instead of an Access mdb.
I could get this done myself most likely, but it would involve
registry hacking, and I would rather have a step by step outline from
MS first. Especially when this is for a client site and I need to have
MS support if things go wrong. Which I doubt would be the case when I
tell them I hacked the registry to get this clustering working.
Cheers,
Reece.
uttamkp@.online.microsoft.com (Uttam Parui[MS]) wrote in message news:<dUcw#Z0aEHA.2924@.cpmsftngxa06.phx.gbl>...
> Reece,
> Guess what? The KB is public today. Here is the link
> How to cluster SQL Server 2000 Analysis Services in Windows 2000 and Windows Server 2003
> http://support.microsoft.com/?kbid=308023
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
|||I am currently working the responsible parties in Microsoft to have the KB updated for 64 bit.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||here are the steps that worked for me. Use public documnet
http://support.microsoft.com/default...b;en-us;308023
Add the following steps
Replace the 32bit steps for "Install Anlysis Services on Node 1" with:
1) Make sure a virutual instance of SQL server 64bit is already installed
and clustered.
2) run setup.exe
3) click "Start a New Installation", Click "Local Instance" and then "next"
4) Click "next" twice
5) Clear the SQL server check box so that only Analysis services will eb
installed
6) Click "data Files" and change the location to a Clustered drive to be
used by Analysis Services
7) Under Instance Name type in the name of a SQL server instance to be used
by Analysis Services 64 bit. You will have to do the same on Node to so pick
2 slightly different name like ASInstance-A that way on the second one you
will have ASInstance-B
8) Take the defaults for the rest
For the steps "Move the Analsysis Services Query Log Database"
1) log on to the local instance of SQL you created on Node 1
2) move the following DB OLAPQueryLog to the Virutal instance of SQL. Make
sure the Database files are on one of the Clustered drives the virutual
instance SQL can access.
For "install Anlysis Services on Node2"
Follow the steps for "installing Analysis Services on Node 1" above
Move the OlapRepository DB from the local instance on Node 2 to the Virutual
SQL instance. Make sure the DB files reside on a drive the Virtual instance
of SQL can access.
For the section called "modify the registry Keys for the analysis server on
Node 2"
- 64 bit changes for steps 1-4
1) Run the analysis services manager on a 32 bit client. Type in the name
of the local SQL server instance on Node 1 (it does not matter if SQL or
Analysis Services is running)
2) Right-click the server name, click "modify repository Connection String"
3) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit changes for Step 5
1) change the location to the same drive letter where you stored the
OLAPQueryLog and OLAPRepository DB files.
- 64 bit changes for steps 7 and 8
1) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit additional steps (Otherwise your AS data will be stored on the loca
C drive of one of the nodes and will not be avaialable to the cluster.
1) Connect to the registry Key
HKLM\Software\Microsoft\OLAPSERVER\Currentversion
2) Change the values of the following keys to reflect the drive letter where
you stored the OLAPQueryLog and OLAPRepository DB files
RootDir
RootDir:Default
TempDirectory
TempDirectory:Default.
- Repeat all steps for Node 2
"Reece" wrote:

> Uttam,
> Thanks for this, but I've already seen this article. I'm after one
> which explains how to do the clustering with 64-bit Analysis Services.
> As this uses SQL Server instead of an Access mdb.
> I could get this done myself most likely, but it would involve
> registry hacking, and I would rather have a step by step outline from
> MS first. Especially when this is for a client site and I need to have
> MS support if things go wrong. Which I doubt would be the case when I
> tell them I hacked the registry to get this clustering working.
> Cheers,
> Reece.
>
> uttamkp@.online.microsoft.com (Uttam Parui[MS]) wrote in message news:<dUcw#Z0aEHA.2924@.cpmsftngxa06.phx.gbl>...
>
|||here are the steps that worked for me. Use public documnet
http://support.microsoft.com/default...b;en-us;308023
Add the following steps
Replace the 32bit steps for "Install Anlysis Services on Node 1" with:
1) Make sure a virutual instance of SQL server 64bit is already installed
and clustered.
2) run setup.exe
3) click "Start a New Installation", Click "Local Instance" and then "next"
4) Click "next" twice
5) Clear the SQL server check box so that only Analysis services will eb
installed
6) Click "data Files" and change the location to a Clustered drive to be
used by Analysis Services
7) Under Instance Name type in the name of a SQL server instance to be used
by Analysis Services 64 bit. You will have to do the same on Node to so pick
2 slightly different name like ASInstance-A that way on the second one you
will have ASInstance-B
8) Take the defaults for the rest
For the steps "Move the Analsysis Services Query Log Database"
1) log on to the local instance of SQL you created on Node 1
2) move the following DB OLAPQueryLog to the Virutal instance of SQL. Make
sure the Database files are on one of the Clustered drives the virutual
instance SQL can access.
For "install Anlysis Services on Node2"
Follow the steps for "installing Analysis Services on Node 1" above
Move the OlapRepository DB from the local instance on Node 2 to the Virutual
SQL instance. Make sure the DB files reside on a drive the Virtual instance
of SQL can access.
For the section called "modify the registry Keys for the analysis server on
Node 2"
- 64 bit changes for steps 1-4
1) Run the analysis services manager on a 32 bit client. Type in the name
of the local SQL server instance on Node 1 (it does not matter if SQL or
Analysis Services is running)
2) Right-click the server name, click "modify repository Connection String"
3) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit changes for Step 5
1) change the location to the same drive letter where you stored the
OLAPQueryLog and OLAPRepository DB files.
- 64 bit changes for steps 7 and 8
1) change the portion of the string for "Source=" to reflect the name of
your Virtual SQL server
- 64 bit additional steps (Otherwise your AS data will be stored on the loca
C drive of one of the nodes and will not be avaialable to the cluster.
1) Connect to the registry Key
HKLM\Software\Microsoft\OLAPSERVER\Currentversion
2) Change the values of the following keys to reflect the drive letter where
you stored the OLAPQueryLog and OLAPRepository DB files
RootDir
RootDir:Default
TempDirectory
TempDirectory:Default.
- Repeat all steps for Node 2
"Uttam Parui[MS]" wrote:

> I am currently working the responsible parties in Microsoft to have the KB updated for 64 bit.
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>