"Gene" <Gene@discussions.microsoft.com> wrote in message
news:85740AA2-9F4B-4CF8-B304-E27782458703@microsoft.com...
> Hi!
>
> I know that the default instance of MSDE is the computer name. If the
> computer's name is subsequently changed, will the default instance's name
> change to the new computer name as well.
>
> Thanks for your thoughts.

"Roger Wolter[MSFT]" wrote:

> Actually the default instance name is not the computer name. All instances
> are addressed in connections strings as <computer name>\<instance name>. If
> you leave off the instance name then SQL Server assumes you are talking
> about the default instance. So yes, if you change the computer name, all
> your connection strings will break, probably including some that you aren't
> aware of so changing the computer name is a risky thing to do. At a minimum
> you will nee to use sp_addserver and restart MSDE to change SQL Server's
> local server name.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "Gene" <Gene@discussions.microsoft.com> wrote in message
> news:85740AA2-9F4B-4CF8-B304-E27782458703@microsoft.com...
> > Hi!
> >
> > I know that the default instance of MSDE is the computer name. If the
> > computer's name is subsequently changed, will the default instance's name
> > change to the new computer name as well.
> >
> > Thanks for your thoughts.
>
>