I've connected to a number of Microsoft Sequel Server views (using the Data Connection wizard)while in a SharePoint worksheet. I have one simple view that will not allow me to connect to when using Log in credentials other then Windows authentication. I receive the following error:
The request for procedure 'xxxxxxxx' failed because 'xxxxxxx' is a view object.
I can connect to other views using the same login and password (in the same database) with no problem. Any ideas would greatly be appreciated!
The request for procedure 'xxxxxxxx' failed because 'xxxxxxx' is a view object.
I can connect to other views using the same login and password (in the same database) with no problem. Any ideas would greatly be appreciated!