HI , 

Job is getting failed with out of memory error though Server is having enough RAM .
Job is failing on Second Server which refer to first Server

HI ,
We are running this on VMWare ,
windows server 2012 R2 Standard .

We are using this server for monitoring the log shipping and keeping backup...

Failed allocate pages: FAIL_PAGE_ALLOCATION 1

CACHESTORE_XMLDBTYPE (node 0)       KB    
---------------------------------------- ----------    
VM Reserved             0    
VM Committed             0    
Locked Pages Allocated          0    
SM Reserved             0    
SM Committed             0    
Pages...

HI Thom,

You firstly seem to be saying you have a SQL Agent job that runs an SSIS package, that create a SSRS report, correct?  -- Yes 

I...

OK thanks a lot.

HI Sue,

A quick question .. if we mention @rmtuser as admin which login it will refer while executing linked server.

Also can we implement in production...

HI Sue ,

one question ... Can we implemnt this on prod . Will it be any security constraint if we mention @rmtuser as Admin.

Regards,

Hi sue,

Thanks you very much .

I am stuck in this issue from long time.

the mistake I was doing is @rmtuser = Admin . 

HI Sue,

Actually we are trying to coonect using non admin sql login having developer access.

SELECT * FROM OPENQUERY(ExcelServer1, 'SELECT * FROM [Sheet1$]')

While executing...

Error using SQL login :Continue ...

7) SQL AGENT and SQL services are running using Service account .
Service account is in administrator group....

HI Sue,

Sorry for delayed in revert.. 

Steps I did on server : 
1) Installed Microsoft .ACE.OLEDB.Provider.12.0 on server 
2) Microsoft Office 365 proplus en-us

3) Added the...

HI Team,

I am trying to read Excel file from SQL server using non- sysadmin  sql login .

select * from OPENROWSET('MICROSOFT.ACE.OLEDB.12.0',
'Excel 8.0;HDR=YES;DATABASE=L:\Linked Server\RT_CargaPolizas.xls',sheet$)