KB934525 Troubleshooting "Cannot start service SPAdmin on computer '.'."

If when running the sharepoint upgrade wizard you get the error KB934525 Troubleshooting "Cannot start service SPAdmin on computer '.'." follow step 4 in the following link which is

"Option # 4

On the machine where psconfig failed to start the SPAdmin service run:
%commonprogramfiles%\Microsoft Shared\Web Server Extensions\12\BIN\psconfig -cmd upgrade -inplace b2b -wait -force
Modify the service timeout values in the Registry:

HKLM\SYSTEM\CurrentControlSet\Control add/modify DWORD value ServicesPipeTimeout to 60000 (60 seconds)

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control add/modify STRING value WaitToKillServiceTimeout to 120000 (120 seconds)
Restart the server machine.

"


This fixes the problem

http://blogs.technet.com/wbaer/archive/2007/10/15/kb934525-troubleshooting.aspx

Remotely Reboot server using Computer Management Console

This is a very useful way of rebooting a server if you know the box is up and running but are not able to connect to it through remote desktop.

Thanks Priyabrata Lahiri (Priyo) http://blogs.msdn.com/priyo/archive/2007/11/20/remotely-reboot-windows-server-2003.aspx for pointing us to this resource..(The below is copied and pasted from the mentioned url)

1. Open Computer Management (Local)

2. In the console tree, right-click Computer Management (Local), and then click Connect to another computer.

3. In the Select Computer dialog box, click Another computer, type the name of the computer that you want to restart or shut down, and then click OK. You can also click Browse to search for the name of the computer.

4. In the console tree, right-click Computer Management (Remote computer name), and then click Properties.

5. On the Advanced tab, click Startup and Recovery.

6. Click Shut Down to open the Shut Down dialog box.

7. Under Action, select the actions you want to perform on the computer to which you are connected.

8. Under Force Apps Closed, select the circumstances under which you want to force applications to close when you shut down or restart the computer, and then click OK.


Note

• To open Computer Management, click Start, and then click Control Panel. Click Performance and Maintenance, click Administrative Tools, and then double-click Computer Management.

• You must be recognized as an administrator or a member of the

Save Site as Template Link does not appear in Sharepoint

If the Save Site as Template link does not appear under the Look and Feel tab of site settings, then go to the site settings of the site that you want to save as a template and replace the page name to savetmpl.aspx.

for Example

Change http://ServerName/SiteName/_layouts/settings.aspx
to
http://ServerName/SiteName/_layouts/savetmpl.aspx

ListViewWebPart - Adding Announcements List programatically to sharepoint page

While working with a listviewwebpart in sharepoint the name property should be set to the GUID of the List. The key thing to note is it i s not enough to set the value as GUID.Tostring() but as it is case sensitive it should be set as spListGuid.ToString("B").ToUpper();

The full code is below

ListViewWebPart listWebPart = new ListViewWebPart();
listWebPart.ListName = spListGuid.ToString("B").ToUpper();
webPartManager.AddWebPart(listWebPart, "RightColumnZone", 0);

Cannot open database requested in login '' Error in Moss 2007

The error message below is displayed when trying to view a page in MOSS 2007 that is checked out by another user.

Server Error in '/' Application.
--------------------------------------------------------------------------------

Cannot open database requested in login 'MOSS2007_SSP1_DB_DEV'. Login fails.
Login failed for user 'EC\WMSPSGBWA001003$'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'MOSS2007_SSP1_DB_DEV'. Login fails.
Login failed for user 'EC\WMSPSGBWA001003$'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Cannot open database requested in login 'MOSS2007_SSP1_DB_DEV'. Login fails.
Login failed for user 'EC\WMSPSGBWA001003$'.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
Microsoft.Office.Server.Data.SqlSession.OpenConnection() +621
Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) +214
Microsoft.Office.Server.Administration.SharedObjectStore.Initialize() +269
Microsoft.Office.Server.Administration.SharedObjectStore.GetObject() +384
Microsoft.Office.Server.Administration.SharedResourceProvider.Microsoft.Office.Server.Administration.ISharedObjectStore.GetObject() +122
Microsoft.Office.Server.Administration.SharedApplicationCollection`1.GetValue(SharedResourceProvider sharedResourceProvider) +118
Microsoft.Office.Server.Administration.SharedApplicationCollection`1.get_Item(SharedResourceProvider sharedResourceProvider) +30
Microsoft.Office.Server.ServerContext.GetApplication(String name) +174
Microsoft.Office.Server.ServerContext.GetApplication() +87
Microsoft.Office.Server.ServerContext.get_UserProfileApplication() +42
Microsoft.Office.Server.UserProfiles.UserProfileManager.get_m_Site() +49
Microsoft.Office.Server.UserProfiles.UserProfileManager.get_IsSiteAdmin() +62
Microsoft.Office.Server.UserProfiles.UserProfileManager..ctor(ServerContext serverContext, Boolean IgnoreUserPrivacy, Boolean backwardCompatible) +348
Microsoft.Office.Server.UserProfiles.UserProfileManager..ctor(ServerContext serverContext) +55
Microsoft.SharePoint.Publishing.WebControls.ConsoleUtilities.GetPageCheckedOutMessage(String userLoginName, String userName, String userEmail) +923
Microsoft.SharePoint.Publishing.WebControls.ConsoleDataSource.OnPreRender(EventArgs e) +1025
System.Web.UI.Control.PreRenderRecursiveInternal() +77
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42