Again a "Login failed for user 'null"

Hi,
I'm trying to setup replication between 2 SQL server on 2 different sites.
SQL server A is a W2k SP4 server with SQL7.0 with SQL2000 client tools
SQL server B is a W2k SP4 server with SQL2000
Servers are in mixed mode.
Servers both have MDAC version 2.6 sp2
Username used to login to the server is the administrator and for connection
to SQL is use the sa account.
When I try to start a snapshot agent I get the message "Login failed for
user 'null'. Reason: Not associated with a trusted SQL Server connection"
How can I solve this problem.
kind regards
Michiel BoerHow are you launching the snapshot agent? through command line or sql server
agent?
What is the exact command that you are using?
What account is the SQL agent service running under?
Thanks,
Bala.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Michiel" <meme@.ikkus.com> wrote in message
news:403b5fc8$0$32978$e4fe514c@.dreader15
.news.xs4all.nl...
> Hi,
> I'm trying to setup replication between 2 SQL server on 2 different sites.
> SQL server A is a W2k SP4 server with SQL7.0 with SQL2000 client tools
> SQL server B is a W2k SP4 server with SQL2000
> Servers are in mixed mode.
> Servers both have MDAC version 2.6 sp2
> Username used to login to the server is the administrator and for
connection
> to SQL is use the sa account.
> When I try to start a snapshot agent I get the message "Login failed for
> user 'null'. Reason: Not associated with a trusted SQL Server connection"
> How can I solve this problem.
> kind regards
> Michiel Boer
>
>

Advisor Scan Fails

Hey all. I'm in the process of starting an upgrade from SQL2000 to SQL2005. I ran the Upgrade Advisor like suggested and I keep receiving an error.

'Cannot use DSO (Decision Support Objects) to connect to Analysis Services, DSO is either not installed ot the installation is corrupted. Error details: Retrieving the COM class factory for component with CLSID {B492C386-0195-11D2-89BA-00C04FB9898D} failed due to the following error: 80040154.'

Any suggestions or ideas?

Chris

Upgrade Advisor requires DSO. Here is the except from the help files that tells you how to install it.

SQL Server 2000 decision support objects (DSO) are required to scan upgrade issues in Analysis services. To install DSO, insert the SQL Server 2000 media into the CD/DVD drive. This starts the SQL Server 2000 Setup program. Click Install SQL Server 2000 Components. Click Analysis Services to start the Analysis Services Setup program. In Select Components, make sure that the Decision Support Objects component is selected.

Thanks

Michelle

Advise on Multiple Column Updates

Using SQL2000, is there another way of optimizing the original query below.
TIA,
Bob

Update Transaction
set field1 = (select (sum(tax)-sum(credit))/sum(credit) from tblOrder where
tblOrder.id = Transaction.id),
field2 = (select avg(price) from tblOrder where tblOrder.id =
Transaction.id),
field3 = (select min(cost) from tblOrder where tblOrder.id = Transaction.id)
etc..
(there are six additional updates)

Is this a quicker way:

Update Transaction
SET field1 = (sum(tax)-sum(credit))/sum(credit) , field2 = avg(price) ,
field3 = min(cost) , etc....
FROM tblOrder
WHERE tblOrder.id = Transaction.idThe format is:
UPDATE <table> SET (<columnlist>) = (SELECT <select_list> FROM ...)
WHERE ...

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab