Do you need two jobs? You can put JOB A as the first step and JOB B as the second step in one job?

There's two ODBC Administrators: 32 bit and 64 bit

32 bit: %windir%\syswow64\odbcad32.exe

64 bit: %windir%\system32\odbcad32.exe

I asked if you could ping the server(s) by name to verify that the DNS was working.

By the additional information I see that it tries to connect via Named Pipes...

You need both a 32 bit AND 64 bit ODBC data source.

What is the error message when it fails to connect?

Can you ping the server(s) by name?

A ODBC DSN should work. I've used it myself, but not to Sybase.

In New Linked Server Wizard I enter the folllowing:

Linked server: <SERVER NAME>

Other data source: Microsoft OLE DB Provider...

This will work. You must enclose the login name with brackets []...

Perform Index Operations Online

http://msdn.microsoft.com/en-us/library/ms177442.aspx

It's not just a question of which driver to use, but also if you need to use the 32 bit and/or 64 bit driver(s).

There's two ODBC Administrators:

32 bit %windir%\syswow64\odbcad32.exe

64 bit...

You don't specify how you transfer data, but if you're using SQL Server Import and Export Wizard you need a 32 bit ODBC-driver.

There's two ODBC Administrators:

32 bit %windir%\syswow64\odbcad32.exe

64 bit %windir%\system32\odbcad32.exe

General...

Have you checked the memory settings in the new server? Is Maximum Server Memory limited?

Is the audit trail file an external file or is it in the database?

Here's some direct links

SQL Server 2012 Feature Pack

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

SQL Server 2012 Native Client

x86 Package http://go.microsoft.com/fwlink/?LinkID=239647&clcid=0x409

x64 Package http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409

The database is looking for the log file in the directory specified in the mdf file, not where you placed it.

T-SQL

USE [master]

GO

CREATE DATABASE [AdventureWorks2012] ON

( FILENAME = N'<Enter path...

As far as I know the licensing is per processor/core in the server. Not the number of instances.

I should check this myself. I have several servers with three instances set...

If you're only running 64-bit SQL Server (or other 64-bit software) on the servers all you need is the 64-bit Oracle Client.

If you're using Business Intelligence Development Studio (BIDS) or...