Archive for 'MS SQL Server'
finding those orphaned users in a mssql server database
Ever move to a new mssql server database and orphan the users…. You get all kinds of nasty errors… here is some things to fix those mssql accounts. This will not work with Windows accounts.
You can find them with this SP
sp_change_users_login ‘report’
and you can fix them with this SP
sp_change_users_login ‘update_one’, ‘username’, […]
Posted: February 7th, 2006 under MS SQL Server.
Comments: none
Enable the DTC between MSDTC and SQL server on windows 2003
Besides adding the dword of 1 to a new local machine, software, microsoft, msdtc, TurnOffRpcSecurity, you need to change AllowOnlySecureRpcCalls to be set to Zero.
Posted: February 4th, 2006 under MS SQL Server.
Comments: none