Running Totals Across Columns in SSRS Matrix
I have an issue similar to the one described in this thread (http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/7b1ebaef-b1a2-4bd4-9896-47c2b2a6fc9f) but I don't feel the solution posted will work for me.
I am running SQL 2008 R2 and am using Report Builder 3.0 to create a report.
The report should look something like this:
| Q1 | Q2 | |||||
| Jul | Aug | Sep | Oct | Nov | Dec | |
| Item 1 | July $ Total for item 1 | July + Aug Total for item 1 | Jul - Sep Total for item 1 | Jul - Oct Total for item 1 | July - Nov Total for item 1 | July - Dec Total for item 1 |
| Item 2 | July $ Total for item 2 | July + Aug Total for item 2 | Jul - Sep Total for item 2 | Jul - Oct Total for item 2 | July - Nov Total for item 2 | July - Dec Total for item 2 |
| Item 3 | July $ Total for item 3 | July + Aug Total for item 3 | Jul - Sep Total for item 3 | Jul - Oct Total for item 3 | July - Nov Total for item 3 | July - Dec Total for item 3 |
| Item 4 | July $ Total for item 4 | July + Aug Total for item 4 | Jul - Sep Total for item 4 | Jul - Oct Total for item 4 | July - Nov Total for item 4 | July - Dec Total for item 4 |
| Item 5 | July $ Total for item 5 | July + Aug Total for item 5 | Jul - Sep Total for item 5 | Jul - Oct Total for item 5 | July - Nov Total for item 5 | July - Dec Total for item 5 |
The RunningValue() function seems to only work if you specify grouping by Row. Is there a way to provide a running value across columns?
Note: I've omitted a few extra columns. For example, there will be a couple of columns at each quarter grouping where totals will be compared against goals, etc...
Reply:
------------------------------------
Bootmgr image is corrupt on boot
Ji!
I have been trying to install Windows 8 ever since launch of the consumer preview.
I have tried the .exe file which downloads and installs over win7, I have downloaded sountless iso files, which rarely has the right sha1 sum, though I have on iso now which reports the right checksum.
I have tried different usb sticks (3 different) and a couple of DVD-Rs. And when I try to boot from either of them I get this horrible message of bootmgr image is corrupt. I have tried them on another computer and they boot fine, both the dvd and the usb.
If I try to install over win7 I get the bootmgr image is corrupt after installation is done and restarts for the first time. I have also tried to open the sources folder in the iso file and install directly from the setup application which is found in there. Still same result.
Yesterday I made a bootable win7 usb, deleted the three folders setup, sources and upgrade and copied the three equal folders from a win 8 iso. I then managed to boot the usb and it sort of booted both the win7 and win8 installation, first it showed the classic white bar saying windows loading files, then the black screen with the win 8 fish showed and the circle started loading. Then I was met with windows 8 installation program and everything seemed fine, until first reboot and the same bootmgr image is corrupt message greeted me.
I then tried to automatic repair in the windows 8 installation program, but it couldn't help me.
Does anybody have a clue on what I can do?
I have a acer aspire 6930g, with two drives, one hdd and one ssd with win7 on it. Preferrably I would like to install just win8 on the ssd and live without win7, but I can also live with a dualboot solution. I can add that I have tried installing win8 on both the ssd and the hdd, also with either of the disks physically removed, still no luck.
PLEASE HELP ME OUT HERE GUYS!
- Changed type simongis Tuesday, March 6, 2012 12:46 PM
Reply:
------------------------------------
Reply:
You can try Dual-boot Repair.
Download and install the tool in either Windows 7 or Windows 8.
Click on "Automatic Repair". This will put Windows 8 boot files on active partition, first disk. (If Windows 8 can be found on any disk and partition on computer).
Later after rebooting to Windows 8 you can add a boot entry for Windows 7 (if missing) - run Visual BCD Editor, right-click in tree view and select "Create missing Windows loaders".
NOTE:
To check system files consistency for Windows 7 or Windows 8 run on elevated command prompt:
sfc /scannow - this will check and repair system files if errors are found.
------------------------------------
OCS 2007 and Live Meeting Bandwidth Requirements...
Kindly share your expert opinion on LM being a good option for Meetings and all.
Thanks in advance.
Reply:
Anybody out there who would care to suggest something please?
------------------------------------
Reply:
------------------------------------
Reply:
check this, this might help you
http://office.microsoft.com/en-us/communicator-help/office-communications-server-2007-r2-client-system-requirements-HA010355759.aspx
------------------------------------
Need help with SQL query
Hi all,
I've a table like
Declare @table table ( Name varchar(10),
measureid int,
Value decimal(10,2) )
insert into @table
values('a',110,50.00),
('a',150,30.00),
('a',190,20.00),
('b',110,0.00),
('b',150,30.00),
('b',190,20.00)
INSERT INTO @table
SELECT name ,
200 as measureid,
SUM(value)
FROM @table
GROUP BY name
select * from @table
order by Name
Now can any one please let me know the query to get below results
Name measureid Value
a 110 50.00
a 150 30.00
a 190 20.00
a 200 100.00
a 210 1.00
b 110 0.00
b 150 30.00
b 190 20.00
b 200 50.00
b 210 -1.00
The objective is if any employee is missing scores for either measure id 110 or 150 (value <=0) then value for measure id (210) should be -1 (Rating ).
Igonre value for Measure id (190) because it is always 20.
Thanks,
Jyo
Reply:
Hi, you can do something like this:
select Name, measureid, Value from @table union all select Name, 210 as measureid, case when count(*) < 4 then -1 else 1 end as Value from @table where Value > 0 group by Name order by 1, 2
David.
------------------------------------
Mail Auto erases Exchange server - argh
I am in the process of migrating away from Scalix to a new Exchange 2010 server. I was hoping to setup both system in outlook 2007 and get the users to move over the emails they would like to keep. I decided to test this on a user first to see what the process would be like, wow i have lots of issues...
1. Scalix connector does not allow OST files (offline files) to be created older than 2002 format (exchange offline mode)
successfully imports up to 1.5 GB then errors out because of the type of OST file and unicode cannot exceed 2 GB...sweet.
2 With Online mode i drag and drop the mail from a PST file and it copies to the server - then exchange Server starts to remove them ??? At first i thought this was a quota issue as i eventually would receive an error about message store reached maximum size...corrected that problem. tried to import again...imports, no errors and then sure enough it just starts removing emails from the server...they are imported as new emails and during a send and receive cycle which states 4 hrs to complete. i can see the number of items in the mailbox being reduced one at a time...if a wait the full four hours. they are gone...why would exchange purge the mail? and not report and error?
i can confirm the import through OWA - all mail present :) - 4 hrs later after send and receive through owa - all mail missing :( ?
Would rather have outlook 2010 installed but the Scalix does not support it...yep Scalix is a POS software
any thoughts or idea?
i do not want to by more software to perform the migration - I am dealing with three countries with five locations and different timezones and languages so i was hoping to run both system in parallel for a period of time...
That's no moon, It's a space station...
Reply:
Exchange doesn't remove email on its own, so unless you have changed something from the default configuration, something else is doing so.
The main reasons for removal of email is something else accessing the mailbox, such as a POP3 client, or an Exchange client is set to use a PST file and is storing the email locally.
If you are adding Exchange to an existing profile that is using a PST file then it can mean email is stored locally only as the default storage location is the PST file. A new Outlook profile should be created, with Exchange as default and then if an additional account type is required, it is added to Exchange.
Simon.
Simon Butler, Exchange MVP
Blog | Exchange Resources | In the UK? Hire Me.
------------------------------------
Reply:
Thanks for the reply...I don't see how anything other device can be performing this, I only have one device connected to the new exchange server...it most be the send and receive in outlook that fired after the import that removes the mail...I don't understand why especially in online mode...I have not made any changes to the policies on the exchange server...(as proof I already stated that i forgot to remove the 2GB limit causing my first error)...
I would love to have exchange be the default but Scalix throws out errors every time you open Outlook...this is the first user to move to the new server...i have never seen this before...i am going to perform an import from the exchange cmdlet and see if this corrects the problem...i will remove the profile again (4th time). I will import, then setup exchange profile for the user online mode, then setup scalix, then see what happens after another drag and drop and send and receive.
Right now it about getting a procedure down...
Note: There is more work that I am doing to the whole infrastructure (moving to a complete windows solutions) so i am dealing with a very messy layout every system has it own username ans password (a broken windows domain, Novell NDS, Several Workgroups, 3 independent Linux systems - a big mess). So i am building a complete windows solution from scratch in parallel...i would love to be able to flip it over at once but i cannot be in three countries at once. i need to be able to deploy it a desktop at a time.
That's no moon, It's a space station...
------------------------------------
Reply:
okay so...i have good news...
I setup exchange offline mode then i setup Scalix account as a simple imap server and everything works exactly they way i want...as I hate the scalix system, I am going to put the error and all my problems on the Scalix connector for outlook...when i setup exchange first i then setup the scalix connector I was unable to...error was unsupported connection when connected to an exchange server (Unicode vs non-Unicode) i think is the problem...i care not to investigate, I do not want to waste more time on Scalix.
thanks for the help
That's no moon, It's a space station...
------------------------------------
Promote a Windows 8 Core machine to DC
Hello,
I have found the following PS command which should promote a Windows 8 server to Domain Controller, however this does not appear to work in Core:
#
# Windows PowerShell Script for AD DS Deployment
#
Import-Module ADDSDeployment
Install-ADDSForest `
-DatabasePath "C:\Windows\NTDS" `
-DomainMode "Win2008R2" `
-DomainName "addict.local" `
-DomainNetBiosName "ADDICT" `
-ForestMode "Win2008R2" `
-InstallDNS:$true `
-LogPath "C:\Windows\NTDS" `
-RebootOnCompletion:$false `
-SafeModeAdministratorPassword (Read-Host -AsSecureString -Prompt "Enter Password") `
-SYSVOLPath "C:\Windows\SYSVOL"
First question, am I using the correct command? Secondly, why does this not appear to be working in Core? Lastly, is there a better way to accomplish this?
- Changed type Niki Han Tuesday, April 3, 2012 2:37 AM
Reply:
You have posted your question in the wrong forum. This is a Windows 7 peer-to-peer forum for end users. It does not deal with any of the Windows Servers.
You can find links for Windows Server 8 Beta @ http://social.technet.microsoft.com/Forums/en-US/category/winserver8
http://social.technet.microsoft.com/forums/en-us/winserver8setup
http://social.technet.microsoft.com/forums/en-us/winserver8gen
Please post all Windows Server 8 questions in one of the forums above.
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. "
------------------------------------
Reply:
You have posted your question in the wrong forum. This is a Windows 7 peer-to-peer forum for end users. It does not deal with any of the Windows Servers.
You can find links for Windows Server 8 Beta @ http://social.technet.microsoft.com/Forums/en-US/category/winserver8
http://social.technet.microsoft.com/forums/en-us/winserver8setup
http://social.technet.microsoft.com/forums/en-us/winserver8gen
Please post all Windows Server 8 questions in one of the forums above.
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. "
Sorry, not sure how that happened, will post again in the correct forum.
------------------------------------
System Center 2012 RTM is now available through volume licensing
DPM agent communication error
Hi,
I have a DPM2007 server installed on Windows Server 2008 Standard which is backing up a file server installed on Windows Server 2003 standard. While running a consistency check, I got the following eror:
DPM failed to communicate with the protection agent on NMGWW104.corporateroot.net because the agent is not responding. (ID 43 Details: Internal error code: 0x8099090E)
I checked the records from DPMRA source in the file Server and saw the following message:
A DPM agent failed to communicate with the DPM service on <server> because access is denied. Make sure that <server> has DCOM launch and access permissions for the computer running the DPM agent (Error code: 0x80070005, full name: <server>).
I followed the article http://technet.microsoft.com/en-us/library/bb795716.aspx to correct the DCOM launch and access permissions and saw that the agent is a part of the DCOM Users.
I went to Administrative Tools -> Component Services -> My Computer Properties -> COM Security and checked access permission limits where DCOM Users are given both Lcal Access and Remote Access. I checked the Launch and Activate permission limits where DCOM Users are given Local Launch, Remote Launch, Local Activation and Remote Activation.
The DPM Server is accessible from the agent. I tried restarting the DPMRA service on the agent also but that did not help. After this I ran a Sync Job again, but now it says 'unable to configure protection'.
Please help.
Thanks
Pavit
Reply:
Hi Community,
Any Suggestions why this may be occuring?
Thanks
Pavit
------------------------------------
Reply:
Hi Community,
Seems like there was a problem while communicating with the DC. The DPM error was often accompanied by a communication error ID:1053. So I checked the DNS entries and found that the two entries present there were wrong. Backup is running fine after correcting those entries.
Pavit
------------------------------------
Runbook to Provision Servers
Hello,
I am new to creating runbooks . I have created few using SCCM IP. I will have to create one for provisioning virtual server. Has anyone try doing it. We have Vmware ESX environment.
Thank you
Sandip Kanojia
- Changed type Robert_Hearn Wednesday, May 9, 2012 5:44 AM general question
Reply:
Hello, i'm interested about runbooks for provisionning physical server.
Thanks
------------------------------------
Reply:
------------------------------------
Reply:
Hello,
Thank you for your answer. I am interested in creating virtual servers using VMWare templates. do you mind sharing your runbook and scripts? I would really appreciate your help
Thank you
------------------------------------
Xbox 360 wireless controller for Windows
Hello,
I have bought today new XBox 360 wireless controller , but when i attach the wireless receiver the receiver light blinks or you can say it is working exactly, but still my wirelesss controller does not work, i installed all the latest drivers then, i saw the devices and printers section in control panel, their it shows UnKnown device , then through device manager i try to load the receivers drivers to the PC, that time is shows the following screenshot
http://img641.imageshack.us/img641/6720/receiver.png
I m having all my wireless devices switched off, and also i m using Lenovo Laptop with 64bit Windows 7, 4GB RAM, Core 2 Duo 2.2ghz processor, 1GB Graphics card
Please help or give me refund , i wanna enjoy playing games
- Changed type Niki Han Thursday, July 14, 2011 9:56 AM
Reply:
------------------------------------
Reply:
Hi,
Could you share your method to solve the issue? It will help other people to find the clue when encounter the same issue. Your efforts are highly appreciated.
Niki
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
------------------------------------
Reply:
I just googled this and i found the solution in a YouTube-video: http://www.youtube.com/watch?v=kxa5CJsDzwQ
Just watch the video and I promise it will help you! I will copy this post to any other thread which touches this exact subject.
- Edited by Ejohrik Monday, April 2, 2012 2:55 PM
------------------------------------
Need to put MS on different location
Hi Team,
I am thinking of Putting Management servers in the below location.I need asistance on the same.Where should i put MS.
Ashburn Datacenter-300 servers
Australis Datacenter-10 serevrs
Chicago Datacenter-5 servers
India Datacenter-10 servers
London Office Datacenter-10 servers
Minneapolis Datacenter3 servers
Rochester Datacenter-40 servers
San Francisco Datacenter-5 servers
Singapore Datacenter-5 servers
Toronto Datacenter-5 servers
All the MS should be connected to RMS. Need guidance on this
Durgesh Kumar
- Changed type Yog Li Friday, May 4, 2012 5:30 AM duplicated thread
Reply:
Duplicate post so closing.
Regards
Graham
Regards Graham New System Center 2012 Blog! - http://www.systemcentersolutions.co.uk
View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/
------------------------------------
Losing access to file shares daily
I'm working with a number of clients who are only noticing this problem on Windows XP machines. They have a program that maps a UNC path to a drive letter (for the users to access on their own) and then proceeds to use the UNC to access these files. (it basically runs the command "net use v: \\computername\sharename" for the user and then tries to access a few files on \\computername\sharename)
Lately, they have been running into a large number of problems with their XP machines using this program. The program works fine for a day, but the next day, it is unable to connect to this same UNC path for file sharing. It returns an error about not being able to find the specified network path (I don't have the text of the exact error). I've noticed a few things about this.
1) The issue seems isolated to specific shared folders. It always seems to affect the one this program uses, but other folders are still accessible. Occasionally other folders are affected, but it is primarily the folder that this program uses.
2) If I change the UNC path to the IP address (\\computername\sharename\ -> \\xx.xx.xx.xx\sharename\), the program works fine for another day, but the next day, the same symptoms arise. Switching back to the original UNC works again and the process repeats in a seemingly endless cycle. (UNC works -> Next day UNC not work but IP does -> next day IP not work but UNC does -> UNC not work but IP does -> etc).
3) When this happens, if the mapped drive is still connected, they can access the files here still, but the UNC (or IP - depending on the day) does not allow access.
4) Sometimes a reboot of the client pc has fixed it. Other times, a reboot of the server has fixed it. Other times, neither options work and we have to go back to the IP/UNC rotation.
5) It only affects Windows XP machines, but does not affect ALL Windows XP machines.
6) I can ping the computer with the file share fine. The computer with the problematic file share can ping and access shared files from the other computer(s) without any problems.
7) It had been working fine up until about 2 or 3 weeks ago, and we've had the issue consistently on a daily basis with these clients since then.
It is puzzling and we have a number of our clients experiencing the same issue. It also is limited to Windows XP machines, though the computer hosting the file share could be practically any OS it seems. Any help would be appreciated.
- Changed type ScottStairs Monday, April 2, 2012 2:21 PM Needs some discussion
Reply:
------------------------------------
Look up colunm not working
Hi
i have a list i made it a template and i restored that to another server now i tried to create a new list with this template from the other server so i will be having the same list with the data
but now in the server i got the list but the lookup is not working in this new server but when i delete the particular field and recreate the look up i am able to get the values but i dont have to do it in this way
any suggestions
Alen Austin
Reply:
Hi
That means the field is having different guids on those servers. Field must have been created manually using UI on these two environments. If you deploy the site column as features and maintain guids then it will work.
Regards
Yogesh
------------------------------------
Deleted
Reply:
Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."
------------------------------------
Reply:
Hello Jitender,
First of all, let me tell you about this problem, this issue has been reported by many people, those who have eforms, running in their environment, and particularly, for those who have been transitioned from the legacy Exchange versions, especially from Exchange 2003, and so far there is no official resolution to fix this problem.
Now lets talk about the resolution, it been said that creating Conflict-logging registry key on the users computer as a workaround for this problem, but unfortunately it has been noticed that it is also not working, and today after adding this registry, I saw that one error entry got logged in my Outlook for the same problem, as you mentioned.
I will post you, if I get something from my peers.
Zahir Hussain Shah | MVP - Exchange Server | Senior Infrastructure Consultant - Messaging | My blog: http://zahirshahblog.com ]If my answer fixes your problem, mark them as answer, so it will help others to find a solution]
------------------------------------
Reply:
Hello Jitender,
First of all, let me tell you about this problem, this issue has been reported by many people, those who have eforms, running in their environment, and particularly, for those who have been transitioned from the legacy Exchange versions, especially from Exchange 2003, and so far there is no official resolution to fix this problem.Now lets talk about the resolution, it been said that creating Conflict-logging registry key on the users computer as a workaround for this problem, but unfortunately it has been noticed that it is also not working, and today after adding this registry, I saw that one error entry got logged in my Outlook for the same problem, as you mentioned.
I will post you, if I get something from my peers.
Zahir Hussain Shah | MVP - Exchange Server | Senior Infrastructure Consultant - Messaging | My blog: http://zahirshahblog.com ]If my answer fixes your problem, mark them as answer, so it will help others to find a solution]
If you wana try this, see this:
Change the registry key to disable the conflict logs for Outlook 20xx
===========================================
1. On one of the affected machines, add the following registry key to ensure that conflicts does not get saved
Key: HKEY_CURRENT_USER\ Software\Microsoft\Office\12.0\Outlook\Options
DWORD: DiscardConflicts
Value: 1
2. If you do not want the Modification Resolution message to be saved under the sync issues folder as well, add the following keys –
Key: HKEY_CURRENT_USER\ Software\Microsoft\Office\12.0\Outlook\Options
DWORD: EnableConflictLogging
Value : 0
Zahir Hussain Shah | MVP - Exchange Server | Senior Infrastructure Consultant - Messaging | My blog: http://zahirshahblog.com ]If my answer fixes your problem, mark them as answer, so it will help others to find a solution]
------------------------------------
Reply:
------------------------------------
Reply:
Zahir Hussain Shah | MVP - Exchange Server | Senior Infrastructure Consultant - Messaging | My blog: http://zahirshahblog.com ]If my answer fixes your problem, mark them as answer, so it will help others to find a solution]
------------------------------------
Reply:
------------------------------------
Unable to access Azure Account Storage
Hi,
I am using a Srorage Account for few months. Now I am not able to access it (using celebrata tools), it gives error:The remote server returned an error: (401) Unauthorized.
Even if I try to connect it using Visual Studio, I am getting the same error. I have just created another Storage account on the same server, it's giving the same error.
Please advise.
Thanks & Regards
Kakali Gupta
raich
Reply:
Hi,
It seems the issue with the credentials. Please verify if you are using correct key associated with the storage account.
If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Thanks! Vaibhav Gujral.
------------------------------------
Reply:
------------------------------------
Reply:
Auto-scaling & monitoring service for Windows Azure applications at http://www.paraleap.com
------------------------------------
Reply:
Thanks,
After regenerating the account key, I am able to access it.
Thanks & Regards
Kakali Gupta
raich
------------------------------------
Management Group in SCOM
Hi ,
I am new to SCOM. I would like to know about Management Group in SCOM. Can any one please explain about what is Management Group in SCOM.
Reply:
Hi,
it is not the right Forum for this question look at http://social.technet.microsoft.com/Forums/en-US/category/systemcenteroperationsmanager
The Management Group contains all assigned Server, Devices, Clients and you can assign security goups with the desired permissions.
You connect with your SCOM console to this Management Group. You can also deploy more then one Management Groups and assign each Server to only one Management Group while you install the Scom agent.
regards Holger Technical Specialist UC
------------------------------------
Replace XML node name in sql server 2008
HI,
How can I update and xml node name using sql server 2008?
I have the below xml in one of my tables.
<Employee>
<EMPName>
a</EMPName>
<Designation>a1 </designation>
//some more details are available here
</Employee>
I need to replace it as given below:
<Employee>
<Name>
a</Name>
<Designation>a1 </designation>
//some more details are available here
</Employee>
Please help me to solve the above issue.
Regards,
Vidya
Reply:
Check out this thread:
http://social.msdn.microsoft.com/Forums/en/sqlxml/thread/5143d593-e750-4975-b227-885495c47f31
Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008
------------------------------------
Reply:
Yes similar thread as pointed out by Russ, slightly different implementation:
DECLARE @t TABLE ( x XML ) INSERT INTO @t VALUES ( '<Employee> <EMPName>a</EMPName> <Designation>a1</Designation> <!-- ... --> <x/> <y/> </Employee>' ) INSERT INTO @t VALUES ( '<Employee> <EMPName>b</EMPName> <Designation>b1</Designation> <!-- ... --> </Employee>' ) SELECT 'Before' s, DATALENGTH(x) l, x FROM @t UPDATE t SET x = x.query('<Employee> <Name>{data(Employee/EMPName)}</Name> (: Get all other elements :) {Employee/*[local-name() != "EMPName"]} </Employee>') FROM @t t SELECT 'After' s, DATALENGTH(x) l, x FROM @t ------------------------------------
[SCE 2010] Problems with P2V over trusted domains
Hello,
i've built a 2-node cluster under Windows Server 2008 R2 SP1 and all seems to be fine (LiveMig, transfer rates between cluster and iSCSI SAN).
The actual configuration is composed of 2 Dell R610 with 24GB RAM each, 8 NICs per server (2 for the lan (teaming with BACS), 4 for the iSCSI, 1 for LiveMig, 1 for Heartbeat) and a Dell MD3200i iSCSI SAN with 3,5TB of storage (2 LUNs, 1 of 2,5TB the orther of 1TB, both added as cluster storage in failover clustering manager).
We currently have a 2003 R2 domain composed of 2 2003 R2 DCs and 30 domain clients, let's name this domain domain2k3.lan
The cluster is in its own domain, let's name it cluster2k8.lan
Both domains approve each other through a bi-directional forest approbation.
I've configured a VM on the cluster so i can install SCE 2010 on it and manage the PCs in the domain domain2k3.lan. At first, this VM was added to the cluster2k8.lan domain so i could manage the 2 nodes of the cluster and my problems started. I wasn't able to install the agent on my domain2k3.lan clients, even with the domain2k3.lan admin credentials. So i tried another solution and reformatted my VM, added it to the domain2k3.lan domain and installed SCE 2010 on it. This time, i was able to deploy SCE agent over the domain, even on the 2 2k8 cluster nodes (specifying the good credentials).
Now i have many problems :
- SCE can't detect the hardware of the 2k8 servers, nor the updates applied on them or the installed software
- The second problem is, i think, a consequence of the first problem : i try to P2V a simple WinXP laptop (1GB RAM, 30GB HDD) but at the step where i have to choose the host on which i want to create my VM, both of my cluster nodes are tagged "not compatible" with the note : "this configuration causes the host cluster to become overcommitted".
My cluster has enough resources to host a lot of VM's, only 4GB of RAM is used on each node and the cluster reserves are set to default, so i have at least 16Gb. I presume this error comes from the fact that my SCE can't get the HW and SW inventory of my 2 cluster nodes which are in a different (but trusted) domain and can't determine if the reserved resources are hit or not. So, here are my 2 questions :
- Is it possible to fully manage server across trusted domains (i know this is possible in SCVMM but i only have SCE) so that SCE 2010 can get all HW and SW specs
- Is it possible to P2V a machine which is in the same domain as the SCE server but on a cluster in a different (forest-level trusted) domain ?
Thank you in advance for your help. Sorry for the english mistakes, it's not my native language.
Have a nice day.
Richard
Reply:
Hello Richard,
SCE 2010 can fully managed the agents installed in a trusted domain. You can see it here:
Supported Topologies and Performance Guidance for System Center Essentials 2010
http://technet.microsoft.com/en-us/library/bb422797.aspx
The second answer should also be YES. From the article below, there is no restriction that only the server in the same domain can be designated as a host.
How to Designate a Host for Virtualization Management in Essentials
http://technet.microsoft.com/en-us/library/ff603584.aspx
To troubelshoot this issue, I would suggest the following articles for your reference:
Introduction to Virtualization in System Center Essentials 2010
http://blogs.technet.com/b/systemcenteressentials/archive/2010/05/28/introduction-to-virtualization-in-system-center-essentials-2010.aspx
Why is my Hyper-V Cluster showing as overcommitted?
http://social.technet.microsoft.com/Forums/en-US/virtualmachinemgrclustering/thread/b14268ab-30ff-4709-ac41-6e80167a9541
Thanks,
Yog Li
TechNet Community Support
------------------------------------
Windows 8 CP CCID driver does not comply with ISO specifications
Dear Technet. Our company produces smart card-like USB-tokens and we have recently noticed that our CCID tokens had stopped working in Win8 CP (in Win8 beta everything was fine).
Win8 CP has a newer CCID driver version compared to Win8 beta. After some research we saw that if we replace the driver with older one (from beta or Win7) our tokens are recognized by the OS.
We believe that the problem here is that new driver does not comply with ISO 7816-12 standard, particularly the part concerning USB endpoints. The table from ISO document states that when using bulk transfers (and that is how our cards work) the presence of Interrupt-IN endpoint is optional. The same is also true for the message NotifySlotChange.
According to the "DWG Smart-Card Integrated Circuit(s) Card Interface Devices" document we have the following:
5.2.3 Interrupt-IN Endpoint
The Event Report pipe is used by the CCID to notify the host of an ICC insertion event, ICC removal event, or hardware errors such as over current.
The interrupt pipe is mandatory for a CCID that supports ICC insertion/removal. It is optional for a CCID with ICCs that are always inserted and are not removable. If there is an Interrupt-In endpoint, then the RDR_to_PC_NotifySlotChange message is required and all other messages are optional.
Since our tokens have non-removable ICCs, it is optional for them to have this interrupt pipe. According to that we have the following bits set in Smart Card Device Class Descriptor:
- dwMechanical = 0, i.e. "No special characteristics"
- dwFeatures bit 0x04h "Automatic activation of ICC on insertion" is inactive.
These bits indicate that Interrupt message is optional.
If we add a new endpoint in our device and send a NotifySlotChange message, then our device starts working correctly with the new driver. But according to ISO 7816-12 such message is optional and the card should be recognized successfully without it.
- Edited by Кирилл Романовский Monday, April 2, 2012 10:17 AM fixed a typo
Server 2008 R2 profession Raid 5
I configured the RAID 5/w a spare on (6) 2tb drives and Raid 1 on (2) 1tb drives through the HP Smart Start CD. I've loaded 2008 R2 Professional on the RAID 1. I'm able to see drive C through explorer, but not the Raid 5. When I go into disk management Disk one displays the following, two unformatted spaces, one with 2048gb the other with 5403bg. What do I need to do in order to view the RAID 5?
Reply:
"I configured the RAID 5/w a spare on (6) 2tb drives and Raid 1 on (2) 1tb drives through the HP Smart Start CD."
As I understand these are hardware raids. So raid is setup at hardware level and not at software level. In this case these will appear as unformatted disks in windows subsystem. You need to create volume and format it in order to view RAID5.
Regards
Satish
------------------------------------
Reply:
TechNet Subscriber Support in forum |If you have any feedback on our support, please contact tnmff@microsoft.com.
------------------------------------
No comments:
Post a Comment