I have created a view in my SQL Server database that is a union between tables in two different databases. The view works fine in SQL Server, but when I attempt to access it using ASP in my page, it comes back with an error message that says the "Server user 'username' is not a valid user in database 'databasename'". For all of the other pages, I've only had to access tables in one database, so it hasn't been an issue up to this point. I have the connection information for the second database being used in this view, but not sure how to get it to work. Anyone have any ideas?<BR><BR>FYI, the view (i.e. - recordset) is in the database I've been using up to this point. The second database is simply being used to help populate the view. Thanks.