Skip to content

SCCM will not connect to SQL Server.

Featured Replies

After one of the updates hanging on sharing content. I restarted the sql service and now sccm cannot connect. I have tried running modify sql server connection on the setup wizard hta but I get the error attached. When I run a UDL file test it connects using windows authentication but not when I enter the credentials of the user I am actually logged on as. Any ideas?

Capture.JPG

 

The smsexec.log states *** [28000][18456][Microsoft]

[SQL Server]Login failed for user


Here the user account has not changed and is still the same. It is the computer account of the site system server.

Is the SQL service running using the built-in system accounts or an AD service account? Under "administration --> overview --> security --> Administrative Users" does the service account have the appropriate permissions there?  For example, I have a service account called "domain\svc_sccm" that has "Full Administrator" permissions.  If you are logged into the admin console of the server, does it connect during that interactive session?  In short, these couple tests will help rule out general Windows server connectivity behavior.  If the SQL still fails after validating the above, it may be something else.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.