Server 2k3 standard - fixing corrupt profile

[jrm73]

We have a SQL server that our DBA's botched. When they login (with
Sqladmin for example) it just sits and a blank, blue screen. Never
gets to the desktop. Other logins are fine so it just looks like
profile issue. I was planning to create a new profile and use copy
profile but the current Sqladmin login is used across several
platforms and tied to a lot stuff in SQL.
Does anyone know a better way to fix/troubleshoot this?

Thanks for any input.

 

[DaveMills]

On Thu, 17 Sep 2009 10:20:17 -0700 (PDT), jrm73 wrote:

>We have a SQL server that our DBA's botched. When they login (with
>Sqladmin for example) it just sits and a blank, blue screen. Never
>gets to the desktop. Other logins are fine so it just looks like
>profile issue. I was planning to create a new profile and use copy
>profile but the current Sqladmin login is used across several
>platforms and tied to a lot stuff in SQL.
>Does anyone know a better way to fix/troubleshoot this?
>
>Thanks for any input.

I would not expect things to be tied to the profile except X509 certificates.
Backup the profile folders and then delete the profile. Login and create a new
profile. Copy bits needed from the backup profile folder.
X509 Certs should be exported first if you can but if the profile is that
screwed you may have little to loose.

--
Dave Mills
There are 10 types of people, those that understand binary and those that don't.