Push works / Pull doesn't

When I set up a pull subscription through the wizard, I get the following error when I try to run the distribution agent:
-->
The subscription to publication '(null)' has expired and does not exist. The step failed.
<--
If I set up a push subscription, everything works fine. Any ideas what would cause this issue?
Thanks in advance!
Greg,
there was an issue with this in SQL 7.0:
http://www.kbalertz.com/Feedback_290054.aspx.
Hopefully this is relevant to your case (;-))
Regards,
Paul
|||Here's more info:
I'm using sql server 2000, sp3 on win2kadv server on both publisher and subscriber. It's a Transaction replication publication, no merge or updating back to the publisher. I set up a very simple database with one table that has a primary key and a varchar
(50) column, and 3 rows to isolate the problem. The snapshot runs quick, but the pull distribution agent keeps getting the before mentioned error. If I set up a push subscription, it works.
Any ideas?
|||Greg,
as far as I can tell, this error is raised from
sp_MShelp_distribution_agentid, which is undocumented. The error message
relates to the independant_agent setting when you created the publication.
Please could you run profiler on the subscriber while you try the pull
subscription to check if this is the case. If so please post up the
arguments sent to the procedure and your script which creates the
publication and I'll see if I can get any further.
Regards,
Paul Ibison
|||I figured it out! I set up aliases rather than using ip addresses and it is now working.
http://support.microsoft.com/?id=321822

Push Subscription Wizard

Hello,
I am trying to setup a push subscription between two SQL 2000 Servers using
the Push Subscription Wizard through Enterprise Manager. After clicking
"Finish" at the end of the wizard, Enterprise Manager hangs at the first
step "Enabling this server as a subscriber". Can anyone help me identify
the problem, I can't see anything in the logs.
Thanks,
Ben Gibson
Ben,
additionally, you could use sp_who2 and dbcc inputbuffer(spid) as per usual
to get some more info.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

PULL Subscription Problem

I am trying to create a PULL subscription from EM between two SQL 2000
servers on the same network. At the end of the wizard I get the following
error message.
ERROR 15004: Name cannot be NULL
I cannot find any detail information of what is the cuase of this error any
possible resolution. Please help.
what do you get when you issue a select @.@.servername on the publisher and
subscriber?
If you get (NULL) follow the instructions here for more information.
http://support.microsoft.com/default...b;en-us;302223
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Jeremy Brown" <JeremyBrown@.discussions.microsoft.com> wrote in message
news:7DD7EE37-2311-46CD-946F-963316B4A3F9@.microsoft.com...
>I am trying to create a PULL subscription from EM between two SQL 2000
> servers on the same network. At the end of the wizard I get the following
> error message.
> ERROR 15004: Name cannot be NULL
> I cannot find any detail information of what is the cuase of this error
> any
> possible resolution. Please help.
|||Thank you Hilary. The article put me on the right track and I was able to
solve my problem. Thanks again.
"Hilary Cotter" wrote:

> what do you get when you issue a select @.@.servername on the publisher and
> subscriber?
> If you get (NULL) follow the instructions here for more information.
> http://support.microsoft.com/default...b;en-us;302223
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
> "Jeremy Brown" <JeremyBrown@.discussions.microsoft.com> wrote in message
> news:7DD7EE37-2311-46CD-946F-963316B4A3F9@.microsoft.com...
>
>

Publishing Wizard - Bad Magic?

I've been working with the Database Publishing Wizard and have found what I initially thought was a bug but have decided is a rather nasty "feature". Or am I missing something?

I have membership implemented in a live database. I took a backup and loaded it into a local database. I created a new table locally that is foreign-keyed off aspnet_roles, and added some data.

Using the Publishing Wizard for a partial deployment, I followed the steps which seem perfectly clear to script out ONLY the new table and its data. The screens provide a nice GUI for selecting specific database objects, and I carefully chose the one new table.

From good habits I looked at the script before deploying it. Itdrops and recreates aspnet_roles and aspnet_applications as well (and inserts the data from the development tables).

Presumably this is because of the foreign key relationships. But there's no need to do so. What if I or another developer had added in some roles to the live table in the meantime? This script would blow them away.

Am I missing an option with the Wizard that would script out only what is specified? I've tidied up the script (i.e. removed the undesirable sections) - but this seems to be a naughty wizard. Any thoughts?

What publishing wizard are you using for your database? It is a bit expensive but I believe Red Gate has the best db tools available. It contains separate data comparison and sql structure (table changes) tools.

|||

We use Red Gate when we have a choice. But one of our clients uses the Database Publishing Wizard, which is a free download from Microsoft.

I was curious so was checking it out. It seems to me that it should pop up a list of tables affected by the user choice, particularly when the user has selected only one table. Anyway, I'll continue pursuing this elsewhere, thanks for the response.

|||

If that's the case is it possible to just modify the sql by removing the data insert statements?

|||

At the risk of stating the obvious, did you try changing the "Drop existing objects in script" option to false? This will prevent the script from adding the if exists-drop statements when publsihing and when writing scripts.

This option is on the "Select Publishing Options" page.

|||

Yes, but take this scenario - I deploy a single new table fk-ed to aspnet_roles and uncheck "drop existing objects". Everything is hunky-dory first time round. But then I want to add a single new column to this recent table? It makes sense to check "drop existing objects" and then select the changed table - behind the scenes, aspnet_roles is dropped and recreated alongside the new table.

And regardless of whether the "drop existing objects" is unchecked - the Wizard will still try to insert the data from the development database into aspnet_roles. This will fail, because it turns identity insert on - so will bomb out on the primary key.

I seem to remember looking at the Wizard when it first was released and it didn't have partial deployment options - only full deployment. So partial deployment has been added later - which is a nice feature. But I think if the Wizard "decides" that it knows best and will also work with foreign-keyed tables for a chosen table in the GUI - it should warn the user of exactly which tables are affected.

Yes - the user can edit the script - but this Wizard isn't aimed at DBAs who will tend to want to roll their own scripts anyway - I think it's aimed at developers who are proficient in coding but don't want to get bogged down in the database side.

publishing sql db

web site made in web dev

db all ok locally

got server at local ip......

need to upload script files to server...

got microsoft publishing wizard all working and database all scripted out.

server consul looks like horrible unix outfit....virtuozzo

question is now what?

ip says use enterprise manager to publish to server.....is that the old

version of management studio express, which i have

You can always download the new version of SQl Management Studio for free. For publishing you need to register it with the DNS and then put either the IP or the servername in the connection string.

|||

I have got ssmse already

can you expand a little on this "For publishing you need to register it with the DNS "

|||

If you are using an IP address or a server name thatshould be resolved through DNS or over the Internet, you'll want to make sure that TCP/IP is enabled. Go to Start / Programs / Microsoft SQL Server, open the Client Network Utility, and on the General tab, make sure TCP/IP is at the top of the list on the right hand side.

If you are trying to connect to a named instance, you can use the following format:

Data Source = <server/ip>\<instancename>;

If you are running SQL Server or MSDE on the same machine as your ASP pages, you are probably tempted to use the hostname "localhost." This doesn't always work, due to different configuration issues, so try (local), 127.0.0.1, the actual host name, or simply a period (".").

|||

yes.. why dont I run both the asp pages and sql server on the

server together...sounds much cleaner. great idea

I,ll give it a try.

Thanks so much for your help naturehermit

|||

yes.. why dont I run both the asp pages and sql server on the

server together...sounds much cleaner. great idea

I,ll give it a try.

Thanks so much for your help naturehermit

|||

Thanks and all the best

(If you have got a large website, running sql server and code on same machine will create performance issues)

|||

oooh

right ..maybe not then...i think i can see where

you are coming from.

|||

However I have run many test with 100 or so cuncurrent users where SQL Enterprise and Asp.net are both sitting on a win2k3 Enterprise Machine with 4 Gig RAM, havent found any issue at all.

|||

So if I was running a server with seperate asp.net pages ...no problem.

This is all new to me and trying to get sorted what road

to go down is the hardest bit.

Got any help on publishing scripts to a server.

I don,t know if I should be uploading sql server 2005 to the server or just

the .mdf

|||

Hi there,

I shall try to explain this,

With publishing scripts if you mean the code, then in visual studio there is a publish website option, from Build. If you mean something different please specify.

sql server 2005 is a server itself that runs on top of windows 2003 and hence if you havent given your sql server a different name it should be the name of your 2003, If you have DNS enabled and have got a domain, it should already be configured for you.

If you want somebody to host the db for you, then you can supply them the .mdf files so that they can re-create the table in their sql host for you, however in that case you will need to modify your connectionstring to theirs.

so for e.g. curently say you are using server =192.168.1.1 and they may have a server with ip 2.3.2.1 or say sqlserver(if mapped to dns)

then you will simply use

server =sqlserver or server =2.3.2.1 in your connection string.

Hope that helps

|||

If you want somebody to host the db for you, then you can supply them the .mdf files so that they can re-create the table in their sql host for you, however in that case you will need to modify your connectionstring to theirs.

Is that all.

You see after reading this article I decided that I should have to build scripts..DDL to upload to a "server"

http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx

rather than just upload .mdf to my host......I think I have over cooked this some what

|||

Well that article is to make life easier for people and for people with stored procedures and other stuff. Generally .mdf is enough to create the database. But as pointed out in that article most providers do not know what they are doing and hence it creates a lot of problems to iron out these installation issues. Do not upload but supply them .mdf files and ask them to create the db for you, and they will give you the server name to modify in your connection string.

|||

naturehermit you are truly a star of mine.

thanks for all your help today...I owe you.

And I hope this post may help others who get to this greyer area

regards Richard

|||

Hey Richard,

Thanks for your compliments but I am just an ordinary folk. Please feel free to ask if you get stuck. Also please mark all posts that helped you.

Regards

Publishing data while using same server as distributor

Hi all,
I am trying to publish data making the same server as Distributor while
using the wizard it says i am using "sa" account and the server cannot be
used as a distributor if i use "sa" account,how do i go around this? do i
need to stop the server and start with a different account? and setup server
agent to use other account ?
Can anyone clear my doubts?
Thanks
Sudha
Does it say "Local System" or "sa" I have never heard of it having a problem
with the sa account but I have when it uses the local system account. Can
you ensure that your SQL Server service account is running under a domain
account? Make this change through enterprise manager.
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
"sudha" <sudha@.discussions.microsoft.com> wrote in message
news:9DA7173A-C32D-4953-9453-8AEE0656F752@.microsoft.com...
> Hi all,
> I am trying to publish data making the same server as Distributor while
> using the wizard it says i am using "sa" account and the server cannot be
> used as a distributor if i use "sa" account,how do i go around this? do i
> need to stop the server and start with a different account? and setup
server
> agent to use other account ?
> Can anyone clear my doubts?
> Thanks
> Sudha
|||Hi Hilary,
I appreciate your reply. Yes it says "SQL Server Agent on "servername" uses
System Account,which causes replication between servers to fail.
You suggested me to change,sql service account ,how do i change it and do i
need to stop and start the server after i make a change?
I will be thankful if i can get this answer.
Sudha
"Hilary Cotter" wrote:

> Does it say "Local System" or "sa" I have never heard of it having a problem
> with the sa account but I have when it uses the local system account. Can
> you ensure that your SQL Server service account is running under a domain
> account? Make this change through enterprise manager.
> --
> 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
> "sudha" <sudha@.discussions.microsoft.com> wrote in message
> news:9DA7173A-C32D-4953-9453-8AEE0656F752@.microsoft.com...
> server
>
>
|||Right click on EM, select Properties, click on the security tab and its at
the bottom - yes there will be a restart.
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
"sudha" <sudha@.discussions.microsoft.com> wrote in message
news:9B912EFE-BF61-4C57-B7A1-2F35F430B5D7@.microsoft.com...
> Hi Hilary,
> I appreciate your reply. Yes it says "SQL Server Agent on "servername"
uses
> System Account,which causes replication between servers to fail.
> You suggested me to change,sql service account ,how do i change it and do
i[vbcol=seagreen]
> need to stop and start the server after i make a change?
> I will be thankful if i can get this answer.
> Sudha
> "Hilary Cotter" wrote:
problem[vbcol=seagreen]
Can[vbcol=seagreen]
domain[vbcol=seagreen]
while[vbcol=seagreen]
cannot be[vbcol=seagreen]
do i[vbcol=seagreen]
|||Hi Hilary,
Thanks for your response again but in my EM in the Security Tab of database
properties the server agent account start up options frame is disabled,why is
it? and what do i do with it?
thanks
sudha
"Hilary Cotter" wrote:

> Right click on EM, select Properties, click on the security tab and its at
> the bottom - yes there will be a restart.
> --
> 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
> "sudha" <sudha@.discussions.microsoft.com> wrote in message
> news:9B912EFE-BF61-4C57-B7A1-2F35F430B5D7@.microsoft.com...
> uses
> i
> problem
> Can
> domain
> while
> cannot be
> do i
>
>
|||You need to set up a domain user account for your sql
server service and sql server agent. Editing the startup
properties in EM won't give you the option to browse AD,
so it's easiest to do this in Control Panel,
Administratove Tools, Services.
Have a look for MSSQLSERVER, SQLSERVERAGENT. For
replication purposes we are almost always just concerned
with the latter service. From the ideal DBA point of
view, you should change them both, however. To make
things simple, select the same domain user for both
services, and this account must be a local administrator.
If not, you'll end up editing permissions on various
registry keys, and you really don't want to have to do
this. After you've restarted, it should all be tickety-
boo.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

>--Original Message--
>Hi Hilary,
>Thanks for your response again but in my EM in the
Security Tab of database
>properties the server agent account start up options
frame is disabled,why is[vbcol=seagreen]
>it? and what do i do with it?
>thanks
>sudha
>"Hilary Cotter" wrote:
security tab and its at[vbcol=seagreen]
message[vbcol=seagreen]
2F35F430B5D7@.microsoft.com...[vbcol=seagreen]
Agent on "servername"[vbcol=seagreen]
servers to fail.[vbcol=seagreen]
do i change it and do[vbcol=seagreen]
change?[vbcol=seagreen]
heard of it having a[vbcol=seagreen]
local system account.[vbcol=seagreen]
running under a[vbcol=seagreen]
manager.[vbcol=seagreen]
message[vbcol=seagreen]
8AEE0656F752@.microsoft.com...[vbcol=seagreen]
server as Distributor[vbcol=seagreen]
account and the server[vbcol=seagreen]
do i go around this?[vbcol=seagreen]
different account? and setup
>.
>
|||Thanks Paul,
I will try out the things which you have suggested and let you know if i am
fine.
Great to know how things get fixed and from which places.The more we try to
dig the more we are ignorant.Thanks for giving me the information.
Sudha
"Paul Ibison" wrote:

> You need to set up a domain user account for your sql
> server service and sql server agent. Editing the startup
> properties in EM won't give you the option to browse AD,
> so it's easiest to do this in Control Panel,
> Administratove Tools, Services.
> Have a look for MSSQLSERVER, SQLSERVERAGENT. For
> replication purposes we are almost always just concerned
> with the latter service. From the ideal DBA point of
> view, you should change them both, however. To make
> things simple, select the same domain user for both
> services, and this account must be a local administrator.
> If not, you'll end up editing permissions on various
> registry keys, and you really don't want to have to do
> this. After you've restarted, it should all be tickety-
> boo.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
> Security Tab of database
> frame is disabled,why is
> security tab and its at
> message
> 2F35F430B5D7@.microsoft.com...
> Agent on "servername"
> servers to fail.
> do i change it and do
> change?
> heard of it having a
> local system account.
> running under a
> manager.
> message
> 8AEE0656F752@.microsoft.com...
> server as Distributor
> account and the server
> do i go around this?
> different account? and setup
>

Publication script error

Hello,
I am creating Publication through sql script. I have created Publication on
my machine using wizard and after that I created the script for the
publication. When I am running this script on another sql server it is giving
me an error saying Distributor not configured properly. What I need to do to
remove this error? Can this problem be solved by running some sql script?
Becoz I am creating all this through Installshield. So I need the script of
this. Please Help...
Sounds like replication is not installed on this server. Go to tools,
replication, enable replication and follow the prompts accepting the
defaults.
"Subin" <Subin@.discussions.microsoft.com> wrote in message
news:567DC900-D413-4769-916C-E24FF90B9A0E@.microsoft.com...
> Hello,
> I am creating Publication through sql script. I have created Publication
> on
> my machine using wizard and after that I created the script for the
> publication. When I am running this script on another sql server it is
> giving
> me an error saying Distributor not configured properly. What I need to do
> to
> remove this error? Can this problem be solved by running some sql script?
> Becoz I am creating all this through Installshield. So I need the script
> of
> this. Please Help...

Publication Problem

Hello,
I want to Create Publication with the Wizard but i always have a great
problem: After i click on okay on the Specify Snapshot Folder i always get
the following error:
"SQL Server Enterprise Manager could not retrieve information about the
Distributor of the database. Error 1038: Cannot use empty object or column
names. Use a single space if necessary."
And when i click on okay and the "Choose Publication Database" screen
appears i cannnot choose any database because in there do not appear any
databases.
What went wrong here?
Can anybody please help me here?
regards
patrick
PS: When i want to create a new Table for a Database a similar error occurs:
An unexpected error happened during this operation.
[Microsoft SQL-DMO (ODBC SQLState: 42000) - Cannot use empty object or
column names. Use a single space if necessary.
Maybe this could help to explain me what went wrong in my Enterprise Manager
that the Publication does not work correctly?
Hello,
I installed the Microsoft SQL Server 2000 on my machine once more and
fortunately the Publicaten worked. I did it like it is quoted in your posted
doc-file and on this
<a
href=http://msdn.microsoft.com/SQL/SQLCE/default.aspx?pull=/msdnmag/issues/03/09/datapoints/default.aspx> ReplicationExample
site, because i want to go through the sample of this site.
But it were to good to be true if all would be work, when i deploy the
sample application from this site on the Emulator and presses the
Synch-Button of the application, the following error occurs in a message box
on the display:
Error #1 of 1
Error Code: -2147012867
Message: A request to send data to the computer running IIS has failed. For
more information, see HRESULT.[,,,,]
Minor Err.: 28037
Source: Microsoft SQL Server 2000 Windows CE Edition.
Do know what went wrong here or do i have forgotten anything during the
Create Virtual Directory Wizard or the Publication Wizard or anything else?
Hopefully you are willing to help me again, because i do not simply look
through it.
regards
patrick
PS: I did all as i quoted it in the previous posting and once more my IIS,
SQL Server 2000 and VS.NET are all on the same machine.