Does anyone know if SQL 2000 Replication uses NetBios or Instance Name when
setting up a new replication partner? The reason I'm asking is because we've
got a server with a hostname of 16 characters long. The instance name is the
same as the hostname, which is also 16 characters long. When trying to setup
a replication, it fails unless we change the server name (and the instance
name) to 15 characters long. I thought SQL is using the Instance name, not
the Netbios name for replication? It seems that Netbios name is being used...
This is a very complex question. It uses the name that it was registered
with in Enterprise Manager. This should be the NetBIOS name of the machine +
the instance name. When it is mapping a drive or connecting to the FTP
server it uses the NetBIOS name, unless you specified your ftp server was a
FQDN.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Monica" <Monica@.discussions.microsoft.com> wrote in message
news:60FAC952-AB91-4EBB-AF70-10F904A50087@.microsoft.com...
> Does anyone know if SQL 2000 Replication uses NetBios or Instance Name
> when
> setting up a new replication partner? The reason I'm asking is because
> we've
> got a server with a hostname of 16 characters long. The instance name is
> the
> same as the hostname, which is also 16 characters long. When trying to
> setup
> a replication, it fails unless we change the server name (and the instance
> name) to 15 characters long. I thought SQL is using the Instance name, not
> the Netbios name for replication? It seems that Netbios name is being
> used...
|||Hi Hilary,
Here's what we tried and it seems to fix the problem:
1. Re-register the 16 character long SQL server in the EM
2. Change the authentication to SQL/Windows. It was set to "Windows only".
3. Drop all the existing replication partners (those were setup with the
15-character SQL registration).
4. Re-created the replication partners.
Everything seems to work fine.
Do you know if SQL replication uses RPC remote connect to the "subscriber"?
(I can't find it being documented so far.) If so, then it makes sense.
Monica
"Hilary Cotter" wrote:
> This is a very complex question. It uses the name that it was registered
> with in Enterprise Manager. This should be the NetBIOS name of the machine +
> the instance name. When it is mapping a drive or connecting to the FTP
> server it uses the NetBIOS name, unless you specified your ftp server was a
> FQDN.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Monica" <Monica@.discussions.microsoft.com> wrote in message
> news:60FAC952-AB91-4EBB-AF70-10F904A50087@.microsoft.com...
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment