LogShipping Between Named Instances

Have never done this yet and can't see anything in BOL or other docs which
would indicate that I can't or should not do this.
Does anyone have any feedback on this if they have performed this in the past?
Any problems?
thks
tom,
I have not encountered any problems with SQL Server 2000. I take it you
are shipping between SQL 2000 instances and not mixing with SQL7?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
tom frost wrote:
> Have never done this yet and can't see anything in BOL or other docs which
> would indicate that I can't or should not do this.
> Does anyone have any feedback on this if they have performed this in the past?
> Any problems?
> thks
|||thats correct..it would be between 2 sql2000 named instances..both at svc
pack 3a..
using win2000 adv srvr with latest svc pack..
thks
"Mark Allison" wrote:

> tom,
> I have not encountered any problems with SQL Server 2000. I take it you
> are shipping between SQL 2000 instances and not mixing with SQL7?
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> tom frost wrote:
>
|||Exactly what I'm using! No probs at all, except I'm on two active/active
clusters.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
tom frost wrote:[vbcol=seagreen]
> thats correct..it would be between 2 sql2000 named instances..both at svc
> pack 3a..
> using win2000 adv srvr with latest svc pack..
> thks
> "Mark Allison" wrote:
>

Logon failure in sql server 2000

Hi every one
I have got a problem with my Ms SQL Server: I have defined a server and
in the server i am running a rainbow portal, however i cant get my
rainbow working because it says that SQL does not exist or access
denied. I checked me services for sql and it gives a message saying
the following "Could not start the MSSQL... Service on Local
Computer... Error 1069: The service did not start due to logon
failure." Aparently i am logged in as the administrator in the server,
so i don=B4t understand why this is happening. If anyone can give some
inputs on that i will highly appreciate.
Thanks in advance for any help
ErnestoEmesto,
What account MSSQL service run on the machine? You can check it from
the Services control panel. If it is not run as 'local system', which
is by default, then make sure that account is a member of local
administrator.
Mel|||In Services go to property of that server , go to logon tab and apply
new password for that account.
Make sure that account is not locked.
Make sure that account is member of administrator group
Regards
Amish Shah

Logon failure in sql server 2000

Hi every one
I have got a problem with my Ms SQL Server: I have defined a server and
in the server i am running a rainbow portal, however i cant get my
rainbow working because it says that SQL does not exist or access
denied. I checked me services for sql and it gives a message saying
the following "Could not start the MSSQL... Service on Local
Computer... Error 1069: The service did not start due to logon
failure." Aparently i am logged in as the administrator in the server,
so i don=B4t understand why this is happening. If anyone can give some
inputs on that i will highly appreciate.
Thanks in advance for any help
ErnestoEmesto,
What account MSSQL service run on the machine? You can check it from
the Services control panel. If it is not run as 'local system', which
is by default, then make sure that account is a member of local
administrator.
Mel|||In Services go to property of that server , go to logon tab and apply
new password for that account.
Make sure that account is not locked.
Make sure that account is member of administrator group
Regards
Amish Shah