Wednesday, March 28, 2012

msde 7

I need to change a computer name on a computer running
msde 7, But i need to do this without doing a reinstall or
update of the software. Any ideas?
With SQL Server 7.0 you cannot rename the computer it is running on without
reinstalling SQL Server. Your best course of action is to install MSDE 2000
on a the same box (or new system) create the logins you need for the
database, restore the database to the new instance of SQL Server and synch
the logins with the database users with sp_change_users_login
Jim
"dhaven" <dhaven@.stny.rr.com> wrote in message
news:2b67601c4683e$7aa10310$a401280a@.phx.gbl...
> I need to change a computer name on a computer running
> msde 7, But i need to do this without doing a reinstall or
> update of the software. Any ideas?

No comments:

Post a Comment