Can't delete subscription

Hello,

I delete the publication, but the subscription still exists.

If I will delete the abonement I get following error 21776(Can't find Name xxx in the list of the TransPublications).

I tryed to craete the publication for the failed subscription again, but then I get the error, that a subscription for this publication still exists.

What can I do? How can I delete the subscription ?

Many thx for help!

Which SQL version are you using? Do you use scripts or UI to drop publication and subscription? Is subscription pull and located on the remote server? Could you please provide detailed repro step by step?

Thanks

Yunjing

|||

hello,

we use sql server 2000 and droped the replication via tsql

subscription is push and located on the remote server. I think I must delete all informations manuell in the server protocols, but how?

thx

Can't connect to through OLE DB to remote host - Database 'XXX' does not exist.

My application is to get some data from SQL/OLAP server.
When I try to open OleDbConnection using connection string:
"Provider=MSOLAP;Data Source=servername;Initial Catalog=dbname;"
I get message:
Database 'XXX' does not exist.
I can easily connect in the same way to localhost.
My user is olap administrator on the remote and localhost.
Using Analysis Manager or MDX Sample App from my PC I can connect to
both - local and remote DB.
The problem is I think that I still log in as anonymous user - I found
it in remote server's event log.
How can I log on authenticated? Analysis Manager can!
Any suggestions welcome!It seems that only I have that kind of problem.
Is there something I'm doing wrong?
Is it possible that my pc has to be in a domain? What if there is no
domain?
Guys please suggest me some checks or tests. Ask me something :)
This is my first approach to OLAP.
I don't know what to do.
On 27 Sie, 18:02, panko <PKoper...@.gmail.com> wrote:
> My application is to get some data from SQL/OLAP server.
> When I try to open OleDbConnection using connection string:
> "Provider=MSOLAP;Data Source=servername;Initial Catalog=dbname;"
> I get message:
> Database 'XXX' does not exist.
> I can easily connect in the same way to localhost.
> My user is olap administrator on the remote and localhost.
> Using Analysis Manager or MDX Sample App from my PC I can connect to
> both - local and remote DB.
> The problem is I think that I still log in as anonymous user - I found
> it in remote server's event log.
> How can I log on authenticated? Analysis Manager can!
> Any suggestions welcome!|||You all miserable geeks! ;)
I finally solved the problem.
The application was running as service. This service by default was
using System Local Account to log on. Therefore was refused by the
remote machine system which was not allowing this user to be
authenticated.
Solution was:
Services: MyService>Properties>Log On
Radio button on 'This Account': user and password that has right on
remote host.

Can't connect to the sql server

I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
use mixed authentication mode. A and B are in the same LAN and
workgroup.
B use Sql Server username and passoword to access the XXX sql server.
In ADO.Net and Visual Studio .Net, if I first register the Server A on
Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
server username and password, otherwise it failed.
Or, if I first connect to Server A by visiting network connections to
give A's windows username and password, then I can connect to XXX by
the pre-set sql server username and password.
However, if I don't first gain access A, then I can't connect XXX by
the pre-set sql server username and password.
What's the problem here?
Thanks;Can you describe your installation more fully? Which edition of SQL
Server 2005 (I assume it's SQL Server 2005) are you using? Which CTP?
Thanks
Andrew Watt
MVP - InfoPath
On 9 Oct 2005 11:55:29 -0700, zhenghong04@.yahoo.com wrote:

>I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
>use mixed authentication mode. A and B are in the same LAN and
>workgroup.
>B use Sql Server username and passoword to access the XXX sql server.
>In ADO.Net and Visual Studio .Net, if I first register the Server A on
>Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
>server username and password, otherwise it failed.
>Or, if I first connect to Server A by visiting network connections to
>give A's windows username and password, then I can connect to XXX by
>the pre-set sql server username and password.
>However, if I don't first gain access A, then I can't connect XXX by
>the pre-set sql server username and password.
>What's the problem here?
>Thanks;

Can't connect to the sql server

I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
use mixed authentication mode. A and B are in the same LAN and
workgroup.
B use Sql Server username and passoword to access the XXX sql server.
In ADO.Net and Visual Studio .Net, if I first register the Server A on
Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
server username and password, otherwise it failed.
Or, if I first connect to Server A by visiting network connections to
give A's windows username and password, then I can connect to XXX by
the pre-set sql server username and password.
However, if I don't first gain access A, then I can't connect XXX by
the pre-set sql server username and password.
What's the problem here?
Thanks;
Can you describe your installation more fully? Which edition of SQL
Server 2005 (I assume it's SQL Server 2005) are you using? Which CTP?
Thanks
Andrew Watt
MVP - InfoPath
On 9 Oct 2005 11:55:29 -0700, zhenghong04@.yahoo.com wrote:

>I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
>use mixed authentication mode. A and B are in the same LAN and
>workgroup.
>B use Sql Server username and passoword to access the XXX sql server.
>In ADO.Net and Visual Studio .Net, if I first register the Server A on
>Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
>server username and password, otherwise it failed.
>Or, if I first connect to Server A by visiting network connections to
>give A's windows username and password, then I can connect to XXX by
>the pre-set sql server username and password.
>However, if I don't first gain access A, then I can't connect XXX by
>the pre-set sql server username and password.
>What's the problem here?
>Thanks;

Can't connect remotely

I installed MSDE SP2 from the MSDN. I can connect to it using sa on the
local machine but can't connect remotely.
If I try telnet xxx.xxx.xxx 1433 it doesn't connect. Not even if I try it
from the local machine as telnet localhost 1433.
The server is Win Web 2003.
Any ideas?
-Joe
Additional info:
I have the following in the setup.ini file:
DISABLENETWORKPROTOCOLS=0
SAPWD="xxx"
SECURITYMODE=SQL
if I run netstat -a on the machine it doesn't show port 1433 to be listening
"Joe" <jbassking@.noemail.noemail> wrote in message
news:elAJsVa0FHA.460@.TK2MSFTNGP15.phx.gbl...
>I installed MSDE SP2 from the MSDN. I can connect to it using sa on the
>local machine but can't connect remotely.
> If I try telnet xxx.xxx.xxx 1433 it doesn't connect. Not even if I try it
> from the local machine as telnet localhost 1433.
> The server is Win Web 2003.
> Any ideas?
> -Joe
>
|||For anyone who reads this...
In order to fix the problem I had to apply a security patch called:
SQLCritUpdPkg_ENU.exe from MS.
It fixed the problem and now I can connect.
"Joe" <jbassking@.noemail.noemail> wrote in message
news:elAJsVa0FHA.460@.TK2MSFTNGP15.phx.gbl...
>I installed MSDE SP2 from the MSDN. I can connect to it using sa on the
>local machine but can't connect remotely.
> If I try telnet xxx.xxx.xxx 1433 it doesn't connect. Not even if I try it
> from the local machine as telnet localhost 1433.
> The server is Win Web 2003.
> Any ideas?
> -Joe
>
|||hi Joe,
Joe wrote:
> For anyone who reads this...
> In order to fix the problem I had to apply a security patch called:
> SQLCritUpdPkg_ENU.exe from MS.
> It fixed the problem and now I can connect.
this is not clear to me... the "fix" you installed is a a kit of security
tools provided in order to fix Slammer vulnerability
(http://www.microsoft.com/downloads/d...displaylang=en)
... all the included fix are already available in sp3/sp3a and sp4, that are
all available for a long time.. but this is another story... and of course
you are invited to apply latest sp (sp4 from
http://www.microsoft.com/sql/downloads/2000/sp4.mspx)..
but again, it's not clear to me what all this has to do with you problem..
can you provide details about what and where you find the information that
guided you to this "solution"?
thank you
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I know this doesn't make sense but it worked. I was searching google NGs for
a similar problem and found someone who had the same problem, installed the
update and it fixed his. So, I figured I would give it a shot and it worked
for me as well.
Here's the thread:
http://groups.google.com/group/micro...4514b439a44fd1
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3rev0qFioh2lU1@.individual.net...
> hi Joe,
> Joe wrote:
> this is not clear to me... the "fix" you installed is a a kit of security
> tools provided in order to fix Slammer vulnerability
> (http://www.microsoft.com/downloads/d...displaylang=en)
> ... all the included fix are already available in sp3/sp3a and sp4, that
> are all available for a long time.. but this is another story... and of
> course you are invited to apply latest sp (sp4 from
> http://www.microsoft.com/sql/downloads/2000/sp4.mspx)..
> but again, it's not clear to me what all this has to do with you problem..
> can you provide details about what and where you find the information that
> guided you to this "solution"?
> thank you
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>