Wednesday, November 16, 2011

An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'

Msg 15600, Level 15, State 1, Procedure sp_change_users_login, Line 214
An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'.

I ran this script:

EXECUTE sp_change_users_login @action = 'auto_fix', @UserNamePattern = 'login'


I added @Password parameter:

EXECUTE sp_change_users_login @action = 'auto_fix', @UserNamePattern = 'login', @Password = 'password'

Saturday, November 5, 2011

SharePoint disable loopback check

I was constantly prompted for the username and password. In SharePoint 2010, it can really annoy you by not accepting your username password credentials in the popup window.

Its a ‘feature’ on the server that you need to disable as a workaround.
Caution: Microsoft Best practices is out of scope in this article. Do your own research on this topic.

You would need to create a DWORD registry key in the registry called DisableLoopbackCheck and set it to 1.
Follow these steps:

Click Start, click Run
Type regedit, and then click OK
In Registry Editor, locate the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
Right-click Lsa, point to New, and then click DWORD Value. (In Win 2008, its DWORD 32bit)
Type DisableLoopbackCheck, and then press ENTER.
Right-click DisableLoopbackCheck, and then click Modify.
In the Value data box, type 1 and then click OK.
Quit Registry Editor.
You may need to restart your server.

For more information about this, click the following article number to view the article in the Microsoft Knowledge Base: 281308 ( ) Connecting to SMB share on a Windows 2000-based computer or a Windows Server 2003-based computer may not work with an alias name.