Azure & Office 365

 

Hi Friends,

Recently I wanted to configure RBS on SQL server 2014. According to me I did configure everything fine but then I was unable to create a Site collection in that database. I get below error message.

Sorry, something went wrong
The URL ‘_cts/Document Set/docsethomepage.aspx’ is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web.
Technical Details
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: af6aef9c-01ea-20f9-005a-d8bb2b2da40d
Date and Time: 3/4/2015 3:14:36 AM

 

In ULS logs I see below error:

Document Management Server      Document Sets       Unexpected DocumentSet FeatureActivating: throws exception: The URL ‘_cts/Document Set/docsethomepage.aspx’ is invalid. It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web…. Stacktrace: at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx) at Microsoft.SharePoint.Library.SPRequest.PutFile(String bstrUrl, String bstrWebRelativeUrl, Object punkFile, Int64 cbFile, Object punkSPFileMgr, Object punkFFM, Int64 PutFileOpt, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String bstrCheckinComment, String bstrLockIdMatch, String bstEtagToMatch, Int32 lockType, String lockId, Int32 minutes, Int32 fRefreshLock, Int32 … 2068ef9c-91d4-20f9-005a-da81ca62d058
Document Management Server      Document Sets      Unexpected …bValidateReqFields, Guid gNewDocId, SPFileSaveParams sfsp, SPFileInfo& pFileProps, UInt32& pdwVirusCheckStatus, String& pVirusCheckMessage, String& pEtagReturn, Byte& piLevel, Int32& pbIgnoredReqProps) at Microsoft.SharePoint.SPFileCollection.AddStreamOrBytesInternal(String urlOfFile, Stream file, Int64 fileSizeToSave, SPFileStreamManager spmgr, PutFileOpt fileOpt, String createdBy, String modifiedBy, Int32 createdByID, Int32 modifiedByID, DateTime timeCreated, DateTime timeLastModified, Object varProperties, String checkInComment, Stream formatMetadata, String lockIdMatch, String etagToMatch, SPLockType lockType, String lockId, TimeSpan lockTimeout, Boolean validateRequiredFields, SPVirusCheckStatus& virusCheckStatus, String& virusCheckMessage, String& etagNew, Boolean& ignoredRequire… 2068ef9c-91d4-20f9-005a-da81ca62d058

 

Document Management Server     Document Sets      Unexpected …dProps) at Microsoft.SharePoint.SPFileCollection.Add(String urlOfFile, Byte[] file, Boolean overwrite, String checkInComment, Boolean checkRequiredFields) at Microsoft.SharePoint.SPFileCollection.Add(String urlOfFile, Byte[] file, Boolean overwrite) at Microsoft.Office.DocumentManagement.Internal.DocumentSetFeatureReceiver.FeatureActivated(SPFeatureReceiverProperties properties). 2068ef9c-91d4-20f9-005a-da81ca62d058

 

I did a lot of search trying to find the issue but couldn’t find anything. Lucky I found a article which says database might be read only. I then create a new database without RBS enabled and it was working fine.

Then I enabled RBS on same database and got the same error. So I confirmed that it was RBS configuration issue.

I then followed below steps one by one and confirmed that it was issue with ActiveProviderName

$cdb = Get-SPContentDatabase “contentdbname”
$rbss = $cdb.RemoteBlobStorageSettings
$rbss

I then run below command on same content database which resolved my issue.

$cdb = Get-SPContentDatabase “contentdbname”
$rbss = $cdb.RemoteBlobStorageSettings
$rbss.Installed()
$rbss.Enable()
$rbss.GetProviderNames()
$rbss.SetActiveProviderName(RBSFilestreamProvider)
$rbss.Migrate()

 

Hope this will help you.

Happy Learning friends. 🙂

Hi,  I just saw this awesome app on APP store on Android and through I should blog on same.

Microsoft has recently release a Office 365 Partner admin app using which it can check service status of the Office 365 subscription. For now you cannot manager the admin related or site related activity using this APP but you can just check the status of service which is available. We can even check the ticket status associated to our subscription.

Incase you are managing Tenant of your customers\partners this app will help you all the Tenants on a single go.

I am looking for more Admin like functionality like creating site collection in SharePoint, Creating users, change some exchange related settings etc using this APP. Hope Microsoft will work on this app going forward. I can see that this APP is available for Android (4.1 and above) and for iOS (7 and above).

Yes currently the App is not yet ready for Windows Phone but I think it will be in market soon.

Below are some pics of this app

Home page of all the services

Check more details of services

 

Check Ticket status and details

Hope you enjoyed reading it.

 

Hi Friends,

I recently got to know about the SQLServerGeeks Annual Summit 2015 on August 27, 28, 29, 2015 in Bangalore at NIMHANS Convention Center by Microsoft Regional Director Amit Bansal, SQL MVP Sarabjeet Singh and many more….

It is a great moment for SQLServerGeeks.com as this event would be one of the biggest event by SQLServerGeeks.

I also got to know that SQLServerGeeks Annual Summit 2015 is not just the largest but the only SQL Server conference in Asia apart from Microsoft conference.

Looking at the populatry o the event first thing you must do is Register for the event.

http://www.sqlservergeeks.com/summit2015/registration-details/

 

Looking at the cost of registration I assume we are only playing for the Lunch and snacks where as the SQL Server learning is completely free 🙂

Little bit about the conference and its tracks. There are 40+ speakers, 60+ sessions for all this 5 tracks with a awesome learning experience.  Session would be related to

Database Administration
Database Development Business Intelligence
Cloud
Big Data and so on…..

The sessions scale out on knowledge level from 200 through 500 from the SQL experts around the globe. Additionally, you will have networking opportunities with your peers, speakers, sponsors and exhibitors.

Look forward to meet you in SQLServerGeeks Annual Summit 2015 !

Microsoft recently updated their blog post with below update:
“As part of the update shared around the Evolution of SharePoint and the next SharePoint Server on-premises release, we are also updating the timelines for removal of InfoPath Forms Services components of SharePoint and SharePoint Online. Specifically, InfoPath Forms Services will be included in the next on-premises release of SharePoint Server 2016, as well as being fully supported in Office 365 until further notice. Customers will be able to confidently migrate to SharePoint Server 2016 knowing that their InfoPath forms will continue to work in their on-premises environments, as well as in Office 365.

The InfoPath 2013 application remains the last version to be released and will work with SharePoint Server 2016.”

For me the shocking news is not that Microsoft did extended support for Infopath 2013 but still no update on FOSL(Forms for SharePoint Library) in SharePoint 2016 and Office 365. When check the Office 365 Roadmap(http://roadmap.office.com/en-us), FOSL(Forms for SharePoint Library) is a cancelled features which means feature will not be released.

 

Reference. ” http://blogs.office.com/2014/01/31/update-on-infopath-and-sharepoint-forms/

 

Hi Everyone,

Hope you are using different version of SharePoint fom last couple of year and you have a lot of complains. Here is another platform through which you can give suggestions to Microsoft on how they can improve any area in SharePoint server.

Understading the priority you might not be able to vote all the feedback but you can leave a comment on them. This will be helpful to priortise things.

How to vote and suggest:
Check out the ideas others have suggested and vote on your favorites
If you have a suggestion that’s not listed yet, submit your own — 25 words or less, please
Include only one idea or suggestion per post

Customer Feedback for SharePoint Server:
http://sharepoint.uservoice.com/forums/282887-customer-feedback-for-sharepoint-server

Issue :

When you logon to some server using Domain account, you cannot access the pre-installed software like SQL server.

 

Solution:

When the VM is created, it is created account you specify using Azure VM creation screen and then added to domain. So by default other account don’t have access to the application installed during VM creation. You have to 1^st Logon to the server using Azure VM account give appropriate permission to domain account and then use it.

• Create a new domain

Now let’s configure this server to be a Domain Controller. As discussed earlier Domain controller manage DNS, AD Users, etc. and are normally the 1st and most important server in a company.

 

1. Login to your Azure Subscription Portal site https://manage.windowsazure.com
2. Select Virtual Machine from left Menu
3. Select the Virtual Machine we just created and click on Connect at bottom
4. Now RDP to the Virtual Machine we created and click on Server Manager

5. Select Manager > Add Roles and Features

6. Select “Next” on Installation Type screen

7. Select “Next” on Destination Server screen

8. Check Box “Active Directory Domain servers”

9. Click on “Add Feature” on pop-up screen

10. Select the check box “Restart the destination server if required” > Click OK

11. Once it is installed, Click on Close

12. Open the Server Manager again, Click on Flag at top and select “Promote this server to a Domain Controller”

13. Select “Add a New forest”, type domain name
14. Type the DSRM password and click “Next” (Note: this is required when you try to recover your active directory)

15. Now you will have to select your domain name. For example. Demo.com
16. The NetBIOS Name screen will remove .com and you will see only demo.
17. Select the Default location of installation and click “Next”
18. Click on “Install”

19. Once the Computer is restarted, your Domain Controller would be ready.

Note: From now on when you logon to server you need use your domain name along with username we just created to authenticate to server. Example: demo\user1

Hello Everyone, Today i was doing some testing and configuration on my Windows Azure server and got a weird error message as shown below:

Test-AzureStaticVNetIP : No current subscription has been designated. Use Select-AzureSubscription –
Current <subscriptionName> to set the current subscription.
At line:1 char:1
+ Test-AzureStaticVNetIP –VNetName test –IPAddress 11.0.0.1
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Test-AzureStaticVNetIP], ApplicationException
+ FullyQualifiedErrorId :
System.ApplicationException,Microsoft.WindowsAzure.Commands.ServiceManagement.IaaS.TestA
zureStaticVNetIPCommand

 

Did some research and found that we need to connect to Azure subscription and then run these command. To do so we need to download and install Azure Powershell. Copy paste below url on your browser and install the Web Platform Installer. This will give you option to download Azure Powershell.

http://go.microsoft.com/fwlink/p/?linkid=320376&clcid=0x409

 

Once the Powershell is downloaded and installed, we will

 

Now we will download the Azure Setting file to connect to the azure server. In the Azure Powershell, type below command.

Get-AzurePublishSettingsFile

Once you login to your Azure website, you will get a file named “Visual Studio Premium with MSDN-date-credentials.publishsettings”. Save it to a secure location. This file contains secure credentials and additional information about subscriptions that you can use in your development environment.

 

Now Import the Azure Settings file to Powershell. Run “Import-AzurePublisingSettingsFile” and then type path of the file we just downloaded as shown in below image

 

 

To check Subscription details run below command

Get-AzureSubscription

 

 

Now the command completed successfully.

 

Today we will understand we can connect to our Azure Subscription using Powershell and run some basic command on it.

To connect to Azure subscription we need to download and install Azure Powershell. Copy paste below url on your browser and install the Web Platform Installer. This will give you option to download Azure Powershell.

http://go.microsoft.com/fwlink/p/?linkid=320376&clcid=0x409

 

Once the Powershell is downloaded and installed, we will

 

Now we will download the Azure Setting file to connect to the azure server. In the Azure Powershell, type below command.

Get-AzurePublishSettingsFile

Once you login to your Azure website, you will get a file named “Visual Studio Premium with MSDN-date-credentials.publishsettings”. Save it to a secure location. This file contains secure credentials and additional information about subscriptions that you can use in your development environment.

 

Now Import the Azure Settings file to Powershell. Run “Import-AzurePublisingSettingsFile” and then type path of the file we just downloaded as shown in below image

 

 

To check Subsctiption details run below command

Get-AzureSubscription

 

 

 

Microsoft recently announced that Microsoft Learning brought back its most popular Second Shot Offer for MCP exams.

The Second Shot offer will help you retake an exam in case you failed it the first time between January 5th 2015 and May 31st 2015
Again as mentioned in my previous posts that all exams are now taken at Pearson Vue testing centers and scheduled directly from your MCP portal and there is no coded needed. Prometric is now not an option for MCP examination.

 

Once you register for an MCP exam between January 5, 2015, and May 31, 2015, you will be eligible for a free retake if you don’t pass it. You have 30 days from the date you took the initial exam to schedule a retake. To schedule your retake, sign in, select your exam from the exam list, and click Schedule now for free.

Please do read Frequently Asked Questions(FAQ) below:

https://www.microsoft.com/learning/en-us/second-shot.aspx

 

Best Of Luck for the examination 🙂