Prev: Problem with Simple Create Script
Next: sql server 2008 db ownership question
From: mat on 11 Apr 2010 17:17
I am seeing two odd characteristics with a new windows 7 x64 box. The
install and config steps were like so:

[1] Computer OS installed, computer named Comp1.
[2] Install sql server std 2008, developer version, including ssms, as
default instance
[3] Install sql server express 2005, named instance (sqlexpress).
[4] Change computer name to Comp2.

It's possible that the timing of 3 and 4 are reversed in the list above.

The two oddities are that when I browse for sql servers on this box
(browse service is on) I see only two entries:

Comp1\sqlexpress
Comp2\sqlexpress

IE a default instance is not listed.

The other thing that seems off is that when I just attached a db
(created by someone else as a demo db) in the ssms database property
windows it's owner is listed as Comp1\mylogin. But for sure the db was
attached today, well after the computer was renamed to Comp2.

I can log in to the Comp2 default sql server instance if I type the name
in...just that in the browse dialog, it's not shown.

From: Uri Dimant on 12 Apr 2010 00:55
mat
I think you have to run sp_addserver/sp_dropserver just after changing the
com name , please for more details take a look into the BOL



"mat" <mat(a)notarealdotcom.adr> wrote in message
news:MPG.262bdc3cb96fc6d59897c5(a)msnews.microsoft.com...
>I am seeing two odd characteristics with a new windows 7 x64 box. The
> install and config steps were like so:
>
> [1] Computer OS installed, computer named Comp1.
> [2] Install sql server std 2008, developer version, including ssms, as
> default instance
> [3] Install sql server express 2005, named instance (sqlexpress).
> [4] Change computer name to Comp2.
>
> It's possible that the timing of 3 and 4 are reversed in the list above.
>
> The two oddities are that when I browse for sql servers on this box
> (browse service is on) I see only two entries:
>
> Comp1\sqlexpress
> Comp2\sqlexpress
>
> IE a default instance is not listed.
>
> The other thing that seems off is that when I just attached a db
> (created by someone else as a demo db) in the ssms database property
> windows it's owner is listed as Comp1\mylogin. But for sure the db was
> attached today, well after the computer was renamed to Comp2.
>
> I can log in to the Comp2 default sql server instance if I type the name
> in...just that in the browse dialog, it's not shown.
>


From: mat on 12 Apr 2010 20:06
I'm sure that your tip is in the right direction. But I must be making
some mistake. Old pc name was OldPC and new pc name was NewPC

EXEC sp_dropserver 'OLDPC'
GO

EXEC sp_addserver 'NEWPC', 'local'
GO

Then I restarted that sql server; it still does not show when I browse
the local machine for database servers.

In article <#S2Ruwf2KHA.5212(a)TK2MSFTNGP04.phx.gbl>, urid(a)iscar.co.il
says...
>
> mat
> I think you have to run sp_addserver/sp_dropserver just after changing the
> com name , please for more details take a look into the BOL
>
>
>
> "mat" <mat(a)notarealdotcom.adr> wrote in message
> news:MPG.262bdc3cb96fc6d59897c5(a)msnews.microsoft.com...
> >I am seeing two odd characteristics with a new windows 7 x64 box. The
> > install and config steps were like so:
> >
> > [1] Computer OS installed, computer named Comp1.
> > [2] Install sql server std 2008, developer version, including ssms, as
> > default instance
> > [3] Install sql server express 2005, named instance (sqlexpress).
> > [4] Change computer name to Comp2.
> >
> > It's possible that the timing of 3 and 4 are reversed in the list above.
> >
> > The two oddities are that when I browse for sql servers on this box
> > (browse service is on) I see only two entries:
> >
> > Comp1\sqlexpress
> > Comp2\sqlexpress
> >
> > IE a default instance is not listed.
> >
> > The other thing that seems off is that when I just attached a db
> > (created by someone else as a demo db) in the ssms database property
> > windows it's owner is listed as Comp1\mylogin. But for sure the db was
> > attached today, well after the computer was renamed to Comp2.
> >
> > I can log in to the Comp2 default sql server instance if I type the name
> > in...just that in the browse dialog, it's not shown.
> >


From: mat on 12 Apr 2010 20:10
And if I run

SELECT @@SERVERNAME
GO

it returns

NEWPC

as I'd expect. What am I doing wrong?

In article <#S2Ruwf2KHA.5212(a)TK2MSFTNGP04.phx.gbl>, urid(a)iscar.co.il
says...
>
> mat
> I think you have to run sp_addserver/sp_dropserver just after changing the
> com name , please for more details take a look into the BOL
>
>
>
> "mat" <mat(a)notarealdotcom.adr> wrote in message
> news:MPG.262bdc3cb96fc6d59897c5(a)msnews.microsoft.com...
> >I am seeing two odd characteristics with a new windows 7 x64 box. The
> > install and config steps were like so:
> >
> > [1] Computer OS installed, computer named Comp1.
> > [2] Install sql server std 2008, developer version, including ssms, as
> > default instance
> > [3] Install sql server express 2005, named instance (sqlexpress).
> > [4] Change computer name to Comp2.
> >
> > It's possible that the timing of 3 and 4 are reversed in the list above.
> >
> > The two oddities are that when I browse for sql servers on this box
> > (browse service is on) I see only two entries:
> >
> > Comp1\sqlexpress
> > Comp2\sqlexpress
> >
> > IE a default instance is not listed.
> >
> > The other thing that seems off is that when I just attached a db
> > (created by someone else as a demo db) in the ssms database property
> > windows it's owner is listed as Comp1\mylogin. But for sure the db was
> > attached today, well after the computer was renamed to Comp2.
> >
> > I can log in to the Comp2 default sql server instance if I type the name
> > in...just that in the browse dialog, it's not shown.
> >


From: Uri Dimant on 13 Apr 2010 02:36
mat
You added NEWPC server name as local, is that what you wanted?
I am not sure that understood your question



"mat" <mat(a)notarealdotcom.adr> wrote in message
news:MPG.262d56307f5914599897c7(a)msnews.microsoft.com...
> And if I run
>
> SELECT @@SERVERNAME
> GO
>
> it returns
>
> NEWPC
>
> as I'd expect. What am I doing wrong?
>
> In article <#S2Ruwf2KHA.5212(a)TK2MSFTNGP04.phx.gbl>, urid(a)iscar.co.il
> says...
>>
>> mat
>> I think you have to run sp_addserver/sp_dropserver just after changing
>> the
>> com name , please for more details take a look into the BOL
>>
>>
>>
>> "mat" <mat(a)notarealdotcom.adr> wrote in message
>> news:MPG.262bdc3cb96fc6d59897c5(a)msnews.microsoft.com...
>> >I am seeing two odd characteristics with a new windows 7 x64 box. The
>> > install and config steps were like so:
>> >
>> > [1] Computer OS installed, computer named Comp1.
>> > [2] Install sql server std 2008, developer version, including ssms, as
>> > default instance
>> > [3] Install sql server express 2005, named instance (sqlexpress).
>> > [4] Change computer name to Comp2.
>> >
>> > It's possible that the timing of 3 and 4 are reversed in the list
>> > above.
>> >
>> > The two oddities are that when I browse for sql servers on this box
>> > (browse service is on) I see only two entries:
>> >
>> > Comp1\sqlexpress
>> > Comp2\sqlexpress
>> >
>> > IE a default instance is not listed.
>> >
>> > The other thing that seems off is that when I just attached a db
>> > (created by someone else as a demo db) in the ssms database property
>> > windows it's owner is listed as Comp1\mylogin. But for sure the db was
>> > attached today, well after the computer was renamed to Comp2.
>> >
>> > I can log in to the Comp2 default sql server instance if I type the
>> > name
>> > in...just that in the browse dialog, it's not shown.
>> >
>
>


 |  Next  |  Last
Pages: 1 2
Prev: Problem with Simple Create Script
Next: sql server 2008 db ownership question