log in to SSMS, only show database name

Question

log in to SSMS, only show database name

Viewing 6 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Jared SSC Guru Points: 61793 More actions · Answer 1

Try going to gpedit.msc and navigating to Computer Configuration --> Administrative Templates --> System-Logon; then enable "always wait for the network at computer startup and logon."

Jared
CE - Microsoft

sqlfriend SSC Guru Points: 52794 More actions · Answer 2

Thanks, we did try to delay start for SQL service, and after that, the network person restart the server, it seems fine.

But when I come back , I restarted the server again, it still has this issue.

I tried 3 times.

I will try your recommendation of changing the group policy. And will let you know if it makes a difference.

Thanks

sqlfriend SSC Guru Points: 52794 More actions · Answer 3

Tried to enable the option in group policy, then restart the server, still have the problem

sqlfriend SSC Guru Points: 52794 More actions · Answer 4

I see the network guy uses Avocent DSView to make it work, so I tried that, it works for me this time after reboot, before I tried to use remote desktop to restart it, it had the same issue.

I just gave another try using remote desktop, it worked.

It seems this is not consistant.

sqlfriend SSC Guru Points: 52794 More actions · Answer 5

I would update this so it may help other ones, our network specialist changed the fiber controller card to a different type , it then it works all fine now.

Thanks for all the help.

george sibbald SSC Guru Points: 104210 More actions · Answer 6

thanks for posting back.

---------------------------------------------------------------------