Post reply

2 Server Communication

  • April 30, 2003 at 11:13 am

    #159808

    I have 2 SQL Servers (Prd and Dev). A SQL DTS Package resides on Dev, and it is a script to copy tables from Dev to Prd. When I call the on the package from ASP, the tranfers fail. Anyone know how to do this ?

  • April 30, 2003 at 11:30 am

    #455831

    Can you post the error message you recieve?

  • April 30, 2003 at 12:04 pm

    #455844

    quote:

    Can you post the error message you recieve?

    I am using a 'trusted connection'/256 . It just says the step/task failed.

  • April 30, 2003 at 12:18 pm

    #455849

    I got an error message that makes sense, but I still dont know how to immediately fix. In the log file it says the login failed for user 'NT Authority\Anonymous Login' - 80040E4D.

    thanks

  • April 30, 2003 at 1:28 pm

    #455852

    You are tring to access SQL Server with 'trust connection' from IIS server.

    Option1 : create SQL Server login with proper permissions to your database and modify your ASP connection string to use 'SQL Server authentication' to access SQL Server.

    connStr = "Provider=SQLOLEDB;Server=x.x.x.x;Database=" & _

    dbname & ";UID=username;PWD=password"

    Option2 : Grant 'NT Authority\Anonymous Logon' to access SQL Server with proper permission to your database.

  • April 30, 2003 at 1:56 pm

    #455853

    allen = could you give me some more sample code for Option 1.

    on Option 2 - how secure is that ?

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

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