Hi
Recently I have moved sql 2005 from one box to another with bigger hdd space and more memory. Since then I am getting the attached error message when I Execute all the job.Hey Common Gurus Help Me out... since 24 hours no reply
Thanks|||Resolved the issue.. thanks...|||Can you please post your resolution?|||Follow the link, has complete solution...
http://support.microsoft.com/kb/903205sql
Showing posts with label attached. Show all posts
Showing posts with label attached. Show all posts
Friday, March 23, 2012
Wednesday, March 7, 2012
Mail Delivery - Corupt attachments
When I configure Mail Delivery in RS sending mails with links works fine, but when I want that also report is attached in mail I get corupted files.
There is no difference if it's PDF, Excel or TIFF.
Delivery to File Share is working fine and all files are readable.
I use LotusNotes SMTP service to deliver mail, but to minimize possibilitie that this has influence I have configured local virtual SMTP which re-route mail to LN SMTP.
I'm using Reporting Services Ent. SP1 on Win 2003 Server with SQL 2000 SP3.
All services uses strartup account NETWORK/SERVICE and connection between RS and SQL database uses SQL account.
Second test machine is on WinXP with SQL 2000 SP3 Developer and RS Developer with domain startup accounts.
On both machines there is the same problem.There is an issue with RS delivering email through lotus. We have issued a
QFE. I believe you will need to contact Product Support to resolve this
issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mario Spicar" <Mario Spicar@.discussions.microsoft.com> wrote in message
news:50BBA072-BDC0-4653-AC05-A3CDA535BD7F@.microsoft.com...
> When I configure Mail Delivery in RS sending mails with links works fine,
but when I want that also report is attached in mail I get corupted files.
> There is no difference if it's PDF, Excel or TIFF.
> Delivery to File Share is working fine and all files are readable.
> I use LotusNotes SMTP service to deliver mail, but to minimize
possibilitie that this has influence I have configured local virtual SMTP
which re-route mail to LN SMTP.
> I'm using Reporting Services Ent. SP1 on Win 2003 Server with SQL 2000
SP3.
> All services uses strartup account NETWORK/SERVICE and connection between
RS and SQL database uses SQL account.
> Second test machine is on WinXP with SQL 2000 SP3 Developer and RS
Developer with domain startup accounts.
> On both machines there is the same problem.
There is no difference if it's PDF, Excel or TIFF.
Delivery to File Share is working fine and all files are readable.
I use LotusNotes SMTP service to deliver mail, but to minimize possibilitie that this has influence I have configured local virtual SMTP which re-route mail to LN SMTP.
I'm using Reporting Services Ent. SP1 on Win 2003 Server with SQL 2000 SP3.
All services uses strartup account NETWORK/SERVICE and connection between RS and SQL database uses SQL account.
Second test machine is on WinXP with SQL 2000 SP3 Developer and RS Developer with domain startup accounts.
On both machines there is the same problem.There is an issue with RS delivering email through lotus. We have issued a
QFE. I believe you will need to contact Product Support to resolve this
issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mario Spicar" <Mario Spicar@.discussions.microsoft.com> wrote in message
news:50BBA072-BDC0-4653-AC05-A3CDA535BD7F@.microsoft.com...
> When I configure Mail Delivery in RS sending mails with links works fine,
but when I want that also report is attached in mail I get corupted files.
> There is no difference if it's PDF, Excel or TIFF.
> Delivery to File Share is working fine and all files are readable.
> I use LotusNotes SMTP service to deliver mail, but to minimize
possibilitie that this has influence I have configured local virtual SMTP
which re-route mail to LN SMTP.
> I'm using Reporting Services Ent. SP1 on Win 2003 Server with SQL 2000
SP3.
> All services uses strartup account NETWORK/SERVICE and connection between
RS and SQL database uses SQL account.
> Second test machine is on WinXP with SQL 2000 SP3 Developer and RS
Developer with domain startup accounts.
> On both machines there is the same problem.
Monday, February 20, 2012
LUN attachment and moving temp db
F:\ is a RAID 0 LUN attached to the server (it's on a SAN)
After running
ALTER DATABASE tempdb
MODIFY FILE (name=tempprod, filename='f:\tempdb\tempdb_data.mdf')
I get the error
Server: Msg 5184, Level 16, State 1, Line 1
Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered server. Only
formatted files on which the cluster resource of the server has a
dependency can be used.
What do i need to change in my configuration? Seems I can only see a
g:\ drive who is also on the san.Apparently, the F drive is from your locally attach
drives, not those shared by the cluster nodes. You cannot
create a database file on a non-shared drive if your SQL
instance runs in a cluster.
Create the tempdb file on the G drive.
Linchi
>--Original Message--
>F:\ is a RAID 0 LUN attached to the server (it's on a
SAN)
>After running
>ALTER DATABASE tempdb
> MODIFY FILE (name=tempprod,
filename='f:\tempdb\tempdb_data.mdf')
>I get the error
>
>Server: Msg 5184, Level 16, State 1, Line 1
>Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered
server. Only
>formatted files on which the cluster resource of the
server has a
>dependency can be used.
>What do i need to change in my configuration? Seems I
can only see a
>g:\ drive who is also on the san.
>.
>|||Ahh the F:\ drive needed to be a dependancy of the sql cluster service.
I was able to create temp on that drive after it was added.
Linchi Shea wrote:
> Apparently, the F drive is from your locally attach
> drives, not those shared by the cluster nodes. You cannot
> create a database file on a non-shared drive if your SQL
> instance runs in a cluster.
> Create the tempdb file on the G drive.
> Linchi
>
>>--Original Message--
>>F:\ is a RAID 0 LUN attached to the server (it's on a
> SAN)
>>After running
>>ALTER DATABASE tempdb
>> MODIFY FILE (name=tempprod,
> filename='f:\tempdb\tempdb_data.mdf')
>>I get the error
>>
>>Server: Msg 5184, Level 16, State 1, Line 1
>>Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered
> server. Only
>>formatted files on which the cluster resource of the
> server has a
>>dependency can be used.
>>What do i need to change in my configuration? Seems I
> can only see a
>>g:\ drive who is also on the san.
>>.
After running
ALTER DATABASE tempdb
MODIFY FILE (name=tempprod, filename='f:\tempdb\tempdb_data.mdf')
I get the error
Server: Msg 5184, Level 16, State 1, Line 1
Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered server. Only
formatted files on which the cluster resource of the server has a
dependency can be used.
What do i need to change in my configuration? Seems I can only see a
g:\ drive who is also on the san.Apparently, the F drive is from your locally attach
drives, not those shared by the cluster nodes. You cannot
create a database file on a non-shared drive if your SQL
instance runs in a cluster.
Create the tempdb file on the G drive.
Linchi
>--Original Message--
>F:\ is a RAID 0 LUN attached to the server (it's on a
SAN)
>After running
>ALTER DATABASE tempdb
> MODIFY FILE (name=tempprod,
filename='f:\tempdb\tempdb_data.mdf')
>I get the error
>
>Server: Msg 5184, Level 16, State 1, Line 1
>Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered
server. Only
>formatted files on which the cluster resource of the
server has a
>dependency can be used.
>What do i need to change in my configuration? Seems I
can only see a
>g:\ drive who is also on the san.
>.
>|||Ahh the F:\ drive needed to be a dependancy of the sql cluster service.
I was able to create temp on that drive after it was added.
Linchi Shea wrote:
> Apparently, the F drive is from your locally attach
> drives, not those shared by the cluster nodes. You cannot
> create a database file on a non-shared drive if your SQL
> instance runs in a cluster.
> Create the tempdb file on the G drive.
> Linchi
>
>>--Original Message--
>>F:\ is a RAID 0 LUN attached to the server (it's on a
> SAN)
>>After running
>>ALTER DATABASE tempdb
>> MODIFY FILE (name=tempprod,
> filename='f:\tempdb\tempdb_data.mdf')
>>I get the error
>>
>>Server: Msg 5184, Level 16, State 1, Line 1
>>Cannot use file 'f:\tempdb\tempdb_data.mdf' for clustered
> server. Only
>>formatted files on which the cluster resource of the
> server has a
>>dependency can be used.
>>What do i need to change in my configuration? Seems I
> can only see a
>>g:\ drive who is also on the san.
>>.
Subscribe to:
Posts (Atom)