Error when trying to update

Hi All
I get this error when i open a specific table from enterprise manager and
try to update values in it.
Data has changed since the results pane was last updated. Do you want to
save your changes now?
Click Yes to save your chnages and update the database.
Click No to discard your changes and refresh the results pane.
Click Cancel to continue editing.
If i click Yes which is of course what i wnated to do from the begining i
get this error:
Row cannot be located for updating.Some values may have been changed since
it was last Read.
So i was wonderring if anybody can give me some help with that.
Thanks in Advance
Naderseems like someone else already made a change to your data or that you are
trying to make a change to a key value that is used by em to locate the
record you want to update
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Nader Galal" <ngalal@.health-insights.com> wrote in message
news:uNxO%23CD1DHA.3224@.tk2msftngp13.phx.gbl...

quote:

---

> Hi All
> I get this error when i open a specific table from enterprise manager and
> try to update values in it.
> Data has changed since the results pane was last updated. Do you want to
> save your changes now?
> Click Yes to save your chnages and update the database.
> Click No to discard your changes and refresh the results pane.
> Click Cancel to continue editing.
> If i click Yes which is of course what i wnated to do from the begining i
> get this error:
> Row cannot be located for updating.Some values may have been changed since
> it was last Read.
> So i was wonderring if anybody can give me some help with that.
> Thanks in Advance
> Nader
>

---

sql

Error when setting MSDTC to autostart

Hi!
I'm getting an error message when I try to set autostart MSDTC in Enterprise manager. This problem just suddenly appered.
Error message:
Error 22002: RegCreateKeyEx() returned error5, 'Access is denied'
I hope somebody can tell me what this is :)Ensure the account used to start SQL Server services and MSDTC have necessary privileges to access the registry key and server.

Also, if you're using the DOMAIN account that you are trying to run the SQL services under must also have privlages to that machine. You must add that account to the local machine, such as the admin group.

If possible to restart the services and BTW what is the level of SQL service pack?sql

Error when refreshing Taskpad view

When the view of a database in Enterprise Manager has been
set to "Taskpad", and this database is selected, there is
a script error reported the first time. After the error is
issued, you have to change the view to somethinh else
before you can succesfully access the Taskpad view. Does
anybody know how to correct this error?
I recall that being a bug....?
"Wilbert" <anonymous@.discussions.microsoft.com> wrote in message
news:01b101c426a9$aedacd40$3501280a@.phx.gbl...
> When the view of a database in Enterprise Manager has been
> set to "Taskpad", and this database is selected, there is
> a script error reported the first time. After the error is
> issued, you have to change the view to somethinh else
> before you can succesfully access the Taskpad view. Does
> anybody know how to correct this error?
|||I can't seem to find any documentation on it (Knowledge
Base), and I've got SP3a installed.

> I recall that being a bug....?
>
|||It's a bug with Internet Explorer (components of which are used to drive the
Taskpad) rather than SQL Server, so check that you got the latest IE patch.
Jacco Schalkwijk
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:173401c426b5$27640960$a301280a@.phx.gbl...
> I can't seem to find any documentation on it (Knowledge
> Base), and I've got SP3a installed.
>
|||I use Windows Server 2003 with IE 6 as a platform. There
are no updates available through Windows Update. Now what?

>--Original Message--
>It's a bug with Internet Explorer (components of which
are used to drive the
>Taskpad) rather than SQL Server, so check that you got
the latest IE patch.
>--
>Jacco Schalkwijk
>SQL Server MVP
|||Its a known bug, which to my knowledge has not been fixed and the workaround
is to select a different view as you have stated. Since it has been around
for such a long time I wouldn't hold your breath about it being fixed
anytime soon.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:1f8001c4276a$fbfec150$a101280a@.phx.gbl...
> I use Windows Server 2003 with IE 6 as a platform. There
> are no updates available through Windows Update. Now what?
>
> are used to drive the
> the latest IE patch.
>

Error when executing a distributed query on a linked server

Hi,
It's a repost of an old thread with more information included
I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits. I've
been trying to link a sql server 2000 SP4 to this but I'm having some
troubles. When creating the linked server from the Sql Server Management
Studio/New Linked Server I choosed Server type to be "SQL Server" for the 2K
linked server. The linked server was created. Then I go to
Properties/Security and configure the linked server to be accesed as sa. But
when I run a distributed query like
Select * from linkedserver.database.dbo.table I get the error:
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "SQLNCLI" for linked server "sqlservhpold" reported an
error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 2
Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked
server "sqlservhpold". A four-part name was supplied, but the provider does
not expose the necessary interfaces to use a catalog or schema.
I tested the link by using sp_testlinkedserver and it returns no failure.
I also created a linked server in the reverse. I mean let server A be the
Sql Server 2005 64 bits Enterprise, and server B be a Sql Server 2000
Standard. I'm in A making B as linked server and trying to make a
distributed query from A to B (Select * from B.database.dbo.table) and this
fails. I tryed in B create A as a linked server. Then I made a distributed
query from B to A (Select * from A.database.dbo.table) and it works as
expected.
The most frustrating is the message that error 7399 returns: "The provider
did not give any information about the error." I cn not find nothing about
such an error message...
Any hint is welcomed
Thanks in advance
SammySammyBar (sammybar@.gmail.com) writes:
> I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits.
> I've been trying to link a sql server 2000 SP4 to this but I'm having
> some troubles. When creating the linked server from the Sql Server
> Management Studio/New Linked Server I choosed Server type to be "SQL
> Server" for the 2K linked server. The linked server was created. Then I
> go to Properties/Security and configure the linked server to be accesed
> as sa. But when I run a distributed query like
> Select * from linkedserver.database.dbo.table I get the error:
> Msg 7399, Level 16, State 1, Line 2
> The OLE DB provider "SQLNCLI" for linked server "sqlservhpold" reported an
> error. The provider did not give any information about the error.
> Msg 7312, Level 16, State 1, Line 2
> Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked
> server "sqlservhpold". A four-part name was supplied, but the provider
> does not expose the necessary interfaces to use a catalog or schema.
Can you double check the SQL 2000 instance, by doing SELECT @.@.version?
I seem to recall that to run linked queries from SQL 2005 to SQL 2000,
the latter needs some catalog procedures that comes with SP4, or possbly
SP2.
Also the exact command you use to create the linked server could be of
interest.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Error when executing a distributed query on a linked server

Hi,
It's a repost of an old thread with more information included
I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits. I've
been trying to link a sql server 2000 SP4 to this but I'm having some
troubles. When creating the linked server from the Sql Server Management
Studio/New Linked Server I choosed Server type to be "SQL Server" for the 2K
linked server. The linked server was created. Then I go to
Properties/Security and configure the linked server to be accesed as sa. But
when I run a distributed query like
Select * from linkedserver.database.dbo.table I get the error:
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "SQLNCLI" for linked server "sqlservhpold" reported an
error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 2
Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked
server "sqlservhpold". A four-part name was supplied, but the provider does
not expose the necessary interfaces to use a catalog or schema.
I tested the link by using sp_testlinkedserver and it returns no failure.
I also created a linked server in the reverse. I mean let server A be the
Sql Server 2005 64 bits Enterprise, and server B be a Sql Server 2000
Standard. I'm in A making B as linked server and trying to make a
distributed query from A to B (Select * from B.database.dbo.table) and this
fails. I tryed in B create A as a linked server. Then I made a distributed
query from B to A (Select * from A.database.dbo.table) and it works as
expected.
The most frustrating is the message that error 7399 returns: "The provider
did not give any information about the error." I cn not find nothing about
such an error message...
Any hint is welcomed
Thanks in advance
SammySammyBar (sammybar@.gmail.com) writes:
> I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits.
> I've been trying to link a sql server 2000 SP4 to this but I'm having
> some troubles. When creating the linked server from the Sql Server
> Management Studio/New Linked Server I choosed Server type to be "SQL
> Server" for the 2K linked server. The linked server was created. Then I
> go to Properties/Security and configure the linked server to be accesed
> as sa. But when I run a distributed query like
> Select * from linkedserver.database.dbo.table I get the error:
> Msg 7399, Level 16, State 1, Line 2
> The OLE DB provider "SQLNCLI" for linked server "sqlservhpold" reported an
> error. The provider did not give any information about the error.
> Msg 7312, Level 16, State 1, Line 2
> Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked
> server "sqlservhpold". A four-part name was supplied, but the provider
> does not expose the necessary interfaces to use a catalog or schema.
Can you double check the SQL 2000 instance, by doing SELECT @.@.version?
I seem to recall that to run linked queries from SQL 2005 to SQL 2000,
the latter needs some catalog procedures that comes with SP4, or possbly
SP2.
Also the exact command you use to create the linked server could be of
interest.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

error when connecting trhough enterprise manager

hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to windows Xp and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connection. the
connection's current state is closed.
i've checked network connection ..it is ok.
the same application we've tested at office ...its working fine.
plz advise
kryshzt
Hi
Are you sure? This error's message is pretty clear, isn't it?
"kryshzt" <kryshzt@.discussions.microsoft.com> wrote in message
news:8636B1D3-80F7-40C7-A384-3DC1E6E9C8ED@.microsoft.com...
> hi all ,
> i've got an application with sql databse. it runs correctly on the server.
> when i go to windows Xp and installed the appliaction and run the sql
> enterprise manager to connect to the server, i get the following error:
> message =: ExecuteReader requires an open and available connection. the
> connection's current state is closed.
> i've checked network connection ..it is ok.
> the same application we've tested at office ...its working fine.
> plz advise
> kryshzt

error when connecting trhough enterprise manager

hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to Windows XP and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connection. the
connection's current state is closed.
i've checked network connection ..it is ok.
the same application we've tested at office ...its working fine.
plz advise
kryshztHi
Are you sure? This error's message is pretty clear, isn't it?
"kryshzt" <kryshzt@.discussions.microsoft.com> wrote in message
news:8636B1D3-80F7-40C7-A384-3DC1E6E9C8ED@.microsoft.com...
> hi all ,
> i've got an application with sql databse. it runs correctly on the server.
> when i go to Windows XP and installed the appliaction and run the sql
> enterprise manager to connect to the server, i get the following error:
> message =: ExecuteReader requires an open and available connection. the
> connection's current state is closed.
> i've checked network connection ..it is ok.
> the same application we've tested at office ...its working fine.
> plz advise
> kryshzt

error when connecting trhough enterprise manager

hi all ,
i've got an application with sql databse. it runs correctly on the server.
when i go to windows Xp and installed the appliaction and run the sql
enterprise manager to connect to the server, i get the following error:
message =: ExecuteReader requires an open and available connection. the
connection's current state is closed.
i've checked network connection ..it is ok.
the same application we've tested at office ...its working fine.
plz advise
kryshztHi
Are you sure? This error's message is pretty clear, isn't it?
"kryshzt" <kryshzt@.discussions.microsoft.com> wrote in message
news:8636B1D3-80F7-40C7-A384-3DC1E6E9C8ED@.microsoft.com...
> hi all ,
> i've got an application with sql databse. it runs correctly on the server.
> when i go to windows Xp and installed the appliaction and run the sql
> enterprise manager to connect to the server, i get the following error:
> message =: ExecuteReader requires an open and available connection. the
> connection's current state is closed.
> i've checked network connection ..it is ok.
> the same application we've tested at office ...its working fine.
> plz advise
> kryshzt

Error Validating Formula for Column

Hi,
I have three fields APPLICANT_FIRST_NAME, APPLICANT_LAST_NAME and
APPLICANT_NAME
While designing table in sql enterprise manager I am inserting
"APPLICANT_FIRST_NAME & APPLICANT_LAST_NAME" for Formula Value of
APPLICANT_NAME field
But I am getting the following error
"Error Validating Formula for Column"
I need a field APPLICANT_NAME that has both values APPLICANT_FIRST_NAME and
APPLICANT_LAST_NAME in it
Can someone help me
Thanks
Ponnurangam
Hi
Your question is answered in .programming group. Don't multi-post.
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:eSljuKsqEHA.3416@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have three fields APPLICANT_FIRST_NAME, APPLICANT_LAST_NAME and
> APPLICANT_NAME
> While designing table in sql enterprise manager I am inserting
> "APPLICANT_FIRST_NAME & APPLICANT_LAST_NAME" for Formula Value of
> APPLICANT_NAME field
> But I am getting the following error
> "Error Validating Formula for Column"
> I need a field APPLICANT_NAME that has both values APPLICANT_FIRST_NAME
and
> APPLICANT_LAST_NAME in it
> Can someone help me
> Thanks
> Ponnurangam
>
|||I get the same error even if use "+" instead of "&"
Any help is appreciated
Ponnurangam
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:<#lLB$NsqEHA.2732@.TK2MSFTNGP09.phx.gbl>...

> Hi

> Your question is answered in .programming group. Don't multi-post.

>

>

>

> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message

> news:eSljuKsqEHA.3416@.TK2MSFTNGP15.phx.gbl...
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]

> and
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]
[vbcol=seagreen]

>

>

Error Validating Formula for Column

Hi,
I have three fields APPLICANT_FIRST_NAME, APPLICANT_LAST_NAME and
APPLICANT_NAME
While designing table in sql enterprise manager I am inserting
"APPLICANT_FIRST_NAME & APPLICANT_LAST_NAME" for Formula Value of
APPLICANT_NAME field
But I am getting the following error
"Error Validating Formula for Column"
I need a field APPLICANT_NAME that has both values APPLICANT_FIRST_NAME and
APPLICANT_LAST_NAME in it
Can someone help me
Thanks
PonnurangamHi
Your question is answered in .programming group. Don't multi-post.
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:eSljuKsqEHA.3416@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have three fields APPLICANT_FIRST_NAME, APPLICANT_LAST_NAME and
> APPLICANT_NAME
> While designing table in sql enterprise manager I am inserting
> "APPLICANT_FIRST_NAME & APPLICANT_LAST_NAME" for Formula Value of
> APPLICANT_NAME field
> But I am getting the following error
> "Error Validating Formula for Column"
> I need a field APPLICANT_NAME that has both values APPLICANT_FIRST_NAME
and
> APPLICANT_LAST_NAME in it
> Can someone help me
> Thanks
> Ponnurangam
>

Error using EM to view data

Hi,
I have a rather annoying problem with enterprise manager. When I select
Open Table, then Select All Rows . or Select Top . I get the following error
from EM:
Provider cannot be found. It may not be properly installed.
This started a few days ago for no apparent reason. The problem seems to be
limited to my machine, and happens if I access the local data store (MSDE)
or that on other servers (full SQL Sever, ent. ed.). I'm running Win2k
(SP4) and the client tools I'm running are from SQL Server 2000 enterprise
edition (SP3).
All other functions seem to work in EM (such as creating / modifying tables,
etc), and I can access data through other applications on this machine (such
as Query Analyzer, VS.Net, etc).
Things I have tried include reinstalling the latest MDAC (2.8), uninstalling
and reinstalling SQL Server client tools + sp3, and using regsvr32 to
reregister some DLLs suggested in other postings.
One last thing - using Profiler and a different workstation, I noticed that
the Open Table, Select all rows. function starts a new application with a
separate login (the app name is listed as "MS SQLEM - Data Tools"). Does
anyone know anything about this?
TIA for any help anyone can provide.
-DH
I found the solution for this and I am posting it for the common good...
Using filemon and regmon (from sysinternals, nice products), I saw that MMC
was trying to use an old version
of the file msdasql.dll in winnt\system32 rather than the version MDAC
installed in
Program Files\Common Files\System\Ole DB
Using regsvr32 to unregister then re-register the newer file fixed the
problem. Since this file is part of MDAC, I would
have thought that reinsalling MDAC should have fixed the problem, but it
didn't. Ditto for SP4 for Win2k.
I hope this helps someone somewhere someday. -DH
"David Howard" <reply@.to.group> wrote in message
news:UvC8c.290$yN6.61@.newsread2.news.atl.earthlink .net...
> Hi,
> I have a rather annoying problem with enterprise manager. When I select
> Open Table, then Select All Rows . or Select Top . I get the following
error
> from EM:
> Provider cannot be found. It may not be properly installed.
>
> This started a few days ago for no apparent reason. The problem seems to
be
> limited to my machine, and happens if I access the local data store (MSDE)
> or that on other servers (full SQL Sever, ent. ed.). I'm running Win2k
> (SP4) and the client tools I'm running are from SQL Server 2000 enterprise
> edition (SP3).
>
> All other functions seem to work in EM (such as creating / modifying
tables,
> etc), and I can access data through other applications on this machine
(such
> as Query Analyzer, VS.Net, etc).
>
> Things I have tried include reinstalling the latest MDAC (2.8),
uninstalling
> and reinstalling SQL Server client tools + sp3, and using regsvr32 to
> reregister some DLLs suggested in other postings.
>
> One last thing - using Profiler and a different workstation, I noticed
that
> the Open Table, Select all rows. function starts a new application with a
> separate login (the app name is listed as "MS SQLEM - Data Tools"). Does
> anyone know anything about this?
>
> TIA for any help anyone can provide.
> -DH
>
|||It helped me, today.
Thanks a lot for your effort to solve this.
Andrew Arace

Error using EM to view data

Hi,
I have a rather annoying problem with enterprise manager. When I select
Open Table, then Select All Rows . or Select Top . I get the following error
from EM:
Provider cannot be found. It may not be properly installed.
This started a few days ago for no apparent reason. The problem seems to be
limited to my machine, and happens if I access the local data store (MSDE)
or that on other servers (full SQL Sever, ent. ed.). I'm running Win2k
(SP4) and the client tools I'm running are from SQL Server 2000 enterprise
edition (SP3).
All other functions seem to work in EM (such as creating / modifying tables,
etc), and I can access data through other applications on this machine (such
as Query Analyzer, VS.Net, etc).
Things I have tried include reinstalling the latest MDAC (2.8), uninstalling
and reinstalling SQL Server client tools + sp3, and using regsvr32 to
reregister some DLLs suggested in other postings.
One last thing - using Profiler and a different workstation, I noticed that
the Open Table, Select all rows. function starts a new application with a
separate login (the app name is listed as "MS SQLEM - Data Tools"). Does
anyone know anything about this?
TIA for any help anyone can provide.
-DHI found the solution for this and I am posting it for the common good...
Using filemon and regmon (from sysinternals, nice products), I saw that MMC
was trying to use an old version
of the file msdasql.dll in winnt\system32 rather than the version MDAC
installed in
Program Files\Common Files\System\Ole DB
Using regsvr32 to unregister then re-register the newer file fixed the
problem. Since this file is part of MDAC, I would
have thought that reinsalling MDAC should have fixed the problem, but it
didn't. Ditto for SP4 for Win2k.
I hope this helps someone somewhere someday. -DH
"David Howard" <reply@.to.group> wrote in message
news:UvC8c.290$yN6.61@.newsread2.news.atl.earthlink.net...
> Hi,
> I have a rather annoying problem with enterprise manager. When I select
> Open Table, then Select All Rows . or Select Top . I get the following
error
> from EM:
> Provider cannot be found. It may not be properly installed.
>
> This started a few days ago for no apparent reason. The problem seems to
be
> limited to my machine, and happens if I access the local data store (MSDE)
> or that on other servers (full SQL Sever, ent. ed.). I'm running Win2k
> (SP4) and the client tools I'm running are from SQL Server 2000 enterprise
> edition (SP3).
>
> All other functions seem to work in EM (such as creating / modifying
tables,
> etc), and I can access data through other applications on this machine
(such
> as Query Analyzer, VS.Net, etc).
>
> Things I have tried include reinstalling the latest MDAC (2.8),
uninstalling
> and reinstalling SQL Server client tools + sp3, and using regsvr32 to
> reregister some DLLs suggested in other postings.
>
> One last thing - using Profiler and a different workstation, I noticed
that
> the Open Table, Select all rows. function starts a new application with a
> separate login (the app name is listed as "MS SQLEM - Data Tools"). Does
> anyone know anything about this?
>
> TIA for any help anyone can provide.
> -DH
>|||It helped me, today.
Thanks a lot for your effort to solve this.
Andrew Arace

Error Trying to VIew data in table

When I try to view the data in a table on my SQL SErver 2000 Enterprise
manager, I get the following message
"Provider cannot be found. It may not be properly installed. I have SQL
2000 installed on my PC for the last 8 months and I have had no problems.
All of a sudden I get this
Any helpIMHO, you should view/manipulate your data in SQL Server's Query Analyzer.
At the very least, this will tell you whether the problem is with Enterprise
Manager, or more deeply rooted.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"dfoote" <dfoote@.napcosecurity.com> wrote in message
news:#bRWbQJrEHA.2788@.tk2msftngp13.phx.gbl...
> When I try to view the data in a table on my SQL SErver 2000 Enterprise
> manager, I get the following message
> "Provider cannot be found. It may not be properly installed. I have SQL
> 2000 installed on my PC for the last 8 months and I have had no problems.
> All of a sudden I get this
> Any help
>|||Thanks Aaron
I tried this and I am able to retrieve data via the Query Analyzer. So I
know it is Enterprise manager? Any more suggestion?
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eOTc6BLrEHA.2764@.TK2MSFTNGP11.phx.gbl...
> IMHO, you should view/manipulate your data in SQL Server's Query Analyzer.
> At the very least, this will tell you whether the problem is with
> Enterprise
> Manager, or more deeply rooted.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "dfoote" <dfoote@.napcosecurity.com> wrote in message
> news:#bRWbQJrEHA.2788@.tk2msftngp13.phx.gbl...
>> When I try to view the data in a table on my SQL SErver 2000 Enterprise
>> manager, I get the following message
>> "Provider cannot be found. It may not be properly installed. I have SQL
>> 2000 installed on my PC for the last 8 months and I have had no
>> problems.
>> All of a sudden I get this
>> Any help
>>
>|||Have you installed SP3a? Have you updated MDAC recently? If not, have you
considered doing these things?
And have you considered just using Query Analyzer?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"dfoote" <dfoote@.napcosecurity.com> wrote in message
news:uz$P$RLrEHA.3080@.TK2MSFTNGP15.phx.gbl...
> Thanks Aaron
> I tried this and I am able to retrieve data via the Query Analyzer. So I
> know it is Enterprise manager? Any more suggestion?
> "Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
> news:eOTc6BLrEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > IMHO, you should view/manipulate your data in SQL Server's Query
Analyzer.
> > At the very least, this will tell you whether the problem is with
> > Enterprise
> > Manager, or more deeply rooted.
> >
> > --
> > http://www.aspfaq.com/
> > (Reverse address to reply.)
> >
> >
> >
> >
> > "dfoote" <dfoote@.napcosecurity.com> wrote in message
> > news:#bRWbQJrEHA.2788@.tk2msftngp13.phx.gbl...
> >> When I try to view the data in a table on my SQL SErver 2000 Enterprise
> >> manager, I get the following message
> >> "Provider cannot be found. It may not be properly installed. I have
SQL
> >> 2000 installed on my PC for the last 8 months and I have had no
> >> problems.
> >> All of a sudden I get this
> >> Any help
> >>
> >>
> >
> >
>

Error trying to create Maintenance plan

We have a SQL server installation on a managed hosting environment and last night they upgraded our version from standard to enterprise. It looks as if they uninstalled, and then reinstalled. So now I need to re-configure our maintenance plans but when I try right-click on Maintenance Plans and select New Maintenance Plan in Management Studio I get the following error: An OLE DB error 0x800004005 occured while enumerating packages. A SQL statement was issued and failed.

I thought it had something to do with the new installation not running as a particular user/system account and the account it wass running under didnt have the proper permissions. As a smoke test I made the user it's running as (sqlservice) an admin in SQL Server, but that didnt fix the problem

Any help would be appreciated.Have you installed SSIS too in this case if that was also available previouslY?

error to register the msde2000 in enterprise manager

Hi all,
can anyone tell what can i do to register the msde in enterprise manager, it prompt me the 'sa' login fail. should the name pipe
protocol included or TCP/IP is already ok? thanks.
hi,
"CWeb@.office" <a@.b.com> ha scritto nel messaggio
news:%23AcFcAioEHA.4032@.TK2MSFTNGP15.phx.gbl
> Hi all,
> can anyone tell what can i do to register the msde in enterprise
> manager, it prompt me the 'sa' login fail. should the name pipe
> protocol included or TCP/IP is already ok? thanks.
MSDE installs by default allowing only trusted connections and not SQL
Server authenticated connections
in order to modify this behaviour at install time you have to pass the
additional parameter
SECURITYMODE = SQL
to the command line setup.exe boostrappert installer
you can have a look at
http://support.microsoft.com/default...b;en-us;285097 for
additional information about that, including further info on how to change
this setting after install hacking the windows registry
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

error to executing job on Sql Server Enterprise Manager

... DTSRun: Executing... DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart:
DTSStep_DTSDataPumpTask_2 DTSRun OnError:
DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error
string: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file
e:\private.dbc. Error source: Microsoft OLE DB Provider for ODBC
Drivers Help file: Help context: 0 Error Detail
Records: Error: -2147467259 (80004005); Provider Error: 171
(AB) Error string: [Microsoft][ODBC Visual FoxPro Driver]Cannot
open file e:\private.dbc. Error source: Microsoft OLE DB
Provider for ODBC Drivers Help file: Help context: 0
DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_3 DTSRun OnError: DTS... Process Exit Code
4. The step failed.

anyone know becaouse if i execute this job whit the Schedule package
dont work but i execute manually it's work ?

pls help me ...Initial guess would be that the account that is used for running SQL
Agent can not see e:\private.dbc... Double check what user account is
being used to run SQL Server service versus SQL Agent service and double
check permissions on the directory. Also, test what user accounts can
run the DTS package from Ent Man. It may be that the system or service
account can not run the scheduled job because service account does not
have access where as your account does via Ent Man.

Maurizio Amoroso wrote:
> ... DTSRun: Executing... DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_2 DTSRun OnError:
> DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error
> string: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file
> e:\private.dbc. Error source: Microsoft OLE DB Provider for ODBC
> Drivers Help file: Help context: 0 Error Detail
> Records: Error: -2147467259 (80004005); Provider Error: 171
> (AB) Error string: [Microsoft][ODBC Visual FoxPro Driver]Cannot
> open file e:\private.dbc. Error source: Microsoft OLE DB
> Provider for ODBC Drivers Help file: Help context: 0
> DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_3 DTSRun OnError: DTS... Process Exit Code
> 4. The step failed.
> anyone know becaouse if i execute this job whit the Schedule package
> dont work but i execute manually it's work ?
> pls help me ...|||"Maurizio Amoroso" <maurizio.amoroso@.mlink.it> wrote in message
news:933ecd1c.0401280623.498fed23@.posting.google.c om...
> ... DTSRun: Executing... DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_2 DTSRun OnError:
> DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error
> string: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file
> e:\private.dbc. Error source: Microsoft OLE DB Provider for ODBC
> Drivers Help file: Help context: 0 Error Detail
> Records: Error: -2147467259 (80004005); Provider Error: 171
> (AB) Error string: [Microsoft][ODBC Visual FoxPro Driver]Cannot
> open file e:\private.dbc. Error source: Microsoft OLE DB
> Provider for ODBC Drivers Help file: Help context: 0
> DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_3 DTSRun OnError: DTS... Process Exit Code
> 4. The step failed.
> anyone know becaouse if i execute this job whit the Schedule package
> dont work but i execute manually it's work ?
> pls help me ...

Check out this KB article:

http://support.microsoft.com/defaul...4&Product=sql2k

The account running the job probably doesn't have access to E:\ (NTFS
permissions, unknown drive mapping), and the article explains quite well how
to work out what context the job is running in.

Simon

Error System.InvalidOperationException: Client found response cont

Hi, All.
I have a windows 2000 server machine with SQL Enterprise 2000 edition and
reporting service enterprise edition on it.
The Report Mangaer application and the Report Server Web service are both
working.
and i have a web application that makes calls against the reporting service
API.
and I get the following error regardless of any method I call.
System.InvalidOperationException: Client found response content type of
'text/html', but expected 'text/xml'. The request failed with the error
message: -- -2146893039 (0x80090311) --. at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
Recursive).
Can anyone help to explain what to do?
tksThe problem is you are getting back an html response rather then a SOAP
response (xml). Have you verified that the .Url property is correct set on
your proxy object?
The error you are seeing is:
No authority could be contacted for authentication.
Have you set the credentials property correctly?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hang" <Hang@.discussions.microsoft.com> wrote in message
news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> Hi, All.
> I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> reporting service enterprise edition on it.
> The Report Mangaer application and the Report Server Web service are both
> working.
> and i have a web application that makes calls against the reporting
> service
> API.
> and I get the following error regardless of any method I call.
> System.InvalidOperationException: Client found response content type of
> 'text/html', but expected 'text/xml'. The request failed with the error
> message: -- -2146893039 (0x80090311) --. at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at
> ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> Recursive).
>
> Can anyone help to explain what to do?
> tks
>|||Thanks for replying, Daniel
Yes. the .Url property is correct. I explicitly set it once i create a proxy
object.
here is a sample code
Dim rs As sqlReport.ReportingService
rs = New ReportingService
rs.Url = "http://severName/ReportServer/ReportService.asmx"
rs.Credentials = New NetworkCredential
("userName", "password", "theDomainName")
Dim c As CatalogItem() = rs.ListChildren("/", True)
that is the code code that throws the exception
by the way, On the same server, I used to have reporting service evaluation
edition and my application worked fine.
Then I got that problem after installing the official version(I uninstalled
the evalutiaon edition and deleted all the database associated with it before
installing).
tks.
"Daniel Reib [MSFT]" wrote:
> The problem is you are getting back an html response rather then a SOAP
> response (xml). Have you verified that the .Url property is correct set on
> your proxy object?
> The error you are seeing is:
> No authority could be contacted for authentication.
> Have you set the credentials property correctly?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Hang" <Hang@.discussions.microsoft.com> wrote in message
> news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> > Hi, All.
> > I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> > reporting service enterprise edition on it.
> >
> > The Report Mangaer application and the Report Server Web service are both
> > working.
> > and i have a web application that makes calls against the reporting
> > service
> > API.
> > and I get the following error regardless of any method I call.
> >
> > System.InvalidOperationException: Client found response content type of
> > 'text/html', but expected 'text/xml'. The request failed with the error
> > message: -- -2146893039 (0x80090311) --. at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at
> > ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> > Recursive).
> >
> >
> > Can anyone help to explain what to do?
> >
> > tks
> >
>
>|||Just to follow up on this. It turned out it was an credential problem in this
case.
The web server, which hosts the web application, needs to be in the same
domain as that of the web server hosting the reporting services web service.
And a proper domain account is needed for accessing the reporting services
web service in this case.
hope this helps others who have encountered similiar problems.
Tks
"Hang" wrote:
> Thanks for replying, Daniel
> Yes. the .Url property is correct. I explicitly set it once i create a proxy
> object.
> here is a sample code
> Dim rs As sqlReport.ReportingService
> rs = New ReportingService
> rs.Url = "http://severName/ReportServer/ReportService.asmx"
> rs.Credentials = New NetworkCredential
> ("userName", "password", "theDomainName")
> Dim c As CatalogItem() = rs.ListChildren("/", True)
> that is the code code that throws the exception
> by the way, On the same server, I used to have reporting service evaluation
> edition and my application worked fine.
> Then I got that problem after installing the official version(I uninstalled
> the evalutiaon edition and deleted all the database associated with it before
> installing).
>
> tks.
> "Daniel Reib [MSFT]" wrote:
> > The problem is you are getting back an html response rather then a SOAP
> > response (xml). Have you verified that the .Url property is correct set on
> > your proxy object?
> >
> > The error you are seeing is:
> >
> > No authority could be contacted for authentication.
> >
> > Have you set the credentials property correctly?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Hang" <Hang@.discussions.microsoft.com> wrote in message
> > news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> > > Hi, All.
> > > I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> > > reporting service enterprise edition on it.
> > >
> > > The Report Mangaer application and the Report Server Web service are both
> > > working.
> > > and i have a web application that makes calls against the reporting
> > > service
> > > API.
> > > and I get the following error regardless of any method I call.
> > >
> > > System.InvalidOperationException: Client found response content type of
> > > 'text/html', but expected 'text/xml'. The request failed with the error
> > > message: -- -2146893039 (0x80090311) --. at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters) at
> > > ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> > > Recursive).
> > >
> > >
> > > Can anyone help to explain what to do?
> > >
> > > tks
> > >
> >
> >
> >

error setting up publication

Hello,
I am trying to setup merge publication and receive the following
error:
SQL Server Enterprise Manager could not configure 'DEV' as the
Distributor for 'DEV'.
Error 18483: Could not connect to server 'DEV' because
'distributor_admin' is not defined as a remote login at the server.
Im stumped on this one.
Todd
Are you using an IP address to set up replication across domains? If so then
you'll need to use an alias instead.
Does SELECT@.@.Servername return a different name to your server select
SERVERPROPERTY('ServerName').
If so then you need to run:
Use Master
go
Sp_DropServer 'Server1'
GO
Use Master
go
Sp_Addserver 'Server1', 'local'
GO
Stop and Start SQL Services
Regards,
Paul Ibison