Configuring Replication

When I try to configure using enterprise manager, at the last step, This
error message raised..
Error 18483: Could not connect to server 'GKBT' because 'distributor_admin'
is not defined as a remote login at the server
What s the problem?
Thank you
Thank you,
Registration name was '192.168.1.200' (Server IP), after your message, I ve
changed the name to server name 'GKBT', but this time error message is ;
Error 21112 - '-polling interval' is not a valid parameter for the log
readere agent
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:774001c4ce44$fd0de220$a601280a@.phx.gbl...
> If you are using an IP address to configure replication
> over non-trusted domains, you'll need to use the client
> network utility to configure an alias.
> Alternatively this could be a naming issue:
> This is usually a naming issue.
> Try:
> Use Master
> go
> Select @.@.Servername
> This should return your current server name but if it
> returns NULL then try:
> Use Master
> go
> Sp_DropServer 'ServerOldName'
> GO
> Use Master
> go
> Sp_Addserver 'ServerNewName', 'local'
> GO
> Stop and Start SQL Services
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Does replication work to any other server?
If not remove replication and reinstall it.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"BonGee" <Bongeeeee@.dotcom.com> wrote in message
news:OPHl6njzEHA.3416@.TK2MSFTNGP09.phx.gbl...
> When I try to configure using enterprise manager, at the last step, This
> error message raised..
> Error 18483: Could not connect to server 'GKBT' because
> 'distributor_admin'
> is not defined as a remote login at the server
> What s the problem?
> Thank you
>
|||PollingInterval is all one word, but don't change it on
the command line properties - leave those for parameters
that aren't included in the profile ie you can just put a
numerical value in a custom profile.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you but I installed MS 2000 2 hours before
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eirUXekzEHA.1296@.TK2MSFTNGP10.phx.gbl...
> Does replication work to any other server?
> If not remove replication and reinstall it.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
> "BonGee" <Bongeeeee@.dotcom.com> wrote in message
> news:OPHl6njzEHA.3416@.TK2MSFTNGP09.phx.gbl...
>
|||By installing/removing replication, I mean going to the menu option in SQL
Server Enterprise Manager and selecting Tools, Replication, Disable
Replication to remove it, and then select Tools, Replication, Configure
Replicaiton to reinstall it.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"BonGee" <Bongeeeee@.dotcom.com> wrote in message
news:OKVrOikzEHA.1396@.tk2msftngp13.phx.gbl...
> Thank you but I installed MS 2000 2 hours before
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eirUXekzEHA.1296@.TK2MSFTNGP10.phx.gbl...
>

configure sql server details

Hi everybody,

I'm installing a network monitoring tool (OpManager). During
installation I reached the following step: Configure the SQL Server
details.

Host Name: ?
Port: 1433
Database Name: xxx
User Name: ?
Password: ?

I don't know which host name I need to put in and also I don't know
which user name and password is required.

Please can anyone help me with this.

Thank you!(pearl146@.hotmail.com) writes:

Quote:

Originally Posted by

I'm installing a network monitoring tool (OpManager). During
installation I reached the following step: Configure the SQL Server
details.
>
Host Name: ?
Port: 1433
Database Name: xxx
User Name: ?
Password: ?
>
I don't know which host name I need to put in and also I don't know
which user name and password is required.
>
Please can anyone help me with this.

Since all this is information that is local to your site we cannot really
help you. But we can give some hints:

The host name is usually the machine which SQL Server is running on. If
you have SQL Server on a cluster, it's likely to be the virtual cluster
name. SQL Server can be installed with named instances, in case which
the server is accessed on the form "MACHINE\INSTANCE". I have no idea
what OpManager wants in this case, but since they ask for port number,
I would guess that they stll only want the machine name, and you would
have to use a different port number.

Username and password. By default, SQL Server is installed with
Windows Authentication. This means that when you log into SQL Server,
SQL Server gets your authentication information from Windows, and you
don't supply any user name or password at all. SQL Server can also be
configured for mixed authentication, so that SQL logins are accepted
as well. SQL Logins are username/password pairs.

What username you should specify in this case, I don't know. Probably
you need to create a login and give that the permissions needed by
OpManager. But if your server is not configured for mixed authentication,
there is all reason if you want to activate to run a certain application.
I would expect the app to work with Windows Authentication as well.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx