Re: 2 instances | sql2k default and sql2005 named | alias configuration
The browsing service is running on both the server and the dev's
workstation. What am I missing?
Rick Byham, MS wrote:
> The SQL Server Browser Service resolves the instance names to the ports. Is
> it running on the SQL Server computer? Try starting that service.
> --
> Rick Byham, MS
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Blackgoo" <blackgoo@gmail.com> wrote in message
> news:1161381986.782005.172140@e3g2000cwe.googlegro ups.com...
> > I'm trying to configure an alias for a sql2005 named instance on the
> > server.
> >
> > My server has 2 instances:
> >
> > sql2k default
> > "sql2005" named
> >
> > One ip address: 192.168.0.15
> >
> > I configure an alias in configuratin manager to the following
> >
> > Alias Name: alias n
> > Port no:
> > Protocol: tcp/ip
> > Server: servername\instancename
> >
> > I can connect to the alias from SQL Studio Manager on the server but as
> > soon as one of my devleopers tries to access it via their Manager, it
> > defaults to the sql2k default instance. If I specify
> > servername\instancename it works so something is wrong with the alias
> > config.
> >
> > Does anyone have some thoughts on this?
> >
> > Thanks.
> >
|