Upgrd 7 to 2k problem; Svr property box disappers

  • Hoping someone can help me out with our SQL 2000 Servers. I recently upgraded our two installations of SQL 7 sp4 to SQL 2000. The installation went through without any problems and all of the databases and applications that use the databases are working fine. The issue arises when I right click on the server in SQL Enterprise Manager and go to properties. The dialog box that normally gives you the ability modify the server briefly pops up but then disappears again. This does not give me the ability change any configuration settings.

    This is what I have done to try and resolve this problem: I have tried logging in to the Registered SQL Enterprise manager as the administrator for the domain and as "sa" but does not make a difference. I have tried upgrading one of the installation to SQL 2000 sp3a. I look in the event viewer for errors but does not show any errors dealing with SQL. I checked the registry and file system to verify permissions. I have searched the knowledgebase on TechNet but have not found anything. I have changed the default connnection to tcp/ip. I have verified that the sql2k dlls are in use. I am at a loss on what to do.

    PLZ HELP me.

    Thanks in advance for you responses.

  • This was removed by the editor as SPAM

  • Sounds like a bad client install - try rerunning just the client tools portion.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • I tried that after I posted to the site, to no avail. The only way I got it to work was to do a complete un-install of SQL then re-install, attach the databases reconfigure each of the security settings and I was back in business. It was not the fix I was looking for but the server is working like a champ now. So I can't complain. Atleast about this topic. Thanks to everyone that replied.

    Ryan

Viewing 4 posts - 1 through 3 (of 3 total)

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