Friday, August 31, 2012

The Unattended Service Account Application ID is not specified or has an invalid value.


This error showed up on the Monitoring > Health Analyzer of my SharePoint 2010 VM.   Apparently after using the wizard to create a new farm, you must double back to supply Visio Services with user credentials for remote data connections.
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/559f72a4-d9ca-4004-b5ca-a0fa6dbad51f was a helpful reference on the steps and below are screenshots.

Steps Taken:
  1. Open Health Analyzer and view details
  2. Manage the Visio Graphics Service (SA) and confirm Application ID is empty.
  3. Manage the Secure Store Service (SA) and Generate New Key
  4. Create a New Target Application
  5. Provide a unique ID, name, and contact email. Select Group Type.
  6. Accept default and just click Next
  7. Provide a user name for both fields.  I used “DEMOAdmin” as that is the only user on this machine. Click OK.
  8. Enter the Target Application ID back on the Visio Graphics Service (SA) page and click OK.
  9. Go to the Health Analyzer rule, open it and click Reanalyze Now, then you should be ready to go.


The Unattended Service Account Application ID is not specified or has an invalid value.

enter applied ID


Generate New Key


New Key


Configure Secure Store Target






Solved Unattended Service Account Applicaiton ID -Visio error

 And you are done. :)
Go ahead check the error again and if error exists click on 'Reanalyze now' to allow sharepoint to check error again and hurray warning/error gone.

Regards,
Viral Shah

Friday, August 10, 2012

Upgrade SQL Server 2008 r2 Express instance to SQL Server 2008 r2 Enterprise

For one of my SharePoint 2010 Setups , I wanted to upgrade one of the SQL Server 2008 R2 Express Edition instances to SQL Server 2008 R2 Enterprise Edition. Since my setup already had SQL Server 2008 R2 Enterprise Edition installed, I only needed to go through the following steps to upgrade the specific instance.

When reviewing the properties of the instance with SQL Server Management Studio, it showed the Product version as SQL Server Express Edition.


ok Lets Start the Upgrade Process:

>> In the Start menu, under Microsoft SQL Server 2008 R2, open the SQL Server Installation Center in the Configuration Tools folder. 









>> Then, under Installation, click Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008

  Install Setup Supported files:

 >> You may be prompted to browse for the SQL Server 2008 R2 installation media to install the Setup Support files. you can give reference to iso, dvd drive or the local drive in which you stored the setup file of SQL Server 2008 R2.

















>> Make sure the Setup Support Rules pass before continuing on.
























>>  


>> Run the Install.

























Upgrade the Express Instance:  

>> After the install is complete, you can now continue with the process to upgrade the Express instance. 
>> Again, make sure the Setup Support Rules all pass before continuing on. 




























>> The setup should find your existing product key. If not, enter it now. 




























>>  Accept the License Terms. 




























>>  Next, select the SQL instance to upgrade. In my case, the name of the Express instance was "SHAREPOINT". 




























>>  The installer will preselect the features to be upgraded in the instance. 




























>> Verify the Instance ID and root directory, and continue on. 




























>> Verify you have enough drive space, and click Next. 




























>> Decide if you want to turn on error reporting, and click Next. 




























>> Verify the Upgrade Rules all pass before continuing on. 




























>> The installer will provide a summary of the upgrade actions. Click Upgrade




























>> After the installer finishing the upgrade, it will provide a confirmation page that the instance was successfully upgraded. 




























>> When reviewing the properties of the SQL instance in the SQL Server Management Studio, it will now show that it has been upgraded to SQL Server Enterprise Edition. 

>> After running the updates, you can also see the instance's build version through the SQL Server Management Studio. 


 After these steps, I ran the SharePoint Products Configuration Wizard to bring everything up to date.

Hurray you are done !!

Regards,
Viral Shah

Total Pageviews