Responsa zu Schemuel I 18:14

Rabbi Shmuel bar Naḥmani said that Rabbi Yonatan said: Anyone who says that David sinned with Bathsheba is nothing other than mistaken, as it is stated: “And David succeeded in all his ways; and the Lord was with him” (I Samuel 18:14). Is it possible that sin came to his hand and nevertheless the Divine Presence was with him? However, how then do I establish the meaning of the rebuke of the prophet Nathan: “Why have you despised the word of the Lord, to do that which is evil in My sight? Uriah the Hittite you have smitten with the sword, and his wife you have taken to be your wife, and him you have slain with the sword of the children of Ammon” (II Samuel 12:9), indicating that David sinned? The Gemara answers: David sought to do evil and have relations with Bathsheba while she was still married to Uriah but did not do so.