View Not Visible Follow

0
Avatar
Legacy Poster

I created a View in MS SQL Server 2008 R2 and it is not visible in Bartender. When I attempt to add it manually via "Enter Table Names by Hand Only," it returns Bartender Error Message #6669, "table_view" is not a valid table name for the named OLE DB Data Source currently in use.

 

I am able to see the view perfectly fine in Crystal Reports and SQL Explorer. Bartender seems to be missing it.

 

Any ideas?

1 comments

0
Avatar
Legacy Poster
Comment actions Permalink

I had to grant db_datareader to my label viewer user in SQL Server Management Console.

 

Able to see the view now!

Please sign in to leave a comment.