Post reply

SQL Standard 2012 and SQL Express

  • April 19, 2017 at 12:26 pm

    #401969

    I have a question regarding SQL Standard 2012 and SQL Express which are installed on their own servers.  When schedule a  SQL job that runs the SSIS package that runs a stored procedure that goes cross server we the following errors below.  We need to confirm the the server running SQL Express need to be upgraded to full version SQL.  Are we being limited by SQL Express when trying to run this package across both server.

  • April 19, 2017 at 1:42 pm

    #1938940

    this error looks like it could either be the linked server security isn't configured right, or potentially a double hop issue is occurring where it can't pass the credentials from the main SQL Server to the remote SQL Server.  How is the security for the linked server setup?  If you can query through the linked server outside of the SQL Agent job it might be a double hop issue then.
    For some info on this:
    https://technet.microsoft.com/en-us/library/ms189580(v=sql.105).aspx
    http://www.sqlservercentral.com/articles/Double+Hop/76743/

  • April 19, 2017 at 2:04 pm

    #1938947

    With that error, it's more likely that credentials aren't being passed.
    This article has a pretty good explanation of Kerberos, SPNs and how they come into play across servers:
    Configuring Kerberos Authentication

    Sue

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply