Error restoring sql backup

Hi All,
I was trying to restore a sql server backup in a Windows 2000 Advanced
Server cluster running SQL Server Enterprise Edition Service Pack 3, in two
nodes.
I have restored successfully some databases, buy I can not restore two
databases. I have obtained the error bellow:
Error 3241 Severity 16 State 1
The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
SQL Server cannot process this media family.
I have tried the Microsoft Article Q297104, but the error continues.
Can anybody help me?
Thanks in advance,
Guillermo Roldan
Spain
Hi
I am not sure what is happening here, but if the KB article is not working,
and you have used the trace flag correctly, then you may want to try some of
the following:
viewing the header only,
restoring the backup onto a different machine,
check the cluster resources allow access to this drive and the files
destination of the MDF and LDF are available.
John
"Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
> Hi All,
> I was trying to restore a sql server backup in a Windows 2000 Advanced
> Server cluster running SQL Server Enterprise Edition Service Pack 3, in
> two
> nodes.
> I have restored successfully some databases, buy I can not restore two
> databases. I have obtained the error bellow:
> Error 3241 Severity 16 State 1
> The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> I have tried the Microsoft Article Q297104, but the error continues.
> Can anybody help me?
> Thanks in advance,
> Guillermo Roldan
> Spain
>
|||Hi John,
I have tried to execute RESTORE HEADERONLY, resulting in an ***INCOMPLETE***
message. I do not understand, because I have checked maintenance plan every
day, and backups was OK. Now, there are only two backups, and there are
incomplete.
It is possible to recover an incomplete backup? There is a full database
backup, with no transactional log backups.
I would like to try the MSSQLRecovery tool on Monday…
Thanks for your answer, John
Guillermo Roldan
Spain
"John Bell" escribió:

> Hi
> I am not sure what is happening here, but if the KB article is not working,
> and you have used the trace flag correctly, then you may want to try some of
> the following:
> viewing the header only,
> restoring the backup onto a different machine,
> check the cluster resources allow access to this drive and the files
> destination of the MDF and LDF are available.
> John
> "Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
> message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
>
>
|||Hi
I can only think that it may be disc corruption, although I would have
expected you to have other things to indicate such a failure. If you
have a backup elsewhere you may want to try that, if not a call to PSS
may required.
John
|||Hi John,
I have discover why it is an Incomplete backup. The tape-robot was offline
since 22/11/2005 because a hardware problem, so somebody copy the sql server
backup files to a Novell Netware share. This is the problem: This Novell
Netware share has a limit of 4.194.304 KB. But the real backup was about
8,5GB !!
Finally, i can restore a new backup from tape. This new backup it's older
(18/11/2005), but it run sucesfully !
Thanks John, for your answers
Guillermo Roldan
"John Bell" wrote:

> Hi
> I can only think that it may be disc corruption, although I would have
> expected you to have other things to indicate such a failure. If you
> have a backup elsewhere you may want to try that, if not a call to PSS
> may required.
> John
>
sql

Error restoring sql backup

Hi All,
I was trying to restore a sql server backup in a Windows 2000 Advanced
Server cluster running SQL Server Enterprise Edition Service Pack 3, in two
nodes.
I have restored successfully some databases, buy I can not restore two
databases. I have obtained the error bellow:
Error 3241 Severity 16 State 1
The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
SQL Server cannot process this media family.
I have tried the Microsoft Article Q297104, but the error continues.
Can anybody help me?
Thanks in advance,
Guillermo Roldan
SpainHi
I am not sure what is happening here, but if the KB article is not working,
and you have used the trace flag correctly, then you may want to try some of
the following:
viewing the header only,
restoring the backup onto a different machine,
check the cluster resources allow access to this drive and the files
destination of the MDF and LDF are available.
John
"Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
> Hi All,
> I was trying to restore a sql server backup in a Windows 2000 Advanced
> Server cluster running SQL Server Enterprise Edition Service Pack 3, in
> two
> nodes.
> I have restored successfully some databases, buy I can not restore two
> databases. I have obtained the error bellow:
> Error 3241 Severity 16 State 1
> The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> I have tried the Microsoft Article Q297104, but the error continues.
> Can anybody help me?
> Thanks in advance,
> Guillermo Roldan
> Spain
>|||Hi John,
I have tried to execute RESTORE HEADERONLY, resulting in an ***INCOMPLETE***
message. I do not understand, because I have checked maintenance plan every
day, and backups was OK. Now, there are only two backups, and there are
incomplete.
It is possible to recover an incomplete backup? There is a full database
backup, with no transactional log backups.
I would like to try the MSSQLRecovery tool on Mondayâ?¦
Thanks for your answer, John
Guillermo Roldan
Spain
"John Bell" escribió:
> Hi
> I am not sure what is happening here, but if the KB article is not working,
> and you have used the trace flag correctly, then you may want to try some of
> the following:
> viewing the header only,
> restoring the backup onto a different machine,
> check the cluster resources allow access to this drive and the files
> destination of the MDF and LDF are available.
> John
> "Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
> message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
> > Hi All,
> >
> > I was trying to restore a sql server backup in a Windows 2000 Advanced
> > Server cluster running SQL Server Enterprise Edition Service Pack 3, in
> > two
> > nodes.
> >
> > I have restored successfully some databases, buy I can not restore two
> > databases. I have obtained the error bellow:
> >
> > Error 3241 Severity 16 State 1
> > The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
> > SQL Server cannot process this media family.
> >
> > I have tried the Microsoft Article Q297104, but the error continues.
> >
> > Can anybody help me?
> >
> > Thanks in advance,
> > Guillermo Roldan
> > Spain
> >
>
>|||Hi
I can only think that it may be disc corruption, although I would have
expected you to have other things to indicate such a failure. If you
have a backup elsewhere you may want to try that, if not a call to PSS
may required.
John|||Hi John,
I have discover why it is an Incomplete backup. The tape-robot was offline
since 22/11/2005 because a hardware problem, so somebody copy the sql server
backup files to a Novell Netware share. This is the problem: This Novell
Netware share has a limit of 4.194.304 KB. But the real backup was about
8,5GB !!
Finally, i can restore a new backup from tape. This new backup it's older
(18/11/2005), but it run sucesfully !
Thanks John, for your answers
Guillermo Roldan
"John Bell" wrote:
> Hi
> I can only think that it may be disc corruption, although I would have
> expected you to have other things to indicate such a failure. If you
> have a backup elsewhere you may want to try that, if not a call to PSS
> may required.
> John
>

Error restoring sql backup

Hi All,
I was trying to restore a sql server backup in a Windows 2000 Advanced
Server cluster running SQL Server Enterprise Edition Service Pack 3, in two
nodes.
I have restored successfully some databases, buy I can not restore two
databases. I have obtained the error bellow:
Error 3241 Severity 16 State 1
The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
SQL Server cannot process this media family.
I have tried the Microsoft Article Q297104, but the error continues.
Can anybody help me?
Thanks in advance,
Guillermo Roldan
SpainHi
I am not sure what is happening here, but if the KB article is not working,
and you have used the trace flag correctly, then you may want to try some of
the following:
viewing the header only,
restoring the backup onto a different machine,
check the cluster resources allow access to this drive and the files
destination of the MDF and LDF are available.
John
"Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
> Hi All,
> I was trying to restore a sql server backup in a Windows 2000 Advanced
> Server cluster running SQL Server Enterprise Edition Service Pack 3, in
> two
> nodes.
> I have restored successfully some databases, buy I can not restore two
> databases. I have obtained the error bellow:
> Error 3241 Severity 16 State 1
> The media family on device 'f:\backupsql\file.bak' is incorrectly formed.
> SQL Server cannot process this media family.
> I have tried the Microsoft Article Q297104, but the error continues.
> Can anybody help me?
> Thanks in advance,
> Guillermo Roldan
> Spain
>|||Hi John,
I have tried to execute RESTORE HEADERONLY, resulting in an ***INCOMPLETE***
message. I do not understand, because I have checked maintenance plan every
day, and backups was OK. Now, there are only two backups, and there are
incomplete.
It is possible to recover an incomplete backup? There is a full database
backup, with no transactional log backups.
I would like to try the MSSQLRecovery tool on Monday…
Thanks for your answer, John
Guillermo Roldan
Spain
"John Bell" escribió:

> Hi
> I am not sure what is happening here, but if the KB article is not working
,
> and you have used the trace flag correctly, then you may want to try some
of
> the following:
> viewing the header only,
> restoring the backup onto a different machine,
> check the cluster resources allow access to this drive and the files
> destination of the MDF and LDF are available.
> John
> "Guillermo Roldan" <GuillermoRoldan@.discussions.microsoft.com> wrote in
> message news:D840177A-3E92-4FB3-B3A9-60656A195E3A@.microsoft.com...
>
>|||Hi
I can only think that it may be disc corruption, although I would have
expected you to have other things to indicate such a failure. If you
have a backup elsewhere you may want to try that, if not a call to PSS
may required.
John|||Hi John,
I have discover why it is an Incomplete backup. The tape-robot was offline
since 22/11/2005 because a hardware problem, so somebody copy the sql server
backup files to a Novell Netware share. This is the problem: This Novell
Netware share has a limit of 4.194.304 KB. But the real backup was about
8,5GB !!
Finally, i can restore a new backup from tape. This new backup it's older
(18/11/2005), but it run sucesfully !
Thanks John, for your answers
Guillermo Roldan
"John Bell" wrote:

> Hi
> I can only think that it may be disc corruption, although I would have
> expected you to have other things to indicate such a failure. If you
> have a backup elsewhere you may want to try that, if not a call to PSS
> may required.
> John
>

error pending file

I've uninstall my previous sql2000 developer edition with leave some dll file undeleted.

once I tried to reinstall the sqlserver, the installation setup stop the process with message: A previous installation created pending file operations on the installation machine.
you must restart the computer before running setup.

I fail in continueing setup although i've restart the pc.

What should i do to handle this?

Regards,

BHT

Hhh.... please someone help me...

I don't want to reinstall the O/S as previously i've done. headache and waisting my days.

Regards,

BHT

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b312995&Product=sql

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

At last I saved. Thank you for your help.

Trully it is very suffer when become a begginer. (

Regards,

BHT

error Openrowset on the provider

I am a newbie, and need all the help i can get!

I am using SQL Server 2000 Personal edition on a Windows XP Pro wkst. I have just installed it, so maybe I have not configured it properly, I just created 2 new databases, online and off. I am trying to import data from Paradox db. I am using the DTS Import/Export Wizard in Enterprise Manager.

I select the database I want to import, which I have copied onto my local hardrive,C: Databases\old.db.

Then when I go to select the destination,
Provider: MS OLE DB Provider for SQL,
Server:local server-(this is my wkst, right?),
Use windows authentication( I have it set to use both windows and sql in security settings)
Database: new (database i just created.)

Next under Select source tables and views it shows my source database: old.db and destination [new].[dbo].[old]

When I click on next I get the following error:
Error source: Microsoft JET Database Engine
Error descrip:Unexpected error from external database driver
Context: Error calling OpenRowset on the provider

What am i doing wrong?

Thanks for your help.Get latest drivers for Paradox.

Error on Query to Sys Views (e.g. sys.objects)

I've just installed SQL Server 2005 Developer Edition, upgraded from SQL Server 2000, and have encountered a problem in trying to query against the System Catalogs.

I've tried SELECT * FROM sys.objects in addition to SELECT suser_name( role_principal_id ) FROM sys.server_role_members. In both cases I receive the following error: Invalid object name 'sys.objects' or 'sys.server_role_members' in the second example.

I changed the properties of the registration for my local db instance to use SQL authentication in lieu of Windows authentication. I used the sa login account to see if that made a difference, no go.

Can someone *please* tell me what I'm doing wrong here?

I would also like to know if it's possible to run a query confirming the user account I'm logged in to the system as.

Thanks!

what i feel is you are still connecting to SQL Server 2000. post the result of

Select @.@.Version

run the above query in query anlyser from where you are getting this error and post the result

you might have only installed Tools...

Madhu

|||

That was it Madhu. Thanks for the prompt reply. I had assumed that in upgrading to Sql Server 2005 all databases were pushed to the 2005 engine. Is there a manual step I must complete in order to do just that?

In addition, can you tell me how to query the user account I'm logged in as?

Thanks again

|||

(a) install SQL Server 2005

(b) use backup/restore or detach /attach method to transfer the database

(c) make script of other server level objects like jobs etc and run it in sql server 2005 instance

To fine user account : SELECT SUSER_SNAME()

Madhu

|||Thanks again for the feedback!

Error on Query to Sys Views (e.g. sys.objects)

I've just installed SQL Server 2005 Developer Edition, upgraded from SQL Server 2000, and have encountered a problem in trying to query against the System Catalogs.

I've tried SELECT * FROM sys.objects in addition to SELECT suser_name( role_principal_id ) FROM sys.server_role_members. In both cases I receive the following error: Invalid object name 'sys.objects' or 'sys.server_role_members' in the second example.

I changed the properties of the registration for my local db instance to use SQL authentication in lieu of Windows authentication. I used the sa login account to see if that made a difference, no go.

Can someone *please* tell me what I'm doing wrong here?

I would also like to know if it's possible to run a query confirming the user account I'm logged in to the system as.

Thanks!

what i feel is you are still connecting to SQL Server 2000. post the result of

Select @.@.Version

run the above query in query anlyser from where you are getting this error and post the result

you might have only installed Tools...

Madhu

|||

That was it Madhu. Thanks for the prompt reply. I had assumed that in upgrading to Sql Server 2005 all databases were pushed to the 2005 engine. Is there a manual step I must complete in order to do just that?

In addition, can you tell me how to query the user account I'm logged in as?

Thanks again

|||

(a) install SQL Server 2005

(b) use backup/restore or detach /attach method to transfer the database

(c) make script of other server level objects like jobs etc and run it in sql server 2005 instance

To fine user account : SELECT SUSER_SNAME()

Madhu

|||Thanks again for the feedback!

error number 1612

I'm doing a reinstall of SQL 2005 Standard Edition but I get this cryptic error message in the installation log file when it tries to install Integration Services or Notification Services. How do I resolve this? I've spent countless hours un-installing and re-installing the product.I looked at the log file and the message says 'The installation source for this product is not available. Verify that the source exists and that you can access it.' It seems to be a problem with the Windows Installer. How do I fix this?|||

Someone else posted a similar problem in the past day. If you're not using the original media to do the reinstall, please try that. If you are, please post again and I'll find a Setup developer and get specific advice from him about this problem.

Paul

|||Thanks for replying, Paul. I am using the original media for the reinstall and I have submitted a more detailed post of this problem in this section under the subject heading 'Cannot install SSIS or Notification services'.

Error messages of return codes of SQL installer

Hi all,

I have one application through which i m installing SQL Server 2005 Express Edition.

If some failure occures, all I get is one exitCode which is a return code of SQL Express installer. Is there any way by which I can find out the exact reason of failure.

One example is error code 28062.

This error code is for "sql is unable to install on compressed folder / drive".

Please help

Thanks and regards,

-Anup

Are you using either encrypted or compressed drives where you want to install the edition on ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error message: Setup failed to configure the server

Re: SQL Server 2000 Developer Edition

Error message: Setup failed to configure the server

I'm attempting to install SQL Server 2000 Developer Edition on a 2nd workstation in our area for development and practice with having this 2nd workstation as a "local" (test) SQL Server box. The install fails with the above mentioned message. (We have a database running in production on SQL Server 2000 and we need a place to simply copy the database and run tests on it)

The target PC is running WInXP Pro-SP3 and has IIS installed, along with Visual Studio 2005 & .Net framework, etc.

I downloaded it (via MSDN license) and accepted the defaults on the install.

Any feedback is appreciated.

Thanks,

RLN

Can you read through this post and see if it applies to your environment?

http://www.dbforums.com/showthread.php?t=374088

Thanks,
Sam Lester (MSFT)

|||

Samuel,

>>HKLM\Software\Microsoft\Windows\CurrentVersion\Set up\ExceptionComponents,<<

Your link mentioned an advisory to delete the following registry entry and re-install. This fixed it. Thank you for the tip and I apologize for not responding back sooner to your suggestion.

Thank you.

Error message: Setup failed to configure the server

Re: SQL Server 2000 Developer Edition

Error message: Setup failed to configure the server

I'm attempting to install SQL Server 2000 Developer Edition on a 2nd workstation in our area for development and practice with having this 2nd workstation as a "local" (test) SQL Server box. The install fails with the above mentioned message. (We have a database running in production on SQL Server 2000 and we need a place to simply copy the database and run tests on it)

The target PC is running WInXP Pro-SP3 and has IIS installed, along with Visual Studio 2005 & .Net framework, etc.

I downloaded it (via MSDN license) and accepted the defaults on the install.

Any feedback is appreciated.

Thanks,

RLN

Can you read through this post and see if it applies to your environment?

http://www.dbforums.com/showthread.php?t=374088

Thanks,
Sam Lester (MSFT)

|||

Samuel,

>>HKLM\Software\Microsoft\Windows\CurrentVersion\Set up\ExceptionComponents,<<

Your link mentioned an advisory to delete the following registry entry and re-install. This fixed it. Thank you for the tip and I apologize for not responding back sooner to your suggestion.

Thank you.

Error message on installation

I have both developer and enterprise edition of SQL 2005. I originally installed developer then did an uninstall and tried to install enterprise. Everytime it starts to install I get the following error description:

EventType : sql90setup P1 : installtoolsaction.10 P2 : 0x643
P3 : sqls__installpackageaction__perform P4 : 0x643
P5 :packageengine_installpackageaction.cpp@.167
P6 :setup.exe@.2005.90.1399.0 P7 : none

It bombs when it tries to install the client tools.

The first time I installed it worked fine but trying to reinstall has caused this error to occur everytime.

I have tried full uninstall/reboots and nothing seems to help. It is coming from an unzipped ISO but I don't see why that would be a problem.

Any Suggestions ?

I had the same problem Installing SQL 2005. Well I don't remember if the error was that one. However I reinstall the OS (Windows 2003) and then after installing SP1 I installed SQL 2005 without any problem.

Hope this helps

Al

|||

Actually I think the problem is i did not have both ISO's unzipped in the same path since there are two.

Error Message after installing SRS SP2

I am building my dev box. I installed SQL Server 2000. I installed SQL Server
2000 SP4. I installed SQL Reporting Services Developer Edition. Installed SRS
SP2 (this seemed to hang, and ran very slowly on my P4 3GHz box with 2GB of
RAM). When I try to launch Report Manager, I get this error:
Method not found: Void System.Xml.XmlTextReader.set_ProhibitDtd(Boolean).
Any ideas? Should I uninstall/reinstall SRS SP2?
TIA,
--
Berry Morgan
JSOHi Berry,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood that you are failed to connect Report
Manager after applied SQL Server Reporting Service SP2. If I have
misunderstood your concern, please feel free to point it out.
Based on my knowledge, it is abnormal when it seems to hang, and ran very
slowly during the installation of SP2. So please hlep me check whether the
installation of SP2 is successfully.
1. Check whether ReportServer in Services is launched successfully, check
whether there is any related information in Event Logs
2. Except Report Manager, could you go into Report Server? Assuming you are
install Reporting Service and IIS on the same local machine. Could you see
the RS version from http://localhost/ReportServer ?
3. Generally speaking, "Method not found" is a common error message which
means some SQL server component isn't installed correctly. It seems XML
compoents is wrong and I recommand you reinstalling VS.NET 2003 and let me
know the results.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Error Message 11004

Hi
Eveyone. I am having trouble connecting to my SQL Server 2005
Expression edition. I can connnect from other pc without any trouble.
The only difference between this PC and the others is this PC is
running Windows 2000 SP4. I can ping my SQL Server no problem. I can
even telnet into it. I just can't connect to it. Any help would be
greatly appreciated.
-Thanks
Thanascheck sql log to see which tcp port sqlexpress started under. then try to
connect via:
sqlcmd -S"servername,tcp_port"
-oj
<atsioplakis@.gmail.com> wrote in message
news:1150481091.896901.173220@.c74g2000cwc.googlegroups.com...
> Hi
> Eveyone. I am having trouble connecting to my SQL Server 2005
> Expression edition. I can connnect from other pc without any trouble.
> The only difference between this PC and the others is this PC is
> running Windows 2000 SP4. I can ping my SQL Server no problem. I can
> even telnet into it. I just can't connect to it. Any help would be
> greatly appreciated.
> -Thanks
> Thanas
>|||check sql log to see which tcp port sqlexpress started under. then try to
connect via:
sqlcmd -S"servername,tcp_port"
-oj
<atsioplakis@.gmail.com> wrote in message
news:1150481091.896901.173220@.c74g2000cwc.googlegroups.com...
> Hi
> Eveyone. I am having trouble connecting to my SQL Server 2005
> Expression edition. I can connnect from other pc without any trouble.
> The only difference between this PC and the others is this PC is
> running Windows 2000 SP4. I can ping my SQL Server no problem. I can
> even telnet into it. I just can't connect to it. Any help would be
> greatly appreciated.
> -Thanks
> Thanas
>|||The trouble is that Windows 2000 OS Data Source section doesn't want to
connect to the SQL Server. I can't get that to work. Any comments on
that?
oj wrote:[vbcol=seagreen]
> check sql log to see which tcp port sqlexpress started under. then try to
> connect via:
> sqlcmd -S"servername,tcp_port"
> --
> -oj
>
> <atsioplakis@.gmail.com> wrote in message
> news:1150481091.896901.173220@.c74g2000cwc.googlegroups.com...|||The trouble is that Windows 2000 OS Data Source section doesn't want to
connect to the SQL Server. I can't get that to work. Any comments on
that?
oj wrote:[vbcol=seagreen]
> check sql log to see which tcp port sqlexpress started under. then try to
> connect via:
> sqlcmd -S"servername,tcp_port"
> --
> -oj
>
> <atsioplakis@.gmail.com> wrote in message
> news:1150481091.896901.173220@.c74g2000cwc.googlegroups.com...|||did you try to connect with explicitly specifying the tcp port#.
to determine the listening port, connect to the instance and run "exec
sp_readerrorlog". this displays the sql error log and you should be able to
find the current listening port.
also, check to see if there is a firewall between the win2k and sql2k5
express. make sure sqlbrowser is running on the sqlserver and UDP 1434 is
open.
-oj
"Thanas" <atsioplakis@.gmail.com> wrote in message
news:1150741206.158850.127400@.p79g2000cwp.googlegroups.com...
> The trouble is that Windows 2000 OS Data Source section doesn't want to
> connect to the SQL Server. I can't get that to work. Any comments on
> that?
> oj wrote:
>|||did you try to connect with explicitly specifying the tcp port#.
to determine the listening port, connect to the instance and run "exec
sp_readerrorlog". this displays the sql error log and you should be able to
find the current listening port.
also, check to see if there is a firewall between the win2k and sql2k5
express. make sure sqlbrowser is running on the sqlserver and UDP 1434 is
open.
-oj
"Thanas" <atsioplakis@.gmail.com> wrote in message
news:1150741206.158850.127400@.p79g2000cwp.googlegroups.com...
> The trouble is that Windows 2000 OS Data Source section doesn't want to
> connect to the SQL Server. I can't get that to work. Any comments on
> that?
> oj wrote:
>

Error Message 11004

Hi
Eveyone. I am having trouble connecting to my SQL Server 2005
Expression edition. I can connnect from other pc without any trouble.
The only difference between this PC and the others is this PC is
running Windows 2000 SP4. I can ping my SQL Server no problem. I can
even telnet into it. I just can't connect to it. Any help would be
greatly appreciated.
-Thanks
Thanascheck sql log to see which tcp port sqlexpress started under. then try to
connect via:
sqlcmd -S"servername,tcp_port"
--
-oj
<atsioplakis@.gmail.com> wrote in message
news:1150481091.896901.173220@.c74g2000cwc.googlegroups.com...
> Hi
> Eveyone. I am having trouble connecting to my SQL Server 2005
> Expression edition. I can connnect from other pc without any trouble.
> The only difference between this PC and the others is this PC is
> running Windows 2000 SP4. I can ping my SQL Server no problem. I can
> even telnet into it. I just can't connect to it. Any help would be
> greatly appreciated.
> -Thanks
> Thanas
>|||The trouble is that Windows 2000 OS Data Source section doesn't want to
connect to the SQL Server. I can't get that to work. Any comments on
that?
oj wrote:
> check sql log to see which tcp port sqlexpress started under. then try to
> connect via:
> sqlcmd -S"servername,tcp_port"
> --
> -oj
>
> <atsioplakis@.gmail.com> wrote in message
> news:1150481091.896901.173220@.c74g2000cwc.googlegroups.com...
> > Hi
> > Eveyone. I am having trouble connecting to my SQL Server 2005
> > Expression edition. I can connnect from other pc without any trouble.
> > The only difference between this PC and the others is this PC is
> > running Windows 2000 SP4. I can ping my SQL Server no problem. I can
> > even telnet into it. I just can't connect to it. Any help would be
> > greatly appreciated.
> >
> > -Thanks
> > Thanas
> >|||did you try to connect with explicitly specifying the tcp port#.
to determine the listening port, connect to the instance and run "exec
sp_readerrorlog". this displays the sql error log and you should be able to
find the current listening port.
also, check to see if there is a firewall between the win2k and sql2k5
express. make sure sqlbrowser is running on the sqlserver and UDP 1434 is
open.
-oj
"Thanas" <atsioplakis@.gmail.com> wrote in message
news:1150741206.158850.127400@.p79g2000cwp.googlegroups.com...
> The trouble is that Windows 2000 OS Data Source section doesn't want to
> connect to the SQL Server. I can't get that to work. Any comments on
> that?
> oj wrote:
>> check sql log to see which tcp port sqlexpress started under. then try to
>> connect via:
>> sqlcmd -S"servername,tcp_port"
>> --
>> -oj
>>
>> <atsioplakis@.gmail.com> wrote in message
>> news:1150481091.896901.173220@.c74g2000cwc.googlegroups.com...
>> > Hi
>> > Eveyone. I am having trouble connecting to my SQL Server 2005
>> > Expression edition. I can connnect from other pc without any trouble.
>> > The only difference between this PC and the others is this PC is
>> > running Windows 2000 SP4. I can ping my SQL Server no problem. I can
>> > even telnet into it. I just can't connect to it. Any help would be
>> > greatly appreciated.
>> >
>> > -Thanks
>> > Thanas
>> >
>

Error message (event id 107)

I have installed Reporting services Enterprise Edition without any problems.
I have also been able to build and deploy a report.
But the Reporting Service logs the following error to the Application log:
"Schedule and Delivery Processor cannot connect to the report server
database" (Event id: 107 ).
There are no errors in the Reporting Services log files .
Can anyone tell me how to fix this error?
Regards,
MarileneI have a similar problem, we have Reporting services deployed & working
across a web cluster. Very intermittently Iâ'm getting the following error in
the application log twice in succession as the reports fail:
"Schedule and Delivery Processor cannot connect to the report server
database" (Event id: 107).
When the report is called a second time I get the following:
"The Report Server service has been activated." (Event id: 124)
So the question is why does the logon\connection to the report server
database fail at the first attempt?
Regards,
Graham
"ms" wrote:
> I have installed Reporting services Enterprise Edition without any problems.
> I have also been able to build and deploy a report.
> But the Reporting Service logs the following error to the Application log:
> "Schedule and Delivery Processor cannot connect to the report server
> database" (Event id: 107 ).
> There are no errors in the Reporting Services log files .
> Can anyone tell me how to fix this error?
> Regards,
> Marilene
>
>