Bennie's Blog

Login failed for user when connecting to Azure SQL

2020-12-17T10:36:00.000-05:00

Problem: When using dotnet ef database update to create database schema for Azure SQL DB. Errored out with below (Login failed for user). But no problem logging in from Managemnet Studio using same credential. Username and password are in connection string as test.

try, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)Error Number:18456,State:1,Class:14
Login failed for user 'xxxx'.

Issue: Seems for some reason the command not able to handle special character in password (with special characters in connection string.

Resolution: Updated the admin password without special characters and it worked fine (You can do so easily with powershell or on Azure admin UI). There were suggestions to escape them with backlash or quote etc,none worked for me so far. Idea?

npm install gulp yo @microsoft/generator-sharepoint error

2020-12-14T19:43:00.005-05:00

Problem:
Errors when trying to install SharePoint with npm install gulp yo @microsoft/generator-sharepoint. It errors out like below
npm ERR! code EEXIST
npm ERR! path C:\Users\XX\AppData\Roaming\npm\node_modules\gulp\bin\gulp.js
npm ERR! dest C:\Users\XXX\AppData\Roaming\npm\gulp.cmd
npm ERR! EEXIST: file already exists, cmd shim 'C:\Users\xxxn\AppData\Roaming\npm\node_modules\gulp\xxx\gulp.js' -> 'C:\Users\xxx\AppData\Roaming\npm\gulp.cmd'
npm ERR! File exists: C:\Users\xxx\AppData\Roaming\npm\gulp.cmd
npm ERR! Remove the existing file and try again, or run npm
npm ERR! with --force to overwrite files recklessly.
npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\xxx\AppData\Roaming\npm-cache\_logs\2020-12-14T19_15_00_552Z-debug.log

Cause: There may be a newer version of gulp and npm is not able to replace. This command works with certain version only.
Resolution: Remove the npm folder and re install. Everything is good after that.
There must be other way to pin point exactly what is needed but this seems to be quick fix.

RowLimit error says range can only be set to 500 maxinum. But doesn't seem to have any effect in return result.

2014-12-10T20:56:00.001-05:00

In SharePoint 2013, based on my experiment/testing: RowLimit setting has no effect on result returned when TotalRowsExactMinimum is set to large nubmer. It has impact when TotalRowsExactMinimum is set to be smaller than total results.

But it seems StartRow is honored for all the cases. Without setting rowlimit. Result is able to return more than 500 results.

When trying to set Keywordquery's RowLimit to large number you will get exception

"RowLimit - The allowed range of values is 0 to 500"

What happens is MaxRowLimit on that application defaults to 500 and that value is passed to the query. RowLimit can't be set to be larger than MaxRowLimit,which is set at search service application level.

The SearchServiceApplication MaxRowLimit can be modified as follows:

PS> $ssa = Get-SPEnterpriseSearchServiceApplication
PS> $ssa.MaxRowLimit = 1000
PS> $ssa.Update()

The server was unable to save the form at this time. Please try again

2014-12-10T20:44:00.001-05:00

Problem: You may periodically encounter some errors like below when trying to perform a search in SharePoint:

"The server was unable to save the form at this time. Please try again"
"Search has encountered a problem that prevents results from being returned."

Solution: Stopping and starting the 'SharePoint Search Host Controller' service.

This solves the issue most of the time. There are times it doesn't. More post to follow on this.

Asp.net/SharePoint button Click event fires only once

2014-12-10T20:41:00.000-05:00

Problem: Response.end and download file problem using asp.net code inside SharePoint. Button click event fires only once when it is first clicked. After that,button no longer respond to click event.

Solution: Insert below script block.
function enablePostBack()
{ window.WebForm_OnSubmit = function () { return true; }; }

button.Onclientclick="enablePostBack";

summary links web parts becomes form content webpart

2012-09-28T18:04:00.001-04:00

Experienced a strange issue where Summary Links webpart turned into form content webpart on sharepoint 2010. The page has been modified by multiple people and was able to restore to old version but unsure how it happened.

summary links webpart,can not remove links.

2012-09-13T18:17:00.001-04:00

As site collection admin,I removed a link and when I saved the change the link reappeared.but when I tried to edit it was not there.
I logged in as a different user and the link was there.I was able to remove it. Still unsure of the reason

Microsoft.SharePoint namespace is not recognized even the DLL has been referenced

2012-09-08T18:23:00.003-04:00

Developing a console app using sharepoint 2010 object model in visual studio 2010. Encountered issue where Microsoft.SharePoint namespace is not recognized even project has referenced the SharePoint dll. Solution: Go to project setting and Make sure to target 3.5 .net framework.

There is no control to be placed to the toolbox.erroe loading dll to toolbox.

2011-12-31T10:14:00.001-05:00

You created a control dll but it won't load to the toolbox.try one of below to fix it:
1.make there is at least one public class in the name space.
2.make sure the control class has a public constructor that don't require any parameters.

Error:System.Web.HttpException: Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm.

2011-11-26T09:51:00.000-05:00

Error:System.Web.HttpException: Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm.

Cause:

Solution:Add this to page enableViewStateMac="false"

This option will work perfectly, but it is always advisable to go with specifying the custom key for encryption and decryption in web.config.

http://forums.asp.net/t/1355367.aspx/1

Object reference not set to an instance of an object when trying to check out document from library WSS30

2011-11-21T16:29:00.001-05:00

Object reference not set to an instance of an object when trying to check out document from library WSS30

Resolution:

–>Open you Central Administration site and go to “operations”
–>look for “Alternate Access Mappings”
–>In the page you will find “Alternate Access Mapping Collection” and it will say “Show All”
–>Click on the small arrow point downwards on this “Show All” location and you will get “Change Alternate Access Mapping Collection”
–>Go ahead and choose the Web Application which is responsible for the problem site
–>You will see that there is a URL already showing in “Default” zone
–>You need to specify the URL which is giving you problem in the “Intranet” zone. So it will see like this:
Default: http://matrix
Intranet: http://yagyashree.org
–>Performed IISRESET
–>Now everything should be working fine, you should be able to check-out and edit the office documents

Workflow issue: Multiple instances seem to be running even though they don't show in History List

2011-11-08T10:29:00.000-05:00

Workflow: Multiple instances seem to be running even though they don't show in History List.

I have a SPD2007 workflow which will modify a field based on the "Modified By" field. This workflow is set on run on "Modified" or "Changed" events. I only need to get the initial Modify By person. And the workflow need to wait for other users to change another field, which seems to trigger the "Modify By" to be changed. It seems this would reset my initial value again which was based on the initial "Modified By". So the value changes multiple times during the workflow. The history list didn't show multiple instances running or duplicate actions occurring.

Eventually I took care of the issue by putting a "Pause for 1 minute" behind each of the "Update Item" action.

It seem the workflow triggering run too fast before they could put a stop to it. Because the workflow ends immediately and the "Change" even still fires to some effect which trigger another workflow?

Giving some "Pause" time seems to stop the workfow from trasitioning into another state. Just my guess.

SharePoint Designer: Datasource List/Library window greyed out.

2011-11-08T09:28:00.000-05:00

A user has Full control of the site but when opening the site in SPD the datasource window is greyed out. The access right to granted individually. It seems adding the user to Owners group takes care of the problem. So somehow somewhere the permission is not propagating correctly.

Steps to check and verify:

1. Open the problem site in SPD

2. In the Folder List navigate to _catalogs/fpdatasources

3. Right-click fpdatasources and click the Security tab

4. Click "Manage permissions using the browser."

5. Add the appropriate permissions.

Asp.net GridView delete confirmation

2011-10-27T11:59:00.000-04:00

    How to ask for confirmation when using the delete command in gridview? By default it just deletes the item right away.

Answer: Disable the "Show Delete" Option and Put below code in the grid template.

"
       <asp:TemplateField><ItemTemplate>
                         <asp:LinkButton ID="lnkDeleteBtn" Runat="server" OnClientClick="return ConfirmDelete();"
                                CommandName="Delete">Delete</asp:LinkButton>
                            </ItemTemplate>
        </asp:TemplateField>

"
Also put this piece of javascript in the header section.
"<script type="text/javascript">
    function ConfirmDelete() {
        return confirm("Are you sure to delete?");
    }
</script>"

Asp.net How to hide columns in DetailsView control

2011-10-27T11:56:00.000-04:00

Asp.net How to hide columns in DetailsView control?

This can be done via code in the page load event.

protected void Page_Load(object sender, EventArgs e)
{
DetailsView1.Fields[2].Visible = false;
}

No exact match was found People Picker - SharePoint 2010

2011-10-26T17:22:00.000-04:00

Problem: All domains have two way trust, supposedly. But can't find users from one domain.

Solution: Run below commands,

STSADM.exe -o setapppassword -password key
Next, set the peoplepicker-searchadforests property:

STSADM.exe -o setproperty-propertyname peoplepicker-searchadforests -propertyvalue <Valid list of forests or domains> -url <URL of the Web application>
where <Valid list of forests or domains> might look like this:
"domain:mydomain.com,mydomain\myuser,mypassword"

The reason of the issue could be (my guess) 1. the default service account doesn't have access to the domain it is trying to query. 2. The two way trust doesn't work correctly.

SharePoint 2010 Link web part issue

2011-10-21T15:48:00.000-04:00

It seems the web part is different than SharePoint 2007 and I don't like the way it works (at least the way I know it works). so far, it always show the column name and it looks strange with a web part title (links) above already. How to make it look like regular links without the columns name showing?

Sharepoint 2010 - Multiple document upload window blank

2011-10-21T14:16:00.000-04:00

Issue: Whenever clicking on Upload Multiple Documents link, it opens the upload window, but it is empty without any button/controls to select files.

Fix:
Add the SharePoint site into the trusted sites of your internet explorer

How to add existing folder with files into Visual Studio?

2011-10-12T15:19:00.000-04:00

How to add existing folder with files into Visual Studio?

Answer:
From the top of the solution explorer window. You will find the button to "Show All Files" for the specific project (you might need to hit "Refresh" to see them). The folders/files that are not part of your project appear slightly "lighter" in the project tree. Right click the folders/files you want to add and click "Include In Project". It will recursively add folders/files to the project.

How to delete a folder from Picture Library?

2011-09-30T09:28:00.000-04:00

How to delete a folder from Picture Library?

It seems difficult to delete or rename a folder in picture library. Explore view is working goofy. It takes a long time to load and doesn't actually get rid of the folder even it asks for confirmation about the "removal".

What is the right way that works?

Look to the same upper right corner of your window and go to View: All Pictures: All Pictures: Details.

This will show you the folders in a list, and you're able to mouse over individual folders, a dropdown arrow appears on the right, click it, and within the list is the option to delete the folder.

Daily Question: How kerberos works?

2011-09-29T17:19:00.000-04:00

Daily Question: How kerberos works?

Answer:
A Mutual Authentication Process built on top of tickets.The core idea behind Kerberos is that you don't hand out your account password to each service you want to use. Instead, you keep all of your tickets on your local system and only show each service a ticket specifically for that service, one that can't be used for any other purpose.

When you first start using your system, you use your password to get a master ticket called a TGT (ticket-granting ticket). This master ticket expires in certain time period, after which you will need to enter your password again to get another one.

Whenever you go to a service that uses Kerberos, you show that master ticket to the Kerberos server and get a ticket specifically for that service. Then, you show the ticket just for that service to the service to prove who you are. All of those tickets are stored on your local system in what is called a ticket cache.

Using your password is like using a birth certificate, citizenship, or immigration papers to prove who you are. They contain all the information required to steal your identity. You don't want to present them every time someone needs to identify you. Instead, you use those papers to get an identification card (a passport, a driver's license, a state ID card, or a Stanford ID card). That ID card is like a Kerberos TGT. You can then use that ID card to prove your identity and get other identifiers indended for specific situations: a movie ticket or a pre-paid phone card, for example. Single-purpose identifiers like movie tickets are similar to Kerberos service tickets.

http://web.mit.edu/kerberos/

Question: In Visual Studio How to set/change state in state machine workflow

2011-09-29T16:34:00.000-04:00

Question: In Visual Studio How to set/change state in state machine workflow?

Answer: Use SetState activity.

Defining states (using State activity), events (Event Driven activity and Handle External Event activity) and transitions (SetState activity).

Daily Question: How to address double hop issue in SharePoint?

2011-09-28T14:29:00.000-04:00

Daily Question: How to address double hop issue in SharePoint?

Answers:
Solution 1: User Kerberos instead of NTLM.
Solution 2: Use secure store in sharepoint 2010.

About the Secure Store Service

The Secure Store Service is an authorization service that runs on an application server. The Secure Store Service provides a database that is used to store credentials. These credentials usually consist of a user identity and password, but can also contain other fields that you define. For example, SharePoint Server 2010 can use the secure store database to store and retrieve credentials for access to external data sources. The Secure Store Service provides support for storing multiple sets of credentials for multiple back-end systems.

Interesting read:
http://blogs.msdn.com/b/besidethepoint/archive/2010/05/09/double-hop-authentication-why-ntlm-fails-and-kerberos-works.aspx

Doube Hop Issue:
Basically it is due to the way NTLM works, where authentication can't be passed on without the actual password. SharePoint doesn't normally have the logged in user's password for access resource on another server/domain ("second hop").
In IIS, when you need to access another resource off of the IIS server and certain fairly common situations occur, when using Integrated Security, anonymous access is disabled, and impersonation is turned on, a security measure kicks in and doesn't allow your site to access resources on any network servers. This includes access to a UNC path directly from IIS or SQL Server using Windows authentication.
The reason is because of a 'double hop' that authentication is doing. When you authenticate to the IIS server using Integrated Authentication, that uses up your first 'hop'. When IIS tries to access a network device, that would be the double or second hop which is not allowed. IIS cannot in turn pass on those credentials to the next network device, otherwise the developer or administrator could abuse your credentials and use them in ways that the site visitor didn't anticipate.

Daily Question: What is drupal?

2011-09-23T10:10:00.001-04:00

What is drupal?

Answer:

Daily Question: How to hide an item in HTML/CSS?

2011-09-23T10:09:00.001-04:00

How to hide an item with CSS?

Answer:

1.Use ""display: none;"

2. If Jquery is used.

$('.target').hide();