>Hello all
>
>I'm connecting to SQL2000 table via remote view.
>But I don't want it to prompt me for login and password everytime I try to open the view.
>
>How do I prevent SQL2000 from asking for login and password?
>
>
>Thanks

Well, Sergey's method will work, if you are using NT Authentication. But, if you are using SQL logins you will need to do what sergey said AND provide the user name and password in the connection. (which is not very secure.)

BOb