two NICs, SQL2000 and SQL2005 on the same machine
At the moment, we have SQL2000 Standard Edition running as the only
instance (it is a named instance) on the server, with one of the two
NICs disabled. If we enable the second NIC, and then create a SQL2005
named instance, will both named instances listen on both NICs by
default, and will the SQL2005 instance automatically select a port to
listen on that does not conflict with SQL2000? The NICs would be
independent, not "teamed".
Thanks
JD
.
Relevant Pages
- Re: SSAS with an Instance name
... The SQL 2005 server is a named instance. ... Try out the MSDN Forums for Analysis Services at: ... Please do not send email directly to this alias. ...
(microsoft.public.data.xmlanalysis) - Re: SQL2005 AS Named instance - SQL Browser issue?
... You can log in to the beta newsgroups using the credentials at ... >> The questioner ended up posting a bug in Product Feedback Center: ... >>>I have installed the September CTP of SQL 2005 as a named instance ... >>>Ensure that the SQLBrowser service is running on the 'SERVERNAME2' server. ...
(microsoft.public.sqlserver.setup) - Re: SSMS cant connect across LAN
... You could check on server to make sure TCPIP is enabled via SQL Server ... Is the server a default instance or a named instance? ... TCP 1433 port for default instance on server. ... Microsoft Online Community Support ...
(microsoft.public.sqlserver.tools) - Re: SSAS with an Instance name
... I would also highly recommend moving the server to SP1 -- there were several ... Try out the MSDN Forums for Analysis Services at: ... Please do not send email directly to this alias. ... We are able to connect to the named instance from Excel without passing ...
(microsoft.public.data.xmlanalysis) - Cant connect to named instance across subnets
... I have a default instance and a named instance of SQL ... Server 2000 on the same PC running NT server. ... the "Test Connection" button is able to connect ...
(microsoft.public.sqlserver.security) |
|
