Error creating a Database Source to SQL in SharePoint Designer 2010

May be you have tried to create a SQL Database Connection in SharePoint Designer 2010 and receive the message:

Server Error:  An error occurred while retrieving the list of databases from (SQL Server): An authentication error occurred. Your logon information may be incorrectly entered, you may not have permission to access this data source, or the requested authentication method may not be supported. Contact the server administrator for more information.

Ok, lets find Administrator. The first thing dropped in my mind is, I am administrator, who i can contact then?

The solution is very easy.

Go to SQL – Right click the SQL-instance – Properties – Security – SQL server and Windows autentication mode – Ok – Right click again SQL instance – Restart – Yes -Yes.

Now lets find the Administrator?

Top SharePoint Intranet sites

Many people ask me about any sample of SharePoint web site live. Often it’s difficult to find some good examples related to what they ask. Here is a link show all SharePoint sites created and available on the net. On this page we can use different types of categories which we can use to figure out what kind of website we want to see. Not only categories, but also based on country and platform too…

Use link.

Use link.

Exclude list or library from appearing in SharePoint Search results

Did some research on net and found some JavaScript and kid of .net code to exclude some lists and libraries from search. Even I also found some articles where people are using Central administration and make some rules and exclusion policies. Well that can we do if we have plenty time to play with SharePoint. It’s just dream to have fun time working with SharePointJ

Here is the solution: Go to the list or library –> Settings –> List Settings –> Advanced Settings –> Search

Create advanced survey using”branch logic”

Branch logic in SharePoint gives us possibility to create multiple sets of questions and use more complex branching to guide people through your survey. In simple words it is survey jump to another question, regardless of the answer. When we create questions in survey, we can join questions together using section called “Branching logic”. In me example I will use same scenario where I want people to skip the questions based on their answers. In my example I create a survey list called “UseSP”.

  1. My first question is “Do you use SharePoint?” answer Yes/No.
  2. If Yes next question “What you like in SharePoint?
  3. If No next question “Why you don’t use SharePoint??”

Haven’t done anything else till now. Just created questions.

Now branch the question by clicking on question 1 using section “Branching Logic”.

Like this:

Now go to the 2 question and choose the Content type rather. That will inherit the settings from question 1.

Now let’s take a survey.

My answer is “Yes” here.

If I in first question replay “No”. Next question is then like: