topic Re: SQL Server - error using views in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768427#M786 <HTML><HEAD></HEAD><BODY><P>Are you able to preview the View in SQL Server Management Studio?</P><P></P><P>What kind of login is being used to create the View and preview in ArcMap (Database Authenticated or Windows Authenticated?</P></BODY></HTML> Mon, 29 Jun 2015 13:59:08 GMT AsrujitSengupta 2015-06-29T13:59:08Z SQL Server - error using views https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768426#M785 <HTML><HEAD></HEAD><BODY><P>We've created a view in SQL Server Management Studio but are getting an error message when viewing in ArcCatalog:</P><P></P><P><IMG alt="ArcCatalog_Error.png" class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/114482_ArcCatalog_Error.png" style="height: auto;" /></P><P></P><P>The only thing unusual about the view query is that it is joining data from a Linked Server. We don't think it is a permissions issue as the user has permissions to display data from the main table and from the table reference via the Linked Server.</P><P></P><P>Thanks for any help,</P><P></P><P>Peter.</P></BODY></HTML> Mon, 29 Jun 2015 13:55:03 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768426#M785 PeterBaldwin 2015-06-29T13:55:03Z Re: SQL Server - error using views https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768427#M786 <HTML><HEAD></HEAD><BODY><P>Are you able to preview the View in SQL Server Management Studio?</P><P></P><P>What kind of login is being used to create the View and preview in ArcMap (Database Authenticated or Windows Authenticated?</P></BODY></HTML> Mon, 29 Jun 2015 13:59:08 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768427#M786 AsrujitSengupta 2015-06-29T13:59:08Z Re: SQL Server - error using views https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768428#M787 <HTML><HEAD></HEAD><BODY><P>Hi Asrujit,</P><P></P><P>Thanks for your reply.</P><P></P><P>I'm able to preview the View in SSMS okay. In ArcCatalog I'm using an OS Authenticated connection.</P><P></P><P>Thanks,</P><P></P><P>Peter.</P></BODY></HTML> Mon, 29 Jun 2015 14:09:37 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768428#M787 PeterBaldwin 2015-06-29T14:09:37Z Re: SQL Server - error using views https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768429#M788 <HTML><HEAD></HEAD><BODY><P>Can you give it a try with any Database Authenticated login and check what happens.</P></BODY></HTML> Mon, 29 Jun 2015 14:11:45 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768429#M788 AsrujitSengupta 2015-06-29T14:11:45Z Re: SQL Server - error using views https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768430#M789 <HTML><HEAD></HEAD><BODY><P>It works okay with one of our Database Authenticated login.</P><P></P><P>Thanks,</P><P></P><P>Peter.</P></BODY></HTML> Mon, 29 Jun 2015 14:20:19 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768430#M789 PeterBaldwin 2015-06-29T14:20:19Z Re: SQL Server - error using views https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768431#M790 <HTML><HEAD></HEAD><BODY><P>Sorry for asking this again, but were you able to preview that same View in SQL Server Management Studio when connected with your Windows Authenticated login?</P></BODY></HTML> Mon, 29 Jun 2015 14:28:43 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768431#M790 AsrujitSengupta 2015-06-29T14:28:43Z Re: SQL Server - error using views https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768432#M791 <HTML><HEAD></HEAD><BODY><P>Actually, when I try to do it in SSMS with Windows authentication using my user login I get this SQL error message:</P><P></P><P>Login failed for user 'NT AUTHORITY\ANONYMOUSE LOGON'.</P><P></P><P>Previously in SSMS I have been connecting with an admin user, which was working fine.</P><P></P><P>Thanks,</P><P></P><P>Peter.</P></BODY></HTML> Mon, 29 Jun 2015 14:40:50 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768432#M791 PeterBaldwin 2015-06-29T14:40:50Z Re: SQL Server - error using views https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768433#M792 <HTML><HEAD></HEAD><BODY><P>That is of course ANONYMOUS <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 29 Jun 2015 16:23:16 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-error-using-views/m-p/768433#M792 PeterBaldwin 2015-06-29T16:23:16Z