Tuesday, March 1, 2022

Ever wonder what all plays nicely w/ Windows8?

Do take a look @, through this... you may be pleasantly surprise or, even, relived.

https://www.microsoft.com/en-us/windows/compatibility/en-US/CompatCenter/Home

Cheers,
Drew

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

is it safe to delete C:\Program Files\Microsoft SQL Server \100\SetupBootstrap\Update Cache in SQL Server 2008 SP3

HI All,

Is it safe to delete C:\Program Files\Microsoft SQL Server \100\SetupBootstrap\Update Cache in SQL Server 2008 SP3 after SP3 installation.

It creates around 1.5 GB of backup of Service Packs.

And also is it safe to delete C:\Program Files\Microsoft SQL Server \100\SetupBootstrap\Logs.

We will not be unistallating and will not be doing repair on our machines.

Reply:

It looks like it's not a good idea to delete the 'Update Cache' files without backing them up somewhere first, however the 'Logs' files should be ok to delete (best to take a backup to be on the safe side in case you need them for future reference)

http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/b71f7b93-91d7-4ce1-a4cf-21425f830712

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

Server Agent Jobs

Hi all.

I'm a newbie when it comes to the securty implications of running overnight jobs via Server Agent. I'd like to pick your brains on how people take a view to this. Here's my scenario:

I currently have a job that has three steps that encompasses 3 databases - two on one server (base_server) and another db on another (ext_server).

What i am currently doing is running all of these jobs on the base_server with a logon specifically generated for running overnight jobs (account1). account1 is the owner of the job. This login is also present on the ext_server, specifically created for the purpose of logging into ext_server via linked server. This account has basic server permssions on both servers but has datareader and datawriter permissions on all databases concerned.

As i'm new to this, this is (as far as i know) the nly way to get the job to function correctly between 2 servers and/or 2 databases on one server (base_server). Are there any security implications on the method of what I have just described? Is creating 2 logins on two different servers the way to go for this type of job or is there a more efficient/secure method of doing this? Would proxy accounts be a way to go? If so, how can I implement them with basic update query steps (as these are)?

Any questions let me know.

Thanks.

Reply:

Are they servers are sitting on same domain then you can grant permissions on dbs to sql agent services account -

Or you can create proxy account and grant the permissions on dbs / grant update permission as it required and run the job under this account

http://uk.linkedin.com/in/ramjaddu

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

Exchange 2010- catch emails which are not delivered.

Hi,

Can some one please help!!!

I have got exchange 2010 in my domain just completed the migration i need to set up a mailbox that only catched the undelivered emails. Please let me know if thats possible i URGENTLY need a solution. thank you heaps.

Cheers

Katty

Reply:

I believe a transport rule could achieve your goal.

Refer to this article for more information:

http://technet.microsoft.com/en-us/library/bb691132.aspx

Regards

Lionel

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

Thanks Lionel for your reply i dont have an edge transport server to configure this.

Is there any other way to configure with the use of the edge server?

cheers

Katty

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

You can do it on the hub transport as well.

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

You can do it on the hub transport as well.

How can i do these on HUB Transport? do you have any source i could refer to please.

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

I'm not sure of a source that describes this exactly, but here goes:

Open Exchange Management Console
Go to Organization Configuration
Click on Hub Transport
Go to Transport Rules tab
Click New Transport Rule
Continue following the instructions from the link I sent earlier (from Step 3, line 4).

This is for incoming mail, if you want it for outgoing mail, reverse the selections of "Inside" and "Outside" organization.

Regards

Lionel

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

IE Tile Behavior

This will make the IE tile on Start open IE on the Desktop w/ the browser's normal appearance.

> Internet Options > Programs & check the box Open IE tiles on the Desktop.

Ends up practically the same as going to Desktop but, w/ browser there & open @ the onset.

W/ the IE tile, as it is, by default, seemed a bit strange to use or see the point of it.

Just more subjective choices for you, lol

Drew MS Partner / MS Beta Tester / Pres. Computer Issues Pres. Computer Issues www.drewsci.com

Edited by Drew1903 Wednesday, March 7, 2012 9:56 PM

How to back up me (a one-man IT dept)?

I run a one man IT dept. It's mostly a Windows operation supporting 30 workstations, Sql Server, Exchange Server, IIS running both static and web apps, file servers, Backup Exec, anti-virus, Active Directory, and a Linux firewall. I need an organization that can be called when I'm not available. (Note that I'm not looking to farm out services, upgrade services, etc. Things are going fine -- I've been doing this for years.) I simply need a backup for me. How would I go about finding this organization? Would I need to enter into some agreement, or are there plenty of these organizations available where I could just have a couple on a list for our company to call should the need arise?
Thanks.

Changed type Tiger LiMicrosoft employee Wednesday, March 7, 2012 7:55 AM

Reply:

Hi Darpa 2012,

Thanks for posting here.

Outsourcing your IT service is a way we may looking for . We can obtain a list of your local Microsoft partner form the site below:

http://pinpoint.microsoft.com/en-US/home

Some tips for sharing :

Tips for outsourcing your small-business needs

http://www.microsoft.com/business/en-us/resources/management/recruiting-staffing/tips-for-outsourcing-your-small-business-needs.aspx?fbid=couYY0AHYRe

Meanwhile, consider moving our services to cloud is also an option.

Thanks.

Tiger Li

TechNet Community Support

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

Tiger Li,

In my question, I'm clearly looking for a person to back me up.
I specifically said I'm not asking to outsource services.
You responded to say I should look to outsource it all out.
Plus you had links to the latest sales pitch for outsourcing it all out.

In summary....
Me: Things are fine, everyone's happy, I just need a backup person.
You: Have someone else take over the entire operation.

With all due respects, this is not helpful.

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

You could try looking for someone on oDesk, you can pay by the hour.

Regards

Lionel

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

Can Not Force Replicate users between 2 Servers (Exchange 2003)

I have 2 servers. One is the main server used to for connectivity and user name access to the domain. The second replicates the users and usergroups and sets up a database for collective use.

For some Reaons I can not replicate users from the main server to the second server. I either receive a tombstone expiration error. Or a improper naming error.

At this point I am out of ideas. Any suggestions?

Reply:

I recommend that you post your question to the Directory Services forum.

http://social.technet.microsoft.com/Forums/en-US/winserverDS/threads

Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."

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

Can I assign permissions for an entire library in a workflow?

Can I use a SPD 2010 WF to assign permissions to an entire document library? I have a situation where I am making a project site template and there are a number of regional groups that will get these sites but no regional group should be able to see another group's site much less their libraries (about 20 lists/libraries involved). The lists/libraries are already going to be security trimmed according to department such as HR, Finance etc. but I need to be able to allow all leadership for a given region to have access to all libraries within their generated sites.

To make a template for each region with security trimmed libraries for their group besides the normal HR, finace,and other departmental security will result in about 25 templates all with their own custom security and would depend on the person making the site to choose the correct template for the region they are making it for.

Would be sweet for them to be able to make a security trimmed site and fire off a workflow that assigns permissions to each list and library in the new site to the Region leaders involved by choosing the region the site is supposed to be for. One template, one workflow with an input for region involved.

Is this possible? I see stuff for item level permission assignments, but not list/library assignments.

Reply:

You would need to create a custom action to do this. The only permission actions built in to SPD are all scoped to operate on a specific list item, not on the whole list. I thought you might be able to do it using a Site Workflow, but that also only contains actions to replace permissions on a specific List item.

Paul Stork SharePoint Server
MVP Chief SharePoint Architect: Sharesquared
Blog: http://dontpapanic.com/blog
Twitter: Follow @pstork
Please remember to mark your question as "answered" if this solves your problem.

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

Dang it.

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

Retrieving blank values using caml

I am trying to retrieve a list containing blank names. The field is of type "Person or Group". The data actually contains some type of space " ". I tried using this but it did not work:

I also tried this:

And I am still not getting any records. Any suggestions?

Thanks Before Hand,
Adiel

Edited by adiel Tuesday, March 6, 2012 7:56 PM

Reply:

Hi Adiel,

The first approach what you tried is the correct one. I tried the below option and it worked for me.

The second option will not work since you are trying to equate the user object with a space which will never be equal.

Thanks

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

Suneetha, thanks but that did not work. However, I have made some progress in the solution. If I put a dummy value in the where clause which I know will never be null on another field, then it correctly returns the records with the null personname! Here is an example that worked:

Now the question is why does the query return the null records for personname when you provide an additional non-null "dummy" check but when you dont, it returns no records?

Thanks,
Adiel

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

Hi Adiel,

This sounds pretty weird and i think this is more to do with either the data or some kind of combination of the column types, because it worked for me pretty well with/without providing an additional non-null column.

Thanks

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

Suneetha, unfortunately your solution did not work. The simple IsNull clause has also worked for me in the past but not in this case. I will have to do some more research. The issue might have something to do with the field type being "Person or Group". In any case, thank you for your suggestion.

Thanks,
Adiel

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

I figured it out! It's another bug in Microsoft's Product. :) If its a "Person or Group" field (Type=User), set to People Only(UserSelectionMode=PeopleOnly) and Indexed(Indexed=TRUE), you must use the above workaround I mentioned to get your results.

If you just use the IsNull clause with the field itself, you will get no records.

Other UserSelectionMode values could possibly have an issue but I do not have time to test that.

Thanks,

Adiel

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

Easy way to delete tile groups

There should be one. When in semantic zoom, right-clicking a group should have a Delete Group option along with Name Group. Perhaps a "Recycle Bin" tile or some type of Undo function.

Changed type Niki HanModerator Wednesday, March 7, 2012 9:27 AM

Reply:

Hi,

Thanks for your feedback. It is a good idea. I will forward it.

Niki Han

TechNet Community Support

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

Please expand that request to:

Anything we can do on the desktop or in the Start menu of yesteryear, we should be able to do on the Metro start screen.

This includes hierarchical organization, the ability to manipulate groups of tiles, the ability to see just where shortcuts point...

The reduction in utility and functionality that people are complaining about in Metro cannot just be written off as resistance to change, and "simpler to use" is not the same as "fewer features", no matter what the "right in the back of a taxi" commercials might imply. Microsoft Engineering would do well to stop listening to Microsoft Marketing quite so intently, lest they end up with an operating system that smart people just don't want to use.

Thank you.

-Noel

Detailed how-to in my eBook: Configure The Windows 7 "To Work" Options

Edited by Noel Carboni Wednesday, March 7, 2012 7:03 PM corrected spelling

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

Fast ESP 5.3. and SP2010 connector

I'm doing initial testing with ESP 5.3 and SP2010. I received usual errors from the SharePoint Connectors stating: Failed to crawl list {GUID} in site http://mysite.com : object not set to an instance of an object. The error seems to be an internal SharePoint programing error.... Does anyone know how to solve these problem or what is the cause…

Thanks In Advance,

Chad

Reply:

First of all: the error "object not set to an instance of an object" means that an earlier operation failed, and insufficent error handling means that the error is not signalled until there is an attempt to use the information that the operation should have returned. The actual error could be in Sharepoint itself (which I think is the least likely), in the Sharepoint connector, or in any custom code that you have deployed in your environment.

You don't mention which version of the Sharepoint connector you're using, but at least the most recent connector (the one implemented in C#/.NET) has a number of errors that means that it is not ready for full-scale deployment.

Your next step should be to run the connector with debug logging, which should help you identify exactly where the error is. If the error appears o be in the connector (and not in any Sharepoint customisations), you should submit a support ticket to MS/FAST (assuming that you have a support contract...)

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

Raymond, thanks for the reply.. the problem was the version of SharePoint connector. Once the patches were applied the errors were resolved.

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

Cannot add users to Public Folder Permissions in Exchange 2010

I'm trying to troubleshoot some Public folder issues for our Exchange 2003 to Exchange 2010 post-migration/upgrade. We had some calendars in our public folders that aren't sending out emails to our libararians if someone books equipment within those public folder calendars. This stopped happeneing after we decommisioned our old Exchange 2003 servers... Might have something to do with mail-enabling? But on to the issue I'm trying to troubleshoot.

In the EMC>Toolbox, I can launch the Public Folders Management Console. Browse and open the Public Folder Tree and select the item I want to view/change properties. When I click on the "Permissions" tab, it will open the "Select User" prompt and have the search field. Default, it looks at our root level domain\users OU path and all I see is "Administrator". I will click Scope, to change where the console should look -- a child domain within the root level domain (so child.domain\child_domain_users). I highlight and click ok and will be given this error:

It won't let me browse my child domains to add users to the permissions tab. What do I do?

Reply:

Found my answer here: Can't change permissions on Exchange 2010 Public Folders

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

Can you change the permissions using the exfolders utility? It's a download from microsoft's site that has to run off of an exchange server.

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

I didn't try exfolders utility. I just ran the Exchange Powershell commands mentioned in the linked thread, and I was able to add users from any child domain.

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

Update Password Not Required for domain controller machine account

What is the importance of Update Password Not Required on domain controller machine account?

Regards

Jas

Jaswinder Singh

Reply:

Jas - from what I understand, behavior regarding access checks for PASSWD_NOTREQD differs between computer and user objects...

What's the reason for asking?

hth
Marcin

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

Hi Marcin,

I'll just elaborate the above question.

When we pre-create a computer account in ADUC and then promote it as DC, the UserAccountControl is set to 532512 instead of the default 532480.

The additional flag "UF_PASSWD_NOTREQD" (32) is present apart from the default 8192 (UF_ SERVER_TRUST_ACCOUNT) + 524288 (UF_TRUSTED_FOR_DELEGATION).

I understand that if this is set for User account (UserAccountControl = 544 (512 + 32)) we can have a blank password for that user, which is a security concern. But that wont happen in case of a machine account (i.e., a machine having blank Pwd) since admin cannot set it.

so the question is:

1) Why is it set by default in first place for a pre-created computer? (I'm assuming because we cannot give a pwd for computer while manually creating it).

2) Why is this not changed after the promotion? (any bug?)

3) How is it affecting a DC or any machine account? (I do not see it causing any issues apart from an error being reported in DCdiag. But DC is still replicating & advertising fine)

Thanks,

Madhu

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

As far as I can tell, this is a bug (obviously a quick way to remediate it would be to set UserAccountControl to the expected value). I don't believe this affects functionality of the DC (or a member server) - beyond the error thrown by DCDiag. Mayby our Microsoft moderators can chime in regarding this...

hth
Marcin

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

It definately causes a problem, as it is stopping my two domain controllers from replicating as it fails the MachineAccount test in dcdiag. Anmyone know how to change the setting?

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

I just replied in the other thread that I think the value should be changed to 532480. I haven't done this myself, but I don't think anything prevents you from changing it. It can be done in ADSI Edit, or in the "Attribute Editor" tab when you view the DC properties in ADUC. The attribute name is userAccountControl.

Richard Mueller - MVP Directory Services

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

Yes,it is bug if you pre create Computer account.

These are the default UserAccountControl values for the certain objects:
Typical user : 0x200 (512)
Domain controller : 0x82000 (532480)
Workstation/server: 0x1000 (4096)

If you want to restore the default DC value You can use either LDP or ADSIEDIT.MSC
http://jimdoylemcse.wordpress.com/2008/06/08/dcdiag-useraccountcontrol-issue/

Incorrect userAccountControl Attribute value causes error when running DCDIAG or during promotion of a server to a DC.
http://blogs.dirteam.com/blogs/jorge/archive/2006/08/27/Incorrect-_2600_quot_3B00_userAccountControl_2600_quot_3B00_-Attribute-value-causes-error-when-running-DCDIAG-or-during-promotion-of-a-server-to-a-DC.aspx

Hope this helps

Best Regards,

Sandesh Dubey.

MCSE|MCSA:Messaging|MCTS|MCITP:Enterprise Adminitrator | My Blog

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

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

Making a simple GPO

I am using the Group policy editor and am making a GPO in which I want to lock down specific users. I have been instructed to modify settings in User configuration->Administrative Templates->Start Menu and TaskBar->Remove Run Menu from Start Menu.

In doing so the new GPO is going to be called "Locked Down User", and it will be linked with a particular OU. However, when creating a GPO the system includes all User and Computer folders / settings, but being that I only want to restrict the User Configuration per above, I should be able to only include this portion of the policy, rather than having all policy settings in the GPO I need to create. I have seen the smaller GPO developed in some past experience but can't recall how to do it?

Any help would be appreciated?

Moved by Mike Kinsman Wednesday, March 7, 2012 5:07 PM off topic (From:TechNet Website Feedback)

Reply:

Ask this question in the Windows Server "Group Policy" Forum at the following address

http://social.technet.microsoft.com/Forums/en-us/winserverGP/threads

Bye.

Luigi Bruno - Microsoft Community Contributor 2011 Award

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

Unfortunately your post is off topic here, in the TechNet Site Feedback forum, because it is not Feedback about the TechNet Website or Subscription.

You may want to try asking your question at http://answers.microsoft.com.

For more information about where to post your question please see this thread: http://social.technet.microsoft.com/Forums/en-US/tnfeedback/thread/24ee65e4-0f35-403c-9bf7-41333cd13cb5

Moving to off topic.

Thanks,
Mike

MSDN and TechNet Subscriptions Support
Read the Subscriptions Blog!

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

HP announces new client

Last week 06/10/2011 HP announced a new WMS zero client the T200.

This access device can be connected to your multipoint servers either directly using usb or via it's network port.

http://www.pcmag.com/article2/0,2817,2394327,00.asp#fbid=QbzJzJnbFXh

The new product also sports 4 usb ports for connecting your keyboard and mouse and includes audio connections.

The suggested selling price is $99 which I think is fantastic allthough I'll wait and see what UK pricing is like.

This device is ideal for me as I can invisage me running all 3 mode of multipoint, direct connected, usb connected and ethernet connected depending on the situation.

Ben

Reply:

The price for the HP T200 Zero Client (QV552AA) in the UK is £ 178 Inc. VAT / £ 148 Exc. VAT.
http://www8.hp.com/uk/en/products/thin-clients/product-detail.html?oid=5180689

In the USA HP has the following models of the T200:
http://h10010.www1.hp.com/wwpc/us/en/sm/WF25a/12454-12454-321959-338927-5112717-5171156.html?dnr=1

HP t200 Zero Client for MultiSeat (QV555AT) $99.00 (Academic Volume License)
HP t200 Zero Client for MultiSeat (QV554AT) $139.00
HP t200 Zero Client for MultiSeat (QV552AT) $159.00

Some of the part numbers have the suffix #ABA

Tim Barrett http://www.NoGeekLeftBehind.com

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

QV555AA & QV552AA are available in the UK.

For the QV555AA I pay around £55 - £60 for it.

This is Academic Pricing.

http://www8.hp.com/uk/en/products/thin-clients/product-detail.html?oid=5180692

One of the differences being if the WMS Cal is included or not.

Ben

Edited by Ben Norcutt Wednesday, March 7, 2012 4:49 PM more info

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

How to get a list of network filters installed on a Windows 7 system

I've run into several situations where users in my office have tried to install software, such as vpn software, and the installation has failed due to exceeding the maximum number of filters allowed, as defined by the registry key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Network\MaxNumFilters. My understanding is that the default is 8 and the maximum is 14.

I'd like to know if it is possible to get a count of the number of network filters currently installed on a system. For bonus points, I'd like to know if there is a way to determine what the filters are associated with: the installed software or dlls, something that could be useful in determining what could be uninstalled.

I would hope this information would be useful to others.

Changed type Niki Han Monday, March 5, 2012 7:51 AM

Reply:

Hi your question was already answered for you on Microsoft Answers:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Network\MaxNumFilters

that shows the maximum count. Further, if you look at:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Network\{4d36e974-e325-11ce-bfc1-08002be10318}\

Each entry corresponds to a possible filter.

Source: how can I find out how many network filter drivers I have using Windows 7 and uninstall if too many

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

Thanks, Jaap.

It doesn't definitively answer my question, but it helps.

The list of items under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Network\{4d36e974-e325-11ce-bfc1-08002be10318} are only possible filters.

According to http://msdn.microsoft.com/en-us/library/windows/hardware/ff553426%28v=vs.85%29.aspx the GUID 4d36e974-e325-11ce-bfc1-08002be10318 is described as "NetService". In my registry, some of the entries appear to be filters, and some do not.

For example, HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Network\{4d36e974-e325-11ce-bfc1-08002be10318}\{03F0DBAD-C963-4EB4-8510-DD8D23454D85} is described as "File and Printer Sharing for Microsoft Networks". I think it would count a s a service, but not as a filter, and consequently not count against MaxNumFilters.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Network\{4d36e974-e325-11ce-bfc1-08002be10318}\{B5F4D659-7DAA-4565-8E41-BE220ED60542} on the other hand is described as "QoS Packet Scheduler" and has sub-keys (if that's the term) with the following names and values that indicate to me that it is an actual filter:

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Network\{4d36e974-e325-11ce-bfc1-08002be10318}\{B5F4D659-7DAA-4565-8E41-BE220ED60542}\Ndi]
"FilterClass"="scheduler"
"FilterType"=dword:00000002
"FilterRunType"=dword:00000002

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Network\{4d36e974-e325-11ce-bfc1-08002be10318}\{B5F4D659-7DAA-4565-8E41-BE220ED60542}\Ndi\Interfaces]
"FilterMediaTypes"="ethernet, wan"

Across all of the key entries that I see on my system, the only ones that seem consistently present and indicating a filter are Ndi\FilterClass and Ndi\Interfaces\FilterMediaTypes

I have one entry on my system that has Ndi\FilterDeviceInfId, and neither of Ndi\FilterRunType and Ndi\FilterType.

Now all I need is confirmation that only the entries that I think are filters count against MaxNumFilters.

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

[Edited the format-list properties. Was outputting all properties instead of just Description and PSPath]

I haven't figured out how to map back to a file on disk.

The following PowerShell will output the current maximum filters configured, the count of filters installed, followed by the description and registry path.

get-itemproperty hklm:\SYSTEM\CurrentControlSet\Control\Network | format-list -property MaxNumFilters  $children = get-childitem -path hklm:\system\currentcontrolset\control\network\"{4d36e974-e325-11ce-bfc1-08002be10318}" | get-childitem | where-object {$_.PSChildName -eq "Ndi"} | get-itemproperty | where-object {$_.FilterClass} |get-itemproperty -name FilterClass  "Filter Count: " + $children.count  "Filter List: "  $children | foreach-object -process { get-itemproperty -path $_.PSParentPath } | format-list -property Description,PSPath

The output will be something like the following:

MaxNumFilters : 8

Filter Count: 6
Filter List:

Description : Eset Personal Firewall
PSPath      : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\system\currentcontr
              olset\control\network\{4d36e974-e325-11ce-bfc1-08002be10318}\{08D58B09-AA0
              4-45BD-9F17-9842CE8CCF6D}

Description : Virtual WiFi Filter Driver
PSPath      : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\system\currentcontr
              olset\control\network\{4d36e974-e325-11ce-bfc1-08002be10318}\{5CBF81BF-505
              5-47CD-9055-A76B2B4E3698}

Description : QoS Packet Scheduler
PSPath      : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\system\currentcontr
              olset\control\network\{4d36e974-e325-11ce-bfc1-08002be10318}\{B5F4D659-7DA
              A-4565-8E41-BE220ED60542}

Description : WFP Lightweight Filter
PSPath      : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\system\currentcontr
              olset\control\network\{4d36e974-e325-11ce-bfc1-08002be10318}\{B70D6460-363
              5-4D42-B866-B8AB1A24454C}

Description : NativeWiFi Filter
PSPath      : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\system\currentcontr
              olset\control\network\{4d36e974-e325-11ce-bfc1-08002be10318}\{E475CF9A-60C
              D-4439-A75F-0079CE0E18A1}

Description : NDIS Capture LightWeight Filter
PSPath      : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\system\currentcontr
              olset\control\network\{4d36e974-e325-11ce-bfc1-08002be10318}\{EA24CD6C-D17
              A-4348-9190-09F0D5BE83DD}

Hopefully someone else will find this useful.

Edited by Saturn Jct Wednesday, March 7, 2012 4:52 PM Changed to use code block

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

First of all, thanks for sharing, nice to see you found the solution.

If you want to export the output to a file on the disk you can use this revised code:

$outtofile = @()  $outtofile += "Maxnumfilters: "+(get-itemproperty hklm:\SYSTEM\CurrentControlSet\Control\Network).maxnumfilters  $children = get-childitem -path hklm:\system\currentcontrolset\control\network\"{4d36e974-e325-11ce-bfc1-08002be10318}" | get-childitem | where-object {$_.PSChildName -eq "Ndi"} | get-itemproperty | where-object {$_.FilterClass} |get-itemproperty -name FilterClass  $outtofile += "Filter Count: " + $children.count  $outtofile += "Filter List: "  $outtofile += $children | foreach-object -process { get-itemproperty -path $_.PSParentPath }  $outtofile | out-file maxnumfilters.log

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

Bug? Alert status iw Warning, but there are no alerts (Unable to clear alert state)

SCE 2010 RC v7.0.2346.0

SCE Console, Computer Groups, All Windows Clients

I have a client with an Alert Status of "Warning", and Update Status of "Unknown" and an Agent Status of "OK". If I select the client, go to the details pain and click on the "Warning" alert; the alert window pops up however there are no alerts shown in the window. The result is that I am unable to clear the alert.

Reply:

I have 4 Windows XP clients that exhibiting similar symptoms; one that I just created. I pulled up an XP Client with an alert, closed the alert, and now the Warning has not cleared and the client still reports an alert.

So I'm thinking the problem is that sometimes when I close an alert, it doesn't close entirely.

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

Hi Lohman,

Can you try the one (or both) of the following:

Press F5 to refresh the computers view
Select a different computer group and then navigate back to All Windows Clients

We don't immediately update the information in the computer views, so it is possible for an alert to be manually resolved, or autoresolved and the computers view to have old information for a short period.

We will get updated information on alerts:

Whenever you change between computer groups
When the current view is refreshed (either by pressing F5, or after clicking on the yellow information bar which appears after 10 minutes)

If the above still leaves you with incorrect information, let us know if we can arrange to do a troubleshooting session with you - drop us an e-mail to scedata@microsoft.com with your contact information.

Thanks

Richard

This posting is provided "AS IS" with no warranties, and confers no rights.

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

It seems to be clearing itself out, somehow. I still have two servers that have a Warning alert and when I click on the alert there is nothing shown. No matter of refreshing seems to be able to clear this out. It seems like it took several days for those other computers to finally realise that they had no alerts. I currently have two systems with Warning that I could show to you. Let me know if you want to check it out.

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

I just created another one of these servers that have an alert status but no alerts. This server had 4 alerts. After closing all 4 alerts I refreshed SCE all over the place and I can't get the Alert status to change to OK, even though there are no alerts available. It seems like there's something stuck in the backend of SCE: As though something runs on a schedule to update the alert status, and that scheduled refresh hasn't yet occured.

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

Thank you for letting us troubleshoot this, we really appreciate it.

We don't currently have an explanation for why this is occuring.

For others who are following this thread - please post a note in this thread if you are also seeing this issue.

Thanks

Richard

This posting is provided "AS IS" with no warranties, and confers no rights.

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

My alert status are also not updating properly.

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

Also having this problem?

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

Yep, me too.

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

I am having this issue, but only with my Windows 7 Enterprise x32 clients. (All other's are XP, 2003, 2008, 2008 R2)

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

I am also experiencing this issue.

The computers involved are all running server OSs, one each of these:

Windows Server 2003 Enterprise
Windows Server 2003 R2 Standard
Windows Server 2003 R2 Enterprise

Michael M. Thornberg

System Administrator
Accobat A/S

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

Also having this issue with multiple Windows Server 2008 R2 OS's.

Running SCE 2010 Version 7.0.2432.1

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

Exactly the same issue here. 4 out of 20 clients. Alle 4 are W2008R2.

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

Have you guys tried flushing the health service and state cache for those clients? It's in monitoring pane->discovered inventory. Highlight one of your problem clients and under health service tasks on the right pane you should see an option to flush health service and state cache. Monitor this client to see if the warnings/alerts come back.

Thanks,

Tim

Ok, so I changed my name...you can still call me Tom if you like. It's a...jump...to conclusions...mat.

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

I have 4 Servers with the same Problem too.

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

Also having this Problem on a few Windows Server 2008 R2´s

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

I have this problem too.

OSes affected - XP/2003R2/2008R2

-=C U=-

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

I also am having this problem, really only happening to server 2008 R2's (both VM and physical) some of them are okay though.

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

Tim, I do not see a Flush Heath Service task entry on the right pane.

Thanks Roy

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

I too am haveing the problem. It appears to only be on SOME of my 2008 R2 servers (with and without SP1). I have noticed that these same systems appear as HEALTHY in the Discovered Inventory list.

Edited by Maze of twisty little passages, all alike Wednesday, March 9, 2011 2:03 PM More info

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

so your screen doesn't look like this? Not sure why the image turned out so small, sorry!

http://i29.photobucket.com/albums/c263/capdod/support/tasks.jpg

Ok, so I changed my name...you can still call me Tom if you like. It's a...jump...to conclusions...mat.
My Blog Site: http://tmagnuson.wordpress.com

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

No, where your's shows "Health Service Tasks" mine has "Windows Computer Tasks". Below that I have "Windows Computer Reports".

The only thing we have in common is "State Actions" and we have the same 3 actions available there.

Thanks Roy

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

hmm..well let me look at an R2 server, I don't think they're any different though..

edit: Nope, R2 is no different for me.

Ok, so I changed my name...you can still call me Tom if you like. It's a...jump...to conclusions...mat.
My Blog Site: http://tmagnuson.wordpress.com

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

I see "Windows Computer Tasks" when I go to Monitoring->Windows Computers, not discovered inventory

Ok, so I changed my name...you can still call me Tom if you like. It's a...jump...to conclusions...mat.
My Blog Site: http://tmagnuson.wordpress.com

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

Definitnatly in Discovered Inventory see http://cid-6372e0958f1d1d72.photos.live.com/self.aspx/Screen%20Shots/Discovered%20Inventory.jpg

Thanks Roy

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

Here is what mine looks like as well.

http://cid-f1b2723372bac022.photos.live.com/browse.aspx/ms?uc=1

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

Has anyone figured out why SCE does this? 30% of my computers have a Warning yet when I open the warning there are no active alerts. This issue makes this product very unreliable!

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

I am seeing this same behavior of an Alert status of Error, but no errors listed. Using Health Explorer, I found that sme of the computers (mostly servers) had Disk Fragmentation warnings. After defragmentation, and waiting a day to check the systems, the same systems had Error Alerts, but no errors listed. Attempting to Reset Health (because there is no Health Serice Tasks group in my task pane) when in the Computers view had no effect. I went to the Monitoring View and selected Disk Health under the Health Monitoring node of the Microsoft Windows Server node. I then clicked on the Logical Disk Fragmentation warning and clicked Reset Health. That cleared the warning. It also cleared the Error Alert from some, but not all, of the machines in the Computers view.

I am also seeing that VM hosts show errors for their VMs when their Error link is clicked. On one host, it shows an error for a VM that it does not host.

Do we need to call the Orkin man?

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

Cannot use file for Clustered server

The error message is saying that clustered disk is not a dependency. I checked and there is a dependency. OS is windows Server 2008 and SQL Server is 2008 R2. All of the other instances that are part of node are working fine. The cluster is a 4 node cluster with 3 active and 1 passive node.

Changed type Vincent Hu Monday, April 9, 2012 7:47 AM

Reply:

The error message is saying that clustered disk is not a dependency. I checked and there is a dependency. OS is windows Server 2008 and SQL Server is 2008 R2. All of the other instances that are part of node are working fine. The cluster is a 4 node cluster with 3 active and 1 passive node.

Disks are online and a part of the sql server instance.

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

Does the SQL server resource depend upon this cluster disk?

Visit my blog about multi-site clustering

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

Discuss Private Cloud Planning Guide for Systems Management

The Private Cloud Planning Guide for Systems Management describes these nine Management Layer capabilities and the impact of private cloud IaaS patterns on their planning and design. The patterns are defined in the Private Cloud Principles, Concepts, and Patterns document and are summarized here:

Resource Pooling: Divides resources into partitions for management purposes.
Physical Fault Domain: The group of physical resources dependent on a single point of failure such as an uninterruptible power supply (UPS).
Upgrade Domain: A group of resources upgraded as a single unit.
Reserve Capacity: Unallocated resources, which take over service in the event of a failed Physical Fault Domain.
Scale Unit: A collection of resources treated as a single unit of additional capacity.
Capacity Plan: A model that enables a private cloud to deliver the perception of infinite capacity.
Health Model: Defines how service or system may remain healthy.
Service Class: Defines services that are delivered by IaaS.
Cost Model: The financial breakdown of a private cloud infrastructure and its services.

We hope you like the guide and if you have questions, post them to this thread.

Thanks!

Tom

Learn more about Private Cloud at the Private Cloud Solutions Hub

When to code and when to script?

I would really like some feedback on the below. I know it answers no questions, but I would appriciate anything that anyone can contribute about what the options are, and what considerations should be made when making a decision about the options.

Thanks,

Josh

When I describe PowerShell to someone new, I tend to refer to it as a glue language. It is very good for tying different types of technology together. In practical use, I have found that it is very beneficial for describing custom business logic to a problem.

Now it is true that in PowerShell you can embed C#, VB, F# and the like. You are sitting in .NET land so you can reasonably do anything in PowerShell that you can do in C#. The question is; where do you draw the line? Fortunately PowerShell has many shades of color between your Visual Studio work, and your ISE work. Picture the rainbow.

What we really need to consider, is the proper choice between the following.

Pure C#.
C# with PowerShell Classes implemented (http://msdn.microsoft.com/en-us/library/windows/desktop/ee706563(v=vs.85).aspx)
PowerShell with a compiled Module
PowerShell Module written in PowerShell calling C#
Script with C#
PowerShell Module written in PowerShell with no add-type definitions.
Pure PowerShell

What attribute of our processes do we want to consider?

Platform (Web based , win forms, WPF, console)
Complexity
What do you know how to do?
How are you going to deploy it?
Do you want to own this process forever?
Do you centrally maintain source code?
How much of this process is potentially going to change.

WMF 3.0 has the ability to make a web service in PowerShell, but if you want a rich web based UI, do it in visual studio. If you want something else you can probably do it in PowerShell with a sliding scale of things getting crazy.

Complexity is probably the most important item to consider and potentially the most difficult to determine. Sometimes very simple things can be subject to scope creep (http://en.wikipedia.org/wiki/Scope_creep). If you are going to use something that is best implemented via object oriented abstractions, then you may want to consider doing your classes in Visual Studio.

What do you know how to do? How much do you know about how things work, vs. what you need to get done? These are two simple questions, but they should still be considered. If you want to have a dialog box for user import, this can probably be done easily enough in PowerShell using ShowUI (http://showui.codeplex.com/) or directly with the Windows.Forms classes. Now if you don't know anything about these, download VS2010 Express, select a library assembly, draw your form, and mark your UI elements as public. It is a bunch of extra steps, but using a UI to wire up the GUI can make a big difference in headaches and subtle bugs.

Remember, if you need to, you can just save the .CS file and pull it in via "Add-Type -TypeDefinition". VS could be used just to author the form. Keep in mind that there is a designer partial class that will need to be loaded also, just append the two files before your Add-Type. I recommend that if you are importing more than a few lines of code via a TypeDefinition, that you keep this in an external file. The PowerShell ISE won't syntax check your C#, and won't be much help in debugging either.

Does deployment matter? If I am going to do automation for another team in the office, it is very crucial that they have access to everything needed to maintain the item. It may be years from now, but a random EXE sitting in accounting is going to get thrown away if things change. If it is implemented in a script, they have everything. They have my name in comments and the entire source to change or pass to someone else. True you could zip any source and pass it around with the EXE, or embed it as a resource with an option to extract it... but that gets a little convoluted. It also requires that someone have Visual Studio or some variant. Ownership is closely paired with this. A script, if it can be done cleanly can much more easily be moved to another process owner if there is no corporate process for managing things like this. If you do centrally manage your source code across anyone that may use your automation, then some of this doesn't apply.

The second largest question is looking at how much of what you are going to do will change. Sure, if you have 5 lines of script and it never changes, then this is a bit mote. But if you are powering Excel to graph frequencies of log entries in a pivot table, and someone asks why you used "THAT" font. A tweak in a script is easier than an application recompile.

Reply:

along the lines of complexity, there are things that cant (I say that

loosely) be done in powershell, for example LINQ

also I havent done any tests, but I imagine the load time of a C# app vs a

powershell script is fairly important dependent on who the end user is..

which goes to, who your end user is. you mention the in house stuff, but

there is the flip side to that, maybe you don't want them to see the code...

there are ways to compile (wrap in exe) in PS, but, is it really worth it?

Justin Rich
http://jrich523.wordpress.com
PowerShell V3 Guide (Technet)
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

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

Fortunately for me, I'm not in an environment in which we need to address these issues in as much detail and with as much planning and forethought as you are exercising. We use powershell to develop somewhat minimal tools in an informal setting to share amongst a small group. As such, I doubt we would ever run into anything that would be better done in more of a production programming paradigm.

That said, powershell modules certainly make maintenance and distribution much less painful than it can be for vbscript and batch tools!

Al Dunbar

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

LINQ is a good one. As I understand, and I havn't looked in a while, this is a combination of compiled magic and adhoc queries on data.

LINQ Articles in PowerShell world:
http://bartdesmet.net/blogs/bart/archive/2008/06/07/linq-through-powershell.aspx
http://josheinstein.com/blog/index.php/2010/02/linq-for-powershell/
These are some interesting reads. They really just try to engineer around some of what is missing in PowerShell; gaining some of the benefits. Even if basic LINQ function were hacked into powershell it deals with specific IEnumerable datatypes that just don't fit into the powershell world.

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

C# is compiled to IL, but PoweShell has a loader, an additional file read, and then the text has to be run through the Tokenizer ([system.management.automation.psparser]::Tokenize). I think PowerShell is a "mixed mode image." So there may also be overhead in passing to the managed aspect. On the flip side loading a natice app that calls into Managed could (could) have less overhead than calling a managed exe from a double click or via the CMD inerpreter. I was going to agree that it was a hands down C# win, but I don't want to underestemate MS engineers. (for giggles http://msdn.microsoft.com/en-us/library/ms973872.aspx)

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

The "End User" consideration, danger they may mess with our stuff.. Yes, good call. Are you thinking more in the realm of making it read only? We could sign the code and format the batch files or policies to require this signiture as valid. OR are we talking more about obfusication?

I don't see the advantage to the compiled PS soultions that I have seen. With SharpDevelop (http://www.icsharpcode.net) and Visual Studio Express, I don't see why somone would really need this. I can understand being comfortable with what they know, but I don't think the learning curve is that big of an issue. I did have a BATCH file hack, that copied itself to a .PS1 then called the PS1 via PowerShell command line. That way I could circumvent needing to explain powershell to a user. I actually didn't need it, but it made me feel clever.

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

I had a discussion with someone. (I cornered them, they didn't talk) about the Java vs. .NET. I said that despite any techincal arguments, the winner for me is .NET because of the IDE and the native feel.

I think that same thing wins for VBScript/Batch files. I like fancy batch files, but syntax highlight and run selected provide the tools to work with the script much better. The fact that powershell is now accross so many MS Os versions helps. Though in a pinch a more portable BAT file may be needed. It has also had the most MS investement and that gets you something.

Those asside, I do FanBoy my .NET.

I even did a new VB6 app lastyear, because I couldn't count on a client's server having .NET installed, so sometimes the right tool is something else entirely.

- Josh

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

well in some cases people need to have important info in scripts.. as much

as it makes me cringe, passwords.. maybe web services they don't want people

to know about?

basically, in a complied app you can hide anything you want from the average

user. obviuosly, if someone really wanted they could get it... when I say

never or no one, I mean 90% of them people :)

but I think you get the point, as a dev you work hard on your code, you hope

to make money on it, you don't want to just hand it over to someone so they

can retool it and give it away free or sell it themselves..

Justin Rich
http://jrich523.wordpress.com
PowerShell V3 Guide (Technet)
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

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

One of my coworkers uses a hash to store passwords in his scripts. The hash process to plain text is in the script. The argument is that this extra layer of obscurity is a 50-99% increase on security depending on the users involved. But yes, security is a slope that never levels off.

I think If you are doing scripts and want to maintain your IP, that you would follow something along the lines of options 2 and 3. Where you have your IP compiled and possibly commercially obfuscated.

I guess technically you could apply some type of hash to your entire script and store it as a Base-64 string inside a wrapper script...

- Josh

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

E mail alerts in tasks for external users

How easy is it to set up external users (e mail addresses) to receive e mail alerts for tasks set up in Sharepoint

Reply:

There are several options, if you will manage alerts, you can enter either usenames, groups or email addresses (can be external). If such a user has an access to SP site, he can manage the alerts himself.

SharePoint just needs to have a valid outgoing email configuration.

Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

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

Weather App won't detect location

The weather app that comes pre-installed does not even recognize my city as a place. When I try and manually enter it, it's not even listed. After it defaulted to Seattle Washington (no where near me), it just says "error on page" instead of displaying any weather. Anyone else have this issue?

I ended up uninstalling the weather app, and installing AccuWeather which had my city as a choosable location.

Edited by Gralen84 Sunday, March 4, 2012 4:12 PM
Moved by Ronnie VernonMVP, Moderator Saturday, March 10, 2012 1:04 AM Moved (From:Windows 8 Performance)

Reply:

Did you try using your zip code?

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

yes, I had the same issue. I had to access the time, change the time zone to the correct time, force a re-synch. Then on the next reboot, the Weather app had the correct location. I also checked to confirm that location awareness was enabled in IE10.

So, something a little strange happened on the one installation, but I am really not sure what caused it. The reboot seemed to correct it.

Try and revert to the first Weather APP and test. That's what the CP is about.

Edited by Nano Warp Thursday, March 8, 2012 12:50 PM

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

Fields not displayed in Online Addressbok (Exchange 2010)

Additional fields (like "employeeType") added to the "User" template using the Exchange 2007 Template Editor.

For users hosted on Exchange 2010 some of the fields empty in online and offline address book.

Previously added fields added to Global Catalog (while all DCs are actually GCs anyway).

Fields now visible in the offline address book (after waiting some hours and performing an "update" address book) <so there was an undocumented change between 2007 and 2010: attribute has to be replicated to GC>.

Unfortunately still missing in "Default Global Address List" - until you reboot all of your CAS servers <even funnier if only 1 CAS has been rebooted - the result looks quite aleatoric...>.

Conclusion: While runngin the Exchange 2010 CAS is caching the schema and needs to be restarted after schema changes affecting Exchange!

testererer

Reply:

Check your address book is properly mapped to the database where the user is located...check out what type of distribution you have used web or Pf...

Exchange Queries

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

TMG at HO and direct access at branches

Dear All,

We are a company with 5 branches, at the moment we are connected using Sonicwall site-to-site vpn, branch staff connect HO using TS and use oracle application. Branch computers and printers have static IP and gateway (address of local sonicwall).

All the remote printers are networked and are configured on DC located at the HO. Remote users use TS for application and printing. Now we would like to implement TMG and UAG to replace the fore said VPN. I understand that all the clients can get connected using direct access and VPN connection will be established transparently to branch / remote users, but there will be problem printing on network printers as the application servers residing at the HO won't be able to find defined remote site printers. So, do you guys have any solution which enable network printing using TS on direct access at remote sites....I hope that I put the question right if it is not understandable then please ask

Changed type Nick Gu - MSFTModerator Wednesday, March 14, 2012 8:29 AM

Reply:

Are you thinking of having TMG and UAG at the HO and then TMG at each branch office, or something else?

Jason Jones | Forefront MVP | Silversands Ltd | My Blogs: http://blog.msedge.org.uk and http://blog.msfirewall.org.uk

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

Error in Crystal Repot 10 To Connect To SQL SERVER 2008 R2??????????

Hi all,

Edited by ENG.KOKO Thursday, March 8, 2012 1:04 PM

Microsoft Office 365 for IT Professionals Jump Start

Microsoft Productivity, Email, & Collaboration in the Cloud

Microsoft Office 365 brings together cloud versions of our most trusted email, communication and collaboration software – Exchange Online, SharePoint Online and Lync Online – with our familiar Office Professional Plus desktop suite. This fast-paced, demo-rich online course features the best experts teaching the technical aspects of Office 365 for IT Professionals.

Dates: May 24 - 26, 2011
Duration: 6 hours per session
Cost: Free
Registration: https://www.eventbuilder.com/microsoft/event_desc.asp?p_event=x8f7i41r

Day One — "Office 365 Platform" May 24, 2011 | 10am-4pm PDT | Live online training

Microsoft Office 365 Overview for IT Pros
Deploying Clients for Office 365
Administration & Automation using PowerShell
Identity and Access Solutions
Directory Synchronization

Day Two — "Exchange Online" May 25, 2011 | 10am-4pm PDT | Live online training

Exchange Online Overview for IT Pros
Exchange Online Administration
Staged Exchange Online Migration
Hybrid Options with Exchange Server & Exchange Online
Exchange Online Archiving & Compliance

Day Three — "Lync & SharePoint Online" May 26, 2011 | 10am-4pm PDT | Live online training

Lync Online Overview & Configuration for IT Pros
SharePoint Online Overview
SharePoint Online Administration
SharePoint Online Extensibility & Customization
Office 365 Deployment Overview

What's a "Jump Start" Course?

Training specifically designed for experienced technologists and IT leaders whose jobs demand they know how to best leverage new, emerging Microsoft technologies. These advanced courses assume a certain level of expertise and domain knowledge, so they move quickly and cover topics in a fashion that enables teams to effectively map new skills to real-world situations.

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Edited by Mr. Wharty Thursday, March 8, 2012 10:44 AM

Reply:

It could also be of interest:

Microsoft offers a free eBook about Office 365:

http://www.microsoft.com/learning/en/us/certification/cloud-campaign.aspx?WT.mc_id=Cloud_MSL_MCPFlash_Mar

With kind regards,

Konrad

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

SQL 2005 upgrade to SQL 2008 R2

Hi,

SELECT

@@VERSION

Should I be able to upgrade In place for SQL 2008 R2 64?

I'm receiving

"The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2008 R2 version and edition upgrade matrix in Books Online."

which mentioning Ref:http://msdn.microsoft.com/en-us/library/ms143393.aspx

SQL Server 2005 X64 (64-bit) Standard SP2

SQL Server 2008 R2 X64 (64-bit) Standard

SQL Server 2008 R2 X64 (64-bit) Enterprise

Thank you

Yataplus

Reply:

Do you plan to upgrade in place? Is that possible to backup all user databases ,logins,jobs and install SS2008R2?

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

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

Thanks Uri for your reply.

Yes this is my backup plan but why I'm receiving this error while it's clearly state it's supported?

Also I have another issue which I need to use the default instance name MSSQLServer with 2008 which already used by 2005.

Thank you

Yataplus

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

Hello

You can run do a in-place upgrade to SQL 2008 R2 as mentioned in

http://msdn.microsoft.com/en-us/library/ms143393.aspx

Make sure you have a rollback plan in case something goes wrong

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

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

Ohh Thank you Javier...

You are confirming that I can do in place upgrade.

Sorry and please don't mind me as today is one of those days ;)

I hope someone will come up with an explanation for why we are receving this error or guide us to a work around..

Thanks again

Yataplus

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

Worh mentioning we receive that error

"The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2008 R2 version and edition upgrade matrix in Books Online."

at "SQL Server 2008 R2 Feature Upgrade" on "Upgrade Rules" step.

is there is any files or registry entry that we can check to fix that as it state that the upgrade is supported?

Yataplus

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

printer not activated error code

i can only print from word,can anyone help as to how to fix.

Reply:

Hi,

Please provide detail error information. What is "error code" in this "printer not activated error code –"?

Can the user print from the Microsoft XPS Document Writer when using Word? Ensure that the spooler service is running on both the client and server.

Whether you are using printer redirection in Terminal/RDS or not?

Please install the latest version of printer driver to see whether the issue still exists.

Technology changes life……

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

Making a 100 % private site or library?

Hello.

Here's my situation.

The company has SharePoint installed.

I have one site collection with one site for each department.

Today, I received a request from CEO that he wants a private folder.

So I would like to make either a private folder or library that is not accessible even from system administrator.

Is that possible? If so, please guide me through.

Thank you for your interest.

Hiro

Reply:

I suppose you mean the system account. No, thats not possible, there can be no location in a sharepoint site which is inaccessible to a system account or a site collection administrator.

These are administrative accounts, so any normal user is not supposed to be using them. Also, in a practical scenario, with time your CEO, might have issues with the private folder, if no one else has access to it accept him/her, then how will you be able to resolve that issue.

Also, if you find that there is no way out but your CEO requires that private folder to be absolutely private then you need to create a separate site collection with site collection administrator as your CEO only and provide the said folder. Even, in this case the system account will have access to the folder unless you decide that the application pool identity for that web application is also your CEO (which is not recommended as the application pool identity should ideally be an account which is not used by any user).

Regards, Huzefa Mala, MCTS

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

Shared data sources - one per: database? Instance? System?

What do people think is the best way to set up data sources?

Do you set up one data source for every database (setting the initial catalog to that database)? Or one for every SQL instance (setting the initial catalog to master)? Or perhaps one per "system" (setting the initial catalog to be master or one of the databases that is that system)?

Example setup:

SQL Instance 1 has 3 databases. CRM1, CRM2, ERP. SQL Instance 2 has 1 database: biztalk. SQL Instance 3 has 1 database: biztalk_messagebox.

How would you set up the data sources? Advantages and disadvantages:

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

1 Per database (CRM1, CRM2, ERP, biztalk, biztalk_messsagebox)

Advantages:

- easy to move a database to a different server, just update the data source for that database

- only need to use two part names in query as long as query only uses one database.

Disadvantages:

-lots of data sources.

-Reports that use more than one database (eg, CRM reports) arbitrarily pick one without any clear direction on which to choose.

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

1 Per instance (SQL1, SQL2, SQL3)

Advantages:

-Fewer data sources to manage.

-No ambiguity when reports need to go across more than one database

Disadvantages:

-Instance name must be abstracted in case the instance is moved to a new machine.

-If a database moves to a new instance all reports using that database must have their data sources changed.

-Report queries must use three part object names

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

1 Per system: (CRM, ERP, biztalk)

Advantages:

-"Sensible" data source names.

- System can move between instances without having to modify reports, just the shared data source.

Disadvantages:

-No clear choice of default catalog if the system is composed of multiple databases (just point to master?).

-Report queires must use three part object names if the system is composed of more than one database

-Not possible if "a system" is split across more than one SQL instance (but the only thing I know of that does this is biztalk, and arguably the messagebox component is a different "system")

Changed type Lola Wang Monday, March 12, 2012 6:22 AM

emails are missing..

My inbox emails are missing...when i want to read or search again my two weeks emails..nothing is found..

Reply:

My inbox emails are missing...when i want to read or search again my two weeks emails..nothing is found

me and my company are using 1 email account but we have server in the office...why in my laptop after 1 week you cannot search the 1 week old mails but in our office you can even find the old emails like last year or even last month.. please help how to solve this matter.

Thank you... in advance

Dina

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

Dear Fellow,

Which email client you are using on your laptop? what is the version and what is the account type configured? Is it IMAP/POP or "Microsoft Exchange"?

This you can verify from Account Settings configured.

Thanks.

Junaid Ahmed

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

Dear Fellow,

Any update on your case or issue is resolved?

Thanks.

Junaid Ahmed

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

How to Navigate from one page to another in microsoft surface 2.0.....

Hi , I am developing an application in microsoft surface 2.0 (WPF) ... I wants to use multiple .XAML pages in my application , I wants to redirect (navigate) from one page to another on TouchEnter event (surfacebutton) , but get not be success. If anyone has idea plz suggest me .... Thanks Anupam mishra

Edited by anupam.mishra Thursday, March 8, 2012 5:30 AM

RMS template deny export (save as) but when user opens he document it actually allows to save as.

The purpose of the template is to allow user to edit and make changes but not to save the document in a different location. This way the author can upload the document at Sharepoint and the user can collaborate with the document but no to save it on his document. This is the scenario: 3 Windows server 2008 R2 (Spanish language) - AD DS - AD CS - AD RMS 2 clients with Windows 7 pro (spanish language) -Office 2010 Pro+ (spanish language) -Right management Service template import task: activated. Note: First I installed Office 2010 SP1 Pro+ (spanish) but the option to protect the document wasn't available only without the SP1 or English version. Any ideas of why even the rights says the user doesn't have the right to export office allows it? Hope I've been clear! Thanks in advance!

Iam a Program-mer

Changed type 1Seer Wednesday, March 7, 2012 4:59 PM

Reply:

I don't think that is what the export permission means. Export means you can extract content from the document and save it unprotected somewhere else. Saving a file at a different location is as good as just saving it in place and the edit permission will allow it. What would be the point of preventing Save As anyway ? You could just copy the file externally to a different location.

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

Windows 8 Are you kidding me.

I own an iPad and an iPhone and am about to buy a MacBook Pro.

I have been a PC user for internet and email my entire life and I have been waiting for a new Windows product.

Windows 8//// What a joke! The improved boot time is great, but the Start page looks like something a 5 year old designed.

Is this the best the minds at Microsoft have? Apple will rule the world in 10 years. Give it up now and just put it in Lake Michigan and save the life's of millions of innocent people.

Reply:

Bud:

Did you happen to notice there is no forum for User Interface? LOL, I got a kick out of that, they knew they didn't want to dedicate terabytes of server space and network bandwidth to complaints from productive people who loathe the toy interface on machines meant to actually accomplish something of substance.

The worst part of this entire debacle is the authoritarian arrogance. It would have been terribly easy to accomodate both usage "paradigms" by including a simple toggle for "Yes, I want Metro to impede my productivity" or "No, I have work to do, let me have a genuine computing environment please."

The sad part is the fanboi crowd who will go out of their way to explain the different ways you can change everything you do to get back to something still not close to the way you work, and their fanboi hat-bands are kept so tight they reject the obvious productivity afforded by a start menu (a real one) and robust multi-tasking as "behind the times". "This is the future, get used to it!".

I'm going to say it again: If a simple toggle is not made available, Windows 8 will go down in history as the OS that killed the world's largest software company.

As for your comments about Apple, Apple is trying to sneak more and more of the toy OS "paradigm" into their laptop/desktop OS's as well, which I'm sure is part of the driving force behind Microsoft's heavy-handed arrogance on this issue as well.

Got to hand it to Apple though, sell a few million tablets and bring down the biggest software company on the planet as they struggle to play "me too".

DAS

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

. . .

I'm going to say it again: If a simple toggle is not made available, Windows 8 will go down in history as the OS that killed the world's largest software company.

As for your comments about Apple, Apple is trying to sneak more and more of the toy OS "paradigm" into their laptop/desktop OS's as well, which I'm sure is part of the driving force behind Microsoft's heavy-handed arrogance on this issue as well.

. . .

Ditto!

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

Hyper-V 3.0 Windows 8 server requirements

I'm trying to get an understanding of the hardware requirements for Hyper-v 3.0 in Windows Server 8.

I want to run this in a lab environment but want to be sure I have the hardware needed.

I've come across comments that a SLAT enabled processor will be required to run Hyper-V with RemoteFX (same as now)
or if you want to use Hyper-V in the desktop versions of Windows 8.

The confusing area for me (and I'm no expert) is that i read of support for SR-IOV, at least for the
virtual switch in Hyper-V 3.0.

Wouldn't SR-IOV require passthrough? vt-d from an intel standpoint with a chipset and bios that supports passthrough?

Changed type Vincent Hu Thursday, February 16, 2012 1:14 AM discussion is better

Reply:

The only people that know, MS employees, can't tell.

Win8 isn't even in beta yet and generally MS does not comment on unreleased products. At this point, the requirements are likely still a moving target.

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

Hi,

Hyper-V on Windows 8 Client version requires the processor to support Secondary Level Address Translation (SLAT). Hyper-V on Windows 8 Server version doesn't need SLAT(the same as previous version), SLAT is required only if you want to use RemoteFX.

Best regards,
Vincent Hu

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

Intel Xeon 5500 may support. I have installed Win8 Server Beta on our lab environmnet and set up an guest OS within the help of Hyper-v. But the driver development process seems torturing...

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

Remove exchange servers from EMC that are not relevant in the organization

How do i delete exchange servers that are no longer relevant or do not exist in my organization from the EMC. Below is the warning i get when i open EMC:

the following servers in your organization running microsoft exhange 2010 are currently unlicensed

Reply:

Hi,

Please refer the following link to troubleshoot this issue:

Enter Product Key
http://technet.microsoft.com/en-us/library/bb124582.aspx

If there is anything unclearly, Please visit related forum to get an effective anwser:

Exchange Server
http://social.technet.microsoft.com/Forums/en/category/exchangeserver

Thanks for your understanding!

Best Regards
Elytis Cheng

Elytis Cheng

TechNet Community Support

Edited by Elytis Cheng Thursday, March 8, 2012 1:37 AM

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

SAP GUI 7.20

A detailed recipe for sequencing SAP GUI 7.20 can be found on the SAP on SQL Server Blog:

http://blogs.msdn.com/b/saponsqlserver/archive/2011/10/11/how-to-virtualize-sap-gui-using-microsoft-app-v.aspx

Excerpt:

Official support from SAP for virtualizing SAP GUI for Windows 7.20 patch level 8 using
App-V 4.6 SP1 is in process. The blog will be updated accordingly once the general support
statement is public.

At this point in time a limited number of "pilot customers" are welcome to start
using SAP GUI 7.20 on App-V with full support ( first come first serve ). The
procedure is described in SAP note 66971.

This blog will describe the key items regarding the sequencing process for
SAP GUI as well as some recommendations to virtualize SAP BEX Analyzer
( Excel plugin ) version 3.5 and 7.

Changed type Dave Trupkin [MSFT] Thursday, March 8, 2012 12:15 AM
Changed type Eduardo Noriega de ArmasMicrosoft employee Friday, March 8, 2013 6:12 PM
Changed type Eduardo Noriega de ArmasMicrosoft employee Friday, March 8, 2013 6:12 PM

How Best to Create A Start Button Replacement?

Microsoft has eliminated the Start button from the Taskbar in the Windows 8 Customer Preview - we see this. They want us jumping through the Metro world as often as possible, presumably in the hopes of making us crave stuff from the new App Store.

Those of us fond of staying on the Desktop and only venturing over to Metro land when absolutely necessary are no doubt thinking:

How can I replace the Start button with something that will allow me to stay on the Desktop, yet not have to have shortcuts for EVERYTHING I could ever want to use on the desktop or pinned to the Taskbar?

At some point there may be custom software to fill the bill - e.g., a derivative of the wonderful ClassicShell package - but it doesn't work yet with the Windows 8 CP.

But we DO see that the Taskbar in Windows 8 DOES support the creation of custom menus, so let's see what we can do to get at least something down there where the Start button used to be...

We find that we can right-click on an open space on the Taskbar, click Toolbars, then click New toolbar..., then point Explorer at an existing folder on the hard drive, and that manipulating the Taskbar after having done so can give us a new menu that we can click on and get a hierarchial folder breakdown...

If it weren't for the fact that the traditional Start menu contents (e.g., in Windows 7) is an aggregation of the user-specific Start Menu and the system-wide Start Menu, it might be good enough just to make a toolbar that points to the place in the folder structure where the Start menu exists. With the creation of a new folder called Start and the addition of a couple of symbolic links to the two Start Menu folders mentioned, we can have a menu called Start on the Taskbar that gives you quick access to both places - though you'll have to choose between them. Something, but perhaps not as convenient as it could be...

Having accomplished the above, I'm now trying to think of ways to consolidate the contents of the two existing Start Menu folders, to provide a slightly more unified experience. Your thoughts and ideas for doing this would be welcome.

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

Edited by Noel Carboni Thursday, March 1, 2012 4:47 PM clarified wording
Changed type Niki HanModerator Wednesday, March 7, 2012 9:17 AM

Reply:

This was my thought. I wish you could still place them anywhere on the screen however.

Vote for Freedom - Vote to Protect our Country

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

Install ViStart:

http://lee-soft.com/vistart/

The only issue is the overlaying icon. I try to find a workaround later.

"A programmer is just a tool which converts caffeine into code"

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

Hm, interesting. You're saying this works on Windows 8 CP then?

As far as reserving some space, you could just create a "null" toolbar by pointing to an empty folder.

Off to try this! Thanks.

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

OK, I've installed ViStart, and yes, putting a toolbar back there on the Taskbar can be used to reserve some space. I called it "-".

Observations...

It consolidates the two Start Menu trees into one nicely.
I don't see a way to reconfigure it to show different stuff on the right (or to show the stuff as menus, etc.).
It doesn't find things it ought to - e.g., type cleartype or color management into the search box and... Nothing.
Occasionally it ends up behind the Taskbar instead of in front of it.
It auto-hides and is okay with the Taskbar being on the top of the display
It comes out from auto-hide at a slightly different time than the Taskbar.
The "user" icon is skewed a little bit up too high.
There's no right-click and open functionality, nor ability to directly reorganize the Start menu in the app itself.

Not perfect, but hey, it has some promise to hold the place until a better solution comes out, and the price is no problem. :)

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

Edited by Noel Carboni Thursday, March 1, 2012 11:55 PM

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

Interesting post, Noel. There were other solutions provided as responses on the Building Windows 8 blog when the new Start screen was unveiled. I highly recommend that anyone looking for options like this review these posts to get a better understanding of the logic behind the new Start screen design and the efficiences that can be gained by using it:

http://blogs.msdn.com/b/b8/archive/2011/10/11/reflecting-on-your-comments-on-the-start-screen.aspx

http://blogs.msdn.com/b/b8/archive/2011/10/04/designing-the-start-screen.aspx

http://blogs.msdn.com/b/b8/archive/2011/10/03/evolving-the-start-menu.aspx

(in any order you prefer). Collectively, a long, but interesting read.

Thanks for your post.

Jim

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

Thanks for the response and info, Jim, but you have to understand that there really needs to be a way not to replace the entire UI with a field of boxes to hunt through while starting a new application. This is not new news; pretty much every serious Windows user feels the same way - they don't want to be blitzed by the Start screen while transitioning between applications on the Desktop.

Microsoft's assumption that there is no need for a hierarchy of programs is almost laughable.

It may be that, because Windows is difficult to configure well, many people don't use it or try to rely on it for complex work, I don't know. I DO know that I have found ways to set Windows 7 up to be a powerhouse business and development environment, and it really does seem that Windows 8 is striving to take all that away. At this point of looking at the CP I'm almost convinced that, with some 3rd party add-on tools, it can be kept a serious, powerful environment in which to create value. But I'm forced to wonder what else Microsoft will be moving away from the needs of serious, multitasking users and into the realm of fun and games. I'm sorry to be blunt.

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

Metro = Idiocracy

Edited by orlyonok Friday, March 2, 2012 8:26 AM

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

Hm, interesting. You're saying this works on Windows 8 CP then?

As far as reserving some space, you could just create a "null" toolbar by pointing to an empty folder.

yes this works:

Thanks for the tip!

"A programmer is just a tool which converts caffeine into code"

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

You're welcome. I ended up having to lengthen it to ----- to ensure there was always enough room.

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

Just found this out:

The shell: functionality still works too. [win] + R to bring up the run dialog then type in:

shell:common start menu

And if you take the folder up one level, right click on the Start Menu item and click on Pin to Start, it appears in the Metro interface and works much like your old start menu, only in a Windows Explorer interface.

This is the backdoor that makes me feel comfortable again. Thanks dgobe for pointing this out.

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

Thanks for the thought, Silverpulser, but it seems that this only opens the C:\ProgramData\Microsoft\Windows\Start Menu folder, which will only give you access to the system-wide Start Menu items, and does not aggregate the user Start Menu items at all.

Are you seeing something I'm not?

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

True but for me it is those items that I would like easy access to. My User items that I mostly use would probably be on the Metro start screen already.

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

This probably sounds like a sneer but heck.. First thanks for sharing, but to be honest I'd rather dig up progman.exe from some archives and get that up & running (it hasn't been removed /that/ long ago) than try any of the solutions above (no offense intended).

My main gripe with this whole metro kaboodle is the lack of jumplists. I've become /very/ dependend on them on Win7 and can't understand why the heck they ditched all that.

Remote desktop? On Win7 this sits right in my recent list, so a mere 2 clicks is enough to start it. If I need more I simply hoover so that my 2 2k3 servers (pinned) become visible (or recent customer servers). An almost perfect experience as far as I'm concerned.

Now? Obviously the Metro remote desktop client is pretty useless. Try typing something over from OneNote whenever an application doesn't allow you to use the clipboard to copy things over. Happy alt-tabbing! No thanks. So now I have to manually fire up mstsc.exe (win - mstsc, then it appears) to get a 'normal' remote desktop experience. Obviously no more (dynamic) jumplists, only a meager "recently used" pulldown.

This whole mess (personal opinion) is a major step backwards to me.

</rant>

With kind regards, Peter

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

Great idea and tried this myself and it worked with a local user account.

The program did NOT work for me with my domain account using folder redirection. It totally bombs out for me since I have my Pictures, Documents, Favorites, Videos, and a few other profile folders redirected to my Windows server.

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

I didn't realize there was a pro forum until pointed to it.

I thought I could do better than ViStart, so I started my own brew. If W8 exits to RTM like that, I have it covered. (http://www.freeimagehosting.net/7nn4w). Mine looks better too. And if I'm rebuilding it, I'm going to make it better. I already have a search box(not visible in the screenshot, the screenshot old, I also fixed icons in the pinned section) with several engines, a la Firefox search, with Ctrl+enter switching engines (search/CMD/Google/BING) and enter searching and new engines are as simple as can be to add (INI file, logos can be any well-known graphic of any size).

After I fixed the list and scroll (it's scrolled with wheel, has type to search), as well as icons and sorting I kind of slowed down. But nonetheless I have no intention of stopping and if it really comes down to it, I am going to fully implement it, jump lists included, then make it better, then make it free and (hopefully) open so there will never be trust issues.

Like I posted in the consumer forum, Start Menu isn't Fata Morgana. It's not Office. It can be written, and written well. I already like it more than my start in W7 and I'm thinking of switching. That CMD mode looks quite shiny. I'm also thinking of a "versatile" box mode that uses keywords "google hello" or "cmd killall".

As I have had quite the positive feedback, I'm pretty sure I'm doing this. If you have ideas, I'll take them.

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

Go for it, but keep in mind that there's almost no doubt that ClassicShell (an open source project) is light-years ahead of you already. They only need to tweak it to get it to work in the updated environment.

I know that for me the buggy and incomplete ViStart will be history when ClassicShell starts to work with Windows 8.

-Noel

Detailed how-to in my new eBook: Configure The Windows 7 "To Work" Options

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

http://www.zdnet.com/blog/hardware/restore-the-start-menu-and-disable-metro-ui-in-windows-8/18767

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

Jim, I'm trying it, but I'm not efficient. I can't shut the laptop down. I can't get to control panel. I can't figure out how to quickly build metro tiles for my users shortcuts that they will need to run applications. I get it that you guys need a touch enabled platform, go for it. But with this design you are turning your back on keyboard and mouse users. In otherwords everyone in my office that currently uses Windows 7 or XP and will tell me not to upgrade them, or will have me building shortcuts for their applications that they use which will slow down my rollout of any windows 8 platform.

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

It's also classic, and that is not going to become better any time soon. I'm going for the best features, glass and wide customization range. Plus a few others I always wanted, such as the ability to tell it to just go full height, resize horizontally, or use it as search engine. I've halted development (kind of a big word for a project one day old) until I have a more or less definitive answer on whether or not this is permanent. (does anyone know if this will carry over to RTM? Will SM be back?)

If it is, I'm starting right now. If Start comes back, it's a side project for me as I would imagine most people would still go for the real deal.

@susan

That procedure doesn't restore the start menu nor does it disable Metro in any way - features are still moved to Metro, and WIN will still pop Start (didn't try it, though I would imagine Windows already hooked the key before the app had a chance to - nor do I think "win" is hookable at normal levels, such as RegisterHotKey)

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

Go for it [...]

I went for it.

The project is called 7Start, it is a rough implementation (with some functional improvements) to Windows 7 style start menu, and has now entered Beta stage (Beta 1). Once I move some settings from INI to a setting UI it will also come with the source.

You are of course free to try and, if you do, please provide some feedback. The 15 people that tried it so far have been silent. Personally, I think it's going well, even with some limitations due to the fact that I'm not the OS.

Keep in mind, it is being called with Ctrl+\, as WIN can't be registered in any way I know. And even if it could, it would still call on Metro. It should work fine on W7 as well.

https://sourceforge.net/projects/ndi7start/

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

Tiles of legacy application with same name

Hello,
I'm sorry if someone already discussed the same issue.

I noticed only one tile appear in start screen if multple applications have the same name. For example,

Step 1. Install a legacy application A, which creates two shortcuts, 'Launch A' and 'ReleaseNotes' in program group 'A'.
Step 2. Install another legacy application B, which creates two shortcuts, 'Launch B' and 'ReleaseNotes' in program group 'B'.

Then, I expect StartScreen shows four additional tiles, 'Launch A', 'ReleaseNotes', 'Launch B', and 'ReleaseNotes', but actually only three tiles are shown, 'Launch A', 'ReleaseNotes', and 'Launch B'. If you select 'ReleaseNotes', then application A's release notes will appear. You cannot open application B's release notes.

So I want StartScreen to create program groups automatically, like 'A' and 'B', and make each group have a tile named 'ReleaseNotes'.

Deny connections coming from a particular application server to sql server

Is there a way with which I can deny connections coming from a particular application server to sql server?

I have an application server which when connects to the sql server it degrades its performance. Now before I look into the queries, for now I want to block all the connections coming from this server without shutting it down.

Thank you in advance.

Prasenjit Gupta DBA Tata Consultancy Services Ltd.

Reply:

Try this... you can plug your application Server hostname in this script

CREATE TRIGGER [connection_trigger]
ON ALL SERVER WITH EXECUTE AS self
FOR LOGON
AS
BEGIN
IF 'YourHostName' =(SELECT host_name FROM sys.dm_exec_sessions
)
ROLLBACK;
END;

GO

ENABLE TRIGGER [connection_trigger] ON ALL SERVER
GO

Edited by sqlrockz Wednesday, March 7, 2012 8:03 PM

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

Thanks Sajid.

Actually I want to block connections based on IP rather than login. While looking for the solution found the following query which did the job:

USE

MASTER

CREATE

TRIGGER logon_trigger

ALL SERVER

WITH

EXECUTE AS 'sa'

FOR

logon

BEGIN

DECLARE

@client_host nvarchar(max);

SELECT

@client_host=EVENTDATA().VALUE('(/EVENT_INSTANCE/ClientHost)[1]','NVARCHAR(MAX)')

@client_host IN ('<IP_ADDRESS>')

ROLLBACK

END

Prasenjit Gupta DBA Tata Consultancy Services Ltd.

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

did you tried my solution ... it is actually using host_name and not login

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

Pls check this article http://sql-articles.com/articles/security/ip-address-blocking-or-restriction-in-sql-server/

http://uk.linkedin.com/in/ramjaddu

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

thanks Sajid and Prasenjit,

your trigger is stopping the users from the particular host from logging into the sql server, but it gives a meggase to the user, that a trigger is stopping it from connection. Is there a way to mask that alert at the host?

Please help.

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

Tuesday, March 1, 2022

Ever wonder what all plays nicely w/ Windows8?

Ever wonder what all plays nicely w/ Windows8?

is it safe to delete C:\Program Files\Microsoft SQL Server \100\SetupBootstrap\Update Cache in SQL Server 2008 SP3

Server Agent Jobs

Exchange 2010- catch emails which are not delivered.

IE Tile Behavior

How to back up me (a one-man IT dept)?

Can Not Force Replicate users between 2 Servers (Exchange 2003)

Can I assign permissions for an entire library in a workflow?

Retrieving blank values using caml

Easy way to delete tile groups

Fast ESP 5.3. and SP2010 connector

Cannot add users to Public Folder Permissions in Exchange 2010

Update Password Not Required for domain controller machine account

Making a simple GPO

HP announces new client

How to get a list of network filters installed on a Windows 7 system

Bug? Alert status iw Warning, but there are no alerts (Unable to clear alert state)

Cannot use file for Clustered server

Discuss Private Cloud Planning Guide for Systems Management

When to code and when to script?

E mail alerts in tasks for external users

E mail alerts in tasks for external users

Weather App won't detect location

Fields not displayed in Online Addressbok (Exchange 2010)

TMG at HO and direct access at branches

Error in Crystal Repot 10 To Connect To SQL SERVER 2008 R2??????????

Microsoft Office 365 for IT Professionals Jump Start

SQL 2005 upgrade to SQL 2008 R2

printer not activated error code

Making a 100 % private site or library?

Shared data sources - one per: database? Instance? System?

emails are missing..

How to Navigate from one page to another in microsoft surface 2.0.....

RMS template deny export (save as) but when user opens he document it actually allows to save as.

Windows 8 Are you kidding me.

Hyper-V 3.0 Windows 8 server requirements

Remove exchange servers from EMC that are not relevant in the organization

SAP GUI 7.20

How Best to Create A Start Button Replacement?

Tiles of legacy application with same name

Deny connections coming from a particular application server to sql server

Setup is Split Across Multiple CDs