Category: Uncategorized

Posted on by — Leave a comment

Unable to begin distributed transaction

Symptom: The transaction manager has disabled its support for remote/network transactions

Issue: Need to enable inbound/outbound transaction manager communication

Solution:
1. Open Component Services Snap-in (dcomcnfg)
2. Browse to Console->Component Services->Computers->My Computer->Distributed Transaction Coordinator
3. Right Click Local DTC and select properties
4. Select Securty tab
5. Check Network OTC Access, Check Allow Inbound, Check Allow Outbound
6. Click OK
7. DTC services should restart and then can give it a test

Additional info:
 http://sysadminwebsite.wordpress.com/2012/05/29/9/
 http://msdn.microsoft.com/en-us/library/aa561924.aspx 

Posted on by — Leave a comment

low free memory

Check your servers “free” memory, all the available memory may be tied up in cache due to copying files to/from your server
Create a file the size of your available memory or larger.
Then copy the file and then permanently delete both the original and the copy. (Delete from command line, use shift + delete, and/or empty the trash bin)
Now all available memory should be free 🙂

 

 

 

Script:

fsutil file createnew 2gb.txt 2147483648
copy 2gb.txt 2gb-2.txt
del 2gb*.txt
Posted on by — Leave a comment

15404 Could not obtain information about Windows NT group/user

Error message:

03/03/2015 12:43:09,spid28s,Unknown,An exception occurred while enqueueing a message in the target queue. Error: 15404 State: 19. Could not obtain information about Windows NT group/user 'domainsvc_name' error code 0x5.
03/03/2015 12:43:09,spid28s,Unknown,Error: 28005 Severity: 16 State: 2.


Diagnosis:

Can confirm this by executing the following SQL:


xp_logininfo 'domainsvc_name'


Msg 15404, Level 16, State 19, Procedure xp_logininfo, Line 62
Could not obtain information about Windows NT group/user 'domainsvc_name', error code 0x5.



Resolution:

A: Give the “Authenticated Users”  “Read Permissions” on the ADFS service account.

-or-

B: Add the SQL Server service account or "Authenticated Users" to the "BULTIINWindows Authorization Access Group" in AD for the domain

-or- 

C: Add the SQL Server service account or "Authenticated Users" to the "BULTIINPre-Windows 2000 Compatible Access" in AD for the domain


References:

http://setspn.blogspot.com/2012/05/service-accounts-active-directory_6635.html

http://setspn.blogspot.com/2012/05/service-accounts-active-directory_4905.html

http://blog.matticus.net/2009/08/windows-2008-and-xplogininfo.html
Posted on by — Leave a comment

SQL Server Default Trace 0


--To see if default trace is enabled
SELECT* FROM sys.configurations WHERE configuration_id = 1568


--To enable default trace
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'default trace enabled', 1;
GO
RECONFIGURE;
GO


--To query contents of default trace file
SELECT TE.*
     , T.*
  FROM sys.fn_trace_gettable(CONVERT(VARCHAR(150)
       , ( SELECT TOP 1 f.[value]
             FROM sys.fn_trace_getinfo(NULL) f
            WHERE f.property = 2)), DEFAULT) T
  JOIN sys.trace_events TE 
    ON T.EventClass = TE.trace_event_id



More info:


http://www.databasejournal.com/features/mssql/a-few-cool-things-you-can-identify-using-the-default-trace.html




https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/