SCCM Trying to re-configuration SQL Server

Question

SCCM Trying to re-configuration SQL Server

Sokoban 1,061

Hi
I have moved SQL Server to another server and I need to modify SQL Server configuration
I have machine account to administrator and the user account have local administrator.

Do I have missed something?

// Jonas

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Garth 5,801

did you also make both account sa within Sql too?

Sokoban 1,061 Reputation points

2022-10-17T04:00:34.703+00:00

Hi
What are you mean ?

Please explain more specific, how I do to fix the.sa account in both places ..

// Jonas
Garth 5,801 Reputation points

2022-10-17T11:00:26.303+00:00

so that sound like no you don't add both computer account and you account sa within Sql. this article will show you how to add the computer account with is the hard one to do. https://askgarth.com/blog/updated-how-to-create-a-sql-server-computer-account-login/
Sokoban 1,061 Reputation points

2022-10-23T08:45:07.027+00:00
Hi again

I have still problem :-(

Add the SQLComputer to the SQL Server with public and Sysadmin with dollarsign

Both computers have localadmin account and computer account as local administrator

Both servers have the port 1433 is open in firewall.

More ideas?
Garth 5,801 Reputation points

2022-10-23T11:44:54.053+00:00

to be clean, you added the cm site server computer account as sa within Sql?
and you added your account as sa within Sql?
Sokoban 1,061 Reputation points

2022-10-23T15:35:55.31+00:00

Yes,

SQL Server has the configmanager machine account and my admin account with Public and sysadmin as a role.
Sokoban 1,061 Reputation points

2022-10-23T16:02:50.363+00:00

Yes,

SQL Server has the configmanager machine account and my admin account with Public and sysadmin as a role.

Jonas
Garth 5,801 Reputation points

2022-10-24T11:54:52.737+00:00

temporary turn off the firewall, does it work?
Sokoban 1,061 Reputation points

2022-10-25T06:27:54.57+00:00

I have tried with no Firewall to both servers , same unsuccessfull results :-(

Answer 2

Sokoban 1,061

SQL Server logins:

I have SCCM machine name as account with $ and permission is public and sysadmin.,
My login admin account have permission public and sysadmin.

But I cant see database SUSDB in SQL Server , a hint ?

Any ideas what is wrong ?

Jonas

Share via

SCCM Trying to re-configuration SQL Server

1 additional answer

Your answer