Problems installing RS 2005

-OS: Windows 2000
-RS 2005
-SQL Server 2000
The installation completes successfuly in c:\Program Files\Microsoft SQL
Server\MSSQL.1\Reporting Services\
LogFiles in c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
Services\LogFiles do not have any errors..
But when i visit http://localhost/ReportServer I get a blank page that looks
like this:
localhost/ReportServer -
----
----
Microsoft SQL Server Reporting Services Version 9.00.1399.00
Any ideas'
I tried re-installing several times...There are two websites. One just shows folders and that website is
ReportServer. If you haven't deployed any reports you won't have any folders
created. The portal (Report Manager) is at the Reports website. Try
http://localhost/Reports
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ash" <Ash@.discussions.microsoft.com> wrote in message
news:2D5F1522-EED5-4A81-B2D2-29BF7F5B873E@.microsoft.com...
> -OS: Windows 2000
> -RS 2005
> -SQL Server 2000
> The installation completes successfuly in c:\Program Files\Microsoft SQL
> Server\MSSQL.1\Reporting Services\
> LogFiles in c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
> Services\LogFiles do not have any errors..
> But when i visit http://localhost/ReportServer I get a blank page that
> looks
> like this:
>
> localhost/ReportServer - /
> ----
> ----
> Microsoft SQL Server Reporting Services Version 9.00.1399.00
>
> Any ideas'
> I tried re-installing several times...|||Oh wow thats it!! :)
Thanks...
Sorry for posting twice...I thought the my session expired and the first one
didnt make it. Thanks
"Bruce L-C [MVP]" wrote:
> There are two websites. One just shows folders and that website is
> ReportServer. If you haven't deployed any reports you won't have any folders
> created. The portal (Report Manager) is at the Reports website. Try
> http://localhost/Reports
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ash" <Ash@.discussions.microsoft.com> wrote in message
> news:2D5F1522-EED5-4A81-B2D2-29BF7F5B873E@.microsoft.com...
> > -OS: Windows 2000
> > -RS 2005
> > -SQL Server 2000
> > The installation completes successfuly in c:\Program Files\Microsoft SQL
> > Server\MSSQL.1\Reporting Services\
> >
> > LogFiles in c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
> > Services\LogFiles do not have any errors..
> > But when i visit http://localhost/ReportServer I get a blank page that
> > looks
> > like this:
> >
> >
> > localhost/ReportServer - /
> > ----
> >
> > ----
> > Microsoft SQL Server Reporting Services Version 9.00.1399.00
> >
> >
> > Any ideas'
> > I tried re-installing several times...
>
>

Problems In Connecting Using New Driver

I tried using the new MSSQL 2005 driver which I downloaded from
http://blogs.msdn.com/dataaccess/ar...28/475032.aspx.
But I had problems in connecting to the database using it.
I used the following lines to make the connection.
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con1 =
DriverManager.getConnection("jdbc:sqlserver://localhost;databaseName=BCTEST"
,
"fiorano", "fiorano123");
I got the following error.
com.microsoft.sqlserver.jdbc.SQLServerException: Failed
Logon:com.microsoft.sqls
erver.jdbc.SQLServerException: DBComms.error reading input. Context:Read
packet
header, Unexpected end of stream, readBytes:-1, negative read result,
PktNumber:
0, ReadThisPacket:0, PktDataSize:4,096
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown
Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at JDBCTestYukon.main(JDBCTestYukon.java:17)
I even tried with the simpler URL "jdbc:sqlserver://localhost" but I got the
same error.
Please help.If I use Type1 driver like below its working fine.
java.lang.Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection1 =
java.sql.DriverManager.getConnection("jdbc:odbc:DEV329;user=sa;password=ontr
ack20");
But for the thin driver getteing the same exception..I need to upgrade
my Java version'

Problems changing the password for the service account in SQL 2000

Jill
What is an acoount MSSQL Server running under?
Is that Windows Auithentication or Mixed?
"Jill" <Jill@.discussions.microsoft.com> wrote in message
news:C2E38E25-6D9F-4B25-A330-CAD4FF6C6AFE@.microsoft.com...
> We are currently in the process of Moving all our SQL Server 2000 servers
> from Windows 2000 using NT security over to Window2003 using Activity
> Directory. We have migrated the Service account and password over to the
> new
> domain and have installed SQL Server successfully using this account. We
> have now testing changing the password. We changed the password on the
> domain controller and then in SQL Server and now the only accounts which
> can
> connect to SQL Server are the domain account running SQL Server and SQL
> Server accounts. No other domain accounts can access SQL. The following
> is
> the error which we get " A connection couldn't be established. Reason:
> login
> failed for user (NULL) Reason: not associated with a trusted SQL Server
> connection". If I change the account running SQL to Local system everyone
> can logon. Any idea what is going on?
> --
> JillWe are currently in the process of Moving all our SQL Server 2000 servers
from Windows 2000 using NT security over to Window2003 using Activity
Directory. We have migrated the Service account and password over to the ne
w
domain and have installed SQL Server successfully using this account. We
have now testing changing the password. We changed the password on the
domain controller and then in SQL Server and now the only accounts which can
connect to SQL Server are the domain account running SQL Server and SQL
Server accounts. No other domain accounts can access SQL. The following is
the error which we get " A connection couldn't be established. Reason: login
failed for user (NULL) Reason: not associated with a trusted SQL Server
connection". If I change the account running SQL to Local system everyone
can logon. Any idea what is going on?
--
Jill|||Jill
What is an acoount MSSQL Server running under?
Is that Windows Auithentication or Mixed?
"Jill" <Jill@.discussions.microsoft.com> wrote in message
news:C2E38E25-6D9F-4B25-A330-CAD4FF6C6AFE@.microsoft.com...
> We are currently in the process of Moving all our SQL Server 2000 servers
> from Windows 2000 using NT security over to Window2003 using Activity
> Directory. We have migrated the Service account and password over to the
> new
> domain and have installed SQL Server successfully using this account. We
> have now testing changing the password. We changed the password on the
> domain controller and then in SQL Server and now the only accounts which
> can
> connect to SQL Server are the domain account running SQL Server and SQL
> Server accounts. No other domain accounts can access SQL. The following
> is
> the error which we get " A connection couldn't be established. Reason:
> login
> failed for user (NULL) Reason: not associated with a trusted SQL Server
> connection". If I change the account running SQL to Local system everyone
> can logon. Any idea what is going on?
> --
> Jill

Problems activating a second Report server using rsactivate (Web f

1. I cannot get rsactivate to activate a second RS node on a web farm.
rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config"
Failure starting the web service:
The local NT Service is not activated
2. rskeymgmt on the Original RS node 1 does not work either.
rskeymgmt -e -fc:\rsdbkey.txt -pxxxxx
Are you sure you want to extract the key from the report server (Y/N)? y
The local NT Service is disabled 0x80090005
Environment -
The two RS Servers are both Windows 2003 Servers.
SQL Server is on a third computer: SQL 2000 Server Enterprise Edition.
RS Node1: Works fine.
RS Node 2: Activation fails.
ReportServer service login account for both nodes: "NT
Authority\NetworkService"
SQL Server access - using a "sql admin" account.
IIS (W3Svc) on both RS nodes - "LocalSystemAccount".
Web Servers on both RS nodes are working fine and the ReportServer service
starts as well.To activate a web farm, you will need to run rsactivate -m <name of node 2>
from node 1.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"VChandy" <VChandy@.discussions.microsoft.com> wrote in message
news:539D88F5-35FE-44E7-B2A5-79AC74E363D9@.microsoft.com...
> 1. I cannot get rsactivate to activate a second RS node on a web farm.
> rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Failure starting the web service:
> The local NT Service is not activated
> 2. rskeymgmt on the Original RS node 1 does not work either.
> rskeymgmt -e -fc:\rsdbkey.txt -pxxxxx
> Are you sure you want to extract the key from the report server (Y/N)? y
> The local NT Service is disabled 0x80090005
> Environment -
> The two RS Servers are both Windows 2003 Servers.
> SQL Server is on a third computer: SQL 2000 Server Enterprise Edition.
> RS Node1: Works fine.
> RS Node 2: Activation fails.
> ReportServer service login account for both nodes: "NT
> Authority\NetworkService"
> SQL Server access - using a "sql admin" account.
> IIS (W3Svc) on both RS nodes - "LocalSystemAccount".
> Web Servers on both RS nodes are working fine and the ReportServer service
> starts as well.
>|||Figured it out from an earlier post on 8/17 from Brian Hartman [MSFT]
Did the following -
1. rskeymgmt -d on the orignal RS Node 1.
2. Stopped W3Svs and RS Service on Node 2. (** important)
3. From Node1 ran: rsactivate -mNode2 -c "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
4. Re-started W3Svc and RS Service on Node 2.
5. Deleted and re-deployed all my RDLs to RS Node 1 as the security
information for the Data sources & other stuff got clobbered by rskeymgmt -d
6. Both RS nodes 1 & 2 can access all reports.
7. SSL works fine as well - next need to upgrade both nodes to RS Service
pack 1 and work on an NLB cluster solution ...
"VChandy" wrote:
> 1. I cannot get rsactivate to activate a second RS node on a web farm.
> rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Failure starting the web service:
> The local NT Service is not activated
> 2. rskeymgmt on the Original RS node 1 does not work either.
> rskeymgmt -e -fc:\rsdbkey.txt -pxxxxx
> Are you sure you want to extract the key from the report server (Y/N)? y
> The local NT Service is disabled 0x80090005
> Environment -
> The two RS Servers are both Windows 2003 Servers.
> SQL Server is on a third computer: SQL 2000 Server Enterprise Edition.
> RS Node1: Works fine.
> RS Node 2: Activation fails.
> ReportServer service login account for both nodes: "NT
> Authority\NetworkService"
> SQL Server access - using a "sql admin" account.
> IIS (W3Svc) on both RS nodes - "LocalSystemAccount".
> Web Servers on both RS nodes are working fine and the ReportServer service
> starts as well.
>

Problem: mssql locks several records in a specific table, while no one is editing them

Hi,
I have an Access application with linked tables via ODBC to MSSQL
server 2000.

Having a weird problem, probably something i've done while not being
aware of (kinda newbie).

the last 20 records (and growing)of a specific table are locked - cant
change them - ("another user is editing these records ... ").

I know for a fact that no one is editing records and yet no user can
edit these last records in the MDB - including the administrator -
while able to add new records.

Administrator able to edit records in the ADP (mssql server) where the
tables are stored.

Please help, the application is renedred inert .

Thanks for reading,
Oren.Hi

I can't say that I am an expert on access, but this sounds like the
recordset may need refreshing i.e someone has changed the record and access
knows the local copy is out of date.

John

"Oren" <orentini@.hotmail.com> wrote in message
news:b1368c93.0409160909.128bae81@.posting.google.c om...
> Hi,
> I have an Access application with linked tables via ODBC to MSSQL
> server 2000.
> Having a weird problem, probably something i've done while not being
> aware of (kinda newbie).
> the last 20 records (and growing)of a specific table are locked - cant
> change them - ("another user is editing these records ... ").
> I know for a fact that no one is editing records and yet no user can
> edit these last records in the MDB - including the administrator -
> while able to add new records.
> Administrator able to edit records in the ADP (mssql server) where the
> tables are stored.
> Please help, the application is renedred inert .
> Thanks for reading,
> Oren.|||Hi,
thanks for replying.

There is no local and remote copy of the table, the table is only
stored in the sql server and linked to the access MDB.

Simple refresh wont do (tried it, via the access menubars).

have any more suggestions?

Thanks,

Oren,

"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:<414b53f6$0$27296$afc38c87@.news.easynet.co.uk>...
> Hi
> I can't say that I am an expert on access, but this sounds like the
> recordset may need refreshing i.e someone has changed the record and access
> knows the local copy is out of date.
> John
> "Oren" <orentini@.hotmail.com> wrote in message
> news:b1368c93.0409160909.128bae81@.posting.google.c om...
> > Hi,
> > I have an Access application with linked tables via ODBC to MSSQL
> > server 2000.
> > Having a weird problem, probably something i've done while not being
> > aware of (kinda newbie).
> > the last 20 records (and growing)of a specific table are locked - cant
> > change them - ("another user is editing these records ... ").
> > I know for a fact that no one is editing records and yet no user can
> > edit these last records in the MDB - including the administrator -
> > while able to add new records.
> > Administrator able to edit records in the ADP (mssql server) where the
> > tables are stored.
> > Please help, the application is renedred inert .
> > Thanks for reading,
> > Oren.|||Hi

You may want to post this is an access news group!

John

"Oren" <orentini@.hotmail.com> wrote in message
news:b1368c93.0409180015.718465e6@.posting.google.c om...
> Hi,
> thanks for replying.
> There is no local and remote copy of the table, the table is only
> stored in the sql server and linked to the access MDB.
> Simple refresh wont do (tried it, via the access menubars).
> have any more suggestions?
> Thanks,
> Oren,
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:<414b53f6$0$27296$afc38c87@.news.easynet.co.uk>...
> > Hi
> > I can't say that I am an expert on access, but this sounds like the
> > recordset may need refreshing i.e someone has changed the record and
access
> > knows the local copy is out of date.
> > John
> > "Oren" <orentini@.hotmail.com> wrote in message
> > news:b1368c93.0409160909.128bae81@.posting.google.c om...
> > > Hi,
> > > I have an Access application with linked tables via ODBC to MSSQL
> > > server 2000.
> > > > Having a weird problem, probably something i've done while not being
> > > aware of (kinda newbie).
> > > > the last 20 records (and growing)of a specific table are locked - cant
> > > change them - ("another user is editing these records ... ").
> > > > I know for a fact that no one is editing records and yet no user can
> > > edit these last records in the MDB - including the administrator -
> > > while able to add new records.
> > > > Administrator able to edit records in the ADP (mssql server) where the
> > > tables are stored.
> > > > Please help, the application is renedred inert .
> > > > Thanks for reading,
> > > Oren.

Problem with update tables on linked Sybase server

While working on MsSQL 2000 I'm trying to update table on remote server
(Sybase)
Here is the description of remote table (Sybase)
IF OBJECT_ID('adm.TransClient') IS NOT NULL
drop table adm.TransClient
go
CREATE TABLE adm.TransClient
(
CUST_ID numeric(10,0) NOT NULL,
NAME varchar(254) NOT NULL,
ADR1 varchar(254) NOT NULL,
ADR2 varchar(254) NOT NULL,
CREDIT numeric(17,9) NOT NULL,
SALES varchar(30) NOT NULL,
INN varchar(30) NULL,
TYPEC smallint NOT NULL,
NO_NDS smallint NOT NULL,
NUM_DOG varchar(20) NOT NULL,
LOGIN varchar(16) NOT NULL,
BusinessGroup numeric(10,0) DEFAULT 0 NOT NULL,
TransType varchar(20) DEFAULT "insert" NOT NULL,
TransDate datetime DEFAULT getdate() NOT NULL,
Transferred smallint DEFAULT 0 NOT NULL,
CONSTRAINT PK1
PRIMARY KEY NONCLUSTERED (CUST_ID)
)
LOCK datarows
go
1. Doing like this
update BILLING_ASE12.billing.adm.TransClient
set [Transferred]=1
MsSQL returns:
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Query-based update failed because the row
to update could not be found.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::SetData
returned 0x80004005: ].
2. Second atempt
update BILLING_ASE12.billing.adm.TransClient
set [Transferred]=1 where CUST_ID=7
MsSQL returns:
1 row affected
3. Final shoot - I wrote simpliest cursor that goes throw rows and sets
Transferred=1
Althogh MsSQL has returned:
Remote tables are not updatable. Updatable keyset-driven cursors on remote
tables require a transaction with the REPEATABLE_READ or SERIALIZABLE
isolation level spanning the cursor.
After that
select count(*) from BILLING_ASE12.billing.adm.TransClient = 300
select count(*) from BILLING_ASE12.billing.adm.TransClient where
Transferred=1 = 202 !!!!!!!
select count(*) from BILLING_ASE12.billing.adm.TransClient where
Transferred=0 = 48 !!!!!!!!
No comments from my side - simply do not understand what is going on
Any answers are appreciated
Hi
0x80004005 = Access Denied. Check that you have permissions on the
destination server for what you are doing.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Viacheslav" <Viacheslav@.discussions.microsoft.com> wrote in message
news:2F06080B-EEC4-4D91-A133-AE0C3E3923B6@.microsoft.com...
> While working on MsSQL 2000 I'm trying to update table on remote server
> (Sybase)
> Here is the description of remote table (Sybase)
> IF OBJECT_ID('adm.TransClient') IS NOT NULL
> drop table adm.TransClient
> go
> CREATE TABLE adm.TransClient
> (
> CUST_ID numeric(10,0) NOT NULL,
> NAME varchar(254) NOT NULL,
> ADR1 varchar(254) NOT NULL,
> ADR2 varchar(254) NOT NULL,
> CREDIT numeric(17,9) NOT NULL,
> SALES varchar(30) NOT NULL,
> INN varchar(30) NULL,
> TYPEC smallint NOT NULL,
> NO_NDS smallint NOT NULL,
> NUM_DOG varchar(20) NOT NULL,
> LOGIN varchar(16) NOT NULL,
> BusinessGroup numeric(10,0) DEFAULT 0 NOT NULL,
> TransType varchar(20) DEFAULT "insert" NOT NULL,
> TransDate datetime DEFAULT getdate() NOT NULL,
> Transferred smallint DEFAULT 0 NOT NULL,
> CONSTRAINT PK1
> PRIMARY KEY NONCLUSTERED (CUST_ID)
> )
> LOCK datarows
> go
> 1. Doing like this
> update BILLING_ASE12.billing.adm.TransClient
> set [Transferred]=1
> MsSQL returns:
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: Query-based update failed because the
row
> to update could not be found.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::SetData
> returned 0x80004005: ].
> 2. Second atempt
> update BILLING_ASE12.billing.adm.TransClient
> set [Transferred]=1 where CUST_ID=7
> MsSQL returns:
> 1 row affected
>
> 3. Final shoot - I wrote simpliest cursor that goes throw rows and sets
> Transferred=1
> Althogh MsSQL has returned:
> --
> Remote tables are not updatable. Updatable keyset-driven cursors on remote
> tables require a transaction with the REPEATABLE_READ or SERIALIZABLE
> isolation level spanning the cursor.
> --
> After that
> select count(*) from BILLING_ASE12.billing.adm.TransClient = 300
> select count(*) from BILLING_ASE12.billing.adm.TransClient where
> Transferred=1 = 202 !!!!!!!
> select count(*) from BILLING_ASE12.billing.adm.TransClient where
> Transferred=0 = 48 !!!!!!!!
> No comments from my side - simply do not understand what is going on
> Any answers are appreciated
|||Surely I have access to this server
Otherwise I couldn't do
update no.2
(update BILLING_ASE12.billing.adm.TransClient
set [Transferred]=1 where CUST_ID=7)
that completed successfully
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> 0x80004005 = Access Denied. Check that you have permissions on the
> destination server for what you are doing.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Viacheslav" <Viacheslav@.discussions.microsoft.com> wrote in message
> news:2F06080B-EEC4-4D91-A133-AE0C3E3923B6@.microsoft.com...
> row
>
>

Problem with update tables on linked Sybase server

While working on MsSQL 2000 I'm trying to update table on remote server
(Sybase)
Here is the description of remote table (Sybase)
IF OBJECT_ID('adm.TransClient') IS NOT NULL
drop table adm.TransClient
go
CREATE TABLE adm.TransClient
(
CUST_ID numeric(10,0) NOT NULL,
NAME varchar(254) NOT NULL,
ADR1 varchar(254) NOT NULL,
ADR2 varchar(254) NOT NULL,
CREDIT numeric(17,9) NOT NULL,
SALES varchar(30) NOT NULL,
INN varchar(30) NULL,
TYPEC smallint NOT NULL,
NO_NDS smallint NOT NULL,
NUM_DOG varchar(20) NOT NULL,
LOGIN varchar(16) NOT NULL,
BusinessGroup numeric(10,0) DEFAULT 0 NOT NULL,
TransType varchar(20) DEFAULT "insert" NOT NULL,
TransDate datetime DEFAULT getdate() NOT NULL,
Transferred smallint DEFAULT 0 NOT NULL,
CONSTRAINT PK1
PRIMARY KEY NONCLUSTERED (CUST_ID)
)
LOCK datarows
go
1. Doing like this
update BILLING_ASE12.billing.adm.TransClient
set [Transferred]=1
MsSQL returns:
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Query-based update failed because the
row
to update could not be found.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::SetData
returned 0x80004005: ].
2. Second atempt
update BILLING_ASE12.billing.adm.TransClient
set [Transferred]=1 where CUST_ID=7
MsSQL returns:
1 row affected
3. Final shoot - I wrote simpliest cursor that goes throw rows and sets
Transferred=1
Althogh MsSQL has returned:
--
Remote tables are not updatable. Updatable keyset-driven cursors on remote
tables require a transaction with the REPEATABLE_READ or SERIALIZABLE
isolation level spanning the cursor.
--
After that
select count(*) from BILLING_ASE12.billing.adm.TransClient = 300
select count(*) from BILLING_ASE12.billing.adm.TransClient where
Transferred=1 = 202 !!!!!!!
select count(*) from BILLING_ASE12.billing.adm.TransClient where
Transferred=0 = 48 !!!!!!!!
No comments from my side - simply do not understand what is going on
Any answers are appreciatedHi
0x80004005 = Access Denied. Check that you have permissions on the
destination server for what you are doing.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Viacheslav" <Viacheslav@.discussions.microsoft.com> wrote in message
news:2F06080B-EEC4-4D91-A133-AE0C3E3923B6@.microsoft.com...
> While working on MsSQL 2000 I'm trying to update table on remote server
> (Sybase)
> Here is the description of remote table (Sybase)
> IF OBJECT_ID('adm.TransClient') IS NOT NULL
> drop table adm.TransClient
> go
> CREATE TABLE adm.TransClient
> (
> CUST_ID numeric(10,0) NOT NULL,
> NAME varchar(254) NOT NULL,
> ADR1 varchar(254) NOT NULL,
> ADR2 varchar(254) NOT NULL,
> CREDIT numeric(17,9) NOT NULL,
> SALES varchar(30) NOT NULL,
> INN varchar(30) NULL,
> TYPEC smallint NOT NULL,
> NO_NDS smallint NOT NULL,
> NUM_DOG varchar(20) NOT NULL,
> LOGIN varchar(16) NOT NULL,
> BusinessGroup numeric(10,0) DEFAULT 0 NOT NULL,
> TransType varchar(20) DEFAULT "insert" NOT NULL,
> TransDate datetime DEFAULT getdate() NOT NULL,
> Transferred smallint DEFAULT 0 NOT NULL,
> CONSTRAINT PK1
> PRIMARY KEY NONCLUSTERED (CUST_ID)
> )
> LOCK datarows
> go
> 1. Doing like this
> update BILLING_ASE12.billing.adm.TransClient
> set [Transferred]=1
> MsSQL returns:
> OLE DB provider 'MSDASQL' reported an error.
> [OLE/DB provider returned message: Query-based update failed because the[/vbco
l]
row[vbcol=seagreen]
> to update could not be found.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::SetData
> returned 0x80004005: ].
> 2. Second atempt
> update BILLING_ASE12.billing.adm.TransClient
> set [Transferred]=1 where CUST_ID=7
> MsSQL returns:
> 1 row affected
>
> 3. Final shoot - I wrote simpliest cursor that goes throw rows and sets
> Transferred=1
> Althogh MsSQL has returned:
> --
> Remote tables are not updatable. Updatable keyset-driven cursors on remote
> tables require a transaction with the REPEATABLE_READ or SERIALIZABLE
> isolation level spanning the cursor.
> --
> After that
> select count(*) from BILLING_ASE12.billing.adm.TransClient = 300
> select count(*) from BILLING_ASE12.billing.adm.TransClient where
> Transferred=1 = 202 !!!!!!!
> select count(*) from BILLING_ASE12.billing.adm.TransClient where
> Transferred=0 = 48 !!!!!!!!
> No comments from my side - simply do not understand what is going on
> Any answers are appreciated|||Surely I have access to this server
Otherwise I couldn't do
update no.2
(update BILLING_ASE12.billing.adm.TransClient
set [Transferred]=1 where CUST_ID=7)
that completed successfully
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> 0x80004005 = Access Denied. Check that you have permissions on the
> destination server for what you are doing.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Viacheslav" <Viacheslav@.discussions.microsoft.com> wrote in message
> news:2F06080B-EEC4-4D91-A133-AE0C3E3923B6@.microsoft.com...
> row
>
>