Assuming the Agent XPs configuration option is good to go, check out - https://thelonelydba.wordpress.com/2012/08/09/sql-database-misteriously-read-only/%5B/url%5D

dan-572483 (3/9/2016)

---

We want our Data Center people to be able to manually run an Agent Job on a SQL 2012 instance when the scheduled run fails.

I have added an Active...

Referenced an example below

USE [master]

GO

EXEC master.dbo.sp_addlinkedserver @server = N'ADSI', @srvproduct=N'Active Directory Service Interfaces', @provider=N'ADSDSOObject', @datasrc=N'adsdatasource'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ADSI',@useself=N'False',@locallogin=NULL,@rmtuser=N'SOMEDOMAIN\UserName',@rmtpassword='*******'

GO

EXEC master.dbo.sp_serveroption @server=N'ADSI', @optname=N'collation compatible', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'ADSI', @optname=N'data access',...

If you are uncertain as to the source, might want to start by launching a command prompt and issuing a ping -a XXX.XXX.XXX to identify the source. Once you have...

I know this is a really old thread....did you ever find a solution via SSIS for importing BAI files?

Thanks,

Which edition are you using? Are you aware of the new core licensing model in SQL Server 2012?

http://www.microsoft.com/en-us/sqlserver/get-sql-server/how-to-buy.aspx

http://sqlblog.com/blogs/aaron_bertrand/archive/2012/04/27/a-cautionary-tale-about-grandfathering-CAL-licenses-in-SQL-Server-2012-Enterprise.aspx

http://www.sqlbeats.com/?p=13

Have you tried querying AD using a linked server via the OLE DB Provider for Microsoft Directory Services?

Check out -

http://msdn.microsoft.com/en-us/library/ms190803(v=sql.105).aspx

The packages aren't automatically upgraded to the SQL Server 2012 package format.

Per BOL -

"At runtime DTEXEC uses temporary upgrade process for an existing SQL Server 2005 or 2008...

In our case, this was remediated in CU4 for SQL Server 2012 SP1.

An update is available for SQL Server 2012 Memory Management

http://support.microsoft.com/kb/2845380

CU4 for SQL Server 2012 SP1

http://support.microsoft.com/kb/2833645/en-us

http://www.sqlservercentral.com/Forums/Topic1415833-2799-3.aspx#bm1458905

CU4 for SQL Server 2012 has been released which corrects this issue.

http://support.microsoft.com/kb/2845380

CU4 is available for download via:

http://support.microsoft.com/kb/2833645

FYI, it would appear CU4 for SQL Server 2012 SP1 is immanent based on KB2828205. It is my understanding CU4 will correct the memory management issue which was broken in...

You may also want to take a look at this thread on SSC -

http://www.sqlservercentral.com/Forums/Topic708053-146-1.aspx

Good point. There are other options available. Have you consider the potential for data loss? The following thread may be helpful.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/76e99d3a-0d6b-4ee3-8f22-6d56c3c6e50c/%5B/url%5D

FYI, I believe this was the fix SQLRNNR was referring too -

http://support.microsoft.com/kb/2509302

CU2 for SP1 available via -

http://support.microsoft.com/kb/2790947

Which DB2 client are you working with, IBM? Have you tried Microsoft's OLEDB provider for DB2?

http://www.microsoft.com/en-us/download/details.aspx?id=29100