Renaming Computer Running SQL or MSDE

A number of questions have been posted in the past regarding the
problems encountered when renaming a computer that is running SQL or
MSDE. I too have had these problems but recent experience prompts me
to suspect that it is permissible to rename a computer that is running
XP Pro with MSDE2000 without any such problems.
Does anyone know of, or can anyone direct me to official Microsoft
information which details the restrictions on renaming a host computer
that is running SQL2000 in its various forms (Enterprise, Standard,
Personal Ed, MSDE)
Thanks
In my experience (and those of my customers) when you rename a computer and
reboot, SQL Server will reconfigure itself to the new machine name just
fine. Of course any scripts, DTS packages, or any other processes and
procedures that reference the old server name will need to be brought up to
date.
Jim
"David Vanstone" <dave.vanstone@.fujitsu.com.au> wrote in message
news:78d72c83.0404122023.225e5433@.posting.google.c om...
> A number of questions have been posted in the past regarding the
> problems encountered when renaming a computer that is running SQL or
> MSDE. I too have had these problems but recent experience prompts me
> to suspect that it is permissible to rename a computer that is running
> XP Pro with MSDE2000 without any such problems.
> Does anyone know of, or can anyone direct me to official Microsoft
> information which details the restrictions on renaming a host computer
> that is running SQL2000 in its various forms (Enterprise, Standard,
> Personal Ed, MSDE)
> Thanks
|||Thanks for the response Jim, but earlier versions of MSDE and SQL
often fail to work if the computer is renamed although that does not
seem to be the case recently and I have heard a rumor the MSDE2003
will not have this problem. I would like to know the offical Microsoft
position on the, but it is hard to come by.
Thanks again.
"J Young" <thorium48@.hotmail.com> wrote in message news:<O1wV5RRIEHA.3664@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> In my experience (and those of my customers) when you rename a computer and
> reboot, SQL Server will reconfigure itself to the new machine name just
> fine. Of course any scripts, DTS packages, or any other processes and
> procedures that reference the old server name will need to be brought up to
> date.
> Jim
> "David Vanstone" <dave.vanstone@.fujitsu.com.au> wrote in message
> news:78d72c83.0404122023.225e5433@.posting.google.c om...
|||I've only seen problems with SQL Server 7 (ie and MSDE v1).
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"David Vanstone" <dave.vanstone@.fujitsu.com.au> wrote in message
news:78d72c83.0404132223.739b363e@.posting.google.c om...
> Thanks for the response Jim, but earlier versions of MSDE and SQL
> often fail to work if the computer is renamed although that does not
> seem to be the case recently and I have heard a rumor the MSDE2003
> will not have this problem. I would like to know the offical Microsoft
> position on the, but it is hard to come by.
> Thanks again.
> "J Young" <thorium48@.hotmail.com> wrote in message
news:<O1wV5RRIEHA.3664@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
and[vbcol=seagreen]
to[vbcol=seagreen]
|||Greg is correct. This problem is only present in SQL 7.0 and MSDE 1. In
these version of SQL Server there is no concept of an instance name and the
server name that you would address is always the name of the machine (except
in the case of a SQL7 cluster, which is another topic altogether).
Jim
"David Vanstone" <dave.vanstone@.fujitsu.com.au> wrote in message
news:78d72c83.0404132223.739b363e@.posting.google.c om...
> Thanks for the response Jim, but earlier versions of MSDE and SQL
> often fail to work if the computer is renamed although that does not
> seem to be the case recently and I have heard a rumor the MSDE2003
> will not have this problem. I would like to know the offical Microsoft
> position on the, but it is hard to come by.
> Thanks again.
> "J Young" <thorium48@.hotmail.com> wrote in message
news:<O1wV5RRIEHA.3664@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
and[vbcol=seagreen]
to[vbcol=seagreen]

Renaming a system (host) after MSDE is installed

Should this be an issue?
My system was working fine before I renamed my system (host), but since
I have renamed it, my application is working from a remote system. From
the local system (the machine where the MSDE is running) the app is
working fine.
Any ideas?
- manzoor
With MSDE 2000, if you rename the host then the name of the SQL Server will
follow the name of the host. Make sure your remote client is connection to
the new name.
Jim
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105393521.649255.134690@.c13g2000cwb.googlegr oups.com...
> Should this be an issue?
> My system was working fine before I renamed my system (host), but since
> I have renamed it, my application is working from a remote system. From
> the local system (the machine where the MSDE is running) the app is
> working fine.
> Any ideas?
> - manzoor
>
|||Yeap, it's working fine now. Even though I am not doing anything
different. I had expected teh new name to be required and was trying to
use it initially. Maybe it has something to do with using DHCP, but I'm
not sure.
Anyway, I realy do appreciate your reposnse.
- manzoor

Rename MSDE table using SQL?

I am migrating a little VB6 app from Access to MSDE that
among other things has to rename some tables in a
database. That can be easily done with Enterprise
manager, but in my case has to be done programmatically
through ADO. I am wondering if this is possible, and if
so what is the syntax?
Take a look at sp_rename.
Mike
"s nikolsky" <anonymous@.discussions.microsoft.com> wrote in message
news:008c01c4aafd$480436a0$a401280a@.phx.gbl...
> I am migrating a little VB6 app from Access to MSDE that
> among other things has to rename some tables in a
> database. That can be easily done with Enterprise
> manager, but in my case has to be done programmatically
> through ADO. I am wondering if this is possible, and if
> so what is the syntax?

Removing SQL Instance Name

Hi,
I've MS SQL MSDE 2000 in my m/c. I've the server as an instance. I
want to have the server without any instance name. I want to keep all
the databases and data as it is. How can i remove the instance name?
ie. from "servername\vsdotnet" to "servername" alone.
Thanks,
Senthil.
- copy off the mdf and ldf files to a safe location
- uninstall the named instance
- install the default instance
- copy back the mdf and ldf files and attach them
Vikram
Vikram Vamshi
Eclipsys Corporation
"Senthil" <kumar.senthil@.gmail.com> wrote in message
news:4dce1b6a.0406201015.7891a725@.posting.google.c om...
> Hi,
> I've MS SQL MSDE 2000 in my m/c. I've the server as an instance. I
> want to have the server without any instance name. I want to keep all
> the databases and data as it is. How can i remove the instance name?
> ie. from "servername\vsdotnet" to "servername" alone.
> Thanks,
> Senthil.
|||Hi,
Only way is to backup the dabases, Remove the existing instance and install
a default instance and Restore the backed files.
Other option is detach databases , Remove existing named instance, Install
default and Attach the
Steps:-
1. Start SQL Server in single user mode
2. Perform a backup (BACKUP database) of all databases. COpy the .BAK files
to safe loaction.
3. After this for safe pupose use SP_DETACH to Detach the databases
4. Copy the MDF and LDF files to a safe place
5. Remove named instance using COntrol panel -- add remove programs
6. Install SQL Server default instance and apply the same service pack as
old
7. Restore the Master database after starting the SQL Server in single user
mode.
8. After the Master database restore restore the other databases one by one.
Have a look into the below links for more information on moving datases with
various methods:-
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Note:
Please ensure that you take a backup and keep it in a safe place before
removing the named instance.
Thanks
Hari
MCDBA
"Senthil" <kumar.senthil@.gmail.com> wrote in message
news:4dce1b6a.0406201015.7891a725@.posting.google.c om...
> Hi,
> I've MS SQL MSDE 2000 in my m/c. I've the server as an instance. I
> want to have the server without any instance name. I want to keep all
> the databases and data as it is. How can i remove the instance name?
> ie. from "servername\vsdotnet" to "servername" alone.
> Thanks,
> Senthil.
|||Thanks a lot Vikram and Hari for your replies and links.
Regards,
Senthil.
"Vikram Vamshi" <vikram.vamshi@.nospam.com> wrote in message news:<#YETuLyVEHA.3428@.TK2MSFTNGP12.phx.gbl>...
> - copy off the mdf and ldf files to a safe location
> - uninstall the named instance
> - install the default instance
> - copy back the mdf and ldf files and attach them
> Vikram
> --
> Vikram Vamshi
> Eclipsys Corporation

Removing SQL Instance Name

Hi,
I've MS SQL MSDE 2000 in my m/c. I've the server as an instance. I
want to have the server without any instance name. I want to keep all
the databases and data as it is. How can i remove the instance name?
ie. from "servername\vsdotnet" to "servername" alone.
Thanks,
Senthil.- copy off the mdf and ldf files to a safe location
- uninstall the named instance
- install the default instance
- copy back the mdf and ldf files and attach them
Vikram
--
Vikram Vamshi
Eclipsys Corporation
"Senthil" <kumar.senthil@.gmail.com> wrote in message
news:4dce1b6a.0406201015.7891a725@.posting.google.com...
> Hi,
> I've MS SQL MSDE 2000 in my m/c. I've the server as an instance. I
> want to have the server without any instance name. I want to keep all
> the databases and data as it is. How can i remove the instance name?
> ie. from "servername\vsdotnet" to "servername" alone.
> Thanks,
> Senthil.|||Hi,
Only way is to backup the dabases, Remove the existing instance and install
a default instance and Restore the backed files.
Other option is detach databases , Remove existing named instance, Install
default and Attach the
Steps:-
1. Start SQL Server in single user mode
2. Perform a backup (BACKUP database) of all databases. COpy the .BAK files
to safe loaction.
3. After this for safe pupose use SP_DETACH to Detach the databases
4. Copy the MDF and LDF files to a safe place
5. Remove named instance using COntrol panel -- add remove programs
6. Install SQL Server default instance and apply the same service pack as
old
7. Restore the Master database after starting the SQL Server in single user
mode.
8. After the Master database restore restore the other databases one by one.
Have a look into the below links for more information on moving datases with
various methods:-
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Note:
Please ensure that you take a backup and keep it in a safe place before
removing the named instance.
--
Thanks
Hari
MCDBA
"Senthil" <kumar.senthil@.gmail.com> wrote in message
news:4dce1b6a.0406201015.7891a725@.posting.google.com...
> Hi,
> I've MS SQL MSDE 2000 in my m/c. I've the server as an instance. I
> want to have the server without any instance name. I want to keep all
> the databases and data as it is. How can i remove the instance name?
> ie. from "servername\vsdotnet" to "servername" alone.
> Thanks,
> Senthil.|||Thanks a lot Vikram and Hari for your replies and links.
Regards,
Senthil.
"Vikram Vamshi" <vikram.vamshi@.nospam.com> wrote in message news:<#YETuLyVEHA.3428@.TK2MSFTNGP12.phx.gbl>...
> - copy off the mdf and ldf files to a safe location
> - uninstall the named instance
> - install the default instance
> - copy back the mdf and ldf files and attach them
> Vikram
> --
> Vikram Vamshi
> Eclipsys Corporation

Removing Merge Replication

Several years ago I set up Merge Replication on a SQL 2000 database and an MSDE Client on a Laptop. The Laptop frequently travelled out of the country and would "synch" up when it came back in.

Well the Laptop received some Viruses that we cannot get to remove so putting it on the network is not possible. Also, the owner of the laptop received a new one. He wants the database set up on the new laptop but it is not a priority at the moment and we plan to wait till the "Yemen" project is finished.

In the mean time, I want to remove the old laptop out of the Merge Replication scenario. We are not concerned about losing the data in the database on the laptop.

Does anyone know the steps I need to perform to "unreplicate" my database without being able to connect them?From the publisher's standpoint, it should be a pretty simple matter to delete the subscriber (uncheck the option to remove replication artifacts at the subscriber). See sp_dropmergesubscription in BOL.

If you are trying to remove the merge subscription artifacts from the subscriber database, then you simply execute sp_removedbreplication '[DB_NAME]'.

Regards,

hmscott|||For my situation, the subscriber was dead. So doing any procedure on the subscriber side was not an option. I had a bit of difficulty removing the subscriptions from the publisher side (sp_DropMergesubscription would not run) but I think I have it accomplished now.

The prescribed way of removing replication is to 1. Drop subscriptions, 2. Drop publications, 3. Drop Distributor - see

However I couldn't get the subscriptions to remove because I couldn't attach to them so I skipped step 1 and went to the part in the article on dropping a merge publication. I was able to run the sp_dropMergePublication and sp_Relicationdboption procedures. After that I was able to delete the subscriptions (via Enterprise Manager) as well.

I still have some garbage in the Replication Monitor on my agents that haven't cleaned up. Perhaps a restart will resolve this. Thanks for your input.|||Sorry, my URL didn't display on the last post.
http://http://support.microsoft.com/kb/324401

Removing Data Base Size Restriction

About a month ago I restored a data base that had been originally created in MSDE into a full version of SQL Server 2000. I thought that the size restriction would automatically be removed by putting it into the full version of SQL. I was wrong and about a week or so later the data base reached the 2GB size and needed attention. I received some assistance through Microsoft and they walked my client through the process of removing the size restriction. Since then everything has been OK.

Now I am doing something similar. My client has a data base that was originally created in MSDE. We upgraded them to SQL Express and the data base has now grown to 4GB which is the max that SQL Express allows.

We will be installing SQL for Workgroups this week.

My question is this. Is there a setting I must change inside the data base or in SQL for Workgroups that will allow the data base to grow beyond 4GB? We need to let it expand to whatever they need and I cant seem to find any documentation on whether or not I have to change a setting for this data base.

Thanks for your help. Jean

It's possible that you may need to change the autogrowth settings for the database. In Management Studio, right click the database, choose Properties, then go to the Files page. Check what's in the Autogrowth column for each file and verify that it's either set to "unrestricted growth", or restricted to a sufficiently large size. Looking at an Express Edition installation, it doesn't appear that a 4 GB autogrowth limit is selected by default, however. You should be able to load Developer Edition onto a test machine and play around with this a bit before you go live.|||Thank you David. I will take a look at that when we upgrade the customer. I am certain that is where I will find the settings. I appreciate your help. Jean

removing an instance

Hi all,
I have a copy of MSDE running, and it has 2 instances on it, server and
server\server, is there any way to remove server\server and transfer it
to server?
I want to move it as it appears to be interfearing with any setup of
sql based apps (sharepoint refuses to go past the install stage), and
the webadmin pages which wont let me login.
Thanks for the help.
hi,
donaldsmarshall@.gmail.com wrote:
> Hi all,
> I have a copy of MSDE running, and it has 2 instances on it, server
> and server\server, is there any way to remove server\server and
> transfer it to server?
> I want to move it as it appears to be interfearing with any setup of
> sql based apps (sharepoint refuses to go past the install stage), and
> the webadmin pages which wont let me login.
> Thanks for the help.
in order to remove the desired instance you should rely on the standard
Windows "remove application" applet...
if you want to manually remove it, you can have a look at
http://support.microsoft.com/default...;EN-US;Q290991 ... this
method does not clear the registry entries related to Windows Installer MSDE
keys...
in order to clear those entries you have to download and use the MSIZap.exe
tool from the Platform SDK as described in
http://support.microsoft.com/default...b;en-us;320873
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea I tried that but when I reinstall SERVER is still blank,
and SERVER\SERVER is still there
|||hi,
donaldsmarshall@.gmail.com wrote:
> Thanks Andrea I tried that but when I reinstall SERVER is still
> blank, and SERVER\SERVER is still there
in the install/remove application applet, I have a "Microsoft SQL Server
Desktop Engine (instancename)" entry, where the defautl instance
(servername) should only appear as "Microsoft SQL Server Desktop Engine" ...
the first one you have to "drop"...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Yeah I have nothing in Add/Remove, I did have some trouble with the
install routine always failing on the last step, so maybe thats why, I
followed the KB article which told me to use the DISABLEROLLBACK=1
command as it was installing just not starting for some reason.
Oh well I can live with it, if I could just get any apps to work
Thanks Anyway

Removing an instance

I have SQL Server 2000 running on my development machine and I have installed
a named instance of MSDE. The named instance shows up in Services and is set
to start automatically. The problem... It does not show up in the Service
Manager or Enterprise Manager. I can access it in the Enterprise Manager by
specifically naming the instance when registering a new Server. I now want to
uninstall it. There is no entry in the Add/Remove program files. Any idea how
to remove the instance. I can't release my product until I resolve this issue.
Jim
hi Jim,
"Jim" <Jim@.discussions.microsoft.com> ha scritto nel messaggio
news:F62FD912-20AF-459B-A53B-28640B533F73@.microsoft.com
> I have SQL Server 2000 running on my development machine and I have
> installed a named instance of MSDE. The named instance shows up in
> Services and is set to start automatically. The problem... It does
> not show up in the Service Manager or Enterprise Manager. I can
> access it in the Enterprise Manager by specifically naming the
> instance when registering a new Server. I now want to uninstall it.
> There is no entry in the Add/Remove program files. Any idea how to
> remove the instance. I can't release my product until I resolve this
> issue.
the named instance probably does not show in the Service Manager becouse of
disabled network protocols (default setting for MSDE installations), as
reported in http://support.microsoft.com/default...b;EN-US;814132
you can manually uninstall the MSDE named instance, if you really wanto to,
following http://support.microsoft.com/default...;EN-US;Q290991 KB
article
hints... I was succesfull when I did a mess on a test PC... the only problem
with this method is that it does not clear the Windows Installer entries in
the registry.. the only way to clear it is using Msizap.exe tool form the
Platform SDK as
http://support.microsoft.com/default...b;en-us;320873 reports..
please remind that, from a public known point of view, it's not mandatory to
remove that instance, but I do not know your actual needs about it...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, it would have taken me a month to figure it out.
"Andrea Montanari" wrote:

> hi Jim,
> "Jim" <Jim@.discussions.microsoft.com> ha scritto nel messaggio
> news:F62FD912-20AF-459B-A53B-28640B533F73@.microsoft.com
> the named instance probably does not show in the Service Manager becouse of
> disabled network protocols (default setting for MSDE installations), as
> reported in http://support.microsoft.com/default...b;EN-US;814132
> you can manually uninstall the MSDE named instance, if you really wanto to,
> following http://support.microsoft.com/default...;EN-US;Q290991 KB
> article
> hints... I was succesfull when I did a mess on a test PC... the only problem
> with this method is that it does not clear the Windows Installer entries in
> the registry.. the only way to clear it is using Msizap.exe tool form the
> Platform SDK as
> http://support.microsoft.com/default...b;en-us;320873 reports..
> please remind that, from a public known point of view, it's not mandatory to
> remove that instance, but I do not know your actual needs about it...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Removing a Server Name

SQL

Upgrading to VS05 Pro SP1/SqlExpress (from VS03 Pro/SQL MSDE)

Question 1) – is there a way to tell which version of the SQL Express was installed?I think it is “SQL Server 2005 Express Edition With Advance Services”, but don’t know how to confirm that.

Question 2) - SQL Server Management Studio Express, Registered Servers, it shows :

Database Engine

\sqlexpress (note the lower case)

If I right click and choose “Previously Registered Servers”, it shows a message that I will be displaying SQL Server 2000 (i.e. MSDE) server names, and it shows

SQL Server Group

\SQLEXPRESS (note the upper case)

\CSOLUTION

I wish to completely remove\CSOLUTION (in MSDE you would uninstall it from the Control Panel), but right clicking and choosing the delete option does nothing (it does not delete it).Deleting SQL Server Group also has no affect either. How do I remove \CSOLUTION ?

Question 3) - In the VS05 program, the SQL connection string includes “Data Source=.\SQLEXPRESS….” (NOTE UPPER CASE)Why do I have a lower case and an upper case listed above?Starting/stopping one sqlexpress/ SQLEXPRESS does the same to the other.Don’t I wan’t to complete delete anything under SQL Server Group since it represents SQL Server 2000 (i.e. MSDE) server names?SQL Server 2000 and \CSOLUTION have been uninstalled from this machine.

Thanks!

bob

hi Bob,

BobInIndy wrote:

SQL

Upgrading to VS05 Pro SP1/SqlExpress (from VS03 Pro/SQL MSDE)

Question 1) – is there a way to tell which version of the SQL Express was installed? I think it is “SQL Server 2005 Express Edition With Advance Services”, but don’t know how to confirm that.

executing

SELECT SERVERPROPERTY('Edition'); --< will return Express Edition with Advanced Services --< where a "standard" SQLExpress instance returns Express Edition

Question 2) - SQL Server Management Studio Express, Registered Servers, it shows :

Database Engine

\sqlexpress (note the lower case)

If I right click and choose “Previously Registered Servers”, it shows a message that I will be displaying SQL Server 2000 (i.e. MSDE) server names, and it shows

SQL Server Group

\SQLEXPRESS (note the upper case)

\CSOLUTION

I wish to completely remove \CSOLUTION (in MSDE you would uninstall it from the Control Panel), but right clicking and choosing the delete option does nothing (it does not delete it). Deleting SQL Server Group also has no affect either. How do I remove \CSOLUTION ?

you usually uninstall an instance accessing the control panel Add/Remove applet...

as last resource you can manually delete it as described in http://support.microsoft.com/kb/290991/en-us

Question 3) - In the VS05 program, the SQL connection string includes “Data Source=.\SQLEXPRESS….” (NOTE UPPER CASE) Why do I have a lower case and an upper case listed above? Starting/stopping one sqlexpress/ SQLEXPRESS does the same to the other. Don’t I wan’t to complete delete anything under SQL Server Group since it represents SQL Server 2000 (i.e. MSDE) server names? SQL Server 2000 and \CSOLUTION have been uninstalled from this machine.

Thanks!

bob

the upper/lower case is not actually a problem...

regards