AnsweredAssumed Answered

Connection Problems with 10.2 to SQL 2008r2

Question asked by geonetadmin on Feb 13, 2014
Latest reply on Feb 13, 2014 by geonetadmin
Original User: Buddhatown

I am experiencing a strange connection issue going from 10.2 (and 10.2.1) clients (ArcCatalog) to SQL 2008r2. Windows authenticated users can make that initial connection to retrieve the database list from the server no problem.  However, existing SQL based logins cannot - 'BAD USER login' error every time - no db list gets returned.  Tried all the way up to SA - still nothing.  However, and this is where it gets even stranger - NEW logins can make this connection.  For example, if I were to create a brand new, fresh user called 'TestUser' on the SQL box, I am able to make that initial connection - but nothing with an existing user.  Anyone else seen this?