SQL Express Troubles

SQL Express Troubles

(env: .Net 2.0, SQL Server Express 2005)

I had a problem where I was asked to do some troubleshooting on someone else's code. I had almost successfully set the project up on my machine, but was getting DB permission problems. I could not use the default DB permissions and had to go into the master DB instance on my own machine to register the application user ID. Problem was that my SQL Express Manager was not recognizing the new DB for the app that I was debugging.

The above article contained the solution. Essentially, in order to enable SQL Express Manager to connect to an existing DB, use the following command, replacing the DB name and path with your own.

CREATE DATABASE ASPNetDb
ON (FILENAME = 'C:\Inetpub\wwwroot\ProAspNet20\App_Data\aspnetdb.mdf')
FOR ATTACH;

TechNet Virtual Lab - SharePoint

TechNet Virtual Lab - SharePoint

Microsoft Office SharePoint Portal Server 2003 enables enterprises to develop an intelligent portal that seamlessly connects users, teams, and knowledge so that people can take advantage of relevant information across the organization to work more efficiently. As an administrator or developer, it is important to understand how to effectively deploy, manage and develop web parts for the portal so you can maximize your infrastructure resources and give your users the best possible experience. Join us for hands-on lab sessions where you will learn how to set up the portal, organize content on the portal, manage user permissions, create web parts for custom tasks and much more.

Step into the SharePoint Portal Server 2003 Hands-On Labs Virtual Lab for Free

It's simple - no complex setup or installation is required to try out SharePoint Portal Server 2003 Hands-On Labs running in the full-featured TechNet Virtual Labs. As part of the TechNet Virtual Lab, you will have full access to SharePoint Portal Server 2003 Hands-On Labs through the following modules:

An Introduction to Microsoft SharePoint Products and Technologies

Creating a Custom Site Definition for Microsoft Windows SharePoint Services

Creating a Web Part for Microsoft SharePoint Products and Technologies

Creating Connectible Web Parts for Microsoft SharePoint Products and Technologies

Managing Microsoft Office SharePoint Portal Server 2003 Content and Navigation

Microsoft Office SharePoint Portal Server 2003 People and Personalization

Microsoft SharePoint Products and Technologies Permissions Management

Using Microsoft Office FrontPage 2003 to Customize Microsoft Windows SharePoint Services

Using Microsoft Windows SharePoint Services with Microsoft Office Professional 2003 Applications

Using the Microsoft Windows SharePoint Services Object Model




You get a downloadable manual and a 90-minute block of time for each module. You can sign up for additional 90-minute blocks anytime.

SSO Configuration Part Deux

Another problem arose when executing the Credentials.GetCredentials method in an event handler, received the following in the Event Log:

"The Microsoft Single Sign-on (SSOSrv) service failed to retrieve credentials for user NT AUTHORITY\NETWORK SERVICE, enterprise application definition Workflow. The error returned was 0x80630490. For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK)."

Make sure that the MSSharePointPortalAppPool is configured to use an account with domain admin privs, and that the account is added to the IIS_WPG group.

Configuring SSO in SPS 2003

I'm learning about SP using the aPress book "Microsoft SharePoint: Building Office 2003 Solutions" by Hillier.

Chapter Six discusses the MS Single Sign-on (SSO) service and has a cookbook procedure for installing and configuring SSO.

At the end of the procedure, when setting the configuration settings for SSO in the SPS Manage Server Settings page, the following error was displayed:

"Warning: Single sign on configuration information could not be retrieved. Single sign-on might not be configured, or there might be a problem connecting to the single sign-on database or job server"

The event application log contained a more revealing message:

User DOMAIN\USER failed to configure the single sign-on server. The error returned as 0x80630009. Verify this account has sufficient permissions and try again.

Anyway, the following link helped to solve the issue. In a nutshell, the database and schema for SSO had not been created. Not sure if this was supposed to have been done under the covers at some point, if the book missed a step, or if it was a stupid user error. I did as the post prescribed and was able to successfully complete the installation. Click below for details.

http://www.winserverhelp.com/ftopic32593.html

Windows Vista Developer Site Released

Windows Vista Developer Site Released

From TheServerSide.net... "The site has a brief overview of some of the new features for developers in Windows Vista including new search and organization options, improvements in ClickOnce deployment, new reliability APIs, and new security features.

The site also goes into a fairly non-technical discussion of the WinFX technologies formerly known as Avalon and Indigo."

SQL Server 2005 Training

MS offers SQL Server 2005 training for free (limited time perhaps) on their website. Location is

https://www.microsoftelearning.com/sqlserver2005/.


Courses include:

Course 2936: Installing and Securing Microsoft® SQL Server™ 2005

Course 2937: Administering and Monitoring Microsoft® SQL Server™ 2005

Course 2938: Data Availability Features in Microsoft® SQL Server™ 2005

Course 2939: Programming Microsoft® SQL Server™ 2005

Course 2940: Building Services and Notifications Using Microsoft® SQL Server™ 2005

Course 2941: Creating the Data Access Tier Using Microsoft® SQL Server™ 2005

Course 2942: New Features of Microsoft® SQL Server™ 2005 Analysis Services

Course 2943: Updating Your Data ETL Skills to Microsoft® SQL Server™ 2005 Integration Services

Course 2944: Updating Your Reporting Skills to Microsoft® SQL Server™ 2005 Reporting Services