Thanks for the reply which has got me sorted using the
trusted connection approach, although Im not using Mixed
Mode authentication - but Windows authentication.
As to isql vs osql, I just use what someone showed me to
be run from batch files. I dont really understand when I
should use one over the other for this purpose.
>Sounds like your Server is set to Mixed Mode
>You can change this using Enterprise Manager, Right Click
>on the Server>Properties>Security Tab
>Also you can use a trusted connection
>isql -E -S Servername -i c:\inputfile.sql
>Any reason you are using isql instead of osql ?
>> I am having difficulty running isql from a command
>> isql -U sa -e -P -i CreateDB.sql
>> fails with the error message:
>> Login failed for user 'sa'. Reasong: Not associated
>> a trusted SQL Server connection.
>> DB-Library: Login incorrect.
>> I have tried setting up another user with appropriate
>> priveleges user the Enterprise manager, but I get the
>> same error message. Any ideas?