thanks all for your replies...

i am still exploring options but good info

Sorry.. It's an Enterprise Edition

Sorry please ignore my typo I mean SQL 2014 EE

thanks for your reply. the CANTL\Prd1 is SQL 2015 EE and the primary server is SQL 2008 R2

Hi,

thanks for looking into this. so by: There is likely a deny connect permission for that user.... do you mean need to look into active directory for this login...

thanks all. have tried all and still looking around to resolve this. If any more info please let me know

Thanks for your reply. I do not shrink regularly. I just want the script handy in case need to shrink few logs. Any script you send is much appreciated. ...

Thanks all for your replies. I did try all this but nothing works for me.

Hi All

thanks for the reply. The services is running. Currently my SQL is 10.50.400. May be this will help to figure out something.

Thanks all again.

OK thanks. i checked and the user is in the database as well as under the logins. but the login is not mapped. so how do i map that login.

Thanks for your reply. Thiese logins are Windows logins so no idea how to deal with that.

Thank you... I will review it.

doesn't shrink that way, any script you have please share.

it gives me the same error :

Hi,

I really don't know what data types does Oracle has. I was just give the name and info to create Linked server which I did successfully.

So the person...