Archief voor maart, 2014

The issue might be related to the size and dimension of the Thumbnailphoto attribute stored in AD

The max size for the picture differs between the products but if you want it to show up in OWA, outlook, lync and sharepoint you need to limit to these values:

max size: 10KB ( exchange has this limit, lync supports up to 100kb )
dimensions: 96*96 pixels

Whether a profile picture currently exists can be checked in adsiedit under the attribute ThumbNailPhoto

To easily change the picture dimensions, install the following tool:

ADPhoto edit ( free edition ) http://www.cjwdev.co.uk/Software/ADPhotoEdit/Info.html

This will extract the current pictures and by clicking edit you can set recommended values which will resize the picture to fall below the 96*96 dimensions.

It will be automatically replaced in AD

note that it may take a while for the picture to show up in Office 365 after the change

http://blogs.technet.com/b/msukucc/archive/2011/08/14/office-365-hybrid-deployment-exchange-rich-coexistence-sharing-availability-free-busy.aspx

in this case the entry TargetSharingEPR was empty in the organizationrelation in Exchange Online

TargetSharingEPR
Set this to be your published on premises EWS endpoint ( the hybrid server usually )

migrate customers to new sql server

Geplaatst: maart 14, 2014 in Hosting

after changing the virtual server in WSP, you’ll notice that existing customers still point to the ‘old’ sql server when creating and deleting databases.
New users will start using the new sql server immediately.

This is because the entries in the websitepanel database bound to the wsp enterprise server are not updated.

To fix this do the following:

– take a backup of the sql database through WSP or management studio
– take a note of the sqldb name and sql username.

open up the sql management studio and open the websitepanel db

open up serviceproperties table and find the serviceid for the old and new sql server.
Note these down.

open up dbo.serviceitems table and check which packageid belongs to your database and to your database user ( this should always be the same one )
Let’s assume now this is ’14’ in our example.
Also note the serviceid that belongs to your sql database and dbuser. In our example this is ‘6’

open up dbo.packageservices and under packageid search the id noted down in the previous step ( which is the id corresponding to this specific customer ).
In this example we search the column packageid for the netry ’14’

when you find the corresponding entries with the correct packageid , look at the adjacent column ( Serviceid )

Replace the serviceid entry matching the old sql server ( this was ‘6’ ) with the new sql serviceid ( this is in our example ’15’ )

Now re-add a database under the customer with the same name as before and also create a new sql user with the same name ( and preferably pass ) as before.
You’ll notice the ip for sql has changed to the new sql server and the db is now created on the new sql server.

Restore the previous backup to the newly created database.

Adapt your website ( most likely the web.config file ) to have the connection string point to this new sql server and database. If the pass was changed, change the pass at this location as well.

  1. Install-WindowsFeature Web-Server,NET-Framework-Core,NET-Framework-45-ASPNET,Web-Net-Ext,Web-Net-Ext45,Web-Asp-Net,Web-Asp-Net45,Web-ISAPI-Ext,Web-ISAPI-Filter

System.Web.Services.Protocols.SoapException: Server was unable to process request. —> Error executing ‘BACKUP’ task on ‘DBNAME’ SQL_DATABASE —> Server was unable to process request. —> Cannot open backup device ‘C:\Users\WPServer\AppData\Local\Temp\dbname.bak’. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at WebsitePanel.EnterpriseServer.esDatabaseServers.BackupSqlDatabase(Int32 itemId, String backupName, Boolean zipBackup, Boolean download, String folderName)
at WebsitePanel.Portal.SqlBackupDatabase.BackupDatabase()

when this happens you are missing permissions on the temp folder under the wpserver user account.
This folder is being used to take the backup before transferring it by WSP

To enable archive mailboxes for the synced users:

open adsi edit and go to the properties of the user object

1. Give the archive mailbox a name by editing the “msExchArchiveName” attribute field, for example, Online Archive – Last Name, First Name. This is the display name of the archive mailbox.

2. Change the “msExchRemoteRecipientType” value to 3.

3. Run DirSync

first open webmail for this user. In het url you’ll see which server you are connected to

eg: podxxxx.outlook.com

copy this adress

start the outlook account wizard, choose manual

enter the above servername as server and the UPN login name as username.

Go into advanced properties, under the security tab choose anonymous authentication

in the connection tab choose proxy, open and fill in the servername again and select basic authentication

http://technet.microsoft.com/en-us/library/dn249373(v=exchg.150).aspx

First run these two commands ( even if authentication already shows WSSecurity=true )

set-webservicesvirtualdirectory -identity “ews (default web site)” -wssecurityauthentication $true

set-autodiscovervirtualdirectory -identity “autodiscover (default web site)” -wssecurityauthentication $true

Then check the settings returned by Get-organizationrelationship |fl

freebusyaccessenabled=true
freebusyaccesslevel=limiteddetails

more info: how to change this: http://technet.microsoft.com/en-us/library/dd351260(v=exchg.141).aspx#UseEMC