[SQLSTATE 01000] via Agent Job, but not Query Analyzer

I run a sproc through query analyzer, and all is fine, when I run the job via the SQL Agent, [SQLSTATE 01000] appears after every line in the "log" file, any ideas ?
This happens with the sp_help_revlogin procedure.
both are being run with sa.Known issue with the PRINT command in SQL Server.

[SQL 2005] Transactionnal replication via FTP

Here is the context, in short. I have 2 remote sites with SQL Server 2005.
Each server can't see the other one. I need to replicate data between them.
I use MSSQL Management Studio with SQL Server Developer Edition.
When creating a publication, I can say that I want the snapshot to be put on
a FTP in the publication option. no problem here. When I want to create a
subscribtion, I must give the publication to use, and there is the problem
because I can't see the remote server.
The only thing I need to do is to say the subscriber to take the snapshot on
the FTP, but I've not found how I can do this.
If someone can help me ^^
Thanks in advance.
P.S. : sorry for my bad english, I'm not very good with foreign language :p
Divid,
you'll need some sort of connectivity. This could be a VPN, HTTPS or just
TCP/IP (non-trusted). Somehow, the subscriber will need to contact the
publisher. If you want a purely FTP solution then you must use another
technology.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||VPN, in a wonderfull dream. Maybe one day ... or not :p
Merge replication can use HTTPS but the merge replication is not suitable in
my situation. Transactionnal replication can't use HTTPS as far as I know.
For the TCP/IP (non trusted), can you explain about this a little more. I
don't know what is it so maybe it could do the work.
Thanks again.
|||David,
this should help a bit:
http://www.replicationanswers.com/InternetArticle.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||It doesn't really help. I've add the alias but I can't add a "virtual"
publisher (the alias), and then I can't subscribe it, in Management Studio.
Seems that I'm only able to work on local because local publishing/local
subscribtion are the only options in Management Studio.
|||David,
unfortunately I can't repro this at the moment as we only have one SQL
Server 2005 installation. As soon as another is added I'll give it a go, but
hopefully someone else will take up the thread before then.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

[Newbie] Microsoft Analysis Server: Database not visible via remote XMLA

Hi,

I am trying to install the Adventure Works DW MS SQL Server 2005 Demo. I followed the instructions I found here and here (almost) to the letter. And lo and behold, I can actually see the Adventure Works DW Database in the Microsoft SQL Server Management Studio.

Moreover, when I execute the XMLA-Queries _in the SQL Server Management Studio_ to discover the datasources and then to list all catalogs, it displays all available catalogs just fine.

When I perform the exact same queries from a remote computer, only a previously installed Database (called "TestDB") is returned. No hint that Adventure Works could also exist.

I tried comparing the two databases (properties seem to be identical), but since I don't know anything about that "TestDB", it's really hard to see relevant differences.

Do I have to set certain access rights? I tried restarting the IIS service, but to no effect.

Now, above I stated that I followed the desciptions _almost_ to the letter. The step I could not reproduce was in the second link. It stated that I had to create an "Application Pool", but when I browsed to the IIS Node in the Computer Management console, I expanded it, but could not find "Application Pool" anywhere near it. So I did not create a new application pool -- it may, however, very well be that an Application Pool already existed.

Any ideas as to where I might look for errors?
Thanks in advance!
Philipp

Are you connecting using the same account? If not you would need to add the account to a role in Adventure Works.

The application pools only exist in IIS 6 which comes with Win2003 server, so if you are using WinXP or Win2000 you will not have application pools.

You could run SQL profiler and see what account SSAS is seeing when you ask it for a list of catalogs.

|||Thanks. Adding my user to a rule did the trick.

[DBNETLIB][ConnectionWrite (send()).] General network error.

Hi,
in our environment
- Windows XP
- SQL Server Express 2005
- Internet connection via TCP/IP protocol

The described network error occurs, when we unplug the network cable:
[DBNETLIB][ConnectionWrite (send()).] General network error.

The affected database resides on the locally installed SQLExpress, it doesn't use any network connections. The error doesn't occur immediately, in most cases there are up to 30 seconds where data can be (correctly!) written to the recordset, but after that timeout the connetion is broken.

We already tried out the described workarounds:
- disable named pipes protocol
- set SynAttackProtect=0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

The error doesn't occur with MSDE (SQL 2000) or under Vista.

Thanks for help!

Mathias

I suggest using shared memory to connect locally or making sure your server specification is one that correctly gets resolved to use the loopback (e.g. .\ or (local) or localhost). You may also want to see if your hosts file has an entry for the machine to make sure it resolves its own name. Right now, it appears as though your communications are going out over the network. You may have some amount of data transfer after unplugging the cable because the network connection is buffered, so the server still has that much data in its network buffer before it runs out. I think the connection timeout is consuming the bulk of that 30 seconds. Vista most likely has its own hostname in its hosts file, or has some other trick for self-resolving its computer name. More than likely, your instance of SQL 2000 is using shared memory to connect or using a different specification of the hostname.

Hope that helps,

John

@@SERVERNAME returns NULL

When I do:
SELECT @.@.SERVERNAME
It returns NULL. How, and how can I fix.
Thanks.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
Darin,
use:
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)