question

NerdCi-3095 avatar image
0 Votes"
NerdCi-3095 asked LeonLaude commented

Windows Server 2019 AD


Hello everybody,

I have a main Server which has an Active Directory and a second Server for SQL. Both Servers are in the same Domain.

Now i would like to give a user rights in my SQLServe. When i click on Path:

98228-grafik.png

I just can se:

98301-grafik.png

But i would like to see this:

98302-grafik.png

Can anyoine help me please.


windows-serverwindows-active-directory
grafik.png (13.3 KiB)
grafik.png (7.1 KiB)
grafik.png (3.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LeonLaude avatar image
0 Votes"
LeonLaude answered LeonLaude commented

Hi @NerdCi-3095,

Most likely a domain communication issue, here are a few things to check:

  • Make sure all DNS settings are correct on your SQL Server.

  • Make sure no firewall is blocking any necessary ports.

  • Try rebooting

  • Try unjoining the domain and re-joining.


(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)


Best regards,
Leon

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello LeonLaude,

thank you for your help.

Unjoining and re-joining the domain fixed my problem.

Cheers

0 Votes 0 ·

Glad to hear, you're welcome.

0 Votes 0 ·