To fix, set the AlternateHeader value to "" using PowerShell.
$web = Get-SPWeb "http://
$web.AlternateHeader (this will list the url of the AlternativeCSS)
$web.AlternateHeader = ""
$web.Update()
Friday, May 11, 2012
CSS Content showing in Sharepoint 2010 Site Settings after Creating Site from Template
After saving a site that has custom CSS as template, and creating a new site based on this template, the user-created content can be loaded properly but pages like Site Settings, Site Permissions etc all show the css content as text near the top section of the page.
To fix, set the AlternateHeader value to "" using PowerShell.
$web = Get-SPWeb "http://"
$web.AlternateHeader (this will list the url of the AlternativeCSS)
$web.AlternateHeader = ""
$web.Update()
To fix, set the AlternateHeader value to "" using PowerShell.
$web = Get-SPWeb "http://
$web.AlternateHeader (this will list the url of the AlternativeCSS)
$web.AlternateHeader = ""
$web.Update()
How to copy Sharepoint 2010 Blog between sites
A Sharepoint 2010 Blog does not have Save Site as Template link in the Site Settings.
The hard way:
Using Granular Backup and Restore from Site Administration, choose the Blog:
http://mysites/personal//Blog/default.aspx
Backup to local drive:
\\\xxx.cmp
Created a site named Blog, of type Blog.
e.g. http://sharepointsite/MyNewBlog
Use powershell to run this command in the Application Server:
Start > All Programs > Microsoft SharePoint 2010 Products > SharePoint 2010 Management Shell
Import-SPWeb -identity http://sharepointsite/MyNewBlog -path \\\xxx.cmp
The easy way:
or use the shortcut to save Blog site as template
_layouts/savetmpl.aspx
And then upload the site to the solutions gallery and activate it.
Create site from template.
The hard way:
Using Granular Backup and Restore from Site Administration, choose the Blog:
http://mysites/personal/
Backup to local drive:
\\
Created a site named Blog, of type Blog.
e.g. http://sharepointsite/MyNewBlog
Use powershell to run this command in the Application Server:
Start > All Programs > Microsoft SharePoint 2010 Products > SharePoint 2010 Management Shell
Import-SPWeb -identity http://sharepointsite/MyNewBlog -path \\
The easy way:
or use the shortcut to save Blog site as template
_layouts/savetmpl.aspx
And then upload the site to the solutions gallery and activate it.
Create site from template.
Thursday, May 10, 2012
Cannot connect to database master at SQL Server xxxxx. The database might not exist, or the current user does not have permission to connect to it.
When setting up Sharepoint 2010 and running the Sharepoint Products Configuration Wizard for the first time, I got stumped when configuring the content database.
This is the error I see:
"Cannot connect to database master at SQL Server xxxxx. The database might not exist, or the current user does not have permission to connect to it."
I was connecting to the SQL Server 2008 on a Win2k8 R2 machine using Windows Authentication.
I initially suspected it might be a Domain Controller issue so I tried checking the Firewall configuration and Inbound rules for the SQL server. In this case the Firewall was turned off and ports 1433, 1434 were allowing incoming traffic so that does not solve my problem.
I also tried enabling TCP/IP on the SQL Server using the SQL Server Configuration Manager. Still not working.
Next I tried remoting into another server as the same user, launching SQL Server Management Studio and connecting, another error came up:
"Cannot generate SSPI context."
Checking this Microsoft KB usually solves the issue for the majority of cases but it did not help.
By now I have a general idea that this is probably because of some settings on the SQL server itself.
After parsing dozens of articles I finally came across THE one that resolved my issue.
http://dotnettim.wordpress.com/2010/08/26/cannot-generate-sspi-context-error-from-sql-server-management-studio/
Basically the SPN (Service Principal Name) was somehow generated wrongly and could not be deleted. You could view a list of the SPNs by running this command:
setspn -L
I compared it with the SPNs of other SQL servers and there was a couple of extra SPNs like this:
MSSQLSvc/.domain.com:1433
MSSQLSvc/.domain.com
I was unable to delete the SPN using setspn command due to lack of account privileges.
Resolution:
1. Stop SQL Server Agent. Modify the SQL Server service to run under the Local System account.
2. Start SQL Server.
3. Stop SQL Server.
4. Restore the SQL Server service to run under the account that it was set up with initially.
5. Start SQL Server Agent.
6. Run setspn –L to verify SPN again.
*Poof* problem solved!
This is the error I see:
"Cannot connect to database master at SQL Server xxxxx. The database might not exist, or the current user does not have permission to connect to it."
I was connecting to the SQL Server 2008 on a Win2k8 R2 machine using Windows Authentication.
I initially suspected it might be a Domain Controller issue so I tried checking the Firewall configuration and Inbound rules for the SQL server. In this case the Firewall was turned off and ports 1433, 1434 were allowing incoming traffic so that does not solve my problem.
I also tried enabling TCP/IP on the SQL Server using the SQL Server Configuration Manager. Still not working.
Next I tried remoting into another server as the same user, launching SQL Server Management Studio and connecting, another error came up:
"Cannot generate SSPI context."
Checking this Microsoft KB usually solves the issue for the majority of cases but it did not help.
By now I have a general idea that this is probably because of some settings on the SQL server itself.
After parsing dozens of articles I finally came across THE one that resolved my issue.
http://dotnettim.wordpress.com/2010/08/26/cannot-generate-sspi-context-error-from-sql-server-management-studio/
Basically the SPN (Service Principal Name) was somehow generated wrongly and could not be deleted. You could view a list of the SPNs by running this command:
setspn -L
I compared it with the SPNs of other SQL servers and there was a couple of extra SPNs like this:
MSSQLSvc/
MSSQLSvc/
I was unable to delete the SPN using setspn command due to lack of account privileges.
Resolution:
1. Stop SQL Server Agent. Modify the SQL Server service to run under the Local System account.
2. Start SQL Server.
3. Stop SQL Server.
4. Restore the SQL Server service to run under the account that it was set up with initially.
5. Start SQL Server Agent.
6. Run setspn –L
*Poof* problem solved!
Thursday, March 22, 2012
Snacks to bring back from Taiwan
From Taiwan with love.
Honey Jujube 蜜棗 - Seasonal local produce. A type of fruit that is very crisp and juicy and sweet.
Red Bean Glutinous Rice Cakes Q餅 from Saint Paul Patisserie 聖保羅
Honey Jujube 蜜棗 - Seasonal local produce. A type of fruit that is very crisp and juicy and sweet.
Red Bean Glutinous Rice Cakes Q餅 from Saint Paul Patisserie 聖保羅
Thursday, March 15, 2012
Bebek Tepi Sawah Restaurant, Ubud, Bali
Although it has been almost 1 year since my Bali visit, I never got around to completing the rest of the posts.
Of all the restaurants and warungs that we have visited in Bali, Bebek Tepi Sawah left the most lasting impression on me. It deserves a post of its own!
We were lucky for opting to dine there during lunch instead of dinner, as the beautiful surroundings and deco of the restaurant would be barely visible at night.
The most popular picture-taking spot (above).
Of all the restaurants and warungs that we have visited in Bali, Bebek Tepi Sawah left the most lasting impression on me. It deserves a post of its own!
We were lucky for opting to dine there during lunch instead of dinner, as the beautiful surroundings and deco of the restaurant would be barely visible at night.
The most popular picture-taking spot (above).
Subscribe to:
Posts (Atom)
