Wednesday, February 2, 2022

Power View in SharePoint only shows current year.

I have a customer using the Power View add in for SharePoint 2013 based on SQL 2014. I have created a BISM object that connects directly to an OLAP cube.

When I build reports or Pivot tables against this object they work fine. However when I build dashboards in Power View they only show the current year's data

We do have a default date dimension which forces for some reason Power View to only display current year. Therefore the slider doesn't work since it has only current year / date showing up.

After removing the date dimension in one of our dev. cubes, Power View showed all dates and we were even able to uses the date animation with slider worked fine.

We don't want to do this in production however, because many of our reports rely on the default date dimension.

Has anyone come across this or know a workaround?

Changed type Ed Price - MSFTMicrosoft employee Saturday, May 16, 2015 1:00 AM No response

Reply:

SG, are you still working through this?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

First Map - Newbie Question

I am trying to create my first map. I thought I had what should be the most basic one to try but I cannot get it to work as I would like. I am trying to display potentially 2 data points for a location and I don't want it to show as a pie chart. I would like 2 different bubbles if a city has both. My data currently has 2 columns - CityState & Category. I'm assuming there is just some trick I am missing to get it to display the way I want. Can someone tell me what I am doing wrong? Thank you so much.

Changed type Ed Price - MSFTMicrosoft employee Saturday, May 16, 2015 1:00 AM No response

Reply:

Anneroth, is this still an issue?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

A user-defined function that enables SQL Server to perform similarly to the VB "Split" function

Also shared on TechNet HERE

While working on an interface between Pitney Bowes shipping system APIs and legacy data stored in Microsoft SQL Server, I needed a simple way to parse a delimited string. I knew how to accomplish this in Visual Basic but, after searching the internet, did not find a clean and simple approach using SQL stored procedures. I decided to write my own user-defined function which performed the duty with little effort. You are welcome to incorporate the solution into your own projects.

Description: A user-defined parsing function that enables SQL Server that also performs similarly to the VB "Split" function.

Author: Paul DeBrino .:. InfinityRD.com .:. (C) Oct 2007
---------------------------------------------------------------------------------------------------------

/*   Short Description:   A user-defined parsing function that enables SQL Server that also performs similarly to the VB "Split" function.    Parameters:   	1. String : Value to parse, based on the specified delimiter. Limit 2000 characters (you may alter size limit as needed).  	2. String : Delimiter value. Single character value.  	3. Integer : Section To Return. 0 returns all sections as a table, otherwise specify the parsed section number you wish returned as nvarchar.  	4. String : Section Data to Find. Pass a zero-length string when not applicable. Section To Return defaults to 0 when using this feature.    Returns:  Table with one row per each parsed section:   String : SectionData   Identity : ID (useful when Section To Return parameter is 0 and you want to know the section number for each parsed value)    General Usage:  	select * from splitstring_V2('ABC-123-DEF-789-Z', '-', 0, '')  	>> results in 5 rows -- 1 per each section parsed -- Use cursor or other method to process results.    	select * from splitstring_V2('ABC-123-DEF-789-Z', '-', 0, 'DEF')  	>> results in 1 row: DEF, 3    	select * from splitstring_V2('ABC-123-DEF-789-Z', '-', 4, '')  	>> results in 1 row: 789, 4    	select * from splitstring_V2('ABC-123-DEF-789-S01', '-S', 0, '')  	>> results in 2 rows: ABC-123-DEF-789, 1 and S01, 2 -- Use cursor or other method to process results.    	select * from splitstring_V2('ABC-123-DEF-789-S01', '-S', 0, '') where sectionnumber=2  	>> results in 1 row: S01, 2    Usage to load result into a variable:  	select yourvariable = sectiondata from generic_use..splitstring('ABC-123-DEF-789-Z', '-', 1, '')    Author: Paul DeBrino .:. InfinityRD.com .:. (C) Oct 2007  Please retain the author, copyright and notes, if you adopt this user-defined function.    Long Description: While working on an interface between Pitney Bowes shipping system APIs and legacy data stored in Microsoft SQL Server, I needed a simple way to parse a delimited string. I knew how to accomplish this in Visual Basic but, after searching the internet, did not find a clean and simple approach using SQL stored procedures. I decided to write my own user-defined function which performed the duty with little effort. You are welcome to incorporate the solution into your own projects.  */    ALTER FUNCTION [dbo].[SplitString_V2]  (   @p_StringToParse as nvarchar(2000),    @p_Delimiter as varchar(5),   @p_SectionToReturn as int,   @p_SectionDataToSearchFor as varchar(2000)  )  RETURNS @v_Results TABLE   (   SectionData nvarchar(2000),   SectionNumber int   )  AS  BEGIN     declare @v_Index int, @v_Section int, @v_Slice nvarchar(2000), @v_SectionDataToSearchForFound bit   set @v_Index = 1   set @v_Section = 1   set @v_SectionDataToSearchForFound = 0     -- Monitor for incorrect use of parameters: SectionToReturn must be 0 when specifying SectionDataToSearchFor:   If ((isnull(@p_SectionDataToSearchFor,'') > '') and (@p_SectionToReturn <> 0))   Set @p_SectionToReturn = 0     If @p_StringToParse is null RETURN    	WHILE @v_Index !=0  	BEGIN   		-- GET THE INDEX OF THE FIRST OCCURENCE OF THE DELIMITER:  		SELECT @v_Index = CHARINDEX(@p_Delimiter,@p_StringToParse)    		-- CAPTURE THE SECTION TO THE LEFT OF DELIMITER INTO THE SLICE VARIABLE:  		IF @v_Index !=0  			SELECT @v_Slice = LEFT(@p_StringToParse, @v_Index - 1)  		ELSE  			SELECT @v_Slice = @p_StringToParse    		-- PLACE THE SLICE INTO THE RESULT:  		IF @p_SectionToReturn = 0  		BEGIN  			IF ((isnull(@p_SectionDataToSearchFor,'') > '') AND (@p_SectionDataToSearchFor = @v_Slice))  			BEGIN  				SET @v_SectionDataToSearchForFound = 1  				INSERT INTO @v_Results(SectionData, SectionNumber) VALUES(@v_Slice, @v_Section)  				BREAK  			END  			ELSE IF (isnull(@p_SectionDataToSearchFor,'') = '')  				INSERT INTO @v_Results(SectionData, SectionNumber) VALUES(@v_Slice, @v_Section)  		END  		ELSE IF @v_Section = @p_SectionToReturn  			BEGIN  				INSERT INTO @v_Results(SectionData, SectionNumber) VALUES(@v_Slice, @v_Section)  				BREAK  		END    		-- REMOVE THE CURRENT SECTION FROM THE STRING TO PARSE:  		SELECT @p_StringToParse = RIGHT(@p_StringToParse, LEN(@p_StringToParse) - @v_Index)    		-- BREAK IF NOTHING LEFT TO PARSE:  		IF LEN(@p_StringToParse) = 0   		BREAK    		SET @v_Section = @v_Section + 1   	END    	IF ((isnull(@p_SectionDataToSearchFor,'') > '') AND (@v_SectionDataToSearchForFound = 0))  		Delete from @v_Results    	RETURN    END

Edited by Paulie-D Thursday, April 14, 2016 6:57 PM Version 2 - new 4th argument added

Reply:

Have you read this great article?

http://sqlperformance.com/2012/07/t-sql-queries/split-strings

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

------------------------------------
Reply:

Thanks .. but it's overkill for my purposes.

My code was designed for interactive leveraging; for example, to parse data within a Stored Procedure called from an external API.

Edited by Paulie-D Wednesday, May 6, 2015 5:31 AM

------------------------------------

SSL Certificate comes unbound from IIS web application daily

I have an SSL certificate (issued by a Certifying Authority) that comes unbound from the web application daily. It only does this for one web application near as I can tell. There seems to be very little information on users having similar issues, I've found a few posts here and there but in each case no one responded with any suggestions. Surely there must be some cause or solution to this? Sifting through the logs hasn't shown anything yet, but there is so much to go through, I could be missing it. I've noticed even during the day at random it comes unbound. Maybe if I note the times I can sift through a smaller section of the logs, but I'm not hopefull that there will be any information that points to something.

Changed type Vivian_Wang Wednesday, May 6, 2015 3:28 AM

Reply:

Hi,

Since the issue is related to IIS, i think you could ask in IIS forums:

http://forums.iis.net/

Regards.

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

------------------------------------

SharePoint 2013 BCS Column to a hyperlink in List

Hi folks!

Today i was searching for a solution for SP 2013 to get a column form an external list formatted to hyperlink und google wasn't really helpful there for. All solutions I've found are related to SP 2010 and SPD 2010.

But i found this great post with an answer from AbedKhooli (https://social.technet.microsoft.com/Forums/office/en-US/d0c13348-224f-4cdd-96e2-2f0b37313e34/sharepoint-2010-bcs-column-to-a-hyperlink-in-list?forum=sharepointcustomizationprevious) and tried to port this to SPD2013. And it was successful!

So, if you try to get those things done in SPD2013, have a look:

In addition to AbedKhooli's post, you can use this as a workaround for 2013. It's a little bit considerable for you need to have both a 2010 and a 2013 environment to get this working, for, as you all might know, in SPD 2013 thers is no design view editing a page.

But nevertheless, you can get this working in 2013 as follows:

Do as AbedKhooli described in SPD 2010. Of course you will have to have a working external list to get this done.

Then, when you have formatted your column, switch to code view, find the block within the <xsl>-Tags, open the corresponding page in SPD2013, copy the hole <xsl>-block to SPD 2013 and have fun!

To mention briefly, you will have to store your links in database as absolute ones, e.g.:

http://microsoft.com leeds to http://microsoft.com

otherwise your data will be taken as a relative link and will be added to the actual url:

microsoft.com leeds to http://yourserver/lists/yourlist/mircrosoft.com

Hope, someone will find this helpful!

And btw., if someone has a more easy solution to get this done in SPD2013, please add it as a comment. Thank you in advance!

BR,

Sam

Changed type Victoria Xia Wednesday, May 6, 2015 3:20 AM discussion

Reply:

In Addition, this is "my" resulting XSL-Snippet:

<xsl>  	<xsl:stylesheet xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" version="1.0" exclude-result-prefixes="xsl msxsl ddwrt" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:SharePoint="Microsoft.SharePoint.WebControls" xmlns:ddwrt2="urn:frontpage:internal" xmlns:o="urn:schemas-microsoft-com:office:office">   		<xsl:include href="/_layouts/xsl/main.xsl"/>   		<xsl:include href="/_layouts/xsl/internal.xsl"/>   		<xsl:param name="AllRows" select="/dsQueryResponse/Rows/Row[$EntityName = '' or (position() &gt;= $FirstRow and position() &lt;= $LastRow)]"/>  		<xsl:param name="dvt_apos">'</xsl:param>  		<xsl:template name="FieldRef_Text_body.AP_URL" ddwrt:dvt_mode="body" match ="FieldRef[@Name='AP_URL']" mode="Text_body" ddwrt:ghost="" xmlns:ddwrt2="urn:frontpage:internal">  			<xsl:param name="thisNode" select="."/>  			<xsl:choose>  				<xsl:when test="@AutoHyperLink='TRUE'">  					<xsl:value-of select="$thisNode/@AP_URL" disable-output-escaping ="yes"/>  				</xsl:when>  				<xsl:otherwise>  					<a href="{$thisNode/@AP_URL}"><xsl:value-of select="$thisNode/@AP_URL" /></a>  				</xsl:otherwise>  			</xsl:choose>  		</xsl:template>  	</xsl:stylesheet>  </xsl>

In lines 7, 11 and 14 you see AP_URL resulting from my SQL tablecolumn called "AP_URL".

Change this to your columntitle.

BR,

Sam

Edited by Sam Krieger Tuesday, May 5, 2015 10:22 AM

------------------------------------
Reply:

Hi Sam,

Thank you for sharing this with us, and it will help others who have met with this issue.
I will change this thread type to discussion as it is not an question, more people can join to this topic and share their opinions.

Thanks,

Victoria

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

------------------------------------

How to change the content type of a masterpage

I have a JS file uploaded in the master pages repository. I have it opened in Designer but cant figure put how to change the document's content type from Master Page to Javascript Display Template.

Reply:

Hi,

Please see if it can help you

https://social.technet.microsoft.com/Forums/office/en-US/1fd99b71-c37a-406b-b491-73a89bc00dfc/changing-masterpage-on-content-page?forum=sharepointdevelopmentlegacy

Please remember to click 'Mark as Answer' on the answer if it helps you

------------------------------------
Reply:

Hi,

Please see if it can help you

https://social.technet.microsoft.com/Forums/office/en-US/1fd99b71-c37a-406b-b491-73a89bc00dfc/changing-masterpage-on-content-page?forum=sharepointdevelopmentlegacy

Please remember to click 'Mark as Answer' on the answer if it helps you

I looked at the site but didnt find it applicable to what Im doing. I need to change the content type of my master page. As you can see from the image below, there is no option to select the content type. I believe I have to enable "content type editing" but I dont know on which page can I enable it.

http://i.imgur.com/7paVvOd.png

In addition to changing the content type, I need to do the following:

Set the Target Control Type value to "View."
Set the Standalone value to "Override."
Set the Target Scope value to the URL of your site (e.g. "/sites/site1″).

I dont know how (or where) to set any of the above either as there does not seem to be any option to do so on Designer or on the Sharepoint settings page.

Edited by thumpersd Tuesday, May 5, 2015 8:22 PM

------------------------------------
Reply:

Found the solution:

Site settings > Master Pages > Advanced Settings

Enable editing of content types

Now the fields will be available when editing the master page's properties

------------------------------------
Reply:

Try this https://social.technet.microsoft.com/Forums/office/en-US/1fd99b71-c37a-406b-b491-73a89bc00dfc/changing-masterpage-on-content-page?forum=sharepointdevelopmentlegacy

------------------------------------

FIM2010 licensing model is changing as of 1st of april 2015

Source: http://www.microsoft.com/licensing/products/products.aspx
Download the "Microsoft Product Use Rights (WW, English, April 2015)" document at http://www.microsoftvolumelicensing.com/userights/Downloader.aspx?DocumentId=8488

In short, prior to 1st of april 2015, you required

a FIM server license for every FIM server installed and a CAL for every user managed in the FIM Service, or
Forefront Identity Manager 2010 R2 External Connector

After 1st of april 2015:

Windows Server license (Standard & Datacenter) will include FIM server entitlement
FIM Server 2010 R2 licenses will not be available anymore on the price lists

The FIM server will no longer be sold as a separate license, but instead Windows Server licenses will allow customers to install the FIM Server software.
Azure Active Directory Premium (AADP) and any suite that contains AADP, including Enterprise Mobility Suite (EMS) and Enterprise Cloud Suite (ECS), will also entitle users to access FIM.
Since FIM users already required a Windows Server CAL or equivalent to access FIM running on Windows Server, no additional Windows Server CALs (or Windows Server External Connector) will be required.

More info here:

Peter Geelen (Microsoft Belgium) - Premier Field Engineer Security Identity

[If a post helps to resolve your issue, please click the "Mark as Answer" of that post or click "Vote as helpful" button of that post.
By marking a post as Answered or Helpful, you help others find the answer faster.

Edited by Peter GeelenMVP Tuesday, May 5, 2015 8:02 PM typo

Reply:

Hello,

as you can not bye a FIM Server license any more, I assume that this also apply to already purchased Windows Server licenses,right ?

/Peter

Peter Stapf - ExpertCircle GmbH - My blog: JustIDM.wordpress.com

------------------------------------
Reply:

Interesting...so this almost sounds like MS won't be "selling" FIM/MIM anymore (since its being given away)...so is there any real future in the product? Hmm...

------------------------------------
Reply:

It's more or less the same discussion as to ADLDS, RMS and ADFS.

The MIM roadmap recently has been presented (eg on TechEd) and you see there are significant investments, updated features and important scenario's to support the Identity Manager's future.

That roadmap and the change in licensing model are clear indications that MS is focussing on making Identity Manager more cloud-ready and better integrated with Microsoft's cloud-based identity management solutions, especially Azure Active Directory, and enable more hybrid and cloud-first scenarios.

MS is making a licensing model change to better align with the user-based models of the MS cloud identity and mobility offers.
This change will also allow you to more readily implement high availability, redundant, and load-balanced multi-server deployments, and thus enable more advanced scenarios for your organization.

Let's meet in 5 year (or 10 year), at the end of (extended) support of MIM and discuss what the future has brought us.

------------------------------------
Reply:

Does anyone know where the binary's are available for users with a Windows Server license then? :)

/Frederik Leed

------------------------------------
Reply:

Hello,

Current solution is to download it like before from VLSC: https://www.microsoft.com/Licensing/servicecenter/default.aspx

Regardless if you already purchased it or using Windows Server license from now on.

This is the answer I got from Product Group a few minutes ago.

/Peter

Peter Stapf - ExpertCircle GmbH - My blog: JustIDM.wordpress.com

------------------------------------
Reply:

Thanks for the update, great info.

Wish I could just ignore things like this, but you have a typo:

"FIM Server 2010 R2 lices will not be available anymore on the price lists"

should read:

"FIM Server 2010 R2 licenses will not be available anymore on the price lists"

------------------------------------
Reply:

Fixed.

------------------------------------

activation codes for my nokia lumia 900

I need to activate my windows phone

Reply:

Hello, please follow instructions in guide Activation code required when signing in with a Microsoft account on your Windows Phone.

Activation is normally done with first sign in and start of Windows Phone. Just connect to Wi-Fi or GSM network.

------------------------------------

Delete Out-of-Office Rule with MFCMAPI

[Symptom]
====================================
This OOF issue happens on single user. He is able to:

1. Click turn on/off OOF rule in Outlook and OWA without issue.
2. Edit the OOF message and click save without any issue.

However, any settings he saved do not take effect.

[Cause]
=====================================
OOF rule on the mailbox is corrupted.

[Solution]
=====================================
There is no use to delete and recreate the rule via Outlook or OWA. You have to use MFCMAPI tool to delete the rule directly from the user's mailbox.

1. Download Mfcmapi_bin.exe
<http://download.microsoft.com/download/4/9/f/49f2ce91-72c5-45f5-9849-401cd9b86d67/mfcmapi_bin.exe>

2. Install on the desktop.
3. Double click on MFCMapi.exe, click 'OK'
4. Click on "Session" and select "Logon and Display Store Table"
5. Choose the profile, and click 'OK'
6. Double click on the "Mailbox - alias"
7. Expand "Root Container" >> "IPM_SUBTREE" >> "Inbox"
8. Right click on "Inbox" and select "Display Rules Table"

9. Please delete all the rules in the window:

10. Click File|Exit
11. Click Session|Logoff
12. Click File|Exit
13. Open Outlook, recreate the rules and check if the issue persists.

Please click to vote if the post helps you. This can be beneficial to other community members reading the thread.

Changed type ForumFAQ Wednesday, April 29, 2015 8:23 AM
Edited by ForumFAQ Wednesday, April 29, 2015 8:25 AM

Reply:

Thanks for Sharing.

Hope this helps. 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.

------------------------------------

[SOLVED] Slow mail flow sending in chunks every 20 to 30 minutes.

Hello, I wanted to share an issue I observed with slow mailflow on our new Exchange 2013 CU8 Hybrid environment. It is my hope that this can help someone out there, that like me, thought moving to Exchange 2013 was a huge mistake.

Brief overview of my mail servers and typical mailflow

Hosted spam filter service --> Palo Alto firewall --> On-Prem Exchange 2010 SP3 CAS server --> On-Prem Exchange 2010 SP3 HUB transport & mailbox server <--> Hybrid Exchange 2013 cu8 (CAS&Mailbox roles) <--> Palo Alto firewall <--> hosted exchange online mailboxes

Ever since initial setup I experienced delays with mail flow. Email would become queued at our Hybrid Exchange 2013 cu8 server when attempting to send to the exchange online hosted mailboxes, but it would eventually send. I observed several interesting items (below).

mail would become stuck in the on-prem Hybrid exchange 2013 server queue, and then send out of the queue in chunks , after about 20 to 30 minutes of waiting
when mail started to send "in chunks", all mail would be delivered out of the queue in seconds
after about 45 minutes or so, mail would start queuing again and repeat the process
On prem and external-to-our-organization mail would queue mail destined to exchange online mailboxes. Hosted mailboxes would send to other hosted mailboxes instantly, but the hosted accounts queued mail when sending back to on-prem mailboxes.

Here is what the delayed mail headers would be like (local addresses removed for my benefit)

Initially I thought it could be "the DNS bug" described in the slow-mail-flow thread over here. While I followed the steps and manually specified our DNS settings, we continued to experience the problem.

LOGS and Errors

I enabled verbose logging on the Hybrid on-prem Exchange 2013 connectors

My log file path is:
D:\Exchange2013\TransportRoles\Logs\FrontEnd
D:\Exchange2013\TransportRoles\Logs\HUB

Found errors:

\Logs\Hub\ProtocolLog\SmtpSend errors:

*,,Connector is configured to send mail only over TLS connections and remote doesn't support TLS

\Logs\Hub\Connectivity errors:

*,Session Failover; previous session id = 08D250C62FEB1479; reason = SocketError

Indeed the above errors was related to an invalid TLS certificate setup on our on-prem Exchange 2010 SP3 mailbox server. After fixing the certificate, we still experienced the slow mail queue, but had no more errors in our exchange logs.

The above troubleshooting took about a week to hammer out. During that time I asked our network engineer to take another look at the network config, and he noticed that he had set the Palo Alto firewall to allow port 25 traffic incoming traffic, but he did not allow port 25 outgoing traffic. After he changed the rule to allow outgoing port 25, our problem was gone. Somehow the firewall ended up being the issue all along, and even though plenty of Microsoft articles start with "check your firewall", I was assured that our firewall was OK and email even eventually found a way out (I have some thoughts on that - did the messages send when incoming port 25 traffic opened up? your thoughts welcome). Thanks for reading and I hope someone out there finds this information useful.

Changed type Vinas Tuesday, May 5, 2015 12:53 PM not a question

Reply:

Thanks for sharing.

------------------------------------

Carl

is there any software available for Server 2008 like easy transfer?

Reply:

what do you want to transfer to 2008?File?Role?Permissions?

ADMT tool;

https://technet.microsoft.com/en-us/library/cc974332%28v=ws.10%29.aspx?f=255&MSPPError=-2147217396

Robocopy;

https://technet.microsoft.com/en-us/library/cc733145.aspx

Also use server migration tools comes with 2008 r2.

------------------------------------

SCCM 2012 - Multiple Dependent Applications no Detection of upgrade after a successfull install.

I am finding a detection problem when trying to run an Upgrade of Adobe Reader mui 10.0.11 of an previous version 10.0.6 that contains a dependence on the base install. Even though the detection method works if there is no previous versions installed. it does not work if it tries to update the 11.0.6 or the Base install of 11.0.0. I should mention that the upgrade also has a dependence of the the 11.0.0 base in case a user does not have the current base version.

The main question is does SCCM 2012 handle multiple dependent applications or is it limited to one?

Is there another way to run continuous step upgrades of products and have at the end a dependency of the core/Base install?

Please get back when you can.

Gary AlexionIT

[Fixed] US Gov't CaC Cards Not Recognized

As of build 9860, this issue is fixed!

---------------------------------------------------

// I have already posted this using the formal feedback tool //

Windows 10 Technical Preview for Enterprise does not properly read US Government CaC cards. Windows 7, 8, and 8.1 natively could sans any third party applications. It's not a reader or hardware issue as the same CaC card was used on the same hardware with Windows 8.1 (just a couple of days ago prior to installing Windows Technical Preview for Enterprise).

Changed type DarienHawk67 Tuesday, November 4, 2014 8:01 PM
Edited by DarienHawk67 Tuesday, November 4, 2014 8:03 PM

Reply:

DarienHawk67,

If you have more than one type of smart card reader, try using it instead of the current one. It's possible that it's a compatibility issue with the reader itself.

You could also try manually reinstalling the smart card reader driver. Make sure you use the latest driver available for Windows 8.1.

Hope this helps!

Mike

Windows Outreach Team – IT Pro

Windows for IT Pros on TechNet

------------------------------------
Reply:

I've done that. One three separate machines with different smart card readers (laptops with internal readers and with external readers), Windows 10 Technical Preview fails to properly see DoD CaC certificates on the card. Windows 7, 8, and 8.1 natively can recognize the cards and import the certificates into the user's personal certificate store. According to device manager, all of the drivers are installed and the device is properly working.

It's import to keep in mind that this is based on a clean install. I will have to see if using a third-party middleware application--in our case ActivClient 6.2.195 or ActivClient 7.0.2--has the same results.

Edited by DarienHawk67 Saturday, October 11, 2014 9:35 PM

------------------------------------
Reply:

I have a Gemalto reader and it comes up with all versions of Windows fine.

What card reader are you using, you may need to manually find drivers

Place your rig specifics into your signature like I have, makes it 100x easier!

Hardcore Games Legendary is the Only Way to Play!
Vegan Advocate How can you be an environmentalist and still eat meat?

Edited by Carey FrischMVP, Moderator Sunday, October 12, 2014 10:22 PM Remove annoying graphic

------------------------------------
Reply:

// I have already posted this using the formal feedback tool //

Windows 10 Technical Preview for Enterprise does not properly read US Government CaC cards. Windows 7, 8, and 8.1 natively could sans any third party applications. It's not a reader or hardware issue as the same CaC card was used on the same hardware with Windows 8.1 (just a couple of days ago prior to installing Windows Technical Preview for Enterprise).

A couple of things to check:

With the card inserted into the reader, does the card itself show in Device Manager?
Again with the card inserted, run certutil -scinfo and post the results.

------------------------------------
Reply:

// I have already posted this using the formal feedback tool //

Windows 10 Technical Preview for Enterprise does not properly read US Government CaC cards. Windows 7, 8, and 8.1 natively could sans any third party applications. It's not a reader or hardware issue as the same CaC card was used on the same hardware with Windows 8.1 (just a couple of days ago prior to installing Windows Technical Preview for Enterprise).

A couple of things to check:

With the card inserted into the reader, does the card itself show in Device Manager?
Again with the card inserted, run certutil -scinfo and post the results.

If you look at the screenshot, the card is not being shown at all in the OP's device manager

mine shows as smart card device

Gemalto again, at least with my personal setup

so I am wondering what reader and what card is being used, he may need new drivers

Gemalto is what most ATM machines use today, at least what I have seen

Edited by Carey FrischMVP, Moderator Sunday, October 12, 2014 10:22 PM Remove annoying graphic

------------------------------------
Reply:

If you look at the screenshot, the card is not being shown at all in the OP's device manager
mine shows as smart card device

Gemalto again, at least with my personal setup

so I am wondering what reader and what card is being used, he may need new drivers

Gemalto is what most ATM machines use today, at least what I have seen

'

I did look at the screenshot. I do this for a living. If the card is not inserted, there won't be a Smart Card node in Device Manager.

The vendor for debit and credit cards obviously has nothing at all to do with this thread.

------------------------------------
Reply:

I did not recognize the reader brand

you need additional software with my reader to read bank cards

my reader is flexible, it can do access control too

like opening doors etc or even internet card present transactions

Edited by Carey FrischMVP, Moderator Sunday, October 12, 2014 10:22 PM Remove annoying graphic

------------------------------------
Reply:

I did not recognize the reader brand

my reader is flexible, it can do access control too

like opening doors etc or even internet card present transactions

Which proves my point that you really shouldn't be involved in troubleshooting this issue. O2 Micro, along with Broadcomm are probably the two most widely used smart card reader chipsets currently in use for integrated readers.

That must be quite the magical smart card reader you have if the reader, rather than the card, is able to unlock doors.

I'm going ask politely, even though I know that it is probably futile, to leave troubleshooting this issue to those of us who actually do smart card and PKI deployments. The simple fact that you may have a card and a reader, and that you may use them, does not qualify you to be able to troubleshoot this problem. I use applications and programs daily but I would never presume to help troubleshoot a programming problem.

------------------------------------
Reply:

I will leave this to somebody who has other card readers and cards, as mine work.

The OP should contact the vendor for their hardware seeking updated drivers

Edited by Carey FrischMVP, Moderator Monday, October 13, 2014 1:17 AM Remove annoying graphic

------------------------------------
Reply:

I will leave this to somebody who has other card readers and cards, as mine work.

The OP should contact the vendor for their hardware seeking updated drivers

This likely has nothing at all to do with drivers. It is more likely a trust problem with the certificate(s) on the card and/or a cryptographic service provider problem.

BTW - thanks Carey. :-)

------------------------------------
Reply:

when I insert a valid card, it comes up normally

a bank card shows as a device but with no working drivers, but the class is recognized

when I installed software for the bank it worked fine, that is due to the security layers banks up here use for protecting chip and pin cards

Edited by Carey FrischMVP, Moderator Wednesday, October 15, 2014 1:14 AM Removed distracting graphic

------------------------------------
Reply:

Let me add some additional detail. There is nothing wrong with the reader(s). All of them work properly with Windows 7, 8, 8.1 (and the server variants). It's not, probably not, a driver issue as the card itself is recognized.

For those who may not know, U.S. Gov't CAC (Common Access Card) differs slightly from typical smart cards. The post was to inform that Windows 10 Technical Preview for Enterprise (in it's early release iteration as it stands now) does not properly recognize CAC cards and is currently unable to read and import the certificates into the user's certificate store.

This is feedback for the Windows team to let them know what is happening in the real world. This may be something MSFT already knows about. By no means am I worried as I am 100% sure this will be fixed and addressed with a later update or release.

------------------------------------
Reply:

Thanks for posting that screenshot, it clarifies everything

indeed it looks like the card is being rejected for one reason or another

that means could be server related or certificate etc

maybe your certificate authority can enroll the card fresh?

Edited by Carey FrischMVP, Moderator Wednesday, October 15, 2014 1:14 AM Removed inappropriate graphic

------------------------------------
Reply:

With build 9860, this issue is fixed and no longer a problem!

------------------------------------
Reply:

With build 10049 this problem persist again :( Virtual smart cards are also affected.

Edited by Deyan N. Kochev Tuesday, May 5, 2015 11:22 AM

------------------------------------

Office 360

How can I open my multi Office 360 on different devices? Now where on your account can you set-up and one digit code, even though it tells you, you can open everything with one code!

Changed type Vivian_Wang Monday, May 11, 2015 8:16 AM

Reply:

Hi,

Did you mean Office 365?

If yes, i think you could ask in Office 365 forums:

http://community.office365.com/en-us/f/default.aspx

Regards.

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com

------------------------------------

Feature Request: Keyboard shortcuts for Zoom in/out

One of the best new features of recent versions of Internet Explorer is the ability to do full-page zoom using [CTRL] + [Mouse Scroll Wheel] or [CTRL] + [+] or [-].

PLEASE consider adding [CTRL] + [+] or [-] zoom in/out capability for all us laptops users without mouse scroll-wheels.

Richard Turner www.bitcrazed.com

Changed type David Wolters Thursday, April 14, 2011 8:00 PM This is not a question.

Reply:

On Thu, 14 Apr 2011 18:57:44 +0000, Richard Turner [BitCrazed] wrote:

One of the best new features of recent versions of Internet Explorer is the ability to do full-page zoom using [CTRL] + [Mouse Scroll Wheel] or [CTRL] + [+] or [-].

PLEASE consider adding [CTRL] + [+] or [-] zoom in/out capability for all us laptops users without mouse scroll-wheels.

You can set this up for yourself. First add these macros to a module in your
Normal.dot template (or Normal.dotm for Word 2007 or 2010):

Sub ZoomIn()
If ActiveWindow.View.Zoom < 450 Then
ActiveWindow.View.Zoom = ActiveWindow.View.Zoom + 10
End If
End Sub

Sub ZoomOut()
If ActiveWindow.View.Zoom > 20 Then
ActiveWindow.View.Zoom = ActiveWindow.View.Zoom - 10
End If
End Sub

Then go to the Customize Keyboard dialog and assign the Ctrl+[+] shortcut to
the ZoomIn macro, and Ctrl+[-] to the ZoomOut macro.

The macros change the zoom by 10% with each press of the shortcut. If you want
a larger or smaller increment, change the number 10 in each macro.

Jay Freedman
MS Word MVP FAQ: http://word.mvps.org

------------------------------------
Reply:

Thanks for the suggestion Jay. I've used similar techniques in the past, but it's a PITA to have to carry such scripts forward across all the machines under one's control ... and harder still to make these changes consistenly in environments where one does not have full control.

I still believe that such a fundamental feature as document zooming, which warranted a new UI (slider) element, deserves an appropriate keyboard shortcut that's consistent with other popular apps such as IE.

Richard Turner www.bitcrazed.com

------------------------------------
Reply:

You dont even have to do that. You can just hold down CTRL and scroll anywhere and it will zoom in and out. You can do it in any window, in any program and it will work. I think it is a feature of windows, not of the individual programs.

Or get a wireless mouse with a scroll wheel for your laptop.

Edited by _lhart_ Thursday, November 17, 2011 9:48 PM

------------------------------------
Reply:

How do I scroll on a laptop without a mouse?

Every time I have to take my hands off my keyboard, I lose productivity.

There are many of us who enjoy a significant productivity boost from learning keyboard shortcuts for many of the most frequently performed actions (especially in Ribbonized UI such as Office 2007+ and Windows 8). Not having the ability to zoom in & out via keyboard shortcuts (consistent with other popular apps/experiences) is a hindrance and VERY annoying once you've tried [CTRL] + [+] or [-] in IE/Chrome/FF/etc.

Richard Turner www.bitcrazed.com

------------------------------------
Reply:

Richard Turner [Bitcrazed] wrote:

How do I scroll on a laptop without a mouse?

Richard Turner www.bitcrazed.com

That depends on what you have instead of a mouse. You can certainly scroll with a touchpad.

Stefan Blom, Microsoft Word MVP

------------------------------------
Reply:

That depends on what you have instead of a mouse. You can certainly scroll with a touchpad. Stefan Blom, Microsoft Word MVP

But not with most pen tablets. And touchpads are a PITA for scrolling too if you want to keep your hands on the keyboard. And so on. Honestly, it's becoming almost as standard a set of shortcuts as Ctrl-X/C/V these days -- what's so hard about including it that it eludes the Office devs? It's a trivial addition that would make a lot of users happy.

------------------------------------
Reply:

What David said.

IE Chrome, etc. support font-zooming with [CTRL] + [+]/[-]. Visual Studio now also supports font-zooming albeit with [CTRL] + [<]/[>] (grrr).

It'd be AWESOME if Office were to recognize that people are now using a wider variety of screen sizes @ different DPI levels and that zooming in using a consistent keyboard key chord would be enormously valuable to many users. For example:

I have a Sony Vaio Z Series which doesn't support pinch-zoom.

I also have a MacBook Pro running Win8 which does support pinch-zoom.

Don't forget my SurfaceRT with a trackpad that also supports pinch-zoom, albeit in a very small area. And like my Samsung Series7 slate, both have touch-screens so I can pinch-zoom, but once again I am taking my hands off the keyboard and losing productivity.

Richard Turner www.bitcrazed.com

------------------------------------
Reply:

Dude! thanks so much. I've been wanting this for two or three years now. All other applications that I use do it by default, so I'm constantly trying to zoom but instead I'm typing random symbols. :o)

------------------------------------
Reply:

Hello,

thank you Jay Freedman for the macros. They work great in Word 2010.

Is it possible to get the macros working in Outlook 2010 for the Message text?

a) Navigation Pane Normal and Reading Pane Bottom/Right

b) Message/E-Mail opened in second Window

c) Writing a new Message/E-Mail

References:

https;//msdn,microsoft,com/en-us/library/office/ff834873(v=office.14).aspx

For b) and c) I found the following thread where they use the "Microsoft Word 14.0 Object Libary" as reference:

https;//social,technet,microsoft,com/Forums/office/en-US/46ca9a02-fdb8-4f59-b2bc-e699b244b240/outlook-2010-preview-pane

Then I added my functions to change the zoom level while writing a new Message/E-Mail:

Option Explicit  Dim WithEvents objInspectors As Outlook.Inspectors  Dim WithEvents objOpenInspector As Outlook.Inspector  Dim WithEvents objMailItem As Outlook.MailItem    Private Sub Application_Startup()   Set objInspectors = Application.Inspectors  End Sub    Private Sub Application_Quit()   Set objOpenInspector = Nothing   Set objInspectors = Nothing   Set objMailItem = Nothing  End Sub    Private Sub objInspectors_NewInspector(ByVal Inspector As Inspector)  If Inspector.CurrentItem.Class = olMail Then   Set objMailItem = Inspector.CurrentItem   Set objOpenInspector = Inspector  End If  End Sub    Private Sub objOpenInspector_Close()   Set objMailItem = Nothing  End Sub    Private Sub objOpenInspector_Activate()   Dim wdDoc As Word.Document   Set wdDoc = objOpenInspector.WordEditor   wdDoc.Windows(1).Panes(1).View.Zoom.Percentage = 100  End Sub        ' My functions  Private Sub ZoomIn()   Dim wdDoc As Word.Document   Set wdDoc = objOpenInspector.WordEditor   If wdDoc.Windows(1).Panes(1).View.Zoom.Percentage < 450 Then   wdDoc.Windows(1).Panes(1).View.Zoom.Percentage = wdDoc.Windows(1).Panes(1).View.Zoom.Percentage + 10   Else   MsgBox "Maximum Zoom level reached"   End If  End Sub     Private Sub ZoomOut()   Dim wdDoc As Word.Document   Set wdDoc = objOpenInspector.WordEditor    If wdDoc.Windows(1).Panes(1).View.Zoom.Percentage > 20 Then   wdDoc.Windows(1).Panes(1).View.Zoom.Percentage = wdDoc.Windows(1).Panes(1).View.Zoom.Percentage - 10   Else   MsgBox "Minimum Zoom level reached"   End If  End Sub    Private Sub ZoomDefault()   Dim wdDoc As Word.Document   Set wdDoc = objOpenInspector.WordEditor   wdDoc.Windows(1).Panes(1).View.Zoom.Percentage = 100  End Sub    Sub GetZoomLevel()   Dim z As Integer   Dim wdDoc As Word.Document   Set wdDoc = objOpenInspector.WordEditor   z = wdDoc.Windows(1).Panes(1).View.Zoom.Percentage   MsgBox "Current Zoom level: " & z & "%"  End Sub  ' My functions end

Finally I added my 4 functions to the "Quick Access Toolbar" of and existing and a new Message/E-Mail and assigned 4 icons.

Edited by blueice_haller Tuesday, May 5, 2015 12:37 PM

------------------------------------

Passing Password in Powershell script

I have to pass password in the powershell script.

currently i am using CreditSSP and password storing in secure sting in the disk .

Is there any way to read password from schedule task configuration or SSO or windows authentication

Reply:

Hi,

Password can be easily obtained from PSCredential object using
GetNetworkCredential method:

$PlainPassword = $Credentials.GetNetworkCredential().Password

For more details, please go through the below two articles:

Working with Passwords, Secure Strings and Credentials in Windows PowerShell

http://social.technet.microsoft.com/wiki/contents/articles/4546.working-with-passwords-secure-strings-and-credentials-in-windows-powershell.aspx

Decrypt PowerShell Secure String Password

http://blogs.technet.com/b/heyscriptingguy/archive/2013/03/26/decrypt-powershell-secure-string-password.aspx

Regards,

Yan Li

TechNet Subscriber Support

If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Regards, Yan Li

Edited by Yan Li_ Tuesday, November 12, 2013 6:35 AM edit

------------------------------------
Reply:

OP requested for Integrated Windows Authentication. Requirement is to get the service account credentials and and run the same in task scheduler

Regards Chen V [MCTS SharePoint 2010]

------------------------------------
Reply:

Thank you, your link really helped me!

Dennis Hobmaier, MCSE SharePoint Blog: www.hobmaier.net

------------------------------------

How to enable database journalling for standard users

Dear All,

i have exchange 2010 and require to enable database journalling. please help

Sunil

SUNIL PATEL SYSTEM ADMINISTRATOR

Reply:

Hi Sunil,

1.Create a new mailbox for journal.

2.Then go to EMC--->Organisation configuration --->mailbox --->Right click the database -->properties ->maintenance--->check the box "journal recipient" and browse the mailbox for journal.

Thanks & Regards S.Nithyanandham

------------------------------------

MS DTC not coming online on SQL Server 2008 R2 failover cluster

Dear Experts,

On a SQL Server 2008 R2 failover cluster, MS DTC cluster service is not coming online. It fails with below error message.

"The DTC cluster resource's log file path was originally configured at: E:. Attempting to change that to: M:. This indicates a change in the path of the DTC cluster resource's dependent disk resource. This is not supported. The error code returned: 0x8000FFFF".

From the Component Services, we can see under the clustered DTCs, in the properties of the log file that it is configured for E drive. The 'Transaction list' and 'Transaction Statistics' are empty. When I try to change the log file path to point to M drive I get this warning message.

"An MSDTC log file already exists in the selected directory. Resetting an existing MS DTC log file may cause your databases and other transactional resource managers to become inconistent. Please review the MSDTC Administrator's manual before proceeding. Do you wish to reset the existing MS DTC log"

Could you please advise if this is safe to proceed with this warning as the 'Transaction list' and 'Transaction Statistics' are empty or would it cause any other issue.

Thanks,

Reply:

Any thoughts please?

------------------------------------
Reply:

Second opinion advised:

I do not think from windows server 2008 on wards, there is no need to have clustered MSDTC, enabling local DTC on all nodes should work fine. I remember reading this recently.

also, enabling new MSDTC log and restarting should be okay if there are no currently running distributed transactions.

I guess, you have MSDTC for entire cluster....

Again, please get second opinion. i personally, have not faced this issue.

Hope it Helps!!

------------------------------------

Easy and True solution

This equation has not been solved since 1930 when it was made. The equation is for engineers to design pipes. But I want lots of folks to learn the equation because they will learn the easy and true solution because of the Log function.

There are two numbers that are needed for engineers.
Rr is between 0.00004 and 0.05
Re is between 2,500 and 10,000,000

The solution is to solve the f.

Her is the equation 1/sqrt(f) = -2*Log(Rr/3.7 +2.51/(Re*sqrt(f)))

But the equation can be changed to 1/sqrt(f) = -2*Log(Rr/3.7 +2.51/Re*1/sqrt(f)) and then change the 1/sqrt(f) to X and solve for the X. So the equation is X = -2*Log(Rr/3.7 +2.51/Re*X)

The easy solution is to Guess (about 1 to 10) and X in a cell and below it type = -2*Log(Rr/3.7 +2.51/Re*X), but enter the Rr and Re numbers but for the X, just point to the Guess X. Then format the equation to about 16 digits and then copy that equation to about 20 cells below, and the X will be using the previous cell that was the solving of the next X. Then before the 20th cell the solution for X will stop changing. You can change the Guess X and the last solution will not not change.

The to compute the f it is =1/X/X, (just below to 20th cell) and for the X just point to the bottom cell. You can change the Rr and Re in the cell below the Guessed X and copy the new equation down to the last X, (and the X will change) and the f will still be 1/X/X.

An almost one about 1,000 engineers in the world have learned this is an Easy and True

This is Harrell Geron, and engineer for almost 40 years.

Ragknot

Changed type George123345 Tuesday, May 5, 2015 2:57 AM Experience Sharing

Reply:

Hi Harrell Geron,

Thanks so much for sharing this. It's really valuable. Thanks again.

Regards,

------------------------------------

Why you shouldn't download/purchase Windows 10

1. When you download Windows 10 Technical preview on your laptop you can't rollback

2. Wanna play fullscreen games? Too bad, when you start a game windows will be a D***, You will be thrown out of the game and when you want to get in the game again, the same thing happens again.

3. Wanna reset Windows 10? You can but you can't access the start menu again.

End results, Windows 10 Sucks, you should keep it with Windows xp, Vista, 7, 8 or 8.1 before you're stuck in it forever.

For me it is too late

Reply:

you should have read this Before you install windows 10 technical preview, If you want to go back to your previous operating system.

------------------------------------

MDT 2013 Update 1 Preview - Windows ADK RC for Windows 10 available

Hello and greetings from Portugal!

For everyone testing out MDT 2013 Update 1 Preview and Windows 10 Insider Preview build 10074, I think this can be useful.
Microsoft launched Windows ADK Release Candidate for Windows 10 and I hope this will work with build 10074.

Here's the direct download link:
Windows ADK RC for Windows 10 (direct download)
Windows ADK RC for Windows 10 (more info)

:: Geeking Around Technological World :: | http://front-slash.blogspot.com

Windows 7 clients not honoring screen saver timeout group policy setting

I searched around to see if this had been posted already but no luck. Others seem to have this problem but I have yet to find a workable solution. I believe this post provides one but have only had the opportunity to test on a small number of Windows 7 machines.

Today I was tasked with creating a GPO that would lock a workstation after 10 minutes of inactivity and require authentication to return access to the Desktop. So I enabled and configured the following policies under "User Configuration\Policies\Administrative Templates\Control Panel\Personalization"

"Enable Screen saver" to Enabled
"Prevent changing screen saver" to Enabled
"Password protect the screen saver" to Enabled
"Screen saver timeout" to Enabled
"Force specific screen saver" to Enabled with the executable name "Mystify.scr"

After running "gpupdate /force" I found that almost all of these settings had been honored except for the timeout. I used the group policy results wizard to confirm that the policy was being applied to the machine but still no dice. After some testing I discovered that it was still using the timeout value that had been configured before I had configured the group policy. So it seemed to be holding on to the old timeout value.

After some more research I found that there actually two registry keys that set the screen saver timeout value. "HKCU\Control Panel\Desktop\ScreenSaveTimeOut" is the registry entry that's created when a user configures a timeout value manually. "HKCU\Software\Policies\Microsoft\Windows\Control Panel\Desktop\ScreenSaveTimeOut" is the registry entry that the group policy sets. When both values are present, the user configured setting seems to take precedence. This seems to only be true for the timeout value (i.e. when I make the values for "SCRNSAVE.EXE" conflict, the group policy configured value takes precedence).

So my solution to the problem was to simply create a group policy that deletes HKCU\Control Panel\Desktop\ScreenSaveTimeOut. After the workstation is rebooted, the timeout value set by group policy is honored. Again my testing of this solution is limited to handful of Windows 7 workstations, but so far I have not found any adverse effects.

Attention All T-SQL Gurus! Time to SPRING Into Action!

April fools out of the way, now let's find an April genius!

The name "April" is derived from the Latin verb "aperire", meaning "to open", as it is the season when trees, flowers AND MINDS start to open! And.. I can't wait to OPEN and read this month's community contributions! (groan, tenuous link!)

Things are indeed heating up around TechNet. The Wiki has become a shining example of what the community has to offer, and talent is SPRINGING FORTH from all corners of our garden of knowledge.

If you can find the time to enrich us with your latest revelations, or some fascinating facts, then not only will you build up a profile and name for yourself within the gaze of Microsoft's very own glitterati, but you will be adding pages to the most respected source for Microsoft knowledge base articles. This could not only boost your career, but would benefit generations to come!

So don't be an April fool. Please realise the potential of this platform, realise where we are going, and join us in growing this community, learning more about you, and opening the minds of others!

All you have to do is add an article to TechNet Wiki from your own specialist field. Something that fits into one of the categories listed on the submissions page. Copy in your own blog posts, a forum solution, a white paper, or just something you had to solve for your own day's work today.

Drop us some nifty knowledge, or superb snippets, and become MICROSOFT TECHNOLOGY GURU OF THE MONTH!

This is an official Microsoft TechNet recognition, where people such as yourselves can truly get noticed!

HOW TO WIN

1) Please copy over your Microsoft technical solutions and revelations to TechNet Wiki.

2) Add a link to it on THIS WIKI COMPETITION PAGE (so we know you've contributed)

3) Every month, we will highlight your contributions, and select a "Guru of the Month" in each technology.

If you win, we will sing your praises in blogs and forums, similar to the weekly contributor awards. Once "on our radar" and making your mark, you will probably be interviewed for your greatness, and maybe eventually even invited into other inner TechNet/MSDN circles!

Winning this award in your favoured technology will help us learn the active members in each community.

Feel free to ask any questions below.

More about TechNet Guru Awards

Thanks in advance!
Pete Laker

#PEJL
Got any nice code? If you invest time in coding an elegant, novel or impressive answer on MSDN forums, why not copy it over to TechNet Wiki, for future generations to benefit from! You'll never get archived again, and you could win weekly awards!

Have you got what it takes o become this month's TechNet Technical Guru? Join a long list of well known community big hitters, show your knowledge and prowess in your favoured technologies!

Reply:

1 article so far:

Extending DATEADD Function to Skip Weekend Days by Emiliano Musso

And 2 more days to go!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------
Reply:

Hey, I know this isn't May's thread, but...

Is it permissible to re-submit an article that previously won a medal, if that article has been overhauled?

Thanks!

Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.

Edited by Patrick Hurst Wednesday, May 6, 2015 5:37 PM

------------------------------------
Reply:

Hey, I know this isn't May's thread, but...

Is it permissible to re-submit an article that previously won a medal, if that article has been overhauled?

Hi,

No you cannot submit an article which has already been judged you can create a different fresh article(dealing with same scenario as previous one) with some different name like part2, continued When you do so you put note that this is extension of previous on with some more information.

I will wait for Ed to comment on this

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Wiki Article
MVP

------------------------------------

Summary On Special Groups

Hi,

Suppose I have a table like:

Date	Cust_ID	Region	Sale	Discount
14-Jan-15	Cust_ID_1	Head_Office	8951	805.59
20-Jan-15	Cust_ID_5	Head_Office	6682	801.84
20-Feb-15	Cust_ID_4	Head_Office	3567	0
09-Mar-15	Cust_ID_1	Head_Office	5708	456.64
10-Mar-15	Cust_ID_5	Head_Office	253	15.18
15-Mar-15	Cust_ID_6	Head_Office	2215	110.75
27-Mar-15	Cust_ID_1	Head_Office	2789	27.89
29-Jan-15	Cust_ID_4	Region_1	4771	381.68
09-Jan-15	Cust_ID_2	Region_2	6765	0
07-Feb-15	Cust_ID_4	Region_2	1333	13.33
05-Mar-15	Cust_ID_4	Region_2	181	0
13-Mar-15	Cust_ID_2	Region_2	7119	0
24-Mar-15	Cust_ID_2	Area_2a	4463	267.78
25-Apr-15	Cust_ID_2	Area_2a	356	7.12
02-May-15	Cust_ID_3	Area_2a	4884	488.4
24-Mar-15	Cust_ID_5	Region_3	3316	132.64
04-Apr-15	Cust_ID_2	Region_3	485	0
14-Apr-15	Cust_ID_3	Area_2b	1933	19.33
20-Apr-15	Cust_ID_3	Area_2b	6804	0
20-Apr-15	Cust_ID_2	Region_3	1636	0
03-May-15	Cust_ID_5	Region_3	4933	0

In this case I need to derive a special summary to check out the Sales made & Discount offered to the customers which Only and Only purchased from the Head Office and, similarly for those who purchased from anywhere. In simple words an output of a table resulted in the following form with Totals too:

		Only Head_Off.	All Others
Cust_ID_1	Sales	17448	0
Cust_ID_1	Discount	1290.12	0
Cust_ID_2	Sales	0	20824
Cust_ID_2	Discount	0	274.9
Cust_ID_3	Sales	0	13621
Cust_ID_3	Discount	0	507.73
Cust_ID_4	Sales	0	9852
Cust_ID_4	Discount	0	395.01
Cust_ID_5	Sales	0	15184
Cust_ID_5	Discount	0	949.66
Cust_ID_6	Sales	2215	0
Cust_ID_6	Discount	110.75	0
Total	Sales	19663	59481
Total	Discount	1400.87	2127.3

Thanks in advance.

Thanx in advance, Best Regards, Faraz A Qureshi

Reply:

SELECT  	Cust_ID,  	'Sales' AS [Category],  	SUM( CASE WHEN Region = 'Head_Office' THEN Sale ELSE 0 END) AS [Only Head_Off],  	SUM( CASE WHEN Region = 'Head_Office' THEN 0 ELSE Sale END) AS [All Others]  FROM  	YourTable  GROUP BY  	Cust_Id  UNION ALL  SELECT  	Cust_ID,  	'Discount' AS [Category],  	SUM( CASE WHEN Region = 'Head_Office' THEN Discount ELSE 0 END) AS [Only Head_Off],  	SUM( CASE WHEN Region = 'Head_Office' THEN 0 ELSE Discount END) AS [All Others]  FROM  	YourTable  GROUP BY  	Cust_Id  ORDER BY  	Cust_Id;

Edited by JamesKJ Wednesday, May 6, 2015 3:58 PM

------------------------------------
Reply:

Thanks James,

But the customers are to be split as:

1. Ones who only purchased from the Head_Office; and

2. All others.

Your query results also considers Cust_ID_5 and Cust_ID_6 under the Head_Office Category while they have been purchasing from other Areas/Regions too.

Thanx in advance, Best Regards, Faraz A Qureshi

------------------------------------
Reply:

Ah, I had missed that. Can you try this?

;WITH HeadOfficeOnly AS  (  	SELECT DISTINCT Cust_ID  	FROM YourTable y  	WHERE NOT EXISTS (SELECT * FROM YourTable y2 WHERE y2.Cust_ID = y.Cust_ID AND y2.Region <> 'Head_Office')  )  SELECT  	y.Cust_ID,  	'Sales' AS [Category],  	SUM( CASE WHEN c.Cust_ID IS NOT NULL THEN Sale ELSE 0 END) AS [Only Head_Off],  	SUM( CASE WHEN c.Cust_ID IS NOT NULL THEN 0 ELSE Sale END) AS [All Others]  FROM  	YourTable y  	LEFT JOIN HeadOfficeOnly c ON c.Cust_ID = y.Cust_ID  GROUP BY  	Cust_Id  UNION ALL  SELECT  	Cust_ID,  	'Discount' AS [Category],  	SUM( CASE WHEN c.Cust_ID IS NOT NULL THEN Discount ELSE 0 END) AS [Only Head_Off],  	SUM( CASE WHEN c.Cust_ID IS NOT NULL THEN 0 ELSE Discount END) AS [All Others]  FROM  	YourTable  	LEFT JOIN HeadOfficeOnly c ON c.Cust_ID = y.Cust_ID  GROUP BY  	Cust_Id  ORDER BY  	Cust_Id;

------------------------------------
Reply:

Well! Found some ambiguous names errors, but resolved the same as follows:

WITH HeadOfficeOnly AS
(
SELECT DISTINCT Cust_ID
FROM TABLE_1 y
WHERE NOT EXISTS (SELECT * FROM TABLE_1 y2 WHERE y2.Cust_ID = y.Cust_ID AND y2.Region <> 'Head_Office')
)
SELECT
y.Cust_ID,
'Sales' AS [Category],
SUM( CASE WHEN c.Cust_ID IS NOT NULL THEN Sale ELSE 0 END) AS [Only Head_Off],
SUM( CASE WHEN c.Cust_ID IS NOT NULL THEN 0 ELSE Sale END) AS [All Others]
FROM
TABLE_1 y
LEFT JOIN HeadOfficeOnly c ON c.Cust_ID = y.Cust_ID
GROUP BY
y.Cust_Id
UNION ALL
SELECT
y.Cust_ID,
'Discount' AS [Category],
SUM( CASE WHEN c.Cust_ID IS NOT NULL THEN Discount ELSE 0 END) AS [Only Head_Off],
SUM( CASE WHEN c.Cust_ID IS NOT NULL THEN 0 ELSE Discount END) AS [All Others]
FROM
TABLE_1 y
LEFT JOIN HeadOfficeOnly c ON c.Cust_ID = y.Cust_ID
GROUP BY
y.Cust_Id
ORDER BY
y.Cust_Id;

Thanks again!

Thanx in advance, Best Regards, Faraz A Qureshi

------------------------------------
Reply:

Strange! Can't find the usual Mark As Answer link? Shall click the same as soon as I find the same refelecting so.

Thanx in advance, Best Regards, Faraz A Qureshi

------------------------------------

Asignar permisos de administracion en un solo equipo de Active Directory?

Hola amigos buenos dias, pues basicamente una persona externa va a realizar tareas de instalacion sobre uno de los servidores, pero quisiera saber si es posible que esos apliquen unicamente para ese servidor y no para ingresar en los demas servidores del Directorio.

Gracias, quedo atento a sus comentarios o sugerencias.

Reply:

Hola

De casualidad es un RODC? En los rodc hay algo llamado Administrator Role Separation con lo que podrias lograr lo que quieres..

Si es un RWDC tendrias que darle domain admin para que pueda instalar cosas o en mi caso cuando alguien tenia que instalar cosas en algun DC.. El vendor tenia que enviarme un documento paso a paso y lo mas facil de seguir/entender de tal manera que yo lo pudiera hacer.. O haciendolo yo mientras el vendor solo daba instrucciones por telefono mientras le compartia pantalla

Saludos

Joaquin Camarero Muñoz

Edited by Joaquin Camarero Muñoz Thursday, March 6, 2014 5:09 PM

------------------------------------
Reply:

Hola

De casualidad es un RODC? En los rodc hay algo llamado Administrator Role Separation con lo que podrias lograr lo que quieres..

Si es un RWDC tendrias que darle domain admin para que pueda instalar cosas o en mi caso cuando alguien tenia que instalar cosas en algun DC.. El vendor tenia que enviarme un documento paso a paso y lo mas facil de seguir/entender de tal manera que yo lo pudiera hacer.. O haciendolo yo mientras el vendor solo daba instrucciones por telefono mientras le compartia pantalla

Saludos

Joaquin Camarero Muñoz

Gracias joaquin!

------------------------------------
Reply:

Si ese servidor no es un controlador de dominio, dale acceso con grupos locales de ese propio server.

Si es un DC y necesita permisos especificos en concreto prueba con la opcion de delegacion de tareas a ese usuario.

Saludos

------------------------------------
Reply:

Se soluciono tema?

Saludos,

Edwin Duran Ospina _____________________________________________ Si la respuesta ha sido la solución, favor marcarla.

------------------------------------
Reply:

Se soluciono tema?

Saludos,

Edwin Duran Ospina _____________________________________________ Si la respuesta ha sido la solución, favor marcarla.

Desearía hacerlo pero no tengo la opcion para marcarlo como respuesta.

Saludos! :)

Luis Avila Sotelo

------------------------------------

Mail app: Account unavailable

Im having problems with the mail app in windows 8 in regards to sending.

I have multiple accounts setup via Imap/smtp from my company website. The issue is when I send an email it says "email address" is unavailable. It seems to be syncing mail and folders without any issues.

The account is setup with "outgoing server requires authentication" and I have tested using the same settings in outlook which does in fact work without any problems.

I have tried deleting/re-adding the account. Uninstalling/reinstalling mail and even reinstalling windows and running all available updates for both store and windows.

Any help on the matter would be greatly appreciated.

Kind regards,
simon

Changed type Arthur Xie Friday, December 7, 2012 4:07 AM

Reply:

I'm having the same issue; looking forward to an answer as well, thanks!

------------------------------------
Reply:

I'm having the same problem. It looks like the Mail app is half baked as it cannot work with POP and has problems with some IMAP setups but offers no useful information regarding the difficulty. Microsoft support proposed linking my IMAP account with my hotmail account, an action I deemed unacceptable.

Bill B

------------------------------------
Reply:

To add an IMAP account to Mail:

1.On Start, tap or click Mail.

2.Swipe in from the right edge of the screen, and then tap Settings.
(If you're using a mouse, point to the upper-right corner of the screen, move the mouse pointer down, and then click Settings.)

3.Click Accounts.
4.Click Add an account.
5.Select Other account.
6.Select IMAP.
7.Click Show more details
8.Enter your email address and password and related account data as provided from your email provider.

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:

This does not help in regards to my question, it's not adding an account that's the problem. Its the fact that the mail app shows account as unavailable when trying to send an email.

------------------------------------
Reply:

I agree Bill, linking to another account is of no use to me.

------------------------------------
Reply:

I am having the same issue. I have been in touch with Windows support and they don't seem to have a knowledge base that references this issue. There is definitely something wrong with the mail app. I have done a clean install and still the app won't sync my mail after the first time or two.

------------------------------------
Reply:

Arthur,

Did you even read the question? I'm having the same problem. I have to re-start the mail app to get it to re-sync on my Surface Windows RT tablet. Surely this is an important problem, is it not?

Thanks,

Dan

------------------------------------
Reply:

Hi, same issue here. Accessing servers with self-signed certificates or certificates issued by an untrusted CA may give this problem. I've seen this myself and other people have reported it as well. In this case explicitly trusting the certificate solved the problem.

However, there are cases where certificates are not the issue. I have two Windows 8 installations with the same live account and Mail app configuration (one Exchange account, one secure IMAP, Hotmail and Gmail). On one system all 4 accounts work fine, on the other one only Hotmail and Gmail work.

I've checked everything, deleted and recreated the accounts several times, but nothing. I've also opened the standard IMAP port instead of the secure port for one of the accounts, but the error is still there, therefore I don't think it's related to the certificates.

Is the Mail app logging anything anywhere?

Alberto

------------------------------------
Reply:

I have the same problem, receiving works fine, sending doesn't anymore as it worked fine before. In my case it happens with my hosting/domain mail account.

The only thing that works for me to send my e-mails is using my ISP"s smtp settings.
But now I can only send mails when í'm on my ISP's network and therefore i want it solved

I did some hours of troubleshooting, things like:
Checked settings over 10 times (why, i'm not an idiot lol)
Changed settings (other ports, other password, ssl/no sll, changed server name (virtual so from mail.... to mail11... and into the IP)
Contacted my hosting to report / double check however outlook in win8 and my mobile works fine with the same setup/settings.
Enabled telnet and did some sessions, all fine...
Removed NIS2013 and also reinstalled again (it's needed for my job ;))
Used the netstat command, nothing wrong
Clean boot (msconfig)

Research on internet (technet, ms answers, ...) I found a lot more posts...
There are some tips like remove the mail app / reinstall, add the full imap/smtp name if you hosting is using virutal servers (example: change mail.domain.com into mail32.domain.com) that worked in some cases.

So, either their is an issue within Win8 / Mail App or we have the same software / app that is causing this problem, for example we are all using office 2013 preview, AV/Firewall sofware NIS, ... or it's our ISP as the mail app connection could be blocked.

Edited by Svenny1981 Friday, November 9, 2012 11:57 PM

------------------------------------
Reply:

Same problem here. My mail updated the day I upgraded to Windows 8, but is stuck on that day. I composed an email to a client and hit send, not realizing it did not send until almost a week later. Great!

Please fix this!

Edited by Broncostu Saturday, November 10, 2012 3:36 PM

------------------------------------
Reply:

I've solved at least the problem with connecting to the Exchange server. I share it here in case you hit the same issue.

When an Exchange account is configured in the Windows 8 Mail it is registered in Exchange as a "Phone" connection. Why this is so is beyond me. A few days ago I started receiving notifications from my Exchange server that I had hit the maximum allowed number of phone associations with my mail account. I didn't check it until today and indeed in OWA/Options/Phone I had ten registered connections, one from my Windows Mobile Phone and 9 "WindowsMail" connections! I deleted them and now I can connect again to Exchange. Apparently, every time Windows Mail is configured to access Exchange a Phone association is created. Over the past few months I have installed and reinstalled various Windows 8 betas, RTMs, laptops, desktops, etc. and I hit the limit.

Why is Windows Mail a phone connection???

Alberto

------------------------------------
Reply:

I am not sure if this will help you, but I have a couple of IMAP accounts, an exchange account and a couple of gmail accounts, I noticed that after I connected the exchange account one of my IMAP accounts started to be "unavailable" I was still getting emails but I couldn't send them, then I remember that after connecting the exchange account the app prompted me to agree to an increased security level required by the exchange server and that is what seems to have messed up my IMAP accounts, my email service supports SSL (that I was not using) and I change the account configuration to use it and started working. I find it strange that it would fail by the security but not prompt me of the problem just say that the account is unavailable.

I am not as knowledgeable with email as I would hope, but I hope it helps.

------------------------------------
Reply:

I have the same problem, suddenly, all my accounts can not sync. It say that email is unavailable. I tried to disable the function named Mail Shield in my Avast. All again work perfectly :D. So try to disable your antivirus. It may help

------------------------------------
Reply:

Seems it is a hot issue. I will report to proper department.

------------------------------------
Reply:

has there been any news regarding sending? Still havn't seen any updates or obtained any information to solve the problem.

------------------------------------
Reply:

I had the same problem.

Finally I unchecked both the authentication required and SSL fields

It worked.

------------------------------------
Reply:

Genius!

Thanks Sachin

------------------------------------
Reply:

I am having the same problem...account unavailable. It started with my outlook.com account and then a couple of days later started to impact my gmail and a couple of other POP accounts. The only account currently working is my exchange account. I tried the trouble shooter noted above. It claims to have found two issues on my machine but they did not fix the mail problem. I also tried unchecking the authentication and ssl fields to no avail. Prior to the current problems these accounts were working for over two months.

Suggestions please!

thanks,

Rob

------------------------------------
Reply:

Guys,

This issue can be resolved by just entering the correct passwords of all our registered accounts in the mail > settings > accounts

open mail app > Press start+c and click on settings Go to accounts > click on each account and change your password to actual password

It worked for me. :)

------------------------------------
Reply:

My domain host set up a different outgoing server address. Then have to uncheck "use same password for incoming/outgoing and put in new username and password. It allows you to send messages but now I've got two drafts folders and two sent folders on the account. I have another account from a different domain host and that works perfectly.

I think the whole email experience with MS has gone backwards since Outlook Express was replaced with win 7 and now win 8.

Good Luck

------------------------------------
Reply:

I think this is what happened for me as well, except that after I added an exchange account I could send from my IMAP account but not receive. I've looked all over the support forums for help, but every suggestion other than re-installing the entire app has failed and I really don't want to risk that given the issues I've had with my surface. HELP!

------------------------------------
Reply:

hi, my accounts suddenly had the issue of being unavailable on sync. i reentered my passwords and it works again now

------------------------------------
Reply:

I have similar problem, except I am setup a basic IMAP account for my company website account.

I setup all setting as per ISP instructions.

It syncs first time or two, receives fine, sends fine.

Then stops working within the fist hour, cannot send or receive: mydomain.com is unavailable.

So, removed and added account again - WORKED Fine for an hour or so then stops as before.

Nothing wrong at the server end, works in all other mail clients.

In my experience with computers in general it seems to be Mail App at fault.

------------------------------------
Reply:

It worked for me to reenter my password. There must be a bug that confuses the passwords between accounts. The microsoft account I use to log into Windows and the Gmail account use the same email but have different passwords. It pulled in all my Gmail when I first set up the account, so I had the right password initially. Then it stopped working, as if it forgot it or confused it with my Microsoft Account password.

------------------------------------
Reply:

I was having the same problem until I checked the SSL/TLS boxes in IE and then signed into my microsoft live account, I'm assuming it has to be through IE, soon as I did that I had the mail notifications come in instantly. Hope that helps

------------------------------------
Reply:

I'm also having the same issue except my smtp doesn't require passwords and it's been playing up on and off. I thought Win 8 was designed to be more user friendly?

------------------------------------
Reply:

Windows 8.1 has suddenly changed my email password to the Windows Outlook password (they are different) hence my email is now unavailable. When I follow the above advice it just continues to replace the wrong password. How do I change it?

------------------------------------
Reply:

I am having the same problem as Tamev, in that my password is being changed and then the account is marked unavailable.

I can easily see this because my actual password is 9 characters long ... so I type that in ... but then when I re-enter settings, an eight character password is there.

I would appreciate any help... thanks!!

------------------------------------
Reply:

Your Imap server settings are incorrect, and yes if you have an exchange server setup you need to delete it. I ran into this problem and just deleted all accounts and when I setup the new account I made sure the IMap server settings are correct.

imap.gmail.com

Gmail IMAP port: 993
Gmail IMAP TLS/SSL required: yes

------------------------------------
Reply:

worked a treat thank you very much

------------------------------------

Outlook 2013 "Operation Failed" with inline jpg

Symptoms:
An Outlook client receives an "Operation failed" error message in Outlook when the following conditions are true:
- The client is Outlook 2013 in online mode
- The client composes an HTML message with inline JPG images
- The client saves the message in progress to the drafts folder
- The client opens the message from the drafts folder and attempts to send or edit/change the message.

To reproduce error:

- Start new message in outlook 2013
- Insert JPG
- Save message as draft
- Open Draft and attempt to send

Ran in outlook in safe mode problem persists. Problem exists on all computers tested.

I've tried to research the issue and only find workarounds. Has anyone seen an actual fix for this?

Reply:

Found

https://support.microsoft.com/en-us/kb/2763886?wa=wsignin1.0

------------------------------------

IIS SMTP Rewriting

We have a load of apps that use an internal domain that we need to change to an external domain, i.e. anything@internal.local needs to be re-written to anything@external.com

Is there any way to get the Windows IIS SMTP Server to perform such a re-writing task? Or does anyone know of plug-ins or other software that can do this?

Changed type Vivian_Wang Tuesday, February 18, 2014 6:19 AM

Reply:

If you have Exchange server in your internal infrastructure , then you will have it "at home".

------------------------------------
Reply:

Thanks for your response.

We do have, but we're moving to 365, hence the need to do the rewriting :-)

------------------------------------
Reply:

Hi,

If you can reverse proxy for Exchange Server 2013, you can try installing Url Rewrite module and ARR module in IIS. And then you can creat url rewrite rule to achive this. For more infromation, u can refer the blog:

#IIS Application Request Routing (Part 3

http://www.msexchange.org/articles-tutorials/exchange-server-2013/mobility-client-access/iis-application-request-routing-part3.html

Hope it can help you.

Regards.

Vivian Wang

------------------------------------
Reply:

Thanks for your reply but isn't that for web domain filtering rather than SMTP?

------------------------------------
Reply:

Hi,

For more and detail information, i would suggest that you may ask in IIS forums:

http://forums.iis.net/

Regards.

Vivian Wang

------------------------------------
Reply:

Hi,

I know, this is a old post. But the solution to do this with Windows IIS SMTP Server is named Masquerade Domain.

This setting instructs the SMTP server automatically to rewrite the domain of the From address used for outbound messages. You can use this setting when you want to ensure that outgoing messages have a consistent domain name.

From IIS Manager (6.0), right-click on SMTP Virtual Server then select Properties. On Delivery tab, click Advanced button. Fullfill Masquerade Domain to the external domain.

------------------------------------

EMET 5.2 Ignores DEP Exclusion

EMET Version 5.2.5546.19547 ignores the DEP exclusion list in Window's System Properties in Performance Options under the Data Execution Prevention tab. With EMET installed; seems to overide any selected feature in this location. Even with DEP disable in EMET it still functions as ApplicationOptIn. Selecting ApplicationOptOut does not allow to opt out and behaves as AlwaysOn.

I have an app that doesn't function with DEP enabled so how do I exclude that particular app?

Edited by FireChrome Monday, April 27, 2015 8:21 AM

Reply:

Did you get any answer to this? I'm dealing with something similar. I.e. EMET DEP set to "Opt Out", app configured not to use DEP in EMET, app still crashes.

Edited by Charl13 Wednesday, May 6, 2015 1:42 PM

------------------------------------

Pasting formatted text into OWA results in plain text (no formatting) with double tilde ~~

Here is an interesting little tidbit that I haven't seen documented elsewhere:

When I first started using Outlook Web Access, I could select, copy, and then paste into an email (reply or new) any text wit formatting (font size, type, color, background, tables, etc..) and that formatting would be retained. Sometimes I didn't want the formatting, in which case, I would past the text into the cc or bcc lines and then select all and copy it back out again to remove the formatting (Ctrl-VAX)

I was helping a user setup remote access to our server, and in doing so, we ran into some problems with the "connect to computer" option not showing up. That led us to
https://social.technet.microsoft.com/Forums/en-US/9412cfa4-ff84-4d58-8871-7e0f99c7da56/ie-11-and-sbs-2008-rww?forum=smallbusinessserver

where the answer marked as an answer by the moderator who posted it was NOT helpful, but the answer from someone else, UNmarked as an answer by that same moderator, WAS helpful. This was the answer that said to:

Go to the relevant website thats failing

Right click on IE11, by the tabs and initialise the Command Bar

Click on Page and chose Compatibility View Settings (In IE11, there is no immediate compatibility view simple click)
Add the domain the the list

Click Ok and all should work as normal

And I was making the same changes on my setup as we went along just so I could see what my user was seeing although I didn't need remote web workspace as I use another service to connect to the system. However...

Since then I noticed that when I would paste formatted text into a message, it would show up without formatting, but with a pair of tilde's after it. E.g. This is a test would show up as This is a test ~~

It took a while for 2+2 to add up in my head, but as soon as I removed the server from the Compatibility list, the paste with formatting started working again.

So apparently... In IE11, at least with SBS2008, you can either have remote web workspace with connect to a computer, or you can have paste with formatting, but not both.

Changed type James Newton Tuesday, February 24, 2015 4:18 PM Already answered.

Reply:

Hi James,

Thank you for your question.

From your state, we could do the following test:

We could open OWA in local to check if the issue persist. The issue is "This is a test would show up as This is a test ~~ ";
If the issue wasn't display, I suggest we post this case to Window Server Forum.
If the issue persist, we could change other browser to check if the issue persist.

Best Regard,

Jim

------------------------------------
Reply:

Sorry Jim-Xu, I should have been more clear. There is no need for help, I was just posting because I found no other description of the issue and thought if someone was trying to paste formatted text and could not, this would explain why, and how to get that back.

I guess you could say it's an ongoing issue because you can't have it both ways. But I don't expect any answer for that.

------------------------------------
Reply:

Thanks for taking the time to post that, James. I use OWA to for access to my email on my customers' servers. A couple are running older versions of Exchange and one uses Office 365. I just started having this problem with the Exchange sites. Bloody frustrating. Once again, MS goes and undoes useful and productive functionality. I'm just trying to send a well formatted email and my effort is now doubled. Unfortunately, I need the compatibility view turned on for these older Exchange OWA sites, otherwise I am forced to use the "light" version, which doesen't support HTML formatting at all. I'm all for forward development of product lines, but it should not come at the cost of breaking older, perfectly useful and productive products. Boo... Hissss.

------------------------------------

Server stuck at please wait for windows modular installer.

Server stuck at please wait for windows modular installer. what to do...

Reply:

Reboot the server in safe mode and stop "Windows modular installer" service.Set it to manaul and then reboot the server in normal mode.See if it works.

Thanks,

Umesh.S.K

------------------------------------

unable to access TMG Server remotely

Hello guyz, i am facing a problem regarding remotely accessing to TGM server. Previously i was using teamviewer i just fwd the tv port and get access to server remotely from now anywhere.

now i decided to choose different software and for that i installed "GBridge" i follow the same procedure which i performed when tv ports. but after trying all the methods i failed. i dont know how to resolve this problem. all the available ports are allowed which used by rdp, vnc, tv. but still getting the error.

by the way Gbridge is a tunneling software (a VPN).

electrifying

Reply:

Hi,

If you start live logging , where does the traffic being cage ? default rule? Look at the source and destination whenever you are trying to access remotely.

Hope it helps.

Regards,

Calin

------------------------------------

Windows ADK SIM SIM 10.0.9933.0 refuse to create catalog of 9926 and ask to install same version 10.0.9933.0 !

After installing Windows ADK version 10.0.9933.0, I try to create catalogue of Windows 10 9926 but System Image Manager is unable to create catalog and display the error message:

Windows SIM was unable to create a catalog. For troubleshooting assistance, see topic 'Windows System Image...

This application requires version 10.0.9933.0 of the Windows ADK.

What can I do?. I really use 10.0.9933.0 version of Windows ADK!

Changed type Vivian_Wang Monday, March 9, 2015 7:32 AM

Reply:

Both are preview. Do not expect miracles. Perhaps better forum is Windows 10 Preview one.

------------------------------------
Reply:

Same problem with 10074

------------------------------------

Created a new maintenance solution

Since a while ago I wanted to start learning the DBA aspects within SQL Server and thought the best way to master these skills is creating a maintenance solution. That went a little out of hand and since then I've been writing code to learn these aspects and now it has grown to a complete solution that you can use to create backups, index maintenance, statistic maintenance and cleanup processes. I also focused some attention to the performance aspects withing SQL server and created some reports that gives you a really good insight on whats going on on your SQL servers. It comes with a lot more which you can read about on my website:

http://josjonkmans.com/solutions/maintenance

I also created a method to report the statistics and this can be downloaded to on my website after creating an account. A complete overview of all the reports can be found here:

http://josjonkmans.com/solutions/maintenance-data-warehouse

Before you start using these files keep in mind this is a very new solution and has not been tested much (not like all the years on the Ola Hallengren Solution) so you should not using it yet on your production environment (I hope to improve the product so we could get to that point but need some input from the SQL community first). The files are completely free to use but be so kind to leave your feedback so I can improve it. I have to written the code in my spare time but will try to add changes when possible. I really hope you like the products.

The source files are available on the download section on my website after you created an account (www.josjonkmans.com).

Grtz. Jos

Edited by Jos Jonkmans Tuesday, May 5, 2015 7:42 PM
Changed type Lydia ZhangMicrosoft contingent staff Thursday, May 7, 2015 5:34 AM it is not a question

Reply:

Hi Jos,

Thanks for your information.

Thanks,
Lydia Zhang

Lydia Zhang
TechNet Community Support

------------------------------------

STOP STEALING MY FOCUS

It's unreal how you guys will ensure that even OS X users get to experience the classic maddening Microsoft UX. Stop stealing my focus. Stop. Just stop. If an RDP session times out, bounce the icon. Once. DON'T TAKE MY FOCUS. I'm busy working. The last thing I need when I'm in the middle of writing an email, typing a command over SSH, or doing ANYTHING AT ALL is your app deciding to be the center of attention. Are you getting it yet?

TLDR: STOP STEALING FOCUS

Edited by Helpdesk DCI Monday, May 4, 2015 7:42 PM
Changed type MedicalSMicrosoft contingent staff Thursday, May 21, 2015 6:33 AM

Reply:

Hi,

I can understand if you think the icon keeps bouncing is annoying. However please understand that it is for reminding users that there is something happened - such as session idle, new message, error out etc.

Also it is a design comes from Apple - from my search result, it is improved in newer version of Mac OS that users just need to move pointer cross the icon to stop it, instead of having to click on it in previous Mac OS.

Please remember to mark the replies as answers if they help and un-mark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

------------------------------------
Reply:

Hi,

I can understand if you think the icon keeps bouncing is annoying. However please understand that it is for reminding users that there is something happened - such as session idle, new message, error out etc.

Also it is a design comes from Apple - from my search result, it is improved in newer version of Mac OS that users just need to move pointer cross the icon to stop it, instead of having to click on it in previous Mac OS.

Please remember to mark the replies as answers if they help and un-mark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

Did you actually read my post? I even suggested bouncing the icon. My frustrated rant/post isn't about an "annoying" animation, it's about stealing the focus of the input mechanism. That should NEVER happen. Ever. Bounce the icon? Fine. Bounce it more than once? Annoying, but fine. But the app is stealing the focus of my input. So if I'm typing in, say, Outlook, that typing (and the related flow of thoughts and attention) is completely interrupted and lost when a Remote Desktop session times out or otherwise errors. This is data loss, and it is unacceptable UX. I can think of no argument you might present to convince me otherwise, though you are welcome to try.

Edited by Helpdesk DCI Tuesday, May 5, 2015 5:57 PM

------------------------------------
Reply:

Basically, this is a bug. How do I file a bug report or get someone to do it on all users' behalf?

------------------------------------
Reply:

Update.

You can submit your suggestion here specifically for Mac OS.

https://remotedesktop.uservoice.com/forums/287834-remote-desktop-for-mac

And here are more pages:

Uservoice for iOS: https://remotedesktop.uservoice.com/forums/265183-remote-desktop-for-ios

Uservoie for Android: https://remotedesktop.uservoice.com/forums/272085-remote-desktop-for-android
Uservoice for WinPhone: https://remotedesktop.uservoice.com/forums/255249-remote-desktop-for-windows-phone

Edited by MedicalSMicrosoft contingent staff Wednesday, May 27, 2015 6:42 AM

------------------------------------

PowerView hyperlink to Pivot

Would it be possible to use hyperlink on SharePoint PowerView chart, to underlying PowerPivot's Pivot summary data?

Looking to drill down on PowerView Chart,to a non relating details table based on summary number from another table.

Changed type Ed Price - MSFTMicrosoft employee Saturday, May 16, 2015 1:03 AM No response

Reply:

Sam, have you made any progress with this one?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

PowerView on SharePoint

Hello, Is there any way that Excel VBA workbook can be publish on SharePoint 2013 and render macros?

Changed type Ed Price - MSFTMicrosoft employee Saturday, May 16, 2015 1:02 AM No response

Reply:

Is this related to Power View?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

PowerView Drill down to details list

Great to have PowerView discussion forum. :) Would it be possible to drill the PowerView dashbord to the details list like SSRS sub-reports.

For example: PowerView dashboard that display Yr, make, model car types, and would like to drill to details list by the type use choose from graph.

PowerView graph -> PowerPivot pivot table -> PowerPivot details list ( all on the SharePoint ) .

Changed type Ed Price - MSFTMicrosoft employee Saturday, May 16, 2015 1:02 AM No response

Reply:

Sam, is this still an issue?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

Power View tabs don't open in Sharepoint online teams sites

Hi,

Today when I open excel workbooks (with data model ) from team sites in Sharepoint online ( O365 E3) all the powerview tabs/sheets don't open instead shows the powerview error screen..Anyone experience the same problem?

Changed type Ed Price - MSFTMicrosoft employee Saturday, May 16, 2015 1:01 AM No response

Reply:

Konstantin, is this still an issue?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

An error occurred while loading the model for the item or data source

I tried to create Power View Report with HelloWorldPicnicPowerViewRTM.xslx

error details follow

<detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsCannotRetrieveModel</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://sp.contoso.com/sites/bi/Power%20Pivot%20Gallery/HelloWorldPicnicPowerViewRTM.xlsx'. Verify that the connection information is correct and that you have permissions to access the data source.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsCannotRetrieveModel&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=12.0.2000.8</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">12.0.2000.8</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsCannotRetrieveModel" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsCannotRetrieveModel&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=12.0.2000.8" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://sp.contoso.com/sites/bi/Power%20Pivot%20Gallery/HelloWorldPicnicPowerViewRTM.xlsx'. Verify that the connection information is correct and that you have permissions to access the data source.</Message><MoreInformation><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsErrorOpeningConnection" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsErrorOpeningConnection&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=12.0.2000.8" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Cannot create a connection to data source 'TemporaryDataSource'.</Message><MoreInformation><Source>Microsoft.AnalysisServices.SPClient</Source><Message>We cannot locate a server to load the workbook Data Model.</Message><MoreInformation><Source></Source><Message>We cannot locate a server to load the workbook Data Model.</Message><MoreInformation><Source>Microsoft.Office.Excel.Server.WebServices</Source><Message>We cannot locate a server to load the workbook Data Model.</Message></MoreInformation></MoreInformation></MoreInformation></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>

Changed type Ed Price - MSFTMicrosoft employee Saturday, May 16, 2015 1:01 AM No response

Reply:

GS, so it didn't load the model?

Thanks!

Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

Answer an interesting question? Create a wiki article about it!

------------------------------------

Wednesday, February 2, 2022

Power View in SharePoint only shows current year.

Power View in SharePoint only shows current year.

First Map - Newbie Question

A user-defined function that enables SQL Server to perform similarly to the VB "Split" function

SSL Certificate comes unbound from IIS web application daily

SharePoint 2013 BCS Column to a hyperlink in List

How to change the content type of a masterpage

FIM2010 licensing model is changing as of 1st of april 2015

activation codes for my nokia lumia 900

Delete Out-of-Office Rule with MFCMAPI

[SOLVED] Slow mail flow sending in chunks every 20 to 30 minutes.

Carl

SCCM 2012 - Multiple Dependent Applications no Detection of upgrade after a successfull install.

[Fixed] US Gov't CaC Cards Not Recognized

Office 360

Feature Request: Keyboard shortcuts for Zoom in/out

Passing Password in Powershell script

How to enable database journalling for standard users

MS DTC not coming online on SQL Server 2008 R2 failover cluster

Easy and True solution

Why you shouldn't download/purchase Windows 10

MDT 2013 Update 1 Preview - Windows ADK RC for Windows 10 available

MDT 2013 Update 1 Preview - Windows ADK RC for Windows 10 available

Windows 7 clients not honoring screen saver timeout group policy setting

Attention All T-SQL Gurus! Time to SPRING Into Action!

Summary On Special Groups

Asignar permisos de administracion en un solo equipo de Active Directory?

Mail app: Account unavailable

Outlook 2013 "Operation Failed" with inline jpg

IIS SMTP Rewriting

EMET 5.2 Ignores DEP Exclusion

Pasting formatted text into OWA results in plain text (no formatting) with double tilde ~~

Server stuck at please wait for windows modular installer.

unable to access TMG Server remotely

Windows ADK SIM SIM 10.0.9933.0 refuse to create catalog of 9926 and ask to install same version 10.0.9933.0 !

Created a new maintenance solution

STOP STEALING MY FOCUS

PowerView hyperlink to Pivot

PowerView on SharePoint

PowerView Drill down to details list

Power View tabs don't open in Sharepoint online teams sites

An error occurred while loading the model for the item or data source

Setup is Split Across Multiple CDs