Tuesday, July 2, 2013

Office 365 Team Site URL Change

When using Office 365, you might notice the link at the top, "Team Site". This points to your primary domain's sharepoint site. Unfortunately Microsoft has stated that you cannot change the URL the Sharepoint team site link points to.

That presented a problem to me. I wanted that link to change to the "My Sites" site collection that Microsoft provides. You are unable to create a new MySite host with their plan, so I decided to just make a redirect.

I opened up the Team Site using Sharepoint Designer. I then created a redirect.aspx page and put the following in there.


After I saved it, I simply right clicked on it and made it the homepage. Now when users click Team Site at the top of their email, it will take them to their MySite. The redirect can also be pointed anywhere.

Monday, June 17, 2013

set-msoluserpassword does not accept Secure.String

I recently migrated to Office 365 from Live at EDU. I was pleased to see that the strong password requirements can be disabled. I set out to upgrade my user creation script for the new Powershell cmd-lets. Live @ edu used Exchange cmd-lets which require submitting the password as Secure.String. I figured the MSOL cmd-lets would also require it. when i first ran the updated script i would get this.

"Set-MsolUserPassword : You must choose a strong password that contains 9 to 16 characters, a combination of letters, and at least one number or symbol. Choose  another password and try again."

Even though I had set the new-msoluser to -strongpasswordrequired $false

After a little time spent, I found out converting my to-be passwords as secure.string was the problem. I updated the script to use plain text and it worked fine. The passwords still require at least 8 characters, but they do not require a combination of capitals and numbers

Tuesday, July 3, 2012

App-v Management Server Service fails to start with error %%536912451

"The Application Virtualization Management Server service terminated with service-specific error %%536912451."

This is the error I got when moving my app-v database from a single host machine to a NLB cluster following the directions at  http://blogs.technet.com/b/appv/archive/2011/08/31/how-to-configure-app-v-with-microsoft-network-load-balancing-nlb.aspx.

There are two problems I found to cause this issue.

1.) The service account that is used to for the App-v management service must have access to the app-v directory as well as the IIS default website. If you want to do granular permissions you are welcome to try but I just make the service account an admin (I know its bad practice)

2.) If you are not making a new database with the new App-v installation you will need to add your machine to the server group inside app-v. The easiest way to do this is by using the management console.



If you are unable to open the Management console you will have to update it within SQL. The table you are looking for is dbo.SERVERS


Friday, June 29, 2012

Copy Database Wizard SQL 2008 - InnerException Login Failed for user

Have you ever tried to use the Copy Database Wizard? It is a handy tool, but troubleshooting it takes more time to do than just manually copying the database yourself. If you do try to troubleshoot, then most likely you will see this error in default setups.


StackTrace:    at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
   at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp)
InnerException-->Login failed for user

On an Event ID 12550 on the source server. It is basically telling you that the account you used does not have permission to do the actions. By default the wizard will want you to use the SQL Server Agent account.  That will need permissions to create files in the log and data directories. It will also need permission to import the database files in SQL

Tuesday, June 19, 2012

Lync Reverse Proxy Certificate

Creating a certificate request with the old certreq command line is a pain. When you need to add several SAN's (subject alternative names) to the request the process gets much more convoluted. Here is the way I have done it in the past with a GUI

1.) Open up an admin mmc console
2.) add the local computer "certificates" snap in
3.) Under Personal, Right Click on certificates and click "Create Custom Request"


4.) click Next, the choose "Proceed without enrollment policy"
5.) Accept defaults and click next again
6.) Click details on the custom request and click properties. This is where you will add the certificate details.
7.) The friendly name will be what shows up for tracking.
8.) On the private key tab, make sure, under key options, to change the size to 2048, and make the private key exportable

9.) In the subject tab you will need to add the required information. As you can see the SAN's are DNS type and added under the alternative name.

10.) Once done, you can create the request and send it off to a Public Cert company.
11,) When you receive the certificate back, make sure you import it into the machine you requested it from. You then can export it with the private key so it can be imported into the ISA 2006 or TMG server. The certificate will be invalid if the private key is not kept.

Monday, June 11, 2012

Rename and Move Files with Powershell

I have a software program that will import pictures into its database. Unfortunately it cannot accept files with the same name nor can it distinguish files from each other based off on what is in the file. It does however, index these files based on the file name.

If any of you have worked with a Sharp multi-function device, you might know that when  a person scans a document to a file, it is given a random name based off criteria you select. The criteria available is limited and I needed more precise file names so that the software could index properly.

Here is what i did. I set up different "Scan to network" locations based off the file name needed. For example, Credit Card receipts would have it's own address book button, and send it to a folder called CCR inside of a network share. I would then have a script ran every so often that would move it to the right folder based off its location so the Software could import it. Here is my script:



This will take all items in e:\import\ccr and then move them to e:\import_complete along with a completely different name. The $random variable is there so files will not have the same exact name. The software can then import them with the right indexes

App-v Sequencing of Edconnect 8

The DoE released its new version of Edconnect a few months ago. With the previous version of Edconnect, Iwas able to sequence it with out any problems, but the same could not be said for its newest version. After a normal install and an edit to the OSD file to include a drive mapping, my users would open the app to find the error "system error: directory c:\iam\saig_temp\ does not exist"


Now, at that time, I was pretty busy and did not have time to properly troubleshoot why it could not see a directory which was inside the VFS. I took the easy way out and put that directory on a network share. I opened up the package in the App-v sequencer, extracted the c:\IAM folder. I then edited the package and updated the "Machine\Software\The Department of Education\Edconnect\8.x\TempDirectory" registry key to reflect the new location of the network share. I then saved the package and it started working. I was worried that multiple users using that same temp directory at the same time would cause problems, but it has been 2 months and i have heard no complaints.