Pleeeease help? I get an error when expanding the Tables object under linked servers in Enterprise Manager on a MSSQL2000 server.
I have a standard install of the Pervasive.SQL V8 data engine and DemoData db on my local PC. The SQL Server is also on my local PC.
I manage to create the Linked Server using the MSSQL Enterprise Manager. I used the following configuration:
Provider Name: Pervasive.SQL V8 OLE DB Provider
Product Name: Pervasive.SQL V8
Data source: DemoData
Provider string: <blank>
Location: workstation03
Catalog: <blank>
However when I try to expand the tables object under Linked Servers in the Enterprise manager I get the following error.
Error 7311: Could not obtain the schema rowset for the OLE DB provider 'UNKNOWN'. The provider supports the interface, but retuns a failure code when it is used. OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchemaRowset::GetRowset returned 0x80040155 ].
How would I fix this?
Thank you.moving to microsoft sql server forumsql
Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts
Thursday, March 29, 2012
Wednesday, March 21, 2012
Error Data bases not compatible, Installation Reporting services
Hi,
I install Report services (standard, developer, enterprise edition) on sql
server 2000 personal edition, and windows 2003 server enterprise, during the
installation, when creating the data base sends the following message of
error "This version of the data base of the Reporting services is not
compatible with the version of SQL server 2000"
all the scene this in Spanish language.
I do not understand because, help me please.
excuse I do not speak ingles, thanksYou are posting the same problem multiple times. The answer will be the
same. Personal edition will not work. See my other post which has links to
the MS website that documents this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Arturo Alegria Palacios" <Arturo Alegria
Palacios@.discussions.microsoft.com> wrote in message
news:89C41CA4-B525-49B2-980D-BB39CDE4E018@.microsoft.com...
> Hi,
> I install Report services (standard, developer, enterprise edition) on sql
> server 2000 personal edition, and windows 2003 server enterprise, during
> the
> installation, when creating the data base sends the following message of
> error "This version of the data base of the Reporting services is not
> compatible with the version of SQL server 2000"
> all the scene this in Spanish language.
> I do not understand because, help me please.
> excuse I do not speak ingles, thanks|||Thanks bruce, I am going to verify the documentation of website, will verify
the scene where this executing itself now
"Bruce L-C [MVP]" wrote:
> You are posting the same problem multiple times. The answer will be the
> same. Personal edition will not work. See my other post which has links to
> the MS website that documents this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Arturo Alegria Palacios" <Arturo Alegria
> Palacios@.discussions.microsoft.com> wrote in message
> news:89C41CA4-B525-49B2-980D-BB39CDE4E018@.microsoft.com...
> > Hi,
> > I install Report services (standard, developer, enterprise edition) on sql
> > server 2000 personal edition, and windows 2003 server enterprise, during
> > the
> > installation, when creating the data base sends the following message of
> > error "This version of the data base of the Reporting services is not
> > compatible with the version of SQL server 2000"
> >
> > all the scene this in Spanish language.
> >
> > I do not understand because, help me please.
> >
> > excuse I do not speak ingles, thanks
>
>
I install Report services (standard, developer, enterprise edition) on sql
server 2000 personal edition, and windows 2003 server enterprise, during the
installation, when creating the data base sends the following message of
error "This version of the data base of the Reporting services is not
compatible with the version of SQL server 2000"
all the scene this in Spanish language.
I do not understand because, help me please.
excuse I do not speak ingles, thanksYou are posting the same problem multiple times. The answer will be the
same. Personal edition will not work. See my other post which has links to
the MS website that documents this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Arturo Alegria Palacios" <Arturo Alegria
Palacios@.discussions.microsoft.com> wrote in message
news:89C41CA4-B525-49B2-980D-BB39CDE4E018@.microsoft.com...
> Hi,
> I install Report services (standard, developer, enterprise edition) on sql
> server 2000 personal edition, and windows 2003 server enterprise, during
> the
> installation, when creating the data base sends the following message of
> error "This version of the data base of the Reporting services is not
> compatible with the version of SQL server 2000"
> all the scene this in Spanish language.
> I do not understand because, help me please.
> excuse I do not speak ingles, thanks|||Thanks bruce, I am going to verify the documentation of website, will verify
the scene where this executing itself now
"Bruce L-C [MVP]" wrote:
> You are posting the same problem multiple times. The answer will be the
> same. Personal edition will not work. See my other post which has links to
> the MS website that documents this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Arturo Alegria Palacios" <Arturo Alegria
> Palacios@.discussions.microsoft.com> wrote in message
> news:89C41CA4-B525-49B2-980D-BB39CDE4E018@.microsoft.com...
> > Hi,
> > I install Report services (standard, developer, enterprise edition) on sql
> > server 2000 personal edition, and windows 2003 server enterprise, during
> > the
> > installation, when creating the data base sends the following message of
> > error "This version of the data base of the Reporting services is not
> > compatible with the version of SQL server 2000"
> >
> > all the scene this in Spanish language.
> >
> > I do not understand because, help me please.
> >
> > excuse I do not speak ingles, thanks
>
>
Sunday, February 19, 2012
Error backuping up database to tape.
I am trying to backup a database to tape. I'm using Microsoft SQL Server 2000 Enterprise Edition.
When I try to do the backup using Enterprise Manager I see the following message:
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot open backup device '\\.\Tape0'. Device error or device off-line. See the SQL Server error log for more details.
BACKUP DATABASE is terminating abnormally.
In the Event Viewer is logged the following message:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 14/1/2004
Time: 10:29:20
User: N/A
Computer: MySQLName
Description:
18204 :
BackupTapeFile::OpenMedia: Backup device '\\.\Tape0' failed to open. Operating system error = 5(Access is denied.).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I can do the backup to disk normally, but I need to do to tape.
Please, help me to solve this issue.I found the solution for my problem.
There is some pre-requisites to run/install SQL Server. If SQL Server services are running with a Domain User Account, this account must be member of Administrators or Power Users group. I put the account that are running the services in Administrators group and my problem was solved. This pre-requisite is documented in SQL Server Books On Line.|||Don't mean to "preach" to you or anything, but I would keep backups to disk, and add a step to the job to backup the backup onto the tape afterwards. Many obvious things can go wrong if you do a direct dump onto the tape. It is also easier to restore a file from a tape onto the share, and then do a native restore from it, in case the server you're restoring to doesn't have a local tape drive. Otherwise, along with recovering the server you'll have to attach a local tape device to it, before you even get to see the backup of your database.
When I try to do the backup using Enterprise Manager I see the following message:
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot open backup device '\\.\Tape0'. Device error or device off-line. See the SQL Server error log for more details.
BACKUP DATABASE is terminating abnormally.
In the Event Viewer is logged the following message:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 14/1/2004
Time: 10:29:20
User: N/A
Computer: MySQLName
Description:
18204 :
BackupTapeFile::OpenMedia: Backup device '\\.\Tape0' failed to open. Operating system error = 5(Access is denied.).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I can do the backup to disk normally, but I need to do to tape.
Please, help me to solve this issue.I found the solution for my problem.
There is some pre-requisites to run/install SQL Server. If SQL Server services are running with a Domain User Account, this account must be member of Administrators or Power Users group. I put the account that are running the services in Administrators group and my problem was solved. This pre-requisite is documented in SQL Server Books On Line.|||Don't mean to "preach" to you or anything, but I would keep backups to disk, and add a step to the job to backup the backup onto the tape afterwards. Many obvious things can go wrong if you do a direct dump onto the tape. It is also easier to restore a file from a tape onto the share, and then do a native restore from it, in case the server you're restoring to doesn't have a local tape drive. Otherwise, along with recovering the server you'll have to attach a local tape device to it, before you even get to see the backup of your database.
Error backing up database to tape
I am trying to backup a database to tape. I'm using
Microsoft SQL Server 2000 Enterprise Edition and Windows
Server 2003.
When I try to do the backup using Enterprise Manager I see
the following message:
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot open backup device '\\.\Tape0'. Device error or
device off-line. See the SQL Server error log for more
details.
BACKUP DATABASE is terminating abnormally.
In the Event Viewer is logged the following message:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 14/1/2004
Time: 10:29:20
User: N/A
Computer: MySQLName
Description:
18204 :
BackupTapeFile::OpenMedia: Backup device '\\.\Tape0'
failed to open. Operating system error = 5(Access is
denied.).
If I try do it using OSQL (I want to do using OSQL), the
same error is logged on Event Viewer.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
I try use the Administrator user, but I get the same error.
I can do the backup to disk normally, but I need to do to
tape.
Can any one help me to solve this problem?
Thank you.Can't say I've tried backing up to tape directly.
Can you not backup to file & then backup to tape using NT Backup or similar?
I prefer to backup to file initially because it means I can normally restore
from file which is much faster than tape. Only if something goes wrong with
the file or server itself do I need to resort to the tape...
It sounds like it cannot find the media. Is the correct media inserted, with
the correct name?
Can you backup to this tape through NT backup or similar to verify it is
related to SQL Server & not Windows?
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||I need backup database directly to tape.
I'm using a tape that never was used and another tape,
that was used by NTBACKUP. I see the same error with
everyone.
I can use NTBACKUP to backup files to tape without
problems.
Backup or similar?
can normally restore
something goes wrong with
tape...
media inserted, with
to verify it is
Microsoft SQL Server 2000 Enterprise Edition and Windows
Server 2003.
When I try to do the backup using Enterprise Manager I see
the following message:
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot open backup device '\\.\Tape0'. Device error or
device off-line. See the SQL Server error log for more
details.
BACKUP DATABASE is terminating abnormally.
In the Event Viewer is logged the following message:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 14/1/2004
Time: 10:29:20
User: N/A
Computer: MySQLName
Description:
18204 :
BackupTapeFile::OpenMedia: Backup device '\\.\Tape0'
failed to open. Operating system error = 5(Access is
denied.).
If I try do it using OSQL (I want to do using OSQL), the
same error is logged on Event Viewer.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
I try use the Administrator user, but I get the same error.
I can do the backup to disk normally, but I need to do to
tape.
Can any one help me to solve this problem?
Thank you.Can't say I've tried backing up to tape directly.
Can you not backup to file & then backup to tape using NT Backup or similar?
I prefer to backup to file initially because it means I can normally restore
from file which is much faster than tape. Only if something goes wrong with
the file or server itself do I need to resort to the tape...
It sounds like it cannot find the media. Is the correct media inserted, with
the correct name?
Can you backup to this tape through NT backup or similar to verify it is
related to SQL Server & not Windows?
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||I need backup database directly to tape.
I'm using a tape that never was used and another tape,
that was used by NTBACKUP. I see the same error with
everyone.
I can use NTBACKUP to backup files to tape without
problems.
quote:
>--Original Message--
>Can't say I've tried backing up to tape directly.
>Can you not backup to file & then backup to tape using NT
Backup or similar?
quote:
>I prefer to backup to file initially because it means I
can normally restore
quote:
>from file which is much faster than tape. Only if
something goes wrong with
quote:
>the file or server itself do I need to resort to the
tape...
quote:
>It sounds like it cannot find the media. Is the correct
media inserted, with
quote:
>the correct name?
>Can you backup to this tape through NT backup or similar
to verify it is
quote:
>related to SQL Server & not Windows?
>
>--
>Cheers,
>
>James Goodman MCSE, MCDBA
>http://www.angelfire.com/sports/f1pictures
>
>.
>
Error backing up database to tape
I am trying to backup a database to tape. I'm using
Microsoft SQL Server 2000 Enterprise Edition and Windows
Server 2003.
When I try to do the backup using Enterprise Manager I see
the following message:
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot open backup device '\\.\Tape0'. Device error or
device off-line. See the SQL Server error log for more
details.
BACKUP DATABASE is terminating abnormally.
In the Event Viewer is logged the following message:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 14/1/2004
Time: 10:29:20
User: N/A
Computer: MySQLName
Description:
18204 :
BackupTapeFile::OpenMedia: Backup device '\\.\Tape0'
failed to open. Operating system error = 5(Access is
denied.).
If I try do it using OSQL (I want to do using OSQL), the
same error is logged on Event Viewer.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
I try use the Administrator user, but I get the same error.
I can do the backup to disk normally, but I need to do to
tape.
Can any one help me to solve this problem?
Thank you.Can't say I've tried backing up to tape directly.
Can you not backup to file & then backup to tape using NT Backup or similar?
I prefer to backup to file initially because it means I can normally restore
from file which is much faster than tape. Only if something goes wrong with
the file or server itself do I need to resort to the tape...
It sounds like it cannot find the media. Is the correct media inserted, with
the correct name?
Can you backup to this tape through NT backup or similar to verify it is
related to SQL Server & not Windows?
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||I need backup database directly to tape.
I'm using a tape that never was used and another tape,
that was used by NTBACKUP. I see the same error with
everyone.
I can use NTBACKUP to backup files to tape without
problems.
>--Original Message--
>Can't say I've tried backing up to tape directly.
>Can you not backup to file & then backup to tape using NT
Backup or similar?
>I prefer to backup to file initially because it means I
can normally restore
>from file which is much faster than tape. Only if
something goes wrong with
>the file or server itself do I need to resort to the
tape...
>It sounds like it cannot find the media. Is the correct
media inserted, with
>the correct name?
>Can you backup to this tape through NT backup or similar
to verify it is
>related to SQL Server & not Windows?
>
>--
>Cheers,
>
>James Goodman MCSE, MCDBA
>http://www.angelfire.com/sports/f1pictures
>
>.
>|||I found the solution for my problem.
There is some pre-requisites to run/install SQL Server. If
SQL Server services are running with a Domain User
Account, this account must be member of Administrators or
Power Users group. I put the account that are running the
services in Administrators group and my problem was
solved. This pre-requisite is documented in SQL Server
Books On Line.
>--Original Message--
>I am trying to backup a database to tape. I'm using
>Microsoft SQL Server 2000 Enterprise Edition and Windows
>Server 2003.
>When I try to do the backup using Enterprise Manager I
see
>the following message:
>Microsoft SQL-DMO (ODBC SQLState: 42000)
>Cannot open backup device '\\.\Tape0'. Device error or
>device off-line. See the SQL Server error log for more
>details.
>BACKUP DATABASE is terminating abnormally.
>
>In the Event Viewer is logged the following message:
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 14/1/2004
>Time: 10:29:20
>User: N/A
>Computer: MySQLName
>Description:
>18204 :
>BackupTapeFile::OpenMedia: Backup device '\\.\Tape0'
>failed to open. Operating system error = 5(Access is
>denied.).
>If I try do it using OSQL (I want to do using OSQL), the
>same error is logged on Event Viewer.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>I try use the Administrator user, but I get the same
error.
>I can do the backup to disk normally, but I need to do to
>tape.
>Can any one help me to solve this problem?
>Thank you.
>.
>
Microsoft SQL Server 2000 Enterprise Edition and Windows
Server 2003.
When I try to do the backup using Enterprise Manager I see
the following message:
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot open backup device '\\.\Tape0'. Device error or
device off-line. See the SQL Server error log for more
details.
BACKUP DATABASE is terminating abnormally.
In the Event Viewer is logged the following message:
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 14/1/2004
Time: 10:29:20
User: N/A
Computer: MySQLName
Description:
18204 :
BackupTapeFile::OpenMedia: Backup device '\\.\Tape0'
failed to open. Operating system error = 5(Access is
denied.).
If I try do it using OSQL (I want to do using OSQL), the
same error is logged on Event Viewer.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
I try use the Administrator user, but I get the same error.
I can do the backup to disk normally, but I need to do to
tape.
Can any one help me to solve this problem?
Thank you.Can't say I've tried backing up to tape directly.
Can you not backup to file & then backup to tape using NT Backup or similar?
I prefer to backup to file initially because it means I can normally restore
from file which is much faster than tape. Only if something goes wrong with
the file or server itself do I need to resort to the tape...
It sounds like it cannot find the media. Is the correct media inserted, with
the correct name?
Can you backup to this tape through NT backup or similar to verify it is
related to SQL Server & not Windows?
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||I need backup database directly to tape.
I'm using a tape that never was used and another tape,
that was used by NTBACKUP. I see the same error with
everyone.
I can use NTBACKUP to backup files to tape without
problems.
>--Original Message--
>Can't say I've tried backing up to tape directly.
>Can you not backup to file & then backup to tape using NT
Backup or similar?
>I prefer to backup to file initially because it means I
can normally restore
>from file which is much faster than tape. Only if
something goes wrong with
>the file or server itself do I need to resort to the
tape...
>It sounds like it cannot find the media. Is the correct
media inserted, with
>the correct name?
>Can you backup to this tape through NT backup or similar
to verify it is
>related to SQL Server & not Windows?
>
>--
>Cheers,
>
>James Goodman MCSE, MCDBA
>http://www.angelfire.com/sports/f1pictures
>
>.
>|||I found the solution for my problem.
There is some pre-requisites to run/install SQL Server. If
SQL Server services are running with a Domain User
Account, this account must be member of Administrators or
Power Users group. I put the account that are running the
services in Administrators group and my problem was
solved. This pre-requisite is documented in SQL Server
Books On Line.
>--Original Message--
>I am trying to backup a database to tape. I'm using
>Microsoft SQL Server 2000 Enterprise Edition and Windows
>Server 2003.
>When I try to do the backup using Enterprise Manager I
see
>the following message:
>Microsoft SQL-DMO (ODBC SQLState: 42000)
>Cannot open backup device '\\.\Tape0'. Device error or
>device off-line. See the SQL Server error log for more
>details.
>BACKUP DATABASE is terminating abnormally.
>
>In the Event Viewer is logged the following message:
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 14/1/2004
>Time: 10:29:20
>User: N/A
>Computer: MySQLName
>Description:
>18204 :
>BackupTapeFile::OpenMedia: Backup device '\\.\Tape0'
>failed to open. Operating system error = 5(Access is
>denied.).
>If I try do it using OSQL (I want to do using OSQL), the
>same error is logged on Event Viewer.
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>I try use the Administrator user, but I get the same
error.
>I can do the backup to disk normally, but I need to do to
>tape.
>Can any one help me to solve this problem?
>Thank you.
>.
>
Wednesday, February 15, 2012
Error accessing SQL 7.0 data via SQL Enterprise Manager 2000
Those are informational messages and can be ignored.
143339 INF: ODBC Messages on SQL Server Connections
http://support.microsoft.com/?id=143339
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks for your response. The issue that I am seeing after
these messages are displayed is that no data is returned
via Enterprise Manager. Any thoughts?
confers no rights.
143339 INF: ODBC Messages on SQL Server Connections
http://support.microsoft.com/?id=143339
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks for your response. The issue that I am seeing after
these messages are displayed is that no data is returned
via Enterprise Manager. Any thoughts?
quote:
>--Original Message--
>Those are informational messages and can be ignored.
>143339 INF: ODBC Messages on SQL Server Connections
>http://support.microsoft.com/?id=143339
>Cindy Gross, MCDBA, MCSE
>http://cindygross.tripod.com
>This posting is provided "AS IS" with no warranties, and
confers no rights.
quote:
>.
>
Subscribe to:
Posts (Atom)