Showing posts with label office. Show all posts
Showing posts with label office. Show all posts

Saturday, February 25, 2012

Registration card returned by post office.

I recently purchased SQL Server 2000 Developer Edition
here in Canada. I mailed the registration card to the
P.O. Box in San Francisco as indicated on the
accompanying documentation.
The post office has returned the card with a stamp that
says "Box Closed: Forwarding Order Expired".
As I did not get asked to register on-line when I
installed the product, how do I register that I have
acquired this product ?Chris,
The best is to call the local MS subsidiary. Check the numbers at
www.microsoft.com/canada.
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Chris Smith" <chris.smith@.shaw.ca> wrote in message
news:088701c39fe5$f1774ac0$a001280a@.phx.gbl...
> I recently purchased SQL Server 2000 Developer Edition
> here in Canada. I mailed the registration card to the
> P.O. Box in San Francisco as indicated on the
> accompanying documentation.
> The post office has returned the card with a stamp that
> says "Box Closed: Forwarding Order Expired".
> As I did not get asked to register on-line when I
> installed the product, how do I register that I have
> acquired this product ?

Monday, February 20, 2012

Registered Servers in EM disappear after your machine login changes

We recently migrated from a domain authentication structure to an Active Directory structure in my office and the 90+ SQL Servers that I had registered in SQL Server Enterprise Manager are no longer registered when I enter Enterprise Manager under my new AD login. If I go to [HKEY_USERS\S-1-5-21-10907285-1067259047-1047869632-3055\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group] in the registry I do see all of my servers registered there, but can't access them via EM, unless I re-register each one.
Can I access these servers without re-registering each of them? Is the server registration process linked to my old SID, thus why I can't see them in EM with my new AD userID?
Thanks,
DaveYes, it has to do with the SID. I have some scripts that can export
registrations to a file, from which you can import them onto another/same
machine. But they are not useful anymore, as we don't have the old login
anymore.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Dave" <anonymous@.discussions.microsoft.com> wrote in message
news:59A20FD6-C194-412C-998D-E45E17C204E1@.microsoft.com...
We recently migrated from a domain authentication structure to an Active
Directory structure in my office and the 90+ SQL Servers that I had
registered in SQL Server Enterprise Manager are no longer registered when I
enter Enterprise Manager under my new AD login. If I go to
[HKEY_USERS\S-1-5-21-10907285-1067259047-1047869632-3055\Software\Microsoft\
Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group]
in the registry I do see all of my servers registered there, but can't
access them via EM, unless I re-register each one.
Can I access these servers without re-registering each of them? Is the
server registration process linked to my old SID, thus why I can't see them
in EM with my new AD userID?
Thanks,
Dave