Showing posts with label w2k. Show all posts
Showing posts with label w2k. Show all posts

Sunday, February 19, 2012

Array controller and lost data.

Hi,
I had some problem with our server, SQL Server stopped and W2k Server could
not response. I had to use button ON/OFF.
I find out the array controller was wrong so I change it.
When server was started I found message in system log about error on device
\Device\Harddisk0\DR0 and another errors in SQL errorlog:
2005-10-12 10:20:30.06 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:30.06 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:30.12 spid10 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:30.12 spid10 The log for database 'DSL' is not available..
2005-10-12 10:20:30.88 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:30.88 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:30.88 spid68 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:30.88 spid68 The log for database 'msdb' is not
available..
2005-10-12 10:20:31.20 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.26 spid15 fcb::close-flush: Operating system error
1117(The request could not be performed because of an I/O device error.)
encountered.
2005-10-12 10:20:31.26 spid15 Starting up database 'MyDB'.
2005-10-12 10:20:32.26 spid16 Starting up database 'msdb'.
2005-10-12 10:20:32.54 spid15 Error: 823, Severity: 24, State: 2
2005-10-12 10:20:32.54 spid15 I/O error 1117(The request could not be
performed because of an I/O device error.) detected during read at offset
0x00000016760000 in file 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MyDB.mdf'..
2005-10-12 10:20:32.56 spid15 Error: 3313, Severity: 21, State: 2
2005-10-12 10:20:32.56 spid15 Error while redoing logged operation in
database 'MyDB'. Error at log record ID (33351:450:4)..
2005-10-12 10:20:32.62 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:32.62 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:32.62 spid15 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:32.62 spid15 The log for database 'master' is not
available..
2005-10-12 10:20:32.64 spid15 Error: 3449, Severity: 21, State: 1
2005-10-12 10:20:32.64 spid15 An error has occurred that requires SQL
Server to shut down so that recovery can be performed on database ID 1..
After that I could not start SQL Server.
I made new installation of SQL server on new hardware and I made copy of
files MyDB.mdf and MyDB.ldf to new server.
I attached them to new server and started DBCC CHECKDB with no errors.
But when I made SELECT... to MyDB I found all data from 2005-10-12 were
lost.
Could you any body help me? What was happend? Where is the mistake?
Could I find the lost data in transaction log or tempbd or ...?
Thanks
Radek
Hi
It seems that your server failed on 2005-10-12 10:20:32.64 therefore the
best you can achieve is to recover up to that point. Any uncommitted
transactions would be rolled back when you attached the mdf/ldf file.
John
"RP" wrote:

> Hi,
> I had some problem with our server, SQL Server stopped and W2k Server could
> not response. I had to use button ON/OFF.
> I find out the array controller was wrong so I change it.
> When server was started I found message in system log about error on device
> \Device\Harddisk0\DR0 and another errors in SQL errorlog:
> 2005-10-12 10:20:30.06 spid2 LogWriter: Operating system error 1117(The
> request could not be performed because of an I/O device error.) encountered.
> 2005-10-12 10:20:30.06 spid2 Write error during log flush. Shutting down
> server
> 2005-10-12 10:20:30.12 spid10 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:30.12 spid10 The log for database 'DSL' is not available..
> 2005-10-12 10:20:30.88 spid2 LogWriter: Operating system error 1117(The
> request could not be performed because of an I/O device error.) encountered.
> 2005-10-12 10:20:30.88 spid2 Write error during log flush. Shutting down
> server
> 2005-10-12 10:20:30.88 spid68 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:30.88 spid68 The log for database 'msdb' is not
> available..
> 2005-10-12 10:20:31.20 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.26 spid15 fcb::close-flush: Operating system error
> 1117(The request could not be performed because of an I/O device error.)
> encountered.
> 2005-10-12 10:20:31.26 spid15 Starting up database 'MyDB'.
> 2005-10-12 10:20:32.26 spid16 Starting up database 'msdb'.
> 2005-10-12 10:20:32.54 spid15 Error: 823, Severity: 24, State: 2
> 2005-10-12 10:20:32.54 spid15 I/O error 1117(The request could not be
> performed because of an I/O device error.) detected during read at offset
> 0x00000016760000 in file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\Data\MyDB.mdf'..
> 2005-10-12 10:20:32.56 spid15 Error: 3313, Severity: 21, State: 2
> 2005-10-12 10:20:32.56 spid15 Error while redoing logged operation in
> database 'MyDB'. Error at log record ID (33351:450:4)..
> 2005-10-12 10:20:32.62 spid2 LogWriter: Operating system error 1117(The
> request could not be performed because of an I/O device error.) encountered.
> 2005-10-12 10:20:32.62 spid2 Write error during log flush. Shutting down
> server
> 2005-10-12 10:20:32.62 spid15 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:32.62 spid15 The log for database 'master' is not
> available..
> 2005-10-12 10:20:32.64 spid15 Error: 3449, Severity: 21, State: 1
> 2005-10-12 10:20:32.64 spid15 An error has occurred that requires SQL
> Server to shut down so that recovery can be performed on database ID 1..
> After that I could not start SQL Server.
> I made new installation of SQL server on new hardware and I made copy of
> files MyDB.mdf and MyDB.ldf to new server.
> I attached them to new server and started DBCC CHECKDB with no errors.
> But when I made SELECT... to MyDB I found all data from 2005-10-12 were
> lost.
> Could you any body help me? What was happend? Where is the mistake?
> Could I find the lost data in transaction log or tempbd or ...?
> Thanks
> Radek
>

Array controller and lost data.

Hi,
I had some problem with our server, SQL Server stopped and W2k Server could
not response. I had to use button ON/OFF.
I find out the array controller was wrong so I change it.
When server was started I found message in system log about error on device
\Device\Harddisk0\DR0 and another errors in SQL errorlog:
2005-10-12 10:20:30.06 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:30.06 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:30.12 spid10 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:30.12 spid10 The log for database 'DSL' is not available
.
2005-10-12 10:20:30.88 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:30.88 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:30.88 spid68 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:30.88 spid68 The log for database 'msdb' is not
available..
2005-10-12 10:20:31.20 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.26 spid15 fcb::close-flush: Operating system error
1117(The request could not be performed because of an I/O device error.)
encountered.
2005-10-12 10:20:31.26 spid15 Starting up database 'MyDB'.
2005-10-12 10:20:32.26 spid16 Starting up database 'msdb'.
2005-10-12 10:20:32.54 spid15 Error: 823, Severity: 24, State: 2
2005-10-12 10:20:32.54 spid15 I/O error 1117(The request could not be
performed because of an I/O device error.) detected during read at offset
0x00000016760000 in file 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MyDB.mdf'..
2005-10-12 10:20:32.56 spid15 Error: 3313, Severity: 21, State: 2
2005-10-12 10:20:32.56 spid15 Error while redoing logged operation in
database 'MyDB'. Error at log record ID (33351:450:4)..
2005-10-12 10:20:32.62 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:32.62 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:32.62 spid15 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:32.62 spid15 The log for database 'master' is not
available..
2005-10-12 10:20:32.64 spid15 Error: 3449, Severity: 21, State: 1
2005-10-12 10:20:32.64 spid15 An error has occurred that requires SQL
Server to shut down so that recovery can be performed on database ID 1..
After that I could not start SQL Server.
I made new installation of SQL server on new hardware and I made copy of
files MyDB.mdf and MyDB.ldf to new server.
I attached them to new server and started DBCC CHECKDB with no errors.
But when I made SELECT... to MyDB I found all data from 2005-10-12 were
lost.
Could you any body help me? What was happend? Where is the mistake?
Could I find the lost data in transaction log or tempbd or ...?
Thanks
RadekHi
It seems that your server failed on 2005-10-12 10:20:32.64 therefore the
best you can achieve is to recover up to that point. Any uncommitted
transactions would be rolled back when you attached the mdf/ldf file.
John
"RP" wrote:

> Hi,
> I had some problem with our server, SQL Server stopped and W2k Server coul
d
> not response. I had to use button ON/OFF.
> I find out the array controller was wrong so I change it.
> When server was started I found message in system log about error on devic
e
> \Device\Harddisk0\DR0 and another errors in SQL errorlog:
> 2005-10-12 10:20:30.06 spid2 LogWriter: Operating system error 1117(Th
e
> request could not be performed because of an I/O device error.) encountere
d.
> 2005-10-12 10:20:30.06 spid2 Write error during log flush. Shutting do
wn
> server
> 2005-10-12 10:20:30.12 spid10 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:30.12 spid10 The log for database 'DSL' is not availab
le..
> 2005-10-12 10:20:30.88 spid2 LogWriter: Operating system error 1117(Th
e
> request could not be performed because of an I/O device error.) encountere
d.
> 2005-10-12 10:20:30.88 spid2 Write error during log flush. Shutting do
wn
> server
> 2005-10-12 10:20:30.88 spid68 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:30.88 spid68 The log for database 'msdb' is not
> available..
> 2005-10-12 10:20:31.20 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.26 spid15 fcb::close-flush: Operating system error
> 1117(The request could not be performed because of an I/O device error.)
> encountered.
> 2005-10-12 10:20:31.26 spid15 Starting up database 'MyDB'.
> 2005-10-12 10:20:32.26 spid16 Starting up database 'msdb'.
> 2005-10-12 10:20:32.54 spid15 Error: 823, Severity: 24, State: 2
> 2005-10-12 10:20:32.54 spid15 I/O error 1117(The request could not be
> performed because of an I/O device error.) detected during read at offset
> 0x00000016760000 in file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\Data\MyDB.mdf'..
> 2005-10-12 10:20:32.56 spid15 Error: 3313, Severity: 21, State: 2
> 2005-10-12 10:20:32.56 spid15 Error while redoing logged operation in
> database 'MyDB'. Error at log record ID (33351:450:4)..
> 2005-10-12 10:20:32.62 spid2 LogWriter: Operating system error 1117(Th
e
> request could not be performed because of an I/O device error.) encountere
d.
> 2005-10-12 10:20:32.62 spid2 Write error during log flush. Shutting do
wn
> server
> 2005-10-12 10:20:32.62 spid15 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:32.62 spid15 The log for database 'master' is not
> available..
> 2005-10-12 10:20:32.64 spid15 Error: 3449, Severity: 21, State: 1
> 2005-10-12 10:20:32.64 spid15 An error has occurred that requires SQL
> Server to shut down so that recovery can be performed on database ID 1..
> After that I could not start SQL Server.
> I made new installation of SQL server on new hardware and I made copy of
> files MyDB.mdf and MyDB.ldf to new server.
> I attached them to new server and started DBCC CHECKDB with no errors.
> But when I made SELECT... to MyDB I found all data from 2005-10-12 were
> lost.
> Could you any body help me? What was happend? Where is the mistake?
> Could I find the lost data in transaction log or tempbd or ...?
> Thanks
> Radek
>

Array controller and lost data.

Hi,
I had some problem with our server, SQL Server stopped and W2k Server could
not response. I had to use button ON/OFF.
I find out the array controller was wrong so I change it.
When server was started I found message in system log about error on device
\Device\Harddisk0\DR0 and another errors in SQL errorlog:
2005-10-12 10:20:30.06 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:30.06 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:30.12 spid10 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:30.12 spid10 The log for database 'DSL' is not available..
2005-10-12 10:20:30.88 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:30.88 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:30.88 spid68 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:30.88 spid68 The log for database 'msdb' is not
available..
2005-10-12 10:20:31.20 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
been marked SUSPECT by recovery. See the SQL Server errorlog for more
information.
2005-10-12 10:20:31.26 spid15 fcb::close-flush: Operating system error
1117(The request could not be performed because of an I/O device error.)
encountered.
2005-10-12 10:20:31.26 spid15 Starting up database 'MyDB'.
2005-10-12 10:20:32.26 spid16 Starting up database 'msdb'.
2005-10-12 10:20:32.54 spid15 Error: 823, Severity: 24, State: 2
2005-10-12 10:20:32.54 spid15 I/O error 1117(The request could not be
performed because of an I/O device error.) detected during read at offset
0x00000016760000 in file 'D:\Program Files\Microsoft SQL
Server\MSSQL\Data\MyDB.mdf'..
2005-10-12 10:20:32.56 spid15 Error: 3313, Severity: 21, State: 2
2005-10-12 10:20:32.56 spid15 Error while redoing logged operation in
database 'MyDB'. Error at log record ID (33351:450:4)..
2005-10-12 10:20:32.62 spid2 LogWriter: Operating system error 1117(The
request could not be performed because of an I/O device error.) encountered.
2005-10-12 10:20:32.62 spid2 Write error during log flush. Shutting down
server
2005-10-12 10:20:32.62 spid15 Error: 9001, Severity: 21, State: 4
2005-10-12 10:20:32.62 spid15 The log for database 'master' is not
available..
2005-10-12 10:20:32.64 spid15 Error: 3449, Severity: 21, State: 1
2005-10-12 10:20:32.64 spid15 An error has occurred that requires SQL
Server to shut down so that recovery can be performed on database ID 1..
After that I could not start SQL Server.
I made new installation of SQL server on new hardware and I made copy of
files MyDB.mdf and MyDB.ldf to new server.
I attached them to new server and started DBCC CHECKDB with no errors.
But when I made SELECT... to MyDB I found all data from 2005-10-12 were
lost.
Could you any body help me? What was happend? Where is the mistake?
Could I find the lost data in transaction log or tempbd or ...?
Thanks
RadekHi
It seems that your server failed on 2005-10-12 10:20:32.64 therefore the
best you can achieve is to recover up to that point. Any uncommitted
transactions would be rolled back when you attached the mdf/ldf file.
John
"RP" wrote:
> Hi,
> I had some problem with our server, SQL Server stopped and W2k Server could
> not response. I had to use button ON/OFF.
> I find out the array controller was wrong so I change it.
> When server was started I found message in system log about error on device
> \Device\Harddisk0\DR0 and another errors in SQL errorlog:
> 2005-10-12 10:20:30.06 spid2 LogWriter: Operating system error 1117(The
> request could not be performed because of an I/O device error.) encountered.
> 2005-10-12 10:20:30.06 spid2 Write error during log flush. Shutting down
> server
> 2005-10-12 10:20:30.12 spid10 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:30.12 spid10 The log for database 'DSL' is not available..
> 2005-10-12 10:20:30.88 spid2 LogWriter: Operating system error 1117(The
> request could not be performed because of an I/O device error.) encountered.
> 2005-10-12 10:20:30.88 spid2 Write error during log flush. Shutting down
> server
> 2005-10-12 10:20:30.88 spid68 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:30.88 spid68 The log for database 'msdb' is not
> available..
> 2005-10-12 10:20:31.20 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.21 spid15 Database 'MyDB' cannot be opened. It has
> been marked SUSPECT by recovery. See the SQL Server errorlog for more
> information.
> 2005-10-12 10:20:31.26 spid15 fcb::close-flush: Operating system error
> 1117(The request could not be performed because of an I/O device error.)
> encountered.
> 2005-10-12 10:20:31.26 spid15 Starting up database 'MyDB'.
> 2005-10-12 10:20:32.26 spid16 Starting up database 'msdb'.
> 2005-10-12 10:20:32.54 spid15 Error: 823, Severity: 24, State: 2
> 2005-10-12 10:20:32.54 spid15 I/O error 1117(The request could not be
> performed because of an I/O device error.) detected during read at offset
> 0x00000016760000 in file 'D:\Program Files\Microsoft SQL
> Server\MSSQL\Data\MyDB.mdf'..
> 2005-10-12 10:20:32.56 spid15 Error: 3313, Severity: 21, State: 2
> 2005-10-12 10:20:32.56 spid15 Error while redoing logged operation in
> database 'MyDB'. Error at log record ID (33351:450:4)..
> 2005-10-12 10:20:32.62 spid2 LogWriter: Operating system error 1117(The
> request could not be performed because of an I/O device error.) encountered.
> 2005-10-12 10:20:32.62 spid2 Write error during log flush. Shutting down
> server
> 2005-10-12 10:20:32.62 spid15 Error: 9001, Severity: 21, State: 4
> 2005-10-12 10:20:32.62 spid15 The log for database 'master' is not
> available..
> 2005-10-12 10:20:32.64 spid15 Error: 3449, Severity: 21, State: 1
> 2005-10-12 10:20:32.64 spid15 An error has occurred that requires SQL
> Server to shut down so that recovery can be performed on database ID 1..
> After that I could not start SQL Server.
> I made new installation of SQL server on new hardware and I made copy of
> files MyDB.mdf and MyDB.ldf to new server.
> I attached them to new server and started DBCC CHECKDB with no errors.
> But when I made SELECT... to MyDB I found all data from 2005-10-12 were
> lost.
> Could you any body help me? What was happend? Where is the mistake?
> Could I find the lost data in transaction log or tempbd or ...?
> Thanks
> Radek
>

Monday, February 13, 2012

Arial Narrow not working in PDFs (getting substituted) since W2K->

We use Arial Narrow and ever since we went to a W2K3 box (from a W2K
installation) everything exports correctly, except for PDF which substitutes
Helvetica or something with weird spacing. All looks good on the screen and,
of course, Microsoft Office is installed (which is where the fonts came from
in our W2K box).
Any ideas of what to check? Of course the clients have the font because
embedding is not supported.
--
"Everyone knows something you don't know"Does this happen w/ the latest acrobat reader (v7.0)?
--
Adrian M.
MCP
"David Bienstock" <DavidBienstock@.discussions.microsoft.com> wrote in
message news:B7583531-C4D7-4B04-9C57-E92D17921B9A@.microsoft.com...
> We use Arial Narrow and ever since we went to a W2K3 box (from a W2K
> installation) everything exports correctly, except for PDF which
> substitutes
> Helvetica or something with weird spacing. All looks good on the screen
> and,
> of course, Microsoft Office is installed (which is where the fonts came
> from
> in our W2K box).
> Any ideas of what to check? Of course the clients have the font because
> embedding is not supported.
> --
> "Everyone knows something you don't know"|||Yes it does. But I don't know if something happened when I transferred
everything from W2K to W2K3.
"Adrian M." wrote:
> Does this happen w/ the latest acrobat reader (v7.0)?
> --
> Adrian M.
> MCP
>
> "David Bienstock" <DavidBienstock@.discussions.microsoft.com> wrote in
> message news:B7583531-C4D7-4B04-9C57-E92D17921B9A@.microsoft.com...
> > We use Arial Narrow and ever since we went to a W2K3 box (from a W2K
> > installation) everything exports correctly, except for PDF which
> > substitutes
> > Helvetica or something with weird spacing. All looks good on the screen
> > and,
> > of course, Microsoft Office is installed (which is where the fonts came
> > from
> > in our W2K box).
> >
> > Any ideas of what to check? Of course the clients have the font because
> > embedding is not supported.
> > --
> > "Everyone knows something you don't know"
>
>|||David,
I have used Arial Narrow successfully on W2K3 boxes. Our production web
server did not have Office on it, so I had to put the font on the web server.
Are you sure the web server running RS has Arial Narrow installed in the
C:\windows\fonts directory? Since the PDF is generated there, the font must
be there. It doesn't matter if the end users have Arial Narrow on their
workstations.
Ted
"David Bienstock" wrote:
> We use Arial Narrow and ever since we went to a W2K3 box (from a W2K
> installation) everything exports correctly, except for PDF which substitutes
> Helvetica or something with weird spacing. All looks good on the screen and,
> of course, Microsoft Office is installed (which is where the fonts came from
> in our W2K box).
> Any ideas of what to check? Of course the clients have the font because
> embedding is not supported.
> --
> "Everyone knows something you don't know"|||So you are saying that your clients see everything correctly, but if you
open the PDF on your 2003 server it substitues fonts? Odd. I'll try the
same on our 2003 server to see if we get the same results. In the meantime,
you could try copying ARIALN.TTF (and related ArialN fonts) from a 2K box to
the 2003 box to factor out some strange corruption issue.
--
Adrian M.
MCP
"David Bienstock" <davidleebspam-sqlrs@.yahoo.com> wrote in message
news:4E1E4251-E93B-4AC0-B679-55CA254356E0@.microsoft.com...
> Yes it does. But I don't know if something happened when I transferred
> everything from W2K to W2K3.
> "Adrian M." wrote:
>> Does this happen w/ the latest acrobat reader (v7.0)?
>> --
>> Adrian M.
>> MCP
>>
>> "David Bienstock" <DavidBienstock@.discussions.microsoft.com> wrote in
>> message news:B7583531-C4D7-4B04-9C57-E92D17921B9A@.microsoft.com...
>> > We use Arial Narrow and ever since we went to a W2K3 box (from a W2K
>> > installation) everything exports correctly, except for PDF which
>> > substitutes
>> > Helvetica or something with weird spacing. All looks good on the
>> > screen
>> > and,
>> > of course, Microsoft Office is installed (which is where the fonts came
>> > from
>> > in our W2K box).
>> >
>> > Any ideas of what to check? Of course the clients have the font
>> > because
>> > embedding is not supported.
>> > --
>> > "Everyone knows something you don't know"
>>|||Yes, I checked and installed it through the Fonts control panel. But, I was
told that you have to "open the font then reboot the server". I rebooted the
server but didn't open the font. The next scheduled reboot is Saturday night.
"Ted K" wrote:
> David,
> I have used Arial Narrow successfully on W2K3 boxes. Our production web
> server did not have Office on it, so I had to put the font on the web server.
> Are you sure the web server running RS has Arial Narrow installed in the
> C:\windows\fonts directory? Since the PDF is generated there, the font must
> be there. It doesn't matter if the end users have Arial Narrow on their
> workstations.
> Ted
> "David Bienstock" wrote:
> > We use Arial Narrow and ever since we went to a W2K3 box (from a W2K
> > installation) everything exports correctly, except for PDF which substitutes
> > Helvetica or something with weird spacing. All looks good on the screen and,
> > of course, Microsoft Office is installed (which is where the fonts came from
> > in our W2K box).
> >
> > Any ideas of what to check? Of course the clients have the font because
> > embedding is not supported.
> > --
> > "Everyone knows something you don't know"|||Oh, and I think it does matter regarding the workstations because fonts are
not embedded. Strange thing, it's only PDFs. Excel, TIFF, etc. are all OK.
I can even copy from the PDF and paste into Word and it looks OK without
kerning issues, but it's not OK in the PDF.
"Ted K" wrote:
> David,
> I have used Arial Narrow successfully on W2K3 boxes. Our production web
> server did not have Office on it, so I had to put the font on the web server.
> Are you sure the web server running RS has Arial Narrow installed in the
> C:\windows\fonts directory? Since the PDF is generated there, the font must
> be there. It doesn't matter if the end users have Arial Narrow on their
> workstations.
> Ted
> "David Bienstock" wrote:
> > We use Arial Narrow and ever since we went to a W2K3 box (from a W2K
> > installation) everything exports correctly, except for PDF which substitutes
> > Helvetica or something with weird spacing. All looks good on the screen and,
> > of course, Microsoft Office is installed (which is where the fonts came from
> > in our W2K box).
> >
> > Any ideas of what to check? Of course the clients have the font because
> > embedding is not supported.
> > --
> > "Everyone knows something you don't know"|||Hi,
Acrobat (Reader) has the option to use the local fonts. If turned on Acrobat
also uses local fonts for redering not embedded fonts. If turned off only the
embedded fonts are used. And because all fonts have a embedded substitute
font, these fonts are snown by this one. Helvetica is a substitute for Arial
Narrow. Press Ctrl+Shift+Y for turning it on or off. or Document -> Use Local
Fonts.
Jan Pieter Posthuma
"David Bienstock" wrote:
> Oh, and I think it does matter regarding the workstations because fonts are
> not embedded. Strange thing, it's only PDFs. Excel, TIFF, etc. are all OK.
> I can even copy from the PDF and paste into Word and it looks OK without
> kerning issues, but it's not OK in the PDF.
> "Ted K" wrote:
> > David,
> > I have used Arial Narrow successfully on W2K3 boxes. Our production web
> > server did not have Office on it, so I had to put the font on the web server.
> > Are you sure the web server running RS has Arial Narrow installed in the
> > C:\windows\fonts directory? Since the PDF is generated there, the font must
> > be there. It doesn't matter if the end users have Arial Narrow on their
> > workstations.
> >
> > Ted
> >
> > "David Bienstock" wrote:
> >
> > > We use Arial Narrow and ever since we went to a W2K3 box (from a W2K
> > > installation) everything exports correctly, except for PDF which substitutes
> > > Helvetica or something with weird spacing. All looks good on the screen and,
> > > of course, Microsoft Office is installed (which is where the fonts came from
> > > in our W2K box).
> > >
> > > Any ideas of what to check? Of course the clients have the font because
> > > embedding is not supported.
> > > --
> > > "Everyone knows something you don't know"|||I shall look at that. But keep in mind that everything was OK with SQL RS on
W2K then we moved to W2K3, installed Office, RS, Acrobat 7, etc, and now this
is the only thing not working with ALL clients.
"Jan Pieter Posthuma" wrote:
> Hi,
> Acrobat (Reader) has the option to use the local fonts. If turned on Acrobat
> also uses local fonts for redering not embedded fonts. If turned off only the
> embedded fonts are used. And because all fonts have a embedded substitute
> font, these fonts are snown by this one. Helvetica is a substitute for Arial
> Narrow. Press Ctrl+Shift+Y for turning it on or off. or Document -> Use Local
> Fonts.
> Jan Pieter Posthuma
> "David Bienstock" wrote:
> > Oh, and I think it does matter regarding the workstations because fonts are
> > not embedded. Strange thing, it's only PDFs. Excel, TIFF, etc. are all OK.
> > I can even copy from the PDF and paste into Word and it looks OK without
> > kerning issues, but it's not OK in the PDF.
> >
> > "Ted K" wrote:
> >
> > > David,
> > > I have used Arial Narrow successfully on W2K3 boxes. Our production web
> > > server did not have Office on it, so I had to put the font on the web server.
> > > Are you sure the web server running RS has Arial Narrow installed in the
> > > C:\windows\fonts directory? Since the PDF is generated there, the font must
> > > be there. It doesn't matter if the end users have Arial Narrow on their
> > > workstations.
> > >
> > > Ted
> > >
> > > "David Bienstock" wrote:
> > >
> > > > We use Arial Narrow and ever since we went to a W2K3 box (from a W2K
> > > > installation) everything exports correctly, except for PDF which substitutes
> > > > Helvetica or something with weird spacing. All looks good on the screen and,
> > > > of course, Microsoft Office is installed (which is where the fonts came from
> > > > in our W2K box).
> > > >
> > > > Any ideas of what to check? Of course the clients have the font because
> > > > embedding is not supported.
> > > > --
> > > > "Everyone knows something you don't know"