New Video Tutorials for SharePoint Designer

Microsoft and Total Training have been teaming up to produce a set of training videos for SPD. John Jansen (whose posts you may have read, below) is a senior member of the SharePoint Designer Test Team here at Redmond and hosts the videos, in addition to playing a key role in their development and implementation.

Total Training for Microsoft® Office SharePoint Designer 2007 is a 9 hour, level 300-400 training series. The videos show you how to build very simple or incredibly complex business solutions on the SharePoint platform. John will teach you about Master Pages, how to modify Cascading Style Sheets (CSS) in SharePoint Designer, and how to integrate Visual Studio with custom Web part deployment and workflow actions. All with a smile on his face!


  • Learn how to build a Workflow in SharePoint Designer that leverages custom actions from Visual Studio.
  • Create and modify new layout pages and customize them in SharePoint Designer.
  • Customize the CSS files used in SharePoint to create a custom branded site.
  • Build Master Pages from scratch so that layout pages and CSS files can be used across your site.
  • Develop custom business applications with multiple data views.

Where to go 

Comments (16)

  1. VSeWSS 1.1 Chris O’Brien VSeWSS 1.1. CTP – a look at the nuts and bolts etwas älter aber dazu passend

  2. Body: Happy Tuesday! One of the best things about a long weekend is the short workweek, unless of course

  3. Retomando el clásico recopilatorio de recursos y enlaces que sobre WSS 3.0 & MOSS venimos realizando

  4. Ben says:


    I have purchased the training videos and been going through them several times – great work by the way.

    I had a couple of questions for you regarding the modifying themes lesson:

    – Why do you need to change the codepage number when modifying the .INF file?  What does the codepage number do?

    – You mentioned never to modify the core.css file because when you install a service pack, the core.css file will be undone.  Why will the core.css file be undone when you apply a service pack?

    Again, great work with the tutorial videos.

  5. Snehal Rana says:

    Hi John,

    I have purchased the total training monthly subscription and am going through the Sharepoint Designer 2007 videos for MOSS 2007. I have question regarding Data Source connection via Sharepoint Designer 2007 on our Intranet portal. I am unable to connect to my SQL database via Data source connection. I have tried couple combination of Connection strings also, but no luck. I have also installed SPD2007 on the server but gives me same error. Below is my error:

    Server Error: An error occurred while retrieving the list of Databases from <server name>: The data retrieval service encountered an error during connection to the data source. Contact the server administrator for more information

    Any idea why this must be happening? What am I doing wrong.

    Great videos and very informational. Keep up good work John!!


    Snehal Rana

  6. Chris Eidsmoe says:

    Same issue- Server Error: An error occurred while retrieving the list of Databases from <server name>: The data retrieval service encountered an error during connection to the data source. Contact the server administrator for more information

    Still unable to connect.

  7. James says:

    My sharepiont experience is limited to updating sites in frontpage for sharepoint 2003.  I don’t really have much exp with  My company is looking to upgrade to sharepoint 2007 and it’s my job to figure this out.  Since we used frontpage in 2003 it appears that we’ll need to rebuild all of our sites/web parts.  I am looking to figure out how to brand sharepoint (so create a master page and layout template), webparts and functionality.

    Would thiese training video’s be suggested for someone in my situation?


  8. Jon Frost says:

    The TotalTraing Video series on SPD has a segment that will show you how to build masterpages from scratch.  These pages have all the required SharePoint Controls hidden at the bottom of the page.  You can reveal and use just the controls you want/need.  Most importantly you have absolute control of the look and feel of the entire page.

  9. spdblog says:

    Snehal: As you have no doubt noticed, that error is very unhelpful. The most common reason for this failure is that the authentication has failed for some reason. I wonder if you can try using SSO from your new MOSS installation and using the SSO connection to get your SQL data…

  10. Chris Eidsmoe says:

    I forgot to post this- I can connect now, but only using SQLServer database authentication not Windows authentication.  Which is fine because that way the application uses just one set of credentials and users must be permitted to use the app by group.

  11. Larry Pauley says:

    I found a solution to the "Server Error: An error occurred while retrieving the list of Databases from" problem.  I added a user with the same SAMAccount Id as the Windows User account I was attempting to use.  So if the name was "zionuser01" (this is a made up name of course) in SQL Server, then I added a SQL user "user01".  I set the password to the windows account password.  Apparently the SharePoint Designer cannot authenticate Windows accounts to SQL Server, even though other application have no problem authenticating a Windows user.

  12. spdblog says:

    Hi Larry:

    Just a quick FYI. The reason SPD cannot authenticate using Windows Credentials is because the credentials pass first through the server. Unlike Excel or something which talks directly to SQL, in SPD you are talking to the Server first, then the Server is authenticating to SQL.

    It’s called the "double hop" problem and causes a lot of confusion (search and you’ll see).

    What I think is a problem here is that you were seeing such a generic error. We purposely do that to help with security issues (we don’t want to say "Your username or password are wrong" because then a hacker would know that he/she guessed the right name for a backend Server). Even still, we could do a lot better here and I hope we improve it next release.

    -John Jansen, Test Lead

  13. KevinHou says:


    I did what Larry did, I created a local SQL Server acct. using the same name as my login name and password but I’m still getting the same "An error occurred while retrieving the list of Databases from" problem.  Is there something more that needs to be done?  I’m using SQL 2005, SPD 2007 on a Windows 2003 machine, my database is in the same instance as the SharePoint db, it should be simple, I must me missing something.


  14. EdWagner says:


    I was checking out the trainingvideo for Sharepoint Designer 2007. While viewing I noticed some differences when using the Sharepoint Solution Generator especially when making changes to the Solution XML. I think that I have a different version then is used in the training series. Can you tell me if are there updates to this series. Where do you find the solution xml? Do you have to edit it manually now using the wsp view?

  15. Dennis Forsman says:

    I want to find some training that mainly focuses on the data manipulation portion of Designer.  I have a project where I have a user table and a notes table connected via userid field.  I am trying to enter many notes of the same user. Hence the one to many relationship.  So I bring up the user information on one page and have created a link called ‘add note’ that I want once clicked on will take ther user to a new screen (and carry the user id) where ther user can enter any note.  I cannot figure out how to pass the user id.

  16. Darren says:

    Hi, just started using SP Deisnger and am having probs setting up a server based site by selecting file/new/website…selecting empty website.

    In path I put http://mySharePoint server/my site…

    get error cannot open site, frontpage server extenstions may not be installed, proxy settinga maybe wrong…can anyone help…can’t find sod all on the web about this error….

Skip to main content