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!
Where to go
VSeWSS 1.1 Chris O'Brien VSeWSS 1.1. CTP - a look at the nuts and bolts etwas älter aber dazu passend
Body: Happy Tuesday! One of the best things about a long weekend is the short workweek, unless of course
Retomando el clásico recopilatorio de recursos y enlaces que sobre WSS 3.0 & MOSS venimos realizando
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.
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!!
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.
My sharepiont experience is limited to updating sites in frontpage for sharepoint 2003. I don't really have much exp with asp.net. 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?
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.
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...
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.
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 "zion\user01" (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.
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 live.com 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
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.
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?
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.