Logshipping Help Needed

I am setting up log shipping between a primary server and two secondaries.

The first (secondary ) is applying the logs fine but the second is generating the following error.

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3154: [Microsoft][ODBC SQL Server Driver][SQL Server]The backup set holds a backup of a database other than the existing 'CDE2' database.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.

the logshipping monitor says it failes to apply first_file_0000000000...Trn

I have seen this listed on MS KB Base Article - 311801 .

and have followed all the suggestions to resolve this issue including seperate folders for each log ship but to no avail.

Any help would be greatly appreciated.

Thanks in advanceDIsable the LS and apply full backup on secondary server, then enable LS again.sql

LogShip between SQL 2K and SQL 2005

It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
SQL 2005 is not possible. If any one one knows please confirm this.
Thanks,
Moh
You will get better help in the SQL Server 2005 newsgroups. Please post
your questions there:
http://www.aspfaq.com/sql2005/show.asp?id=1
On 3/23/05 7:44 PM, in article udPCjqAMFHA.3336@.TK2MSFTNGP10.phx.gbl, "Moh
Abb" <mabbas@.aligntech.com> wrote:

> It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
> SQL 2005 is not possible. If any one one knows please confirm this.
> Thanks,
> Moh
>

LogShip between SQL 2K and SQL 2005

It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
SQL 2005 is not possible. If any one one knows please confirm this.
Thanks,
MohYou will get better help in the SQL Server 2005 newsgroups. Please post
your questions there:
http://www.aspfaq.com/sql2005/show.asp?id=1
On 3/23/05 7:44 PM, in article udPCjqAMFHA.3336@.TK2MSFTNGP10.phx.gbl, "Moh
Abb" <mabbas@.aligntech.com> wrote:
> It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
> SQL 2005 is not possible. If any one one knows please confirm this.
> Thanks,
> Moh
>

LogShip between SQL 2K and SQL 2005

It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
SQL 2005 is not possible. If any one one knows please confirm this.
Thanks,
MohYou will get better help in the SQL Server 2005 newsgroups. Please post
your questions there:
http://www.aspfaq.com/sql2005/show.asp?id=1
On 3/23/05 7:44 PM, in article udPCjqAMFHA.3336@.TK2MSFTNGP10.phx.gbl, "Moh
Abb" <mabbas@.aligntech.com> wrote:

> It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
> SQL 2005 is not possible. If any one one knows please confirm this.
> Thanks,
> Moh
>

Logreader access violation

Hi everyone,
I am setting up Transaction Replication on a MSSQL 2000 8.0.194. Everything
was going fine until the log reader stopped with a "An access violation
occurred" error.
I tried setting up a publication on another test database on the same server
to make sure the problem was not with the database it self and encountered
the same error.
In the ReplExceptLogRdr.log I am getting the following error:
Microsoft SQL Server Replication: Exception Stack Dump
************************************************** *****
Computer type is AT/AT COMPATIBLE.
Bios Version is DELL - 1
Phoenix ROM BIOS PLUS Version 1.10 A10Current local time is Fri Apr 13
15:16:41 2007
4 Intel x86 level 15, 2392 Mhz processor(s).
Windows NT 5.2 Build 3790 CSD .
MemoryLoad 62%TotalPhys 2047 MB
AvailPhys 1481 MBTotalPageFile 4095 MB
************************************************** *****
An exception was caught
in LOGREAD.EXE
* Exception Address = 00000001
* Exception Code = c0000005
*
************************************************** *****
Module NameReturn AddressLocation
[No Module Info]003678f000000001
[No Module Info]0040abd5003678f0
logread0040dec90040abd5
logread0040aa5c0040dec9
logread77e4f38c0040aa5c
kernel3200000000TerminateThread + 113
I have tested setting up replication using the same database on the users
reporting server and everything went fine. I have tried giving the folder
that contains the Distributor database and logfile access to "Everyone".
The Event Viewer show the following error and information:
[SQLSERVERAgent Error]
Microsoft SQL Server Replication : The LOGREAD.EXE executable is terminating
abnormally because it hit an exception. Exception Code c0000005. Check file
ReplExceptLogRdr.log for details.
[Information]
SubSystem Message - Job 'CL-SQL-CLUAT-1'
(0x7A865965F727AB4CA60CC19D5A5EEEA8), step 2 - An access violation occurred.
I tried changing the Logreaders agents verbose level to 3, but nothing extra
appeared in the sqlserver log.
Before I set up replication I had to change the logon the sqlserver agent
was running from the system account to a windows user with Admin rights. The
user also has sql server admin rights.
I am kind of stuck now as I don't know what else I can do to further
investigate the problem.
Any help would really be appreciated.
Thanks,
SQLNewbie
Hi Hillary,
Thanks for your time on this. I did post the contents of the
ReplExceptLogRdr.log in me initial post. It was located in the C:\Program
Files\Microsoft SQL Server\MSSQL\LOG folder. Is this the same log you are
referring to? I am not sure what you mean by (IIRC).
I wasn't sure if this was a bug so I haven't applied any patches.
Is this a user rights problem? That is the user running the SQL Server agent
has insufficient rights, because the user I created has Admin rights for
Windows and System Admin rights for SQL Server.
Thanks,
SQLNEwbie
"Hilary Cotter" wrote:

> I get these from time to time. Did you check ReplExceptLogRdr.log IIRC it
> will be found in windows\system32
> Also does this apply?
> http://support.microsoft.com/kb/872843/EN-US/
> --
> 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
>
> "sqlnewbie" <sqlnewbie@.discussions.microsoft.com> wrote in message
> news:C5CCC218-2858-42BD-97BE-6C0B3AB1054E@.microsoft.com...
>
>
|||Hi,
Just a quick update on this problem. I applied SP4 and that has resolved the
problem.
Thanks
"sqlnewbie" wrote:
[vbcol=seagreen]
> Hi Hillary,
> Thanks for your time on this. I did post the contents of the
> ReplExceptLogRdr.log in me initial post. It was located in the C:\Program
> Files\Microsoft SQL Server\MSSQL\LOG folder. Is this the same log you are
> referring to? I am not sure what you mean by (IIRC).
> I wasn't sure if this was a bug so I haven't applied any patches.
> Is this a user rights problem? That is the user running the SQL Server agent
> has insufficient rights, because the user I created has Admin rights for
> Windows and System Admin rights for SQL Server.
> Thanks,
> SQLNEwbie
> "Hilary Cotter" wrote:

loging in to sql express

I am trying to login into sql express using studio express and keep getting this msg.

"Cannot connect

....... under the default setting SQL Server does not allow remote connections. (provider: Named Popes Provider, error: 40 - could not open a connection to sql server) (sql server error2)"

I did try and make a change under surface area configuration to include local and remote connections but it did not help. Any thoughts? Thanks!

David

Are you using the SQL Server Browser service ? If not it could that that you might not use the default port of 1433. If so, type in the port number after the InstanceName using the syntax Servername\InstanceName,PortNumber which should be in your case something more specific Servername\SQLExpress,PortNumber

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Jens, thanks. You gave me the idea to start using the browser service and I logged in that way.

Login setting by IP range?

Hello,
In MySQL we can set to allow a user to login and access certain
table from certain host, is there anything close to that in MSSQL 2000/2005?
Actually, we just need to control certain users unable to use the
Domain Creditial to access certain databases/tables except in the company's
IP, while we need to make sure for certain databases/tables, the client can
be accessed anywhere.
If not, is there any kind of database connection proxies that we can
use to control the connections, or this there any tutorial on how to relay
database datas so we can write a program to do access check?
Looking forward for reply.
Regards,
Lau Lei Cheong
Lau
How do they (users) access the database? Did you divide them into Groups?
You can DENY access on table for the user .
In addition , you can specify a hostname in connection string.
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:uXz12iGMGHA.3856@.TK2MSFTNGP12.phx.gbl...
> Hello,
> In MySQL we can set to allow a user to login and access certain
> table from certain host, is there anything close to that in MSSQL
> 2000/2005?
> Actually, we just need to control certain users unable to use the
> Domain Creditial to access certain databases/tables except in the
> company's IP, while we need to make sure for certain databases/tables, the
> client can be accessed anywhere.
> If not, is there any kind of database connection proxies that we
> can use to control the connections, or this there any tutorial on how to
> relay database datas so we can write a program to do access check?
> Looking forward for reply.
> Regards,
> Lau Lei Cheong
>
|||Yes, I know I can divide users into groups but that's not the problem.
The problem is, as the subject line suggested, I can't find way to limit
certain user's access to certain database/table from certain IP.
"Uri Dimant" <urid@.iscar.co.il> glsD:%23aeJm7GMGHA.500@.TK2MSFTNGP15.phx. gbl...
> Lau
> How do they (users) access the database? Did you divide them into Groups?
> You can DENY access on table for the user .
> In addition , you can specify a hostname in connection string.
>
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:uXz12iGMGHA.3856@.TK2MSFTNGP12.phx.gbl...
>
|||Well, have a look at APPLICATION ROLE in the BOL
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:O2MjaNHMGHA.3960@.TK2MSFTNGP09.phx.gbl...
> Yes, I know I can divide users into groups but that's not the problem.
> The problem is, as the subject line suggested, I can't find way to limit
> certain user's access to certain database/table from certain IP.
> "Uri Dimant" <urid@.iscar.co.il>
> glsD:%23aeJm7GMGHA.500@.TK2MSFTNGP15.phx. gbl...
>
|||Sorry, I've reviewed application role, but it don't help in this case
because:
1) I need to control access by IP, not by application
2) Some users under the control are application developers who can write
their own application.
But your information is really useful on other area, thanks.
"Uri Dimant" <urid@.iscar.co.il> glsD:%23TPXYYHMGHA.2696@.TK2MSFTNGP14.phx .gbl...
> Well, have a look at APPLICATION ROLE in the BOL
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:O2MjaNHMGHA.3960@.TK2MSFTNGP09.phx.gbl...
>

Login setting by IP range?

Hello,
In mysql we can set to allow a user to login and access certain
table from certain host, is there anything close to that in MSSQL 2000/2005?
Actually, we just need to control certain users unable to use the
Domain Creditial to access certain databases/tables except in the company's
IP, while we need to make sure for certain databases/tables, the client can
be accessed anywhere.
If not, is there any kind of database connection proxies that we can
use to control the connections, or this there any tutorial on how to relay
database datas so we can write a program to do access check?
Looking forward for reply.
Regards,
Lau Lei CheongLau
How do they (users) access the database? Did you divide them into Groups?
You can DENY access on table for the user .
In addition , you can specify a hostname in connection string.
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:uXz12iGMGHA.3856@.TK2MSFTNGP12.phx.gbl...
> Hello,
> In mysql we can set to allow a user to login and access certain
> table from certain host, is there anything close to that in MSSQL
> 2000/2005?
> Actually, we just need to control certain users unable to use the
> Domain Creditial to access certain databases/tables except in the
> company's IP, while we need to make sure for certain databases/tables, the
> client can be accessed anywhere.
> If not, is there any kind of database connection proxies that we
> can use to control the connections, or this there any tutorial on how to
> relay database datas so we can write a program to do access check?
> Looking forward for reply.
> Regards,
> Lau Lei Cheong
>|||Yes, I know I can divide users into groups but that's not the problem.
The problem is, as the subject line suggested, I can't find way to limit
certain user's access to certain database/table from certain IP.
"Uri Dimant" <urid@.iscar.co.il> glsD:%23aeJm7GMGHA.500@.TK2MSFTNGP15.phx.gbl...[vbc
ol=seagreen]
> Lau
> How do they (users) access the database? Did you divide them into Groups?
> You can DENY access on table for the user .
> In addition , you can specify a hostname in connection string.
>
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:uXz12iGMGHA.3856@.TK2MSFTNGP12.phx.gbl...
>[/vbcol]|||Well, have a look at APPLICATION ROLE in the BOL
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:O2MjaNHMGHA.3960@.TK2MSFTNGP09.phx.gbl...
> Yes, I know I can divide users into groups but that's not the problem.
> The problem is, as the subject line suggested, I can't find way to limit
> certain user's access to certain database/table from certain IP.
> "Uri Dimant" <urid@.iscar.co.il>
> glsD:%23aeJm7GMGHA.500@.TK2MSFTNGP15.phx.gbl...
>|||Sorry, I've reviewed application role, but it don't help in this case
because:
1) I need to control access by IP, not by application
2) Some users under the control are application developers who can write
their own application.
But your information is really useful on other area, thanks.
"Uri Dimant" <urid@.iscar.co.il> glsD:%23TPXYYHMGHA.2696@.TK2MSFTNGP14.phx.gbl...[vb
col=seagreen]
> Well, have a look at APPLICATION ROLE in the BOL
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:O2MjaNHMGHA.3960@.TK2MSFTNGP09.phx.gbl...
>[/vbcol]

Login setting by IP range?

Hello,
In MySQL we can set to allow a user to login and access certain
table from certain host, is there anything close to that in MSSQL 2000/2005?
Actually, we just need to control certain users unable to use the
Domain Creditial to access certain databases/tables except in the company's
IP, while we need to make sure for certain databases/tables, the client can
be accessed anywhere.
If not, is there any kind of database connection proxies that we can
use to control the connections, or this there any tutorial on how to relay
database datas so we can write a program to do access check?
Looking forward for reply.
Regards,
Lau Lei CheongLau
How do they (users) access the database? Did you divide them into Groups?
You can DENY access on table for the user .
In addition , you can specify a hostname in connection string.
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:uXz12iGMGHA.3856@.TK2MSFTNGP12.phx.gbl...
> Hello,
> In MySQL we can set to allow a user to login and access certain
> table from certain host, is there anything close to that in MSSQL
> 2000/2005?
> Actually, we just need to control certain users unable to use the
> Domain Creditial to access certain databases/tables except in the
> company's IP, while we need to make sure for certain databases/tables, the
> client can be accessed anywhere.
> If not, is there any kind of database connection proxies that we
> can use to control the connections, or this there any tutorial on how to
> relay database datas so we can write a program to do access check?
> Looking forward for reply.
> Regards,
> Lau Lei Cheong
>|||Yes, I know I can divide users into groups but that's not the problem.
The problem is, as the subject line suggested, I can't find way to limit
certain user's access to certain database/table from certain IP.
"Uri Dimant" <urid@.iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D:%23aeJm7GMGHA.500@.TK2MSFTNGP15.phx.gbl...
> Lau
> How do they (users) access the database? Did you divide them into Groups?
> You can DENY access on table for the user .
> In addition , you can specify a hostname in connection string.
>
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:uXz12iGMGHA.3856@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> In MySQL we can set to allow a user to login and access certain
>> table from certain host, is there anything close to that in MSSQL
>> 2000/2005?
>> Actually, we just need to control certain users unable to use the
>> Domain Creditial to access certain databases/tables except in the
>> company's IP, while we need to make sure for certain databases/tables,
>> the client can be accessed anywhere.
>> If not, is there any kind of database connection proxies that we
>> can use to control the connections, or this there any tutorial on how to
>> relay database datas so we can write a program to do access check?
>> Looking forward for reply.
>> Regards,
>> Lau Lei Cheong
>>
>|||Well, have a look at APPLICATION ROLE in the BOL
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:O2MjaNHMGHA.3960@.TK2MSFTNGP09.phx.gbl...
> Yes, I know I can divide users into groups but that's not the problem.
> The problem is, as the subject line suggested, I can't find way to limit
> certain user's access to certain database/table from certain IP.
> "Uri Dimant" <urid@.iscar.co.il>
> ¼¶¼g©ó¶l¥ó·s»D:%23aeJm7GMGHA.500@.TK2MSFTNGP15.phx.gbl...
>> Lau
>> How do they (users) access the database? Did you divide them into Groups?
>> You can DENY access on table for the user .
>> In addition , you can specify a hostname in connection string.
>>
>> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
>> news:uXz12iGMGHA.3856@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> In MySQL we can set to allow a user to login and access certain
>> table from certain host, is there anything close to that in MSSQL
>> 2000/2005?
>> Actually, we just need to control certain users unable to use the
>> Domain Creditial to access certain databases/tables except in the
>> company's IP, while we need to make sure for certain databases/tables,
>> the client can be accessed anywhere.
>> If not, is there any kind of database connection proxies that we
>> can use to control the connections, or this there any tutorial on how to
>> relay database datas so we can write a program to do access check?
>> Looking forward for reply.
>> Regards,
>> Lau Lei Cheong
>>
>>
>|||Sorry, I've reviewed application role, but it don't help in this case
because:
1) I need to control access by IP, not by application
2) Some users under the control are application developers who can write
their own application.
But your information is really useful on other area, thanks. :)
"Uri Dimant" <urid@.iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D:%23TPXYYHMGHA.2696@.TK2MSFTNGP14.phx.gbl...
> Well, have a look at APPLICATION ROLE in the BOL
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:O2MjaNHMGHA.3960@.TK2MSFTNGP09.phx.gbl...
>> Yes, I know I can divide users into groups but that's not the problem.
>> The problem is, as the subject line suggested, I can't find way to limit
>> certain user's access to certain database/table from certain IP.
>> "Uri Dimant" <urid@.iscar.co.il> ¼¶¼g©ó¶l¥ó·s»D:%23aeJm7GMGHA.500@.TK2MSFTNGP15.phx.gbl...
>> Lau
>> How do they (users) access the database? Did you divide them into
>> Groups?
>> You can DENY access on table for the user .
>> In addition , you can specify a hostname in connection string.
>>
>> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
>> news:uXz12iGMGHA.3856@.TK2MSFTNGP12.phx.gbl...
>> Hello,
>> In MySQL we can set to allow a user to login and access certain
>> table from certain host, is there anything close to that in MSSQL
>> 2000/2005?
>> Actually, we just need to control certain users unable to use
>> the Domain Creditial to access certain databases/tables except in the
>> company's IP, while we need to make sure for certain databases/tables,
>> the client can be accessed anywhere.
>> If not, is there any kind of database connection proxies that we
>> can use to control the connections, or this there any tutorial on how
>> to relay database datas so we can write a program to do access check?
>> Looking forward for reply.
>> Regards,
>> Lau Lei Cheong
>>
>>
>>
>

Login Related Question

When setting 2 servers to replicate (in the case of Push Subsription) at
what point one computer will log on to the other?
I am having some login related problems and I would like to understand the
tehnicality of that aspect
Thank you,
Samuel
Samuel,
in standard transactional replication, when the distribution agent runs,
it'll have to read commands from the distribution database and execute procs
at the subscriber.
For merge, it'll also be on synchronization/running of the merge agent.
For transactional with queued updating subscribers, the queue reader's
execution will initiate a logon.
What error are you seeing, and at what stage?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .