Monday, January 31, 2022

hotmail id

hotmail id

hi! this is mithil from ahmedabad.  i m using hotmail id since last 10 years. now it has converted in outlook account automatically. my account storage is full now. so want solution for the same.

Reply:
hi! this is mithil from ahmedabad.  i m using hotmail id since last 10 years. now it has converted in outlook account automatically. my account storage is full now. so want solution for the same.


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

MAC RDC LAT-LIT

When connecting from OS X (10.10) with Latvian keyboard layout to Windows machine, Windows keyboard layout is Lithuanian (LIT). That's annoying.

Reply:

Hi,

Keyboard mapping issue should be fixed in recently update. Please let us know your RDC version. If the issue persists in latest version, I will report this to product team. 

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


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

Hi!

RDC version 8.0.18 (Build 26163). The issue still persists.


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

I agree.

Same problem here!
Problem Has been for many versions and is still here. Version 8.0.18


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

Hi,

I have reported this issue and if there is any update I'll post back. 

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


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

Hi!

Build .19. The problem is still there!


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

Please test drive our new beta application and see if your issue is fixed in this version: http://aka.ms/rdmac-preview

We have worked on an improved experience here and support as well native Mac shortcuts. The beta app will be enhanced over time with features.


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

In beta everything is OK. Thank you!


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

tuzla bilgisayar,tuzla bilgisayar ve teknik servis,tuzlada bilgisayarcı

Tuzla bölgesinde Kurumsal Bakım Anlaşmaları olan işletmeler, işleri ile meşgul olurlar, sorunların çözümü ile ALP BİLGE ilgilenir, sorunların meydana gelmemesi için ALP BİLGE rutin kontroller yapar, ilerleyen dönemlerde olabilecek gereksinimler için, fizibilite çalışmalarıALP BİLGE yapar, işin niteliğine göre gece çalışır, gündüz çalışır, öğle arasında çalışır ve sorunu çözer.

Kurumsal bakım anlaşması yapmak istiyorsanız, bizi arayın, uzman ekibimizle ofisinizi ziyaret edelim, fizibilitesini yapalım,

tuzla bilgisayar kalitesi ile hizmet almanın mutluluğunu yaşayın.

http://tuzlabilgisayar.org/

Hierarchical Database/Data Model

I might have to take over/recreate a specific Forum. And it would be a "really nice to have" feature if the posts of each thread were structured in a Heirarchical Tree.

Now I noticed that Heirarchical Post Structure is really, really rarely used for Forums. MSDN is one of the few examples I know. Otherwise I have only seen this structure for comment systems but there it is most common.

Even MSDN tries to limit the number of answers per thread somewhat (via the "only question per thread" rule). What I would have to make will need a tree structure consisting of easily 100 nodes/thread. With leaf structures 10-20 generations deep. If I do choose tree structure it's per thread scale would be bigger then MSDN or any comment system I have seen.
The original system limited the DB server load by only loading the title of each post, putting loading the actuall post off until the user requested it via the Web GUI (some java/ajax control I think).

My DB experience is limited mostly to Relational databases. Tree structures I have so far only used for basic XML, HTML, XAML and similar markup languages. I never used a Heirarchical DB before, but I do know how to simulate such a structure in a Relational Database. I even have some ideas to make it more manageable (making each thread and possible each top level post it's own tree).
I am just not certain I should, as it is a totally new area and the task seems a bit bigger scale then anything else I see on the internet.
Are there any good resource for teaching a Relational DB programmer to use Heirarchical Structures/DB engines?
Is SQL a good engine for Heirachical Data?
Are there any other good Heirarchical DB engines?
Maybe even a good Heirarchical CMS/pre written Forum system I could just start from?


Reply:
As  you probably know since SQL Server 2008 we can use HierarchyID system data type – along with a variety of
 system methods – is designed to make it easier to store, query,
 modify and work with hierarchical data. This new data type is
 optimized for displaying data trees. The HierarchyID data type 
supports two strategies for index storage. They are called depth-first 
and breadth-first. In depth-first, rows in a single tree are stored 
close to each other in the index. An original chart type data with employees
 and managers is a typical example. In breadth-first, the rows are stored next
 to each other. In the employee / manager example, the employees who report
 to the same manager would be stored next to each other.

There are several system functions and methods associated with the
 HierarchyID data type. Some include GetLevel(), ParentChildOrg(),
 DescendantLimit() and GetAncestor(). The example below shows 
a simple example of a parent child relationship between managers and employees.


CREATE TABLE Organization
   (
 NodeLevel hierarchyid,
    EmployeeID int,
    OrgLevel as NodeLevel.GetLevel(), 
    EmployeeName nvarchar(50) NOT NULL
   ) ;
GO
insert into Organization
(NodeLevel, EmployeeID,  EmployeeName)
values
(hierarchyid::GetRoot(),0,  'Bob')
go
Declare @Manager hierarchyid
SELECT @Manager = hierarchyid::GetRoot()
FROM Organization ;

insert into Organization
(NodeLevel, EmployeeId,  EmployeeName)
values
(@Manager.GetDescendant(null, null), 1, 'Joe')
go
Declare @Manager hierarchyid
declare @NodeLevel hierarchyid

select @NodeLevel = NodeLevel 
from Organization 
where EmployeeName = 'Joe'

SELECT @Manager = max(NodeLevel)
FROM Organization
where NodeLevel.GetAncestor(1) = @NodeLevel

insert into Organization
(NodeLevel, EmployeeID,  EmployeeName)
values
(@NodeLevel.GetDescendant(@Manager, null),2,  'Sarah')
go
select NodeLevel.ToString()as NodeLevel_String, *
FROM Organization
go
drop table Organization
go

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

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


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

Hi Chris,

Please go through this pdf. I found it useful

http://ebooks.cawok.pro/Morgan.Kaufmann.Joe.Celkos.Trees.and.Hierarchies.in.SQL.for.Smarties.May.2004.eBook-DDU.pdf

Please Dont forget to mark as answer and Helpful Post. It helps others to find relevant posts to the same question. Milan Das


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

How to put line below each and every row as the result of Join expression for Textbox in SSRS

Hi Team,

For a textbox we are assigning the below expression. The textbox was placed in a table whose dataset is DataSet1

=Join(LookupSet(101,Fields!CaseId.Value,(Fields!Region.Value+";"+Fields!Jursidiction.value+";"+Fields!Entity.value),"DataSet2"),vbcrLF)

this expression will return the below result set from the "DataSet2"  show in the textbox

Region1;Jursidiction1;Entity1

Region2;Jursidiction2;Entity2

Region3;Jursidiction3;Entity3

but what customer want was a line below each row like  below kind of one column multiple row table. Please help

Region1;Jursidiction1;Entity1

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

Region2;Jursidiction2;Entity2

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

Region3;Jursidiction3;Entity3

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


Just FYI, new blog post "Switch Embedded Teaming - Network Adapter Teaming Within Hyper-V Virtual Switch"

Windows Server Technical Preview now supports Switch Embedded Teaming (SET), which allows you to create a network adapter team within the Hyper-V Virtual Switch. SET teams are compatible with Remote Direct Memory Access (RDMA)-capable NICs, which allows you to use fewer network adapters in servers where you want to use both SET and RDMA.

For more information, see "Switch Embedded Teaming - Network Adapter Teaming Within Hyper-V Virtual Switch" at http://aka.ms/bfgmpt

Thanks -

James McIllece

Just FYI, new blog post "Switch Embedded Teaming - Network Adapter Teaming Within Hyper-V Virtual Switch"

Just FYI, new blog post "Switch Embedded Teaming - Network Adapter Teaming Within Hyper-V Virtual Switch" at http://aka.ms/bfgmpt

Thanks -

James McIllece

How to make my Azure VM with Windows Server2012 R2 image more Secure ?

Hello Everyone!!!

I have an Azure VM with Windows Server 2012R2 Image on it. I am hosting a website on it through IIS, how can I make My Azure VM more secure from external breaches, unauthorized access ?

DotNet Developer at Intellisoft Technologies India

  • Changed type Amy Wang_ Tuesday, September 8, 2015 9:23 AM

Reply:

On Tue, 1 Sep 2015 13:34:25 +0000, Ritesh Verma paradigm wrote:

I have an Azure VM with Windows Server 2012R2 Image on it. I am hosting a website on it through IIS, how can I make My Azure VM more secure from external breaches, unauthorized access ?

Azure related questions should be posted to:

https://social.msdn.microsoft.com/forums/azure/en-US/home?category=windowsazureplatform%2Cazuremarketplace%2Cwindowsazureplatformctp

Paul Adare - FIM CM MVP


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

Off-site PXE building

Hi,

We, for many years have been deploying PC images and task sequences on our LAN.  We're moving to a model where the supplier does as much of the build as possible off-site.  In an ideal world I would get a VPN up between us and our supplier, place some SCCM roles down there, replicate some content and get them to build from a PXE box at their end, meaning that when the machines arrive on site they are fully built and ready to use.  For compliance reasons a VPN is out of the question so we have tested the water using pre-stage media, which is allowing us to perform about half of the task off-site and then continue with the TS back here, where Windows Updates are applied and the machine is domain joined.

Does anyone have any design suggestions to allow more to take place at the supplier end but without VPN?  Our compliance team are happy to expose some ports to enable some communication between us and the supplier, e.g. to allow replication of an image from one site to the other but that is all.  I'd be happy for the domain join to take place when the machine arrives on-site but probably the biggest issue is applying updates.  We produce a new image each month after patches are released but if an old image is used then the number of applicable updates once built is high.  I'd like at least to be apply to run the apply updates stage at the supplier end, or if it was possible run an internet based Windows Update as part of the TS which runs in the factory but this doesn't appear to be an option.

Any thoughts?

Thanks


Reply:

Well the first issue I see is the domain join part. If you can't allow any sort of VPN you would need to remove the domain join part out of the task sequence. By doing this you would need to make sure no other part of your task sequence require to access some sort of domain resources.

Once you are sure that you have nothing in the task sequence that make reference to something inside the domain you could simply provide them with a stand alone media. Each time you build the new ISO you can just make a new media and overnight ship it to them or have it copi over using FTP or something else.

The fact that no VPN can be open to allow communication with your domain makes it hard. I think the best solution if you want the entire process to be done when the pc arrive is to remove every part in the task sequence that require the domain and make a stand alone media. 

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

Well the first issue I see is the domain join part. If you can't allow any sort of VPN you would need to remove the domain join part out of the task sequence. By doing this you would need to make sure no other part of your task sequence require to access some sort of domain resources.

Once you are sure that you have nothing in the task sequence that make reference to something inside the domain you could simply provide them with a stand alone media. Each time you build the new ISO you can just make a new media and overnight ship it to them or have it copi over using FTP or something else.

The fact that no VPN can be open to allow 

Hi,

This is basically what we do now, the steps in the TS which run after the machine is shutdown in the factory include the domain join.  It does work but in the gap between updates being released and us providing the supplier with a new image  means that those machines spend an hour running the Apply Updates step when the box arrives on site.  If there was any way of being able to apply the updates at their end this would be resolved...

Thanks


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

Well if you make a new media every month and you send it right away to the supplier when the machine arrive it should at the most be 1 month behind in patch. It should never take hours.

This part get tricky because the supplier need to have all the windows update you approved so he would need to get access to your SUP to get those package. You could try to make a script in the task sequence that try to install the missing windows update from the internet (if the supplier allow it but still would not be the same as the pre- approve update you decided).

I still think the easy thing for you would be to make a stand alone media and each time you make a new one ( each month) upload it to them for use.


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

[See Warning] Final ADK and MDT 2013 Update 1 download locations

ADK - http://go.microsoft.com/fwlink/p/?LinkId=526740

MDT 2013 Update 1 - http://www.microsoft.com/en-us/download/details.aspx?id=48595
[Published 8/17/2015]

If this post is helpful please vote it as Helpful or click Mark for answer.


  • Edited by Dan_Vega Wednesday, August 26, 2015 3:19 PM

Reply:

FYI: Do *NOT* upgrade to update 1 just yet. If you have to expect issues.

http://blogs.technet.com/b/msdeployment/archive/2015/08/25/mdt-2013-update-1-release-notes-and-known-issues.aspx

If this post is helpful please vote it as Helpful or click Mark for answer.


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

Added more links:

Johan Arwidmark has a guide a long with some bugs listed:
http://deploymentresearch.com/Research/Post/504/A-Geeks-Guide-for-upgrading-MDT-2013-to-MDT-2013-Update-1

Keith Garner has been posting MDT bugs to his blog:
https://keithga.wordpress.com/

If this post is helpful please vote it as Helpful or click Mark for answer.


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

Renew Microsoft Office

  Hell-o,

Trying to renew Microsoft office


Reply:

Hi. Your question is off topic - this thread is related to Microsoft Sharepoint.

Anyway - Office 365 renewal: http://www.microsoftstore.com/store/msusa/en_US/cat/Office-365-Renewal/categoryID.68289700

M.


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

Failover validation error on cluster

The error is as follows: 

The server S3.Posto.local does not have the service principal name (SPN) MSServerClusterMgmtAPI/S3. THis is needed for cluster APIsto authenticate to the server by using kerberos. To add SPNs on the server computer obnect use the Set-ADComputer cmdletwith the -SetPrincipalNames parameter. 

Both systems are in same domain and are windows 2012 R2 standard. 

S1.Posto.local is always reconigzed but never S2 or S3. Tried doing cluster with both. 

Anything will help. 



Rafael


Reply:

Well the error kind of gave it away.

For the computer s1,s2 and s3 do this

setspn -L S*.Posto.local now compare the result and you should see that S1 as probably more spn then the other 2.

Now add the missing SPN to computer S2 and S3


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

Ask for Input and Use Input in the Next Command

Hi Everyone,

I am not very god at scripting and need a bit of your help.

I have a command hat I plan on using to get a remote computesr's OS version and installed patches. 

I can use a txt file with the computer name to be queried, but I thought it would be even easier for the batch file to ask me for input so I enter the computer name and once I enter it, it uses it for the next command.

Here is the code I have so far:

@echo off
set /p CompName= Enter name of computer?  %Compname% > c:\computers.txt
wmic  /node:@c:\computers.txt  os get Caption,CSDVersion /value /format:htable >> C:\OSnPatches.htm  & wmic /node:@c:\computers.txt qfe list full /format:htable >> C:\OSnPatches.htm

Can you help me get the CompName variable be used in the WMIC query?

Thanks in advance,

S

  • Changed type Bill_Stewart Tuesday, September 29, 2015 3:50 PM
  • Moved by Bill_Stewart Tuesday, September 29, 2015 3:51 PM This is not "scripts on demand"

Reply:

Batch files are obsolete. You should be using PowerShell.

wmic  /node:%compname% ...

 

\_(ツ)_/


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

Batch files are obsolete. You should be using PowerShell.

wmic  /node:%compname% ...

 save it as a PS1, I get it. Any help with the code?

\_(ツ)_/



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

There are numerous resources available to you to find pre-written scripts.

For example, there is a Repository link right at the top of this page.

-- Bill Stewart [Bill_Stewart]


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

There are numerous resources available to you to find pre-written scripts.

For example, there is a Repository link right at the top of this page.

-- Bill Stewart [Bill_Stewart]

Thanks, i have already spent 2 days searching for something I do not need to write from scratch, and the repository doesn ot contain what I am looking for.

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

Thanks, i have already spent 2 days searching for something I do not need to write from scratch, and the repository doesn ot contain what I am looking for.

Do you actually have further questions (if so, you'll need to start a new thread)? Yours has already been answered.

I also highly recommend that you drop batch and do all further work in PowerShell.


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

Batch files are obsolete. You should be using PowerShell.

wmic  /node:%compname% ...

 save it as a PS1, I get it. Any help with the code?

\_(ツ)_/


No - the code I posted is the batch line that does what you ask.

Note that you are expected to be a Windows technician with basic training in how to use Windows utilities.  If you are using batch you need to learn how to use batch variables in batch files. This is all part of the most fundamental training in windows administration for the desktop.

You cannot learn or use any of the technologies without learning the basics first.  This is easy with Windows as there are many books, new and used, that will teach you desktop administration.  The problem is that there is almost no resource left for teaching batch but searching will find you some older sites that can help you learn.

\_(ツ)_/


------------------------------------
Reply:
Thanks, i have already spent 2 days searching for something I do not need to write from scratch, and the repository doesn ot contain what I am looking for.

It is usually rare to find a pre-written script that meets your exact specifications.

In these cases, you will need to look for examples of scripts that do things like what you want, and then customize to your specifications.

The purpose of this forum to answer scripting questions, not to deliver pre-written scripts to requested specifications. If you need for someone to write code for you, it would be appropriate to pay a consultant.

-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:
Thank. I'm just starting to learn, but got a task to do this stuff. Will need to learn faster, it seems.

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

Here is what I got trying to put together a script to read the patches on a remote PC:

$computer = gc env:computername  $computers= get-content -path c:\computer.txt  $csvfile = "c:\name.csv"  foreach ($computer in $computers) {Get-WmiObject -Class WIN32_QuickFixEngineering | Select-Object "Caption","CSName","Description","InstalledBy","InstalledOn" |ConvertTo-HTML | Out-File $csvfile}

I do get the results, but I get them from the local machine and not the remote one. What am I doing wrong trying to get the computer name from the c:\computer.txt file?

Thanks again for the help.


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

You need to use the -ComputerName parameter of Get-WmiObject.

http://ss64.com/ps/get-wmiobject.html


------------------------------------
Reply:
Thank. I'm just starting to learn, but got a task to do this stuff. Will need to learn faster, it seems.

There is no such thing as learning faster.  Learning is a biochemical process that operates according to the laws of chemistry and physics.  You can only be healthy and study carefully.  The learning happens at its own pace.

Trying to jam 10 pounds into a 5 pound bag never works.

\_(ツ)_/


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

Cost of setting up SP 2016 on Azure

What's the cost of setting up the SP 2016 Default VM on Azure ?(http://blogs.technet.com/b/wbaer/archive/2015/08/27/sharepoint-server-2016-it-preview-image-in-windows-azure-platform-gallery.aspx)

What is the bare mininum VM config we need? I know we need to select two servers for setting up SharePoint 2016.

Regards,

Kunal


Reply:
The cost will be dependent on the selected virtual machine size, runtime, and other factors.  For detailed Azure Virtual Machine pricing see also http://azure.microsoft.com/en-us/pricing/details/virtual-machines/.  For SharePoint Server 2016 IT Preview evaluation experiences you could assigned as little as 8 GB to the virtual machine and 2 cores or select an equi-sized Azure Virtual Machine.  Domain controllers can be assigned as little at 1-2 GB and a single core for evaluation environments with low Auth characteristics.  For additional information on hardware sizing see also http://social.technet.microsoft.com/wiki/contents/articles/32055.sharepoint-server-2016-resources.aspx.

------------------------------------
Reply:
The cost will be dependent on the selected virtual machine size, runtime, and other factors.  For detailed Azure Virtual Machine pricing see also http://azure.microsoft.com/en-us/pricing/details/virtual-machines/.  For SharePoint Server 2016 IT Preview evaluation experiences you could assigned as little as 8 GB to the virtual machine and 2 cores or select an equi-sized Azure Virtual Machine.  Domain controllers can be assigned as little at 1-2 GB and a single core for evaluation environments with low Auth characteristics.  For additional information on hardware sizing see also http://social.technet.microsoft.com/wiki/contents/articles/32055.sharepoint-server-2016-resources.aspx.

Ya figured it out and provisoned the image on two A4 VMs. Enough power for evaluation enviroment I suppose.

The link to hardware sizing seems to be broken. The link to you blog on this, here.

Thanks Bill!



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

HR Maintenance App in Ramp Up

Hi,

There is a simple HR Maintenance program used in the Ramp Up Virtual labs here:

http://technet.microsoft.com/en-us/forefront/ff793470

Is this program available to download?  The exe name is HRMaintenance.exe.

The virtual labs are all well and good, but they take a while to load and you only have limited time before they expire.  It would be nice to be able to create our own duplicates of these labs for testing\learning.  The FIM & SQL config can be duplicated, this HR tool cannot (easily).

Many thanks.




Reply:

Brendan,

I think I can help you out here. If you look at the about screen, you'll see that my employer (Oxford Computer Group) produced that software - as well as a lot of other things in there. I believe we've made the software available for outside use with an appropriate disclaimer as to what it's for. I'll find out if it's ok to distribute and figure out how to get it to you. No guarantees - but I'll ask.

Frank C. Drewes III - Senior Consultant: Oxford Computer Group


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

Hi Frank,

I'm also interested in downloading the hr maintenance app used in the fim virtual labs. could u pls let me know the download link? I googled after "Oxford Computer Group hr maintenance download" but I didn't find anything suitable.

Thank you,

- Ronin

I appreciate it very much if you vote my Replies as Helpful or Mark as Answer if I could help you out. Thanks!


------------------------------------
Reply:
any word on this test app?  would love to use it.

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

Hi Frank,

I'm also looking for the HR Maintenance application which is available in FIM labs for my testing purpose. Will really appreciate if you can help me get a copy of that application.

Thanks,

Amit  


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

hi frank,

I am looking at trying to do this under MIM and was also looking for the HRMaintenance exe. Was it available for download


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

tuzla bilgisayar,tuzla bilgisayar ve teknik servis,tuzlada bilgisayarcı

tuzla bölgesinde Kurumsal Bakım Anlaşmaları olan işletmeler, işleri ile meşgul olurlar, sorunların çözümü ile ALP BİLGE ilgilenir, sorunların meydana gelmemesi için ALP BİLGE rutin kontroller yapar, ilerleyen dönemlerde olabilecek gereksinimler için, fizibilite çalışmalarıALP BİLGE yapar, işin niteliğine göre gece çalışır, gündüz çalışır, öğle arasında çalışır ve sorunu çözer.

Kurumsal bakım anlaşması yapmak istiyorsanız, bizi arayın, uzman ekibimizle ofisinizi ziyaret edelim, fizibilitesini yapalım,

tuzla bilgisayar servisi kalitesi ile hizmet almanın mutluluğunu yaşayın.

http://alpbilge.com.tr/bilgisayar-teknik-servisi/tuzla-bilgisayar-teknik-servisi.html

http://alpbilge.com.tr/tuzla-bilgisayar.html

Internal outlook users cannot connect to Exchange Server 2013

Hi Everyone,

I installed exchange 2013, already added an SRV for autodiscover on my external DNS, my problem is when I'm on a public network or on my house networt, which doesnt have any firewall (directly connected to the internet). I can connect my outlook to the Exchange server. When I'm @ the office (Internal Network) I'm having issues, we cannot connect to the Exchange Server. Is there any ports? or application control? that we need to allow on the internal security?

Thanks,

MIkey Cunanan

MSI-ECS


Reply:

Do you LB for internal network ? if yes check you are able to telnet to LB on 443.

If not, are able to telnet to port 443 from internal network to direct exchange servers.

Enable netmon and launch outlook and see where the network is routing.


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

Hi Vishwanath,

can it be more specific?


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

LB = load balancer

Do you have load balancer for internal network.

You should be able to telnet from your Internal network to exchange servers / load balancer on 443.


Outlook uses rpc/https for both internal and external communication

Have you set your Exchange internal urs to load balancer urls ? 


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

Load balancer?

are you refering to firewall?

on direct connection @ home I can connect with no problem.

When connecting here in office with proxy, I cannot connect, even if we uncheck the firewall settings.


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

Problem solved..

1.Defined internal OA same as external OA

2. Disable IPV6 on Exchange Server

3. Authentication set to Basic

4. Restart Exchange Server



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

Bug in Outlook 2013

Hi Team,

While working on the Outlook 2013 I found one weird behavior. Looks like it's a bug in the product.

Here is the detail about the bug.

We need to make sure that outlook is running at the time of reproducing the bug.

When I right click on any object on my system and I choose "Send To >>Mail Recepient" :

Then an outlook email opens up.

Now what happens is till the time this new email is opened its do not allow us to work on any other email. Whole outlook seems to be stuck. And as soon as I close this new email or finish the operation outlook becomes normal as it was before.

I hope I am clear here in explaining the bug.

Kind Regards,

Amit Agarwal


Reply:

Hi Amit,

I am facing the same issue.

Let me know if we have any hotfix for that...

Thanks,

Naveen


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

Importing non-standard excel file to sql server

I have to automate the import to a SQL Server table of an excel file with header info in row 6 and ignore a total line at the end.

I'm thinking the best way would be to use vb.net interop, establish a connection to the SQL Server table, read the spreadsheet row-by-row, cell-by-cell, build an insert statement then execute it.

Is there a more efficient way?

Thanks,

Jnana

Jnana Sivananda


  • Edited by Jnana Monday, August 31, 2015 10:21 PM fix typo

Reply:

It depends on where do you want to execute from. Either from your application Userinterface or from the backend Sql server.

From application interface: you need to develop a program to facilitate that. for more help post in relevant forum.

If you want to do in the sql server you can use SSIS package to do this. You can choose a script task and make changes as you wanted.

 


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

If the number of rows is consistent then you can use a named range of excel as a source in SSIS. That is, if your data always start at row 6 and the total line is always at row 100 (as an example), then you can define a named range from row 6 to 99.

In SSIS, you can also parse the rows with Conditional Split if your data is suitable for identification and discard the total row.

In a .Net language, you can parse it row by row and look for an empty row. Discard the last non-empty row as the total row.

- Aalamjeet Rangi | (Blog)


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

Office 365 Claim to allow Sharepoint Online but block OWA

I need some clarification on passive ADFS claims.  I have a requirement to block external access to OWA but still allow external access to Sharepoint Online.  I'm not seeing any way to distinguish between the two in the claim request.  Is this even possible?  

The environment is ADFS 3.0 front-ended by a WAP.  

Thanks,

         Eric

  • Changed type Amy Wang_ Wednesday, September 9, 2015 10:33 AM

Reply:

Using the link below couldn't you setup a client access policy "Block all external access to office 365 except browser-based applications"?

https://technet.microsoft.com/en-us/library/dn592182.aspx#scenario3


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

Thanks for the response.  I already have it set up to block all except browser based apps.  I was looking to distinguish between different browser based apps.  For example....I'd like to allow them to access Sharepoint Online and CRM but BLOCK them from accessing OWA.  

From what I can tell, OWA, Sharepoint and CRM access appears to be an all-or-nothing situation. 

-Thanks


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

Have you looked at using the tool in the link below?

https://gallery.technet.microsoft.com/scriptcenter/Client-Access-Policy-30be8ae2


------------------------------------
Reply:
Yes, I have looked at and used that tool.  Unfortunately it doesn't give me any way to differentiate between the various web based applications.

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

Have you tried setting the block access to all applications and then going onto sharepoint and doing the following.

Go to , Portal Administration . Under SharePoint Online , Click Manage
On SharePoint Administration , Click "Manage Site Collections"
Select the Site collection and then from Ribbon Settings , "Manage External Users".
Change it to Allow .

Go to your site collection , and Site Actions ->Site Settings -> External User Permissions


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

Also have you installed this rollup described in the link below? I do not know how your network is setup but it may help.

https://support.microsoft.com/en-us/kb/2607496


------------------------------------
Reply:
That rollup is for ADFS 2.0.  I'm running ADFS 3.0. 

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

So have you tried settting up a client access policy "Block all external access to office 365 except browser-based applications" and then going into sharepoint and doing the following:

Go to , Portal Administration . Under SharePoint Online , Click Manage
On SharePoint Administration , Click "Manage Site Collections"
Select the Site collection and then from Ribbon Settings , "Manage External Users".
Change it to Allow .

Go to your site collection , and Site Actions ->Site Settings -> External User Permissions


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

Hi Eric,

I need some clarification on passive ADFS claims.

If suggestion above is not helpful, I suggest you refer to experts from the following forum to get professional support:

Claims based access platform (CBA), code-named Geneva Forum

http://social.msdn.microsoft.com/Forums/vstudio/en-US/home?forum=Geneva

Best Regards,

Amy

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

  • Edited by Amy Wang_ Monday, August 17, 2015 4:13 AM

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

I may not have been clear in my initial post.  When I say "block external access", I'm referring to licensed users on the Tenant domain (i.e. contoso.com).  We're using ADFS Claims rules to allow them to access specific O365 resources when they're in the office but block them when they are at home or on a physically external computer.  I believe the Sharepoint External Users you referenced are actually user accounts external to the Tenant domain (i.e. gmail.com, hotmail.com, etc...).

I believe the problem stems from the fact that the passive claim request just doesn't have enough information in it (ex.  Destination URL, client IP, etc...) so I can't use a claims rule to distinguish between different Web based resources.  I was just hoping that somebody out here could validate or disprove my theory on this.



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

Hi Eric,

In that case, kindly try the dedicated ADFS forum above, you will get more professional insights from ADFS experts.

Best Regards,

Amy

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

  • Edited by Amy Wang_ Tuesday, September 1, 2015 1:34 AM

------------------------------------
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Setup is Split Across Multiple CDs

Setup is Split Across Multiple CDs Lately I've seen a bunch of people hitting installation errors that have to do with the fact th...