Web Development·12,157 discussions

Rename MSDE Server

Locked

How can you change the machine name on NT and have MSDE function properly after that? With SQL 7.0 you simply run the setup and sp_dropserver, sp_addserver. What about MSDE?

Topic

Rename MSDE Server

In reply to Rename MSDE Server

Point value changed by question poster.

Rename MSDE Server

In reply to Rename MSDE Server

MSDE is the new database engine for SQL Server 6.5 (with service pack 3 or greater installed) available through Access 2000.

Insert your Office 2000 Professional CD and go to “\SQL\X*^\Setup” Directory and click on “Setupsql.exe” and Windows willrun the MSDE installation program.

Be SURE you have SQL-Server 7 or an upgraded version of 6.5 or the installation program wont work. Good Luck – Don Quigg

Rename MSDE Server

In reply to Rename MSDE Server

sorry – I mean go to “\SQL\X48\Setup” directory.

Once installed you will be able to create the New Access Project (or Access front end to a SQL Server back-end)

Rename MSDE Server

In reply to Rename MSDE Server

MSDE is actually the freely distributable engine from SQL Server 7.0. Your instructions to install it does not address my question of how to change the internal SQL Server (MSDE) name after renaming the machine.

Rename MSDE Server

In reply to Rename MSDE Server

just do your dropserver and addserver as usual to rename the server. MSDE is a tool thet recognizes SQL functionality and allows Access gurus to store queries as stored procedures to cut down network traffic. It does NOT change server names or do any operating system functions.

Rename MSDE Server

In reply to Rename MSDE Server

This question was closed by the author

[Author]

Replies