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'

Fix:

I added @Password parameter:

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

SharePoint disable loopback check

Post from: http://www.jeremytaylor.net/2010/05/24/sharepoint-disable-loopback-check-disableloopbackcheck-dword-in-registry/

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 (http://support.microsoft.com/kb/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.

The type was not expected. Use the XmlInclude or SoapInclude attribute to specify types that are not known statically.

Post from: http://www.johnsoer.com/blog/?p=125&cpage=1#comment-5494

1. public class Test
2. {
3. private string _Field = "";
4. public string Field
5. {
6. get { return _Field; }
7. set { _Field = value; }
8. }
9. }
11. public class TestInherited : Test
12. {
13. }
15. public class Container
16. {
17. private Test ivField;
18. public Test Field
19. {
20. get { return _Field; }
21. set { _Field = value; }
22. }
23. }
25. Container _Test = new Container();
26. _Test.Field = new TestInherited();

Solution:

new XmlSerializer(typeof(Container), new Type[] { typeof(TestInherited) });

This solution was not working for me because:

There was a namspace on my XmlRoot element [XmlRoot("Container", Namespace = "http://namespace", IsNullable = false)]

When i removed namespase, the problem was gone.

Hope this helps someone.

Setup WRT54G (or similar) running DD-WRT as Access Point

Blog from: http://www.maximumpc.com/forums/viewtopic.php?t=59541

Setup > Basic Setup > WAN Connection Type: Connection type: Automatic Configuration - DHCP

Enter a good (outside of your DHCP range) IP address (and, of course, match your current subnet);

Setup > Basic Setup > Network Address Server Settings (DHCP): DHCP Server: Disable
Setup > Advanced Routing > Operating Mode: Operating Mode: Router

Setup > Advanced Routing > Dynamic Routing: Interface: Both

Setup > Advanced Routing > Static Routing: Interface: LAN & WLAN

SSRS 2008 R2 and UAC problem

Post from: http://calebs71.blogspot.com/2010/09/ssrs-2008-domain-user-issue.html

Scenario: I have a new SQL Server Reporting Services 2008 R2 x64 instance that works if you are the local administrator. Once I switch to another user who is an implied administrator via an AD group I get the following error when attempting to access SSRS in a browser:

"User 'TESTDOM\user' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed."

The user is a member of the domain admins group which is obviously a member of the local admins. Also if I right click on IE8 and say "Run As Administrator" it works. The quick fix is to disable the UAC. If you don't want to do that then just do the below:

1. Launch IE8 using "Run As Administrator" and in SSRS (http://servername/Reports) click on Site Settings. In Site Settings navigate to "Security" and add your user "TESTDOM\user" as a System Administrator.

2. Click on "Home" and then "Folder Settings". Now add your account again this time assigning yourself all the roles (Browser, Content Manager, My Reports, Publisher, Report Builder).

3. Close Administrative IE session and open a normal IE8 window and your SSRS should work.

Fix SharePoint 2010 alert url's

http://technet.microsoft.com/en-us/library/cc508847.aspx

Login failed for user .

Server Name: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

Error Number: 18456

Severity: 14

State: 1

Run SSMS as Administrator.