Prev: Problem with Simple Create Script
Next: sql server 2008 db ownership question
From: Tibor Karaszi on 13 Apr 2010 06:33
> Then I restarted that sql server; it still does not show when I browse
> the local machine for database servers.

>>not show when I browse
> the local machine for database servers.

Browsing will remember what you had there previously. Also, it doesn't
necessarily see active servers. I never use the browser for exactly those
reasons: type the name you know it has (and it will remember that name in
the future).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"mat" <mat(a)notarealdotcom.adr> wrote in message
news:MPG.262d557a7ffca8f09897c6(a)msnews.microsoft.com...
> 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 18 Apr 2010 17:30
Well, for some odd reason I thought the browse button would do what
every other browse button like that I've seen does: open a dialog and
show the servers it discovers. Since the server's browse service is on,
I figured the active servers would be offered, especially since it's
local to SSMS (same box).

I don't exactly see what good offering 'browse' is, if all it can show
is names I've typed in manually? Anyways it does better than that, it
finds some other server on the network tab, but it does not show the
most obvious server, the one running on the same box. That to me is a
strange behavior.

In article <#apkDOt2KHA.4336(a)TK2MSFTNGP04.phx.gbl>, urid(a)iscar.co.il
says...
>
> 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
> >> >


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