Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Can renaming of user account on AD cause this?

Author  Topic 

Joozh
Posting Yak Master

145 Posts

Posted - 2006-04-17 : 03:50:47
Hi,

My original account on the AD (Active Directory) was Usr129 and at that time I had installed MSDE on my local box - due to which my "local MSSQLServer" was also called Usr129.

Sometime back our LAN administrator renamed the accounts of all users. My new account on the AD (after this renaming) became GBUsr1177. Untill recently, my "local MSSQLServer" also appeared to have easily go through this renaming activity and thus my local installation became GBUsr1177.

Recently I started to have performance problem (on everything that I do on my local SQL installation via Enterprise manager) and I have this "feeling" that probably at the bacground it is still searching for the old SQL installation???

Can someone please guide me regarding how to get out of this (without re-installating everything).

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2006-04-26 : 01:14:24
I doubt this is causing you performance issues. What do you mean your local installation became GBUsr1177?? You mean the user account registered on the MSDE installation showed up as your new name at that point? You surely don't mean the "installation" or instance name changed.

What do the counters look like on this server when you are having these issues? Do you have access to the SQL server tools so you can run traces?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -