General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only