Enterprise Manager Can Not Connect to a Named Instance

I installed a new named instance of sql server on a machine called faoweb2k04. There are three instances on this machine: default, afosrio, & afosrio2 (which I can not connect to).
Any suggestions? aforio2 does not show up in the enterprise manager when I select the option [New SQL Server Registration...]
Interesting...
Are the services associated with those other instances running?
Rick Sawtell
MCT, MCSD, MCDBA
|||"sjsnraets" wrote:

> I installed a new named instance of sql server on a machine called faoweb2k04. There are three instances on this machine: default, afosrio, & afosrio2 (which I can not connect to).
> Any suggestions? aforio2 does not show up in the enterprise manager when I select the option [New SQL Server Registration...]
Start the New SQL Server Registration wizard
Type server name inmediatelly to available servers field (server name\aforio2) and click on add button. Click next ...
If server instance is running, the registration will be completed. (not need visible in list)
Andras Jakus
MCDBA

Enterprise Manager Can Not Connect to a Named Instance

I installed a new named instance of sql server on a machine called faoweb2k0
4. There are three instances on this machine: default, afosrio, & afosrio2
(which I can not connect to).
Any suggestions? aforio2 does not show up in the enterprise manager when I
select the option [New SQL Server Registration...]Interesting...
Are the services associated with those other instances running?
Rick Sawtell
MCT, MCSD, MCDBA|||"sjsnraets" wrote:

> I installed a new named instance of sql server on a machine called faoweb2
k04. There are three instances on this machine: default, afosrio, & afosrio
2 (which I can not connect to).
> Any suggestions? aforio2 does not show up in the enterprise manager when I select
the option [New SQL Server Registration...]
Start the New SQL Server Registration wizard
Type server name inmediatelly to available servers field (server name\aforio
2) and click on add button. Click next ...
If server instance is running, the registration will be completed. (not need
visible in list)
Andras Jakus
MCDBA

Enterprise Manager Can Not Connect to a Named Instance

I installed a new named instance of sql server on a machine called faoweb2k04. There are three instances on this machine: default, afosrio, & afosrio2 (which I can not connect to).
Any suggestions? aforio2 does not show up in the enterprise manager when I select the option [New SQL Server Registration...]Interesting...
Are the services associated with those other instances running?
Rick Sawtell
MCT, MCSD, MCDBA

Enterprise Manager and named instances

Hi, How to connect via internet to MSDE 2000 named instance using Enterprise
Manager?
On remote server (2K Server) there are installed MSDE 2000 default instance
and named instance. Named instance is using port 3077.
Adam,
in the Client Network utility define an alias which points to your
named instance and define the port number.
M

Enterprise Manager - Available Servers - remote instance not listed

When using the register available servers in Enterprise Manager, the
named instances on a remote machine are not listed. The unnamed
instance is listed and will register successfully.
I have tried manually typing the names of the remote NAMED instances;
then tried to authenticate and get the message "SQL server does not
exist or access denied".
Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
2 Instances
Unnamed
DEV\DB1
On the remote machine SQL Server 2000 (MSDE Edition) installed
3 Instances;
Unnamed
REM\DB1
REM\DB2
Both machines are on the same domain. All SQL server instances are
running.
I have also used the svrnetcn.exe tool to make sure the Named Pipes
and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
been changed to 1433 on all remote instances. (both machines were
rebooted)
What else can I check ?
Thanks
DOn Sep 18, 9:18 pm, do <dmc...@.gmail.com> wrote:
> When using the register available servers in Enterprise Manager, the
> named instances on a remote machine are not listed. The unnamed
> instance is listed and will register successfully.
> I have tried manually typing the names of the remote NAMED instances;
> then tried to authenticate and get the message "SQL server does not
> exist or access denied".
> Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
> 2 Instances
> Unnamed
> DEV\DB1
> On the remote machine SQL Server 2000 (MSDE Edition) installed
> 3 Instances;
> Unnamed
> REM\DB1
> REM\DB2
Create an alias for the named instances on the client end & then try
registering...
> Both machines are on the same domain. All SQL server instances are
> running.
> I have also used the svrnetcn.exe tool to make sure the Named Pipes
> and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
> been changed to 1433 on all remote instances. (both machines were
> rebooted)
> What else can I check ?
> Thanks
> D

Enterprise Manager - Available Servers - remote instance not listed

When using the register available servers in Enterprise Manager, the
named instances on a remote machine are not listed. The unnamed
instance is listed and will register successfully.
I have tried manually typing the names of the remote NAMED instances;
then tried to authenticate and get the message "SQL server does not
exist or access denied".
Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
2 Instances
Unnamed
DEV\DB1
On the remote machine SQL Server 2000 (MSDE Edition) installed
3 Instances;
Unnamed
REM\DB1
REM\DB2
Both machines are on the same domain. All SQL server instances are
running.
I have also used the svrnetcn.exe tool to make sure the Named Pipes
and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
been changed to 1433 on all remote instances. (both machines were
rebooted)
What else can I check ?
Thanks
DHow about trying adding aliases from SQL Server Client Network Utility?
Add Aliases for your named instances and try connecting then.
You may obtain more info about this from the following link:
http://msdn2.microsoft.com/en-us/library/aa213780(SQL.80).aspx
You may want to have a look at the following article from BOL to learn more
about Browser Service of SQL Server 2005. This may be irrelevant however it
informs you about SS2000' s listening service too. It may give you an idea.
http://msdn2.microsoft.com/en-us/library/ms181087.aspx
--
Ekrem Önsoy
"do" <dmcb73@.gmail.com> wrote in message
news:1190189984.640820.24640@.o80g2000hse.googlegroups.com...
> When using the register available servers in Enterprise Manager, the
> named instances on a remote machine are not listed. The unnamed
> instance is listed and will register successfully.
> I have tried manually typing the names of the remote NAMED instances;
> then tried to authenticate and get the message "SQL server does not
> exist or access denied".
> Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
> 2 Instances
> Unnamed
> DEV\DB1
> On the remote machine SQL Server 2000 (MSDE Edition) installed
> 3 Instances;
> Unnamed
> REM\DB1
> REM\DB2
> Both machines are on the same domain. All SQL server instances are
> running.
> I have also used the svrnetcn.exe tool to make sure the Named Pipes
> and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
> been changed to 1433 on all remote instances. (both machines were
> rebooted)
> What else can I check ?
> Thanks
> D
>