Sunday, February 26, 2012

File source error : so much rows

Hello,

I have a problem with my SSIS. I have a data flow with a file source in csv, but itself has 140 000 rows, so when I execute the date flow, I have a error who say that the data exceed the temp of I/O (sorry for the translate, but I have the message in french).
I test to pass the DefaultBufferMaxRow to 140000 but I have always the problem.

If we can help me, thank you.
You might try setting the BufferTempStoragePath property on the data flow to point to a drive with plenty of free space. If you search on the forum for that property, you'll find more information.|||Ok, I go to search it.

Thank you for your answer.

File source error : so much rows

Hello,

I have a problem with my SSIS. I have a data flow with a file source in csv, but itself has 140 000 rows, so when I execute the date flow, I have a error who say that the data exceed the temp of I/O (sorry for the translate, but I have the message in french).
I test to pass the DefaultBufferMaxRow to 140000 but I have always the problem.

If we can help me, thank you.
You might try setting the BufferTempStoragePath property on the data flow to point to a drive with plenty of free space. If you search on the forum for that property, you'll find more information.|||Ok, I go to search it.

Thank you for your answer.

file size of restore

I don't know why it wants 500GB but you do need the entire size of the data
and log files not just the data itself. It is a good idea to have extra
space but you may be pushing it a little too far if you only have 3GB.
Andrew J. Kelly SQL MVP
"Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
news:VvGdna6Hf7i_DF3bnZ2dnUVZ8rOdnZ2d@.bt.com...
> Hi
> I did an initial file size of a db to 100GB .
> The backups reflect the true size of the DB (about 3GB). However if you
> try and restore the DB it wants 500GB of disk space. Is there anyway to
> restore so it only restores the size of the data?
>
>
>
>
>
>I don't know why it wants 500GB
Perhaps the initial size was 100GB and it has now grown to 500GB? Doesn't change what you are
saying, though... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OMhxzCd3HHA.2312@.TK2MSFTNGP06.phx.gbl...
>I don't know why it wants 500GB but you do need the entire size of the data and log files not just
>the data itself. It is a good idea to have extra space but you may be pushing it a little too far
>if you only have 3GB.
> --
> Andrew J. Kelly SQL MVP
> "Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
> news:VvGdna6Hf7i_DF3bnZ2dnUVZ8rOdnZ2d@.bt.com...
>

file size of restore

Hi
I did an initial file size of a db to 100GB .
The backups reflect the true size of the DB (about 3GB). However if you
try and restore the DB it wants 500GB of disk space. Is there anyway to
restore so it only restores the size of the data?I don't know why it wants 500GB but you do need the entire size of the data
and log files not just the data itself. It is a good idea to have extra
space but you may be pushing it a little too far if you only have 3GB.
Andrew J. Kelly SQL MVP
"Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
news:VvGdna6Hf7i_DF3bnZ2dnUVZ8rOdnZ2d@.bt
.com...
> Hi
> I did an initial file size of a db to 100GB .
> The backups reflect the true size of the DB (about 3GB). However if you
> try and restore the DB it wants 500GB of disk space. Is there anyway to
> restore so it only restores the size of the data?
>
>
>
>
>|||>I don't know why it wants 500GB
Perhaps the initial size was 100GB and it has now grown to 500GB? Doesn't ch
ange what you are
saying, though... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OMhxzCd3HHA.2312@.TK2MSFTNGP06.phx.gbl...
>I don't know why it wants 500GB but you do need the entire size of the data
and log files not just
>the data itself. It is a good idea to have extra space but you may be pushi
ng it a little too far
>if you only have 3GB.
> --
> Andrew J. Kelly SQL MVP
> "Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
> news:VvGdna6Hf7i_DF3bnZ2dnUVZ8rOdnZ2d@.bt
.com...
>|||Only thing that makes sense to me is that 1) the data file has grown to
500GB or more likely the LOG file has grown unchecked to 400GB because you
had Full Recovery Mode set but never backed up the log file.
TheSQLGuru
President
Indicium Resources, Inc.
"Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
news:VvGdna6Hf7i_DF3bnZ2dnUVZ8rOdnZ2d@.bt
.com...
> Hi
> I did an initial file size of a db to 100GB .
> The backups reflect the true size of the DB (about 3GB). However if you
> try and restore the DB it wants 500GB of disk space. Is there anyway to
> restore so it only restores the size of the data?
>
>
>
>
>

file size of restore

Hi
I did an initial file size of a db to 100GB .
The backups reflect the true size of the DB (about 3GB). However if you
try and restore the DB it wants 500GB of disk space. Is there anyway to
restore so it only restores the size of the data?I don't know why it wants 500GB but you do need the entire size of the data
and log files not just the data itself. It is a good idea to have extra
space but you may be pushing it a little too far if you only have 3GB.
--
Andrew J. Kelly SQL MVP
"Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
news:VvGdna6Hf7i_DF3bnZ2dnUVZ8rOdnZ2d@.bt.com...
> Hi
> I did an initial file size of a db to 100GB .
> The backups reflect the true size of the DB (about 3GB). However if you
> try and restore the DB it wants 500GB of disk space. Is there anyway to
> restore so it only restores the size of the data?
>
>
>
>
>|||>I don't know why it wants 500GB
Perhaps the initial size was 100GB and it has now grown to 500GB? Doesn't change what you are
saying, though... :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OMhxzCd3HHA.2312@.TK2MSFTNGP06.phx.gbl...
>I don't know why it wants 500GB but you do need the entire size of the data and log files not just
>the data itself. It is a good idea to have extra space but you may be pushing it a little too far
>if you only have 3GB.
> --
> Andrew J. Kelly SQL MVP
> "Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
> news:VvGdna6Hf7i_DF3bnZ2dnUVZ8rOdnZ2d@.bt.com...
>> Hi
>> I did an initial file size of a db to 100GB .
>> The backups reflect the true size of the DB (about 3GB). However if you
>> try and restore the DB it wants 500GB of disk space. Is there anyway to
>> restore so it only restores the size of the data?
>>
>>
>>
>>
>>
>|||Only thing that makes sense to me is that 1) the data file has grown to
500GB or more likely the LOG file has grown unchecked to 400GB because you
had Full Recovery Mode set but never backed up the log file.
--
TheSQLGuru
President
Indicium Resources, Inc.
"Jack Vamvas" <DEL_TO_REPLY@.del.com> wrote in message
news:VvGdna6Hf7i_DF3bnZ2dnUVZ8rOdnZ2d@.bt.com...
> Hi
> I did an initial file size of a db to 100GB .
> The backups reflect the true size of the DB (about 3GB). However if you
> try and restore the DB it wants 500GB of disk space. Is there anyway to
> restore so it only restores the size of the data?
>
>
>
>
>

File Size Limitation

Hi,
I'm trying to upload word documet to report server. I got an error message
that maximum size exceeded. Can anyone tell what's the limitation of size of
the file to be uploaded?
--
Thanks,
IDYou may want to check this related thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=74513284-1467-4a32-b711-bdd7598292e0&sloc=en-us
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"exkievan" <exkievan@.discussions.microsoft.com> wrote in message
news:5E3FA1CA-1C7D-45AB-9F3D-668D26899239@.microsoft.com...
> Hi,
> I'm trying to upload word documet to report server. I got an error message
> that maximum size exceeded. Can anyone tell what's the limitation of size
> of
> the file to be uploaded?
> --
> Thanks,
> ID|||Thanks
"Robert Bruckner [MSFT]" wrote:
> You may want to check this related thread:
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=74513284-1467-4a32-b711-bdd7598292e0&sloc=en-us
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "exkievan" <exkievan@.discussions.microsoft.com> wrote in message
> news:5E3FA1CA-1C7D-45AB-9F3D-668D26899239@.microsoft.com...
> > Hi,
> >
> > I'm trying to upload word documet to report server. I got an error message
> > that maximum size exceeded. Can anyone tell what's the limitation of size
> > of
> > the file to be uploaded?
> > --
> > Thanks,
> >
> > ID
>
>

File size limit / offline cache

Hi,

I have 2 questions:

    Is there any way of getting around the 128MB file size limit when creating and adding SSEv databases to VS2005? Currently I get the following error when trying to connect to a database:"The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only...". This after I altered the app.config file to "...Max Database Size=600;..." Have anyone tried to use SSEv to cache data with the use of the Smart Application Offline Building Block? Is there a provider I can use for doing this?

Thanks in advance!

A SQLEv database can be up to 4GB in size. You control the maximum size of the database through the connection string. See the System.Data.SqlServerCe.SqlCeConnection MSDN documentation for details on this and other connection string parameters that you'll want to know about when working with large databases (e.g. Autoshrink threshold comes to mind)

http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection.connectionstring.aspx

Have a look at the new Mobile Client Software Factory published on MSDN - it includes an off-line app block for use with SQL Mobile and should be directly applicable to SQLEv.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/mcsflp.asp

Darren

File size limit / offline cache

Hi,

I have 2 questions:

    Is there any way of getting around the 128MB file size limit when creating and adding SSEv databases to VS2005? Currently I get the following error when trying to connect to a database:"The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only...". This after I altered the app.config file to "...Max Database Size=600;..."

    Have anyone tried to use SSEv to cache data with the use of the Smart Application Offline Building Block? Is there a provider I can use for doing this?

Thanks in advance!

A SQLEv database can be up to 4GB in size. You control the maximum size of the database through the connection string. See the System.Data.SqlServerCe.SqlCeConnection MSDN documentation for details on this and other connection string parameters that you'll want to know about when working with large databases (e.g. Autoshrink threshold comes to mind)

http://msdn2.microsoft.com/en-us/library/system.data.sqlserverce.sqlceconnection.connectionstring.aspx

Have a look at the new Mobile Client Software Factory published on MSDN - it includes an off-line app block for use with SQL Mobile and should be directly applicable to SQLEv.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/mcsflp.asp

Darren

File size is growing fast

Hi,
My SQL database is about 90MB and start growing very fast to 1000MB over a
w time. I try to shrink from the EM with no success. I notice that only
the size of the log file is reduced. Is there a way to do shrink the
database file through Query Analyzer.
I also want to run the shrink statement at the time of starting the service.
I know that there is a SP in the Master DB that do this.
Any advice on the above topic would be very grateful
SFDBCC SHRINKDATABASE
( database_name [ , target_percent ]
[ , { NOTRUNCATE | TRUNCATEONLY } ]
)
DBCC SHRINKFILE
( { file_name | file_id }
{ [ , target_size ]
| [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ]
}
)
You need to run the DBCC SHRIKNDATABASE first and then execute the DBCC
SHRINKFILE for both files, data and log.
Another note, usually there is a reason for the files to grow to the size
they are before you shrink them. You may want to identify and monitor it. Yo
u
don't want to shrink a file which will be expanded subsequently due to the
normal processing. Expanding a file could be affect performance, specially i
t
it happens during peak hours.
"SF" wrote:

> Hi,
> My SQL database is about 90MB and start growing very fast to 1000MB over a
> w time. I try to shrink from the EM with no success. I notice that only
> the size of the log file is reduced. Is there a way to do shrink the
> database file through Query Analyzer.
> I also want to run the shrink statement at the time of starting the servic
e.
> I know that there is a SP in the Master DB that do this.
> Any advice on the above topic would be very grateful
> SF
>
>|||> I also want to run the shrink statement at the time of starting the servic
e.
I suggest you read this:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"SF" <socfund@.online.com.kh> wrote in message news:ungJVRrWGHA.1192@.TK2MSFTNGP03.phx.gbl...

> Hi,
> My SQL database is about 90MB and start growing very fast to 1000MB over a
> w time. I try to shrink from the EM with no success. I notice that only
> the size of the log file is reduced. Is there a way to do shrink the
> database file through Query Analyzer.
> I also want to run the shrink statement at the time of starting the servic
e.
> I know that there is a SP in the Master DB that do this.
> Any advice on the above topic would be very grateful
> SF
>|||Is the size of the data file (mdf) growing quickly? or that of the log file
(ldf)?
You can check the size of the database files, and if it is the log file that
grows quickly, you are suggested to implement appropriate backup strategy
accordingly.
Martin C K Poon
Senior Analyst Programmer
====================================
"SF" <socfund@.online.com.kh> bl
news:ungJVRrWGHA.1192@.TK2MSFTNGP03.phx.gbl g...
> Hi,
> My SQL database is about 90MB and start growing very fast to 1000MB over a
> w time. I try to shrink from the EM with no success. I notice that only
> the size of the log file is reduced. Is there a way to do shrink the
> database file through Query Analyzer.
> I also want to run the shrink statement at the time of starting the
service.
> I know that there is a SP in the Master DB that do this.
> Any advice on the above topic would be very grateful
> SF
>|||It is the size of the data file (mdf) that grows quickly.
SF
"Martin C K Poon" < martin__dot__poon__at__multiable__dot__c
om> wrote in
message news:eyqL#OwWGHA.4972@.TK2MSFTNGP02.phx.gbl...
> Is the size of the data file (mdf) growing quickly? or that of the log
file
> (ldf)?
> You can check the size of the database files, and if it is the log file
that
> grows quickly, you are suggested to implement appropriate backup strategy
> accordingly.
> --
> Martin C K Poon
> Senior Analyst Programmer
> ====================================
> "SF" <socfund@.online.com.kh> bl
> news:ungJVRrWGHA.1192@.TK2MSFTNGP03.phx.gbl g...
a
only
> service.
>|||SF (socfund@.online.com.kh) writes:
> It is the size of the data file (mdf) that grows quickly.
Most likely then it grows because you are adding a lot of data to it.
If you don't expect it to grow that fast, you should examine what is
going on.
First run this:
exec sp_spaceused null, true
to get accurate information on space within the file.
Then run
SELECT object_name(id), reserved, used
FROM sysindexes
WHERE indid IN (0, 1)
ORDER BY reserved DESC
to see which objects that are taking space in your database.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||You might want to check the default fillfactor (server level) (Database
Settings Tab or run sp_configure)...I have seen this happen when somone
changed this setting without knowing what they were doing.

FILE SIZE IN MODEL

Hi,
where Can I see the default size of new database in database MODEL ?

In which table ?

Saimon(Florence)Unless you specify otherwise, new databases will be created the same size as
model. You can query the model database properties with:

EXEC sp_helpdb 'model'

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Saimon" <saimon181072@.supereva.it> wrote in message
news:c53q0m$on9$1@.newsreader.mailgate.org...
> Hi,
> where Can I see the default size of new database in database MODEL ?
> In which table ?
> Saimon(Florence)

File Size for SQL Server 2005 Error Log

Hello,
My SQL Server 2005 error log is getting very, very large... Like 4 GB in 4
days... How can I recycle my error log so that it doesnt' overrun my c:
drive. Also, if there's a way to move the error log from the c: drive to
another drive, that would also help.
Thanks.
Adam F. HarrisOn Mar 14, 5:39 pm, "Adam Harris" <a...@.jgo.com> wrote:
> Hello,
> My SQL Server 2005 error log is getting very, very large... Like 4 GB in 4
> days... How can I recycle my error log so that it doesnt' overrun my c:
> drive. Also, if there's a way to move the error log from the c: drive to
> another drive, that would also help.
> Thanks.
> Adam F. Harris
You will want to execute sp_cycle_errorlog periodically. I would
suggest scheduling a job that runs it as well.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Hello Enrique,
Ok, that sounds great, but I have no idea how to do that... Do you have a
website or documentation to do that?
Thanks.
Adam F. Harris
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1173921963.231488.253620@.b75g2000hsg.googlegroups.com...
> On Mar 14, 5:39 pm, "Adam Harris" <a...@.jgo.com> wrote:
>> Hello,
>> My SQL Server 2005 error log is getting very, very large... Like 4 GB in
>> 4
>> days... How can I recycle my error log so that it doesnt' overrun my c:
>> drive. Also, if there's a way to move the error log from the c: drive to
>> another drive, that would also help.
>> Thanks.
>> Adam F. Harris
> You will want to execute sp_cycle_errorlog periodically. I would
> suggest scheduling a job that runs it as well.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>

File size big when download report

Hi
I download my report using SQL Server Reporting service export function
(excel format), The file size is very big, when compare to my previous asp
download function.
Note: The no of rec is same.
Ex: Using ASP, the file size is about 1000 kb
Using RS, the file size is about 23,000 kb.
Pls help me, what should I do to reduce the file size to normal.
Thanks
Regards
Kumar.Are you using SP1 version of RS? SP1 introduced excel using its native
store, while RTM used MHTML which was much larger.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:5126C810-2785-4B32-A46C-6FB085FCAADD@.microsoft.com...
> Hi
> I download my report using SQL Server Reporting service export function
> (excel format), The file size is very big, when compare to my previous asp
> download function.
> Note: The no of rec is same.
> Ex: Using ASP, the file size is about 1000 kb
> Using RS, the file size is about 23,000 kb.
> Pls help me, what should I do to reduce the file size to normal.
> Thanks
> Regards
> Kumar.
>

File Size Best Pratice

Hi,
There may be a FAQ covering this. If so, please point that to me.
I have data about the size of 40GB to be loaded onto a RAID configuration
for SQL Server 2000 on Windows Server 2003. Should I use one database
file of the size 40GB, 10 database files (each about 4GB), or 20 database
files (each about 2GB)?
What is the best practice for this? What are the pros and cons?
Thanks,
Wenbin ZhangThere is no official best practice that I know of. But with a DB of only
40GB a single file should be fine. SQL Server 2000 can use multiple threads
to read the same file and the Raid will also split the data between multiple
physical drives as well. You can certainly add multiple files if you like
but the more you add the harder it gets to maintain them. And with a DB that
small you probably don't have much to gain by adding more files unless you
want to isolate tables or indexes onto separate filegroups.
--
Andrew J. Kelly SQL MVP
"Wenbin Zhang" <wzhang@.onesource.com> wrote in message
news:uHk3xKh3EHA.2156@.TK2MSFTNGP10.phx.gbl...
> Hi,
> There may be a FAQ covering this. If so, please point that to me.
> I have data about the size of 40GB to be loaded onto a RAID configuration
> for SQL Server 2000 on Windows Server 2003. Should I use one database
> file of the size 40GB, 10 database files (each about 4GB), or 20 database
> files (each about 2GB)?
> What is the best practice for this? What are the pros and cons?
> Thanks,
> Wenbin Zhang
>

File Size Best Pratice

Hi,
There may be a FAQ covering this. If so, please point that to me.
I have data about the size of 40GB to be loaded onto a RAID configuration
for SQL Server 2000 on Windows Server 2003. Should I use one database
file of the size 40GB, 10 database files (each about 4GB), or 20 database
files (each about 2GB)?
What is the best practice for this? What are the pros and cons?
Thanks,
Wenbin Zhang
There is no official best practice that I know of. But with a DB of only
40GB a single file should be fine. SQL Server 2000 can use multiple threads
to read the same file and the Raid will also split the data between multiple
physical drives as well. You can certainly add multiple files if you like
but the more you add the harder it gets to maintain them. And with a DB that
small you probably don't have much to gain by adding more files unless you
want to isolate tables or indexes onto separate filegroups.
Andrew J. Kelly SQL MVP
"Wenbin Zhang" <wzhang@.onesource.com> wrote in message
news:uHk3xKh3EHA.2156@.TK2MSFTNGP10.phx.gbl...
> Hi,
> There may be a FAQ covering this. If so, please point that to me.
> I have data about the size of 40GB to be loaded onto a RAID configuration
> for SQL Server 2000 on Windows Server 2003. Should I use one database
> file of the size 40GB, 10 database files (each about 4GB), or 20 database
> files (each about 2GB)?
> What is the best practice for this? What are the pros and cons?
> Thanks,
> Wenbin Zhang
>

File Size - Probably missing something basic...

We have one main data file, and I would like to track how
fast it grows.
In the Task Pad of SQL Server it gives the file size as X
By running "select * from sysfiles" I get Y,
But by looking at the actual file size I get Z.
Can anyone tell me whats happening ?
JI'm not sure what you mean by the taskpad of SQL Server.. but here goes.
The sysfiles table shows the size of your database is 8k data pages. So you
need to multiply that number by 8.
For example: select * from sysfiles (while in my master database) reveals
the following two files.
size: 1464
size: 96
If I multiply those out as: SELECT ((1464 * 8) + (96 * 8)) you get about 12
MBs
Now if I go out to my: \Program Files\Microsoft SQL Server\MSSQL\Data
My master.mdb file is 11.4 MB
and the ldf file is .7 MB
That makes just over 12 MB... So these are the same.
If I right-click the database in Enterprise Manager and choose properties, I
get just over 12 MB's...
So, these are all the same size as far as I can see...
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
news:4cb201c490f4$f09a23b0$a501280a@.phx.gbl...
> We have one main data file, and I would like to track how
> fast it grows.
> In the Task Pad of SQL Server it gives the file size as X
> By running "select * from sysfiles" I get Y,
> But by looking at the actual file size I get Z.
> Can anyone tell me whats happening ?
> J|||Thanks for that.
What I mean by taskpad is if you go to SQL Server, select
the database, then View -> Taskpad it shows the size of
the file.
J
>--Original Message--
>I'm not sure what you mean by the taskpad of SQL
Server.. but here goes.
>The sysfiles table shows the size of your database is 8k
data pages. So you
>need to multiply that number by 8.
>For example: select * from sysfiles (while in my master
database) reveals
>the following two files.
>size: 1464
>size: 96
>If I multiply those out as: SELECT ((1464 * 8) + (96 *
8)) you get about 12
>MBs
>
>Now if I go out to my: \Program Files\Microsoft SQL
Server\MSSQL\Data
>My master.mdb file is 11.4 MB
>and the ldf file is .7 MB
>That makes just over 12 MB... So these are the same.
>If I right-click the database in Enterprise Manager and
choose properties, I
>get just over 12 MB's...
>
>So, these are all the same size as far as I can see...
>
>HTH
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>
>
>
>"Jimbo" <anonymous@.discussions.microsoft.com> wrote in
message
>news:4cb201c490f4$f09a23b0$a501280a@.phx.gbl...
>> We have one main data file, and I would like to track
how
>> fast it grows.
>> In the Task Pad of SQL Server it gives the file size as
X
>> By running "select * from sysfiles" I get Y,
>> But by looking at the actual file size I get Z.
>> Can anyone tell me whats happening ?
>> J
>
>.
>

File Size - Probably missing something basic...

We have one main data file, and I would like to track how
fast it grows.
In the Task Pad of SQL Server it gives the file size as X
By running "select * from sysfiles" I get Y,
But by looking at the actual file size I get Z.
Can anyone tell me whats happening ?
JI'm not sure what you mean by the taskpad of SQL Server.. but here goes.
The sysfiles table shows the size of your database is 8k data pages. So you
need to multiply that number by 8.
For example: select * from sysfiles (while in my master database) reveals
the following two files.
size: 1464
size: 96
If I multiply those out as: SELECT ((1464 * 8) + (96 * 8)) you get about 12
MBs
Now if I go out to my: \Program Files\Microsoft SQL Server\MSSQL\Data
My master.mdb file is 11.4 MB
and the ldf file is .7 MB
That makes just over 12 MB... So these are the same.
If I right-click the database in Enterprise Manager and choose properties, I
get just over 12 MB's...
So, these are all the same size as far as I can see...
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
news:4cb201c490f4$f09a23b0$a501280a@.phx.gbl...
> We have one main data file, and I would like to track how
> fast it grows.
> In the Task Pad of SQL Server it gives the file size as X
> By running "select * from sysfiles" I get Y,
> But by looking at the actual file size I get Z.
> Can anyone tell me whats happening ?
> J|||Thanks for that.
What I mean by taskpad is if you go to SQL Server, select
the database, then View -> Taskpad it shows the size of
the file.
J

>--Original Message--
>I'm not sure what you mean by the taskpad of SQL
Server.. but here goes.
>The sysfiles table shows the size of your database is 8k
data pages. So you
>need to multiply that number by 8.
>For example: select * from sysfiles (while in my master
database) reveals
>the following two files.
>size: 1464
>size: 96
>If I multiply those out as: SELECT ((1464 * 8) + (96 *
8)) you get about 12
>MBs
>
>Now if I go out to my: \Program Files\Microsoft SQL
Server\MSSQL\Data
>My master.mdb file is 11.4 MB
>and the ldf file is .7 MB
>That makes just over 12 MB... So these are the same.
>If I right-click the database in Enterprise Manager and
choose properties, I
>get just over 12 MB's...
>
>So, these are all the same size as far as I can see...
>
>HTH
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>
>
>
>"Jimbo" <anonymous@.discussions.microsoft.com> wrote in
message
>news:4cb201c490f4$f09a23b0$a501280a@.phx.gbl...
how[vbcol=seagreen]
X[vbcol=seagreen]
>
>.
>

File Size - Probably missing something basic...

We have one main data file, and I would like to track how
fast it grows.
In the Task Pad of SQL Server it gives the file size as X
By running "select * from sysfiles" I get Y,
But by looking at the actual file size I get Z.
Can anyone tell me whats happening ?
J
I'm not sure what you mean by the taskpad of SQL Server.. but here goes.
The sysfiles table shows the size of your database is 8k data pages. So you
need to multiply that number by 8.
For example: select * from sysfiles (while in my master database) reveals
the following two files.
size: 1464
size: 96
If I multiply those out as: SELECT ((1464 * 8) + (96 * 8)) you get about 12
MBs
Now if I go out to my: \Program Files\Microsoft SQL Server\MSSQL\Data
My master.mdb file is 11.4 MB
and the ldf file is .7 MB
That makes just over 12 MB... So these are the same.
If I right-click the database in Enterprise Manager and choose properties, I
get just over 12 MB's...
So, these are all the same size as far as I can see...
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"Jimbo" <anonymous@.discussions.microsoft.com> wrote in message
news:4cb201c490f4$f09a23b0$a501280a@.phx.gbl...
> We have one main data file, and I would like to track how
> fast it grows.
> In the Task Pad of SQL Server it gives the file size as X
> By running "select * from sysfiles" I get Y,
> But by looking at the actual file size I get Z.
> Can anyone tell me whats happening ?
> J
|||Thanks for that.
What I mean by taskpad is if you go to SQL Server, select
the database, then View -> Taskpad it shows the size of
the file.
J

>--Original Message--
>I'm not sure what you mean by the taskpad of SQL
Server.. but here goes.
>The sysfiles table shows the size of your database is 8k
data pages. So you
>need to multiply that number by 8.
>For example: select * from sysfiles (while in my master
database) reveals
>the following two files.
>size: 1464
>size: 96
>If I multiply those out as: SELECT ((1464 * 8) + (96 *
8)) you get about 12
>MBs
>
>Now if I go out to my: \Program Files\Microsoft SQL
Server\MSSQL\Data
>My master.mdb file is 11.4 MB
>and the ldf file is .7 MB
>That makes just over 12 MB... So these are the same.
>If I right-click the database in Enterprise Manager and
choose properties, I
>get just over 12 MB's...
>
>So, these are all the same size as far as I can see...
>
>HTH
>Rick Sawtell
>MCT, MCSD, MCDBA
>
>
>
>
>"Jimbo" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:4cb201c490f4$f09a23b0$a501280a@.phx.gbl...
how[vbcol=seagreen]
X
>
>.
>

File Shrinking

I have a data file that was created from an ISA web Proxy application that
is (being used by our networking department) 50 gig in size, and I would
like it to be around 5 gig if possible. The problem is that it was
initially creatred at 38 gig, so I cannnot shrink it below this amount. It
has no free space allocated!!! I thought i could even delete some hundred
thousand records from the one and only table in the database, but i can't
even do that without it timing out, or telling me the transaction log is
full. I'm using simple recovery, so i thought the log file would not grow
upon this huge deletion transaction but it did grow enormously. I then
disabled automatic file growth on the log, but it tells me the log file is
full and it won't perform the transaction. I have shrunk the transaction
log down to 500K, but still nothing. I'm using sql server 2005, with
windows xp.
Overall, how can i make this data file smaller? I have tried everything I
know with the transaction log, and manually deleting , but nothing seems to
work.
Error messages:
The transaction log for database 'ISAWebProxyLog' is full. To find out why
space in the log cannot be reused, see the log_reuse_wait_desc column in
sys.databases (this column says NOTHING)
or
A problem occurred attempting to delete row 1. Error source:
Microsoft.visualstudio.datatools. Error Message: The row values updated or
deleted either do not make the row unique or they alter multiple rows.
Correct the errors and attempt to delete the row again.That is why you should never create the files that large to begin with.
Create them relatively small then manually grow them to the size you need
for the next year or so. But in any case you can delete the rows in small
batches so that the tran log can be truncated in-between batches.
SET ROWCOUNT 50000
WHILE 1 = 1
BEGIN
DELETE FROM Table WHERE xxx
IF @.@.ROWCOUNT = 0
EXIT
END
SET ROWCOUNT 0
Another alternative is to export the data you wish to keep. Drop the DB and
create a new one with a smaller size. Then import the data back in.
Andrew J. Kelly SQL MVP
"Matt Fritz" <mafritz@.state.pa.us> wrote in message
news:eoSDUbHpHHA.5092@.TK2MSFTNGP04.phx.gbl...
>I have a data file that was created from an ISA web Proxy application that
> is (being used by our networking department) 50 gig in size, and I would
> like it to be around 5 gig if possible. The problem is that it was
> initially creatred at 38 gig, so I cannnot shrink it below this amount.
> It
> has no free space allocated!!! I thought i could even delete some hundred
> thousand records from the one and only table in the database, but i can't
> even do that without it timing out, or telling me the transaction log is
> full. I'm using simple recovery, so i thought the log file would not grow
> upon this huge deletion transaction but it did grow enormously. I then
> disabled automatic file growth on the log, but it tells me the log file is
> full and it won't perform the transaction. I have shrunk the transaction
> log down to 500K, but still nothing. I'm using sql server 2005, with
> windows xp.
> Overall, how can i make this data file smaller? I have tried everything I
> know with the transaction log, and manually deleting , but nothing seems
> to
> work.
> Error messages:
> The transaction log for database 'ISAWebProxyLog' is full. To find out why
> space in the log cannot be reused, see the log_reuse_wait_desc column in
> sys.databases (this column says NOTHING)
> or
> A problem occurred attempting to delete row 1. Error source:
> Microsoft.visualstudio.datatools. Error Message: The row values updated
> or
> deleted either do not make the row unique or they alter multiple rows.
> Correct the errors and attempt to delete the row again.
>|||The second error message you indicate lets me think that your table is an
Heap (no indexes nor primary key). In some cases this situation causes this
kind of error
Gilberto Zampatti
"Andrew J. Kelly" wrote:

> That is why you should never create the files that large to begin with.
> Create them relatively small then manually grow them to the size you need
> for the next year or so. But in any case you can delete the rows in small
> batches so that the tran log can be truncated in-between batches.
> SET ROWCOUNT 50000
> WHILE 1 = 1
> BEGIN
> DELETE FROM Table WHERE xxx
> IF @.@.ROWCOUNT = 0
> EXIT
> END
> SET ROWCOUNT 0
>
> Another alternative is to export the data you wish to keep. Drop the DB a
nd
> create a new one with a smaller size. Then import the data back in.
> --
> Andrew J. Kelly SQL MVP
> "Matt Fritz" <mafritz@.state.pa.us> wrote in message
> news:eoSDUbHpHHA.5092@.TK2MSFTNGP04.phx.gbl...
>
>

File Shrinking

I have a data file that was created from an ISA web Proxy application that
is (being used by our networking department) 50 gig in size, and I would
like it to be around 5 gig if possible. The problem is that it was
initially creatred at 38 gig, so I cannnot shrink it below this amount. It
has no free space allocated!!! I thought i could even delete some hundred
thousand records from the one and only table in the database, but i can't
even do that without it timing out, or telling me the transaction log is
full. I'm using simple recovery, so i thought the log file would not grow
upon this huge deletion transaction but it did grow enormously. I then
disabled automatic file growth on the log, but it tells me the log file is
full and it won't perform the transaction. I have shrunk the transaction
log down to 500K, but still nothing. I'm using sql server 2005, with
windows xp.
Overall, how can i make this data file smaller? I have tried everything I
know with the transaction log, and manually deleting , but nothing seems to
work.
Error messages:
The transaction log for database 'ISAWebProxyLog' is full. To find out why
space in the log cannot be reused, see the log_reuse_wait_desc column in
sys.databases (this column says NOTHING)
or
A problem occurred attempting to delete row 1. Error source:
Microsoft.visualstudio.datatools. Error Message: The row values updated or
deleted either do not make the row unique or they alter multiple rows.
Correct the errors and attempt to delete the row again.That is why you should never create the files that large to begin with.
Create them relatively small then manually grow them to the size you need
for the next year or so. But in any case you can delete the rows in small
batches so that the tran log can be truncated in-between batches.
SET ROWCOUNT 50000
WHILE 1 = 1
BEGIN
DELETE FROM Table WHERE xxx
IF @.@.ROWCOUNT = 0
EXIT
END
SET ROWCOUNT 0
Another alternative is to export the data you wish to keep. Drop the DB and
create a new one with a smaller size. Then import the data back in.
--
Andrew J. Kelly SQL MVP
"Matt Fritz" <mafritz@.state.pa.us> wrote in message
news:eoSDUbHpHHA.5092@.TK2MSFTNGP04.phx.gbl...
>I have a data file that was created from an ISA web Proxy application that
> is (being used by our networking department) 50 gig in size, and I would
> like it to be around 5 gig if possible. The problem is that it was
> initially creatred at 38 gig, so I cannnot shrink it below this amount.
> It
> has no free space allocated!!! I thought i could even delete some hundred
> thousand records from the one and only table in the database, but i can't
> even do that without it timing out, or telling me the transaction log is
> full. I'm using simple recovery, so i thought the log file would not grow
> upon this huge deletion transaction but it did grow enormously. I then
> disabled automatic file growth on the log, but it tells me the log file is
> full and it won't perform the transaction. I have shrunk the transaction
> log down to 500K, but still nothing. I'm using sql server 2005, with
> windows xp.
> Overall, how can i make this data file smaller? I have tried everything I
> know with the transaction log, and manually deleting , but nothing seems
> to
> work.
> Error messages:
> The transaction log for database 'ISAWebProxyLog' is full. To find out why
> space in the log cannot be reused, see the log_reuse_wait_desc column in
> sys.databases (this column says NOTHING)
> or
> A problem occurred attempting to delete row 1. Error source:
> Microsoft.visualstudio.datatools. Error Message: The row values updated
> or
> deleted either do not make the row unique or they alter multiple rows.
> Correct the errors and attempt to delete the row again.
>|||The second error message you indicate lets me think that your table is an
Heap (no indexes nor primary key). In some cases this situation causes this
kind of error
Gilberto Zampatti
"Andrew J. Kelly" wrote:
> That is why you should never create the files that large to begin with.
> Create them relatively small then manually grow them to the size you need
> for the next year or so. But in any case you can delete the rows in small
> batches so that the tran log can be truncated in-between batches.
> SET ROWCOUNT 50000
> WHILE 1 = 1
> BEGIN
> DELETE FROM Table WHERE xxx
> IF @.@.ROWCOUNT = 0
> EXIT
> END
> SET ROWCOUNT 0
>
> Another alternative is to export the data you wish to keep. Drop the DB and
> create a new one with a smaller size. Then import the data back in.
> --
> Andrew J. Kelly SQL MVP
> "Matt Fritz" <mafritz@.state.pa.us> wrote in message
> news:eoSDUbHpHHA.5092@.TK2MSFTNGP04.phx.gbl...
> >I have a data file that was created from an ISA web Proxy application that
> > is (being used by our networking department) 50 gig in size, and I would
> > like it to be around 5 gig if possible. The problem is that it was
> > initially creatred at 38 gig, so I cannnot shrink it below this amount.
> > It
> > has no free space allocated!!! I thought i could even delete some hundred
> > thousand records from the one and only table in the database, but i can't
> > even do that without it timing out, or telling me the transaction log is
> > full. I'm using simple recovery, so i thought the log file would not grow
> > upon this huge deletion transaction but it did grow enormously. I then
> > disabled automatic file growth on the log, but it tells me the log file is
> > full and it won't perform the transaction. I have shrunk the transaction
> > log down to 500K, but still nothing. I'm using sql server 2005, with
> > windows xp.
> >
> > Overall, how can i make this data file smaller? I have tried everything I
> > know with the transaction log, and manually deleting , but nothing seems
> > to
> > work.
> >
> > Error messages:
> > The transaction log for database 'ISAWebProxyLog' is full. To find out why
> > space in the log cannot be reused, see the log_reuse_wait_desc column in
> > sys.databases (this column says NOTHING)
> >
> > or
> >
> > A problem occurred attempting to delete row 1. Error source:
> > Microsoft.visualstudio.datatools. Error Message: The row values updated
> > or
> > deleted either do not make the row unique or they alter multiple rows.
> > Correct the errors and attempt to delete the row again.
> >
> >
>
>

File Shrinking

I have a data file that was created from an ISA web Proxy application that
is (being used by our networking department) 50 gig in size, and I would
like it to be around 5 gig if possible. The problem is that it was
initially creatred at 38 gig, so I cannnot shrink it below this amount. It
has no free space allocated!!! I thought i could even delete some hundred
thousand records from the one and only table in the database, but i can't
even do that without it timing out, or telling me the transaction log is
full. I'm using simple recovery, so i thought the log file would not grow
upon this huge deletion transaction but it did grow enormously. I then
disabled automatic file growth on the log, but it tells me the log file is
full and it won't perform the transaction. I have shrunk the transaction
log down to 500K, but still nothing. I'm using sql server 2005, with
windows xp.
Overall, how can i make this data file smaller? I have tried everything I
know with the transaction log, and manually deleting , but nothing seems to
work.
Error messages:
The transaction log for database 'ISAWebProxyLog' is full. To find out why
space in the log cannot be reused, see the log_reuse_wait_desc column in
sys.databases (this column says NOTHING)
or
A problem occurred attempting to delete row 1. Error source:
Microsoft.visualstudio.datatools. Error Message: The row values updated or
deleted either do not make the row unique or they alter multiple rows.
Correct the errors and attempt to delete the row again.
That is why you should never create the files that large to begin with.
Create them relatively small then manually grow them to the size you need
for the next year or so. But in any case you can delete the rows in small
batches so that the tran log can be truncated in-between batches.
SET ROWCOUNT 50000
WHILE 1 = 1
BEGIN
DELETE FROM Table WHERE xxx
IF @.@.ROWCOUNT = 0
EXIT
END
SET ROWCOUNT 0
Another alternative is to export the data you wish to keep. Drop the DB and
create a new one with a smaller size. Then import the data back in.
Andrew J. Kelly SQL MVP
"Matt Fritz" <mafritz@.state.pa.us> wrote in message
news:eoSDUbHpHHA.5092@.TK2MSFTNGP04.phx.gbl...
>I have a data file that was created from an ISA web Proxy application that
> is (being used by our networking department) 50 gig in size, and I would
> like it to be around 5 gig if possible. The problem is that it was
> initially creatred at 38 gig, so I cannnot shrink it below this amount.
> It
> has no free space allocated!!! I thought i could even delete some hundred
> thousand records from the one and only table in the database, but i can't
> even do that without it timing out, or telling me the transaction log is
> full. I'm using simple recovery, so i thought the log file would not grow
> upon this huge deletion transaction but it did grow enormously. I then
> disabled automatic file growth on the log, but it tells me the log file is
> full and it won't perform the transaction. I have shrunk the transaction
> log down to 500K, but still nothing. I'm using sql server 2005, with
> windows xp.
> Overall, how can i make this data file smaller? I have tried everything I
> know with the transaction log, and manually deleting , but nothing seems
> to
> work.
> Error messages:
> The transaction log for database 'ISAWebProxyLog' is full. To find out why
> space in the log cannot be reused, see the log_reuse_wait_desc column in
> sys.databases (this column says NOTHING)
> or
> A problem occurred attempting to delete row 1. Error source:
> Microsoft.visualstudio.datatools. Error Message: The row values updated
> or
> deleted either do not make the row unique or they alter multiple rows.
> Correct the errors and attempt to delete the row again.
>
|||The second error message you indicate lets me think that your table is an
Heap (no indexes nor primary key). In some cases this situation causes this
kind of error
Gilberto Zampatti
"Andrew J. Kelly" wrote:

> That is why you should never create the files that large to begin with.
> Create them relatively small then manually grow them to the size you need
> for the next year or so. But in any case you can delete the rows in small
> batches so that the tran log can be truncated in-between batches.
> SET ROWCOUNT 50000
> WHILE 1 = 1
> BEGIN
> DELETE FROM Table WHERE xxx
> IF @.@.ROWCOUNT = 0
> EXIT
> END
> SET ROWCOUNT 0
>
> Another alternative is to export the data you wish to keep. Drop the DB and
> create a new one with a smaller size. Then import the data back in.
> --
> Andrew J. Kelly SQL MVP
> "Matt Fritz" <mafritz@.state.pa.us> wrote in message
> news:eoSDUbHpHHA.5092@.TK2MSFTNGP04.phx.gbl...
>
>

file share subscription problem

I've setup a file share subscription to render a report to an AS/400
file system, but it is failing with Logon failure: unknown user name
or bad password --> System.Runtime.InteropServices.COMException
(0x8007052E):
I'm supplying the correct username and password to access the
directory, and I'm specifying the unc path for the AS/400 correctly
(\\myas400\root\qdls\ftp). The reason I know this is because I am
able to go into Windows Explorer and type in the exact same UNC path,
then supply the username and password when prompted, and I can get in
just fine. I can also copy files back and forth, etc.
Any ideas? This looks like a possible bug to me. My guess is that
nobody's tried rendering a file share subscription to an AS/400
before, so it's probably never been tested.
I guess as a workaround I can render the report to a microsoft file
system and then ftp it over to the AS/400, but I really think this
should work as advertised. That's a lot of extra hoop jumping.This sounds like a security permission issue. Can you try the following: the
RS windows service is running under a certain account. Make sure this
account also has permissions to access the AS/400 network share.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"dcp" <dcp12345678@.yahoo.com> wrote in message
news:1b8617a8.0501041353.60da6aa0@.posting.google.com...
> I've setup a file share subscription to render a report to an AS/400
> file system, but it is failing with Logon failure: unknown user name
> or bad password --> System.Runtime.InteropServices.COMException
> (0x8007052E):
> I'm supplying the correct username and password to access the
> directory, and I'm specifying the unc path for the AS/400 correctly
> (\\myas400\root\qdls\ftp). The reason I know this is because I am
> able to go into Windows Explorer and type in the exact same UNC path,
> then supply the username and password when prompted, and I can get in
> just fine. I can also copy files back and forth, etc.
> Any ideas? This looks like a possible bug to me. My guess is that
> nobody's tried rendering a file share subscription to an AS/400
> before, so it's probably never been tested.
> I guess as a workaround I can render the report to a microsoft file
> system and then ftp it over to the AS/400, but I really think this
> should work as advertised. That's a lot of extra hoop jumping.

File Share Subscription

I have been trying, unsuccessfully, to set up a File Share Subscription. (The path is a location not on the report server.) On the destination server, the network permissions are set to full and the NTFS permissions are set to modify.

I found a post that said a Shared Schedule had to be used for this to work, so I tried that with no luck either. This is the error message I'm receiving:

"Logon failure: unknown user name or bad password. "

However, I can manually map a drive from my machine to that network drive.

And we've also been able to set up the File Share subscription to deliver to a different location on the network w/o issue.

I found something on a blog but I'm not sure that it is accurate. I can't find anything in the help files that indicate this is true. Can anyone confirm or deny?

"...if it fails using any account other than the account that the account Reporting Services is running under

just run your app pools and the reporting services windows service under the same account.

then change the Reports (Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager) and ReportServer (Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer) web.config files so the “impersonation” is to false."|||

In the file share subscription,use your login name and your password as stored credentials, and test the subscription.

Local server accounts may not be in Active Directory and they may not have permissions to write files on another share.

File share subscription

I have a report server in domain â'Aâ' that through a data driven subscription
tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
driven subscriptionâ' wizard, you are asked to provide a username and
password. If I supply domain credentials from domain A (A\UserName), the
subscription appears to run but the report output does not appear in the file
share on domain B. If I supply domain credentials for domain B (B\username),
the subscription fails to run.
Iâ'm assuming that the credentials asked for in the wizard are those used to
access the file share, but it seems as if they also have some bearing on the
running of the subscription (report) itself.
Is there a way I can accomplish what I desire?Check and make sure that your domains have a two way trust between them since
this can cause authentication issues.
Also, make sure that the file share is not set to Read Only and that the
NTFS permissions on the folder do not prevent that user from writing to it.
--
SQL Server Developer Support Engineer
"Herman K" wrote:
> I have a report server in domain â'Aâ' that through a data driven subscription
> tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
> driven subscriptionâ' wizard, you are asked to provide a username and
> password. If I supply domain credentials from domain A (A\UserName), the
> subscription appears to run but the report output does not appear in the file
> share on domain B. If I supply domain credentials for domain B (B\username),
> the subscription fails to run.
> Iâ'm assuming that the credentials asked for in the wizard are those used to
> access the file share, but it seems as if they also have some bearing on the
> running of the subscription (report) itself.
> Is there a way I can accomplish what I desire?
>|||Thanks Chris.
Ah. We do not (and cannot) have trusted domains due to security issues. I
ended up placing the subscription on a report server in domain B.
"Chris Alton [MS]" wrote:
> Check and make sure that your domains have a two way trust between them since
> this can cause authentication issues.
> Also, make sure that the file share is not set to Read Only and that the
> NTFS permissions on the folder do not prevent that user from writing to it.
> --
> SQL Server Developer Support Engineer
>
> "Herman K" wrote:
> > I have a report server in domain â'Aâ' that through a data driven subscription
> > tries to write to a UNC in domain â'Bâ'. In â'Step 4â' of the â'Create a data
> > driven subscriptionâ' wizard, you are asked to provide a username and
> > password. If I supply domain credentials from domain A (A\UserName), the
> > subscription appears to run but the report output does not appear in the file
> > share on domain B. If I supply domain credentials for domain B (B\username),
> > the subscription fails to run.
> >
> > Iâ'm assuming that the credentials asked for in the wizard are those used to
> > access the file share, but it seems as if they also have some bearing on the
> > running of the subscription (report) itself.
> >
> > Is there a way I can accomplish what I desire?
> >

File Share Delivery of subscription fails

I have a subscription that will not deliver to a file share. I've ensured
that the windows acct for share access for the subscription has read/write to
the share.
The error I get in report manager is:
Failure writing file <report name>: The Report Server has encountered a
configuration error; more details in the log files
The log file says:
ReportingServicesService!library!10ec!08/08/2005-12:26:05:: i INFO: Call to
RenderFirst( '/My Reports/<report name>)
ReportingServicesService!library!10ec!08/08/2005-12:26:06:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 234;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!10ec!08/08/2005-12:26:06:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!subscription!10ec!08/08/2005-12:26:06::
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log files
-->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Deliver(Notification notification)
Any ideas?
TIA,
Berry Morgan
JSOAre the user who created the report subscription and the ReportServer in the
same domain (actually the ReportServerService service account). We have seen
this issue in our DEV + QA environments which are in different domains that
are not trusted by our prod domain (but do trust it). We have configured all
our Report Servers to run under prod domain service accounts to get around
this issue (because when testing subscriptions, developers will still be
using their prod accounts and it seems that it is the subscription owner
account that was failing to be resolved)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Berry at JSO" <6399bwmNOSPAM@.community.nospam> wrote in message
news:D735DEE3-F3E8-4250-9AAA-396D1B3742B2@.microsoft.com...
>I have a subscription that will not deliver to a file share. I've ensured
> that the windows acct for share access for the subscription has read/write
> to
> the share.
> The error I get in report manager is:
> Failure writing file <report name>: The Report Server has encountered a
> configuration error; more details in the log files
>
> The log file says:
> ReportingServicesService!library!10ec!08/08/2005-12:26:05:: i INFO: Call
> to
> RenderFirst( '/My Reports/<report name>)
> ReportingServicesService!library!10ec!08/08/2005-12:26:06:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
> the
> log files, AuthzInitializeContextFromSid: Win32 error: 234;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
> the
> log files
> ReportingServicesService!library!10ec!08/08/2005-12:26:06:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!subscription!10ec!08/08/2005-12:26:06::
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
> Server has encountered a configuration error; more details in the log
> files
> -->
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in
> the
> log files
> at
> Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
> userSid)
> at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
> userName)
> at
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
> userName, IntPtr userToken)
> at
> Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
> userName, IntPtr userToken, Byte[] secDesc, ReportOperation
> requiredOperation)
> at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
> catItemType, Byte[] secDesc, ReportOperation rptOper)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
> reportContext, String historyID, Boolean forRendering, Guid& reportID,
> Int32&
> executionOption, String& savedParametersXml, ReportSnapshot&
> compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
> historyDate)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean forRendering, NameValueCollection
> values,
> DatasourceCredentialsCollection credentials)
> at
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
> Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification
> notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Deliver(Notification
> notification)
>
> Any ideas?
> TIA,
> Berry Morgan
> JSO|||The subscription creator is a production domain account, but the
ReportServer service identity is NT AUTHORITY\Network Service.
If I change the ReportServer service identity to a domain account, won't
that require reactivation of the reporting server?
Also, email subscriptions currently work: wouldn't changing the service
identity require configuration changes for this subscription type as well?
My hunch is that subscription delivery to file shares is tied in with code
access security settings, but I'm not the MVP. :)
-Berry
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ewEcpyGnFHA.3304@.tk2msftngp13.phx.gbl...
> Are the user who created the report subscription and the ReportServer in
> the same domain (actually the ReportServerService service account). We
> have seen this issue in our DEV + QA environments which are in different
> domains that are not trusted by our prod domain (but do trust it). We have
> configured all our Report Servers to run under prod domain service
> accounts to get around this issue (because when testing subscriptions,
> developers will still be using their prod accounts and it seems that it is
> the subscription owner account that was failing to be resolved)
>|||Our issue was purely domain related however what I would suggest is that you
contact PSS. They'll be able to provide you with a utility that should help
pinpoint the issue. This is a common problem (the error message you are
seeing) and it's all related to being able to query AD and permissions
related to that (rather than specifically anything SQL related). PSS will be
able to help you track down the specific issue in your environment. Email
subscriptions don't suffer the same issue as far as I'm aware (we haven't
seen it but that doesn't mean it doesn't exist<g>)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Berry Morgan" <6399bwmNOSPAM@.community.nospam> wrote in message
news:uwK78DTnFHA.1372@.TK2MSFTNGP10.phx.gbl...
> The subscription creator is a production domain account, but the
> ReportServer service identity is NT AUTHORITY\Network Service.
> If I change the ReportServer service identity to a domain account, won't
> that require reactivation of the reporting server?
> Also, email subscriptions currently work: wouldn't changing the service
> identity require configuration changes for this subscription type as well?
> My hunch is that subscription delivery to file shares is tied in with code
> access security settings, but I'm not the MVP. :)
> -Berry
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:ewEcpyGnFHA.3304@.tk2msftngp13.phx.gbl...
>> Are the user who created the report subscription and the ReportServer in
>> the same domain (actually the ReportServerService service account). We
>> have seen this issue in our DEV + QA environments which are in different
>> domains that are not trusted by our prod domain (but do trust it). We
>> have configured all our Report Servers to run under prod domain service
>> accounts to get around this issue (because when testing subscriptions,
>> developers will still be using their prod accounts and it seems that it
>> is the subscription owner account that was failing to be resolved)
>

File Share Delivery Failing

I'm trying to deliver a report via the included File Share Delivery method. Every time the subscription fires, the delivery fails with this error in the interface:

Failure writing file Test.pdf : A logon error occurred when attempting to access the file share. The user account or password is not valid.


An in ReportServerService<dateTime>.log, I find the following error:

ReportingServicesService!library!10!08/22/2007-16:17:08:: e ERROR: Throwing Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid., A logon error occurred when attempting to access the file share. The user account or password is not valid.;
Info: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
End of inner exception stack trace
ReportingServicesService!subscription!10!08/22/2007-16:17:08:: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
End of inner exception stack trace
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData d)
ReportingServicesService!subscription!10!08/22/2007-16:17:08:: i INFO: Error writing file Test.pdf to path \\mrhowell\SYS\junk\josh


I have tried using the <domain>\<user> username syntax. I have tried sending to multiple different machines. The only deployment that succeeded was to \\localhost\c$\test with administrator credentials entered into the Subscription (unacceptable, of course).

I've seen this issue raised on this forum at least twice, and neither was met with any ideas or answers. Has anyone encountered and overcome this issue?
I'm having the exact same issue...if you get any sort of response please let me know.

|||Are you using the development edition? I think you can only use localhost on that.

File Share Delivery Failing

I'm trying to deliver a report via the included File Share Delivery method. Every time the subscription fires, the delivery fails with this error in the interface:

Failure writing file Test.pdf : A logon error occurred when attempting to access the file share. The user account or password is not valid.


An in ReportServerService<dateTime>.log, I find the following error:

ReportingServicesService!library!10!08/22/2007-16:17:08:: e ERROR: Throwing Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid., A logon error occurred when attempting to access the file share. The user account or password is not valid.;
Info: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
End of inner exception stack trace
ReportingServicesService!subscription!10!08/22/2007-16:17:08:: Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider+NetworkErrorException: A logon error occurred when attempting to access the file share. The user account or password is not valid. > System.Runtime.InteropServices.COMException (0x8007052E): Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pRPCEndpointName, Int32 type, Guid dataSourceId, String pUserName, String pDomain, String pPassword)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
End of inner exception stack trace
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetImpersonationToken(String userName, String domain, String userPwd)
at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.SaveReport(Notification notification, SubscriptionData d)
ReportingServicesService!subscription!10!08/22/2007-16:17:08:: i INFO: Error writing file Test.pdf to path \\mrhowell\SYS\junk\josh


I have tried using the <domain>\<user> username syntax. I have tried sending to multiple different machines. The only deployment that succeeded was to \\localhost\c$\test with administrator credentials entered into the Subscription (unacceptable, of course).

I've seen this issue raised on this forum at least twice, and neither was met with any ideas or answers. Has anyone encountered and overcome this issue?
I'm having the exact same issue...if you get any sort of response please let me know.

File Share Delivery Error

I have given subscription access to a domain group in reporting services.
Well when the users create a file share subscription and the subscription
launches they are getting the message "Failure writing file .pdf : Error
impersonating user." Thanks,
--
Andrew
MCSA,MCDBAThe error is stating that RS can not log on as the user that you configured
the subscription to use. It has nothing to do with the share permissions.
You should make sure that user can log onto the machine that RS is running
on.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew" <Andrew@.discussions.microsoft.com> wrote in message
news:6E473576-5F7A-430D-AB70-A0EB8A4C7C60@.microsoft.com...
>I have given subscription access to a domain group in reporting services.
> Well when the users create a file share subscription and the subscription
> launches they are getting the message "Failure writing file .pdf : Error
> impersonating user." Thanks,
> --
> Andrew
> MCSA,MCDBA|||Daniel,
Thanks for the advice I discovered the only group granted log on locally
rights was the administrators group. Thanks again,
--
Andrew
MCSA,MCDBA
"Daniel Reib [MSFT]" wrote:
> The error is stating that RS can not log on as the user that you configured
> the subscription to use. It has nothing to do with the share permissions.
> You should make sure that user can log onto the machine that RS is running
> on.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Andrew" <Andrew@.discussions.microsoft.com> wrote in message
> news:6E473576-5F7A-430D-AB70-A0EB8A4C7C60@.microsoft.com...
> >I have given subscription access to a domain group in reporting services.
> > Well when the users create a file share subscription and the subscription
> > launches they are getting the message "Failure writing file .pdf : Error
> > impersonating user." Thanks,
> >
> > --
> > Andrew
> > MCSA,MCDBA
>
>

File share delivery

Hi All,
I am new to SQL 2005 Reporting Services. I have done the reports and now I
want to publish them to a folder in then local machine. I even tried that. I
created a subscription and when it is to rum gives an error "Unable to write
file <abc>, Report Server Configuration error, see log files for more
details". I am not able to understand the problem. Can any one of you please
help me what to do in this and get my problem sorted.
ThanksRajeev,
1. What does the log say? Did you look?
2. Did you specify a UNC path to the folder?
3. Did the user you set up for the subscription have rights to the folder?
--
Andy Potter
blog: http://sqlreportingservices.spaces.live.com/
"Rajeev" wrote:
> Hi All,
> I am new to SQL 2005 Reporting Services. I have done the reports and now I
> want to publish them to a folder in then local machine. I even tried that. I
> created a subscription and when it is to rum gives an error "Unable to write
> file <abc>, Report Server Configuration error, see log files for more
> details". I am not able to understand the problem. Can any one of you please
> help me what to do in this and get my problem sorted.
> Thanks|||Hi,
I think Your folder which contains report files having Readonly. Check it
out by opening Properties of folder and uncheck read only box
"Rajeev" wrote:
> Hi All,
> I am new to SQL 2005 Reporting Services. I have done the reports and now I
> want to publish them to a folder in then local machine. I even tried that. I
> created a subscription and when it is to rum gives an error "Unable to write
> file <abc>, Report Server Configuration error, see log files for more
> details". I am not able to understand the problem. Can any one of you please
> help me what to do in this and get my problem sorted.
> Thanks

File Share Data-Driven Subscription

Hi.
Iâ'm trying to create File Share Data-Driven Subscription. Everything work
right, but when I set User and Password to the position â'Get the value from
databaseâ' some problems begin: the subscription stops working immediately, it
doesnâ't even try to generate report.
Can anybody help me?Yes, this is a known issue with RS. The credentials do not get encrypted
when the notification is created from the DD subscription, causing the
notification to fail. There is a work around, but it is not pretty. :)
Basically it required creating a subscription for each username/password
combo, each time you create it, find the encrypted values in the database
for the user name and password. Store these values in your table where your
DD subscription query is getting it's values. Obviously this won't work if
you can't change the values in the DD queries table.
This issue will be fixed in the next release of RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Boris" <frolovBA@.trytoguessHM.com> wrote in message
news:A7EE6253-C8C5-41B9-B9B8-E97219F10946@.microsoft.com...
> Hi.
> I'm trying to create File Share Data-Driven Subscription. Everything work
> right, but when I set User and Password to the position "Get the value
> from
> database" some problems begin: the subscription stops working immediately,
> it
> doesn't even try to generate report.
> Can anybody help me?
>

File Share Data Processing Extension Sample

Hi all, I am very new to this Reporting Services and I want to follow this
sample that comes with SQL Server 2005 Beta. However, I tried everything
according to the documentation (build the sample, deploy it by modifying the
config files, etc.). Unfortunately, when I create a new report (using the
Report Wizard) in Visual Studio 2005, I still cannot see the File Share
Information.
Searching this newsgroup pointed me to this
http://blogs.msdn.com/bryanke/archive/2004/05/14/132110.aspx#148541
However, this does not help me either.
Any help is greatly appreciated!
Thanks a lot!
JennyHi Jenny,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to deploy
FsiDataExtension and then use it in the Report Manager. If I have
misunderstood your concern, please feel free to point it out.
Based on my knowledge, here is a sample in Reporting Services 2000 but I am
not sure whether it is available in SQL Server 2005 Reporting Services.
For SQL Server 2005's issue, please post the question in the link below
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
cid=us
For SQL Server 2000 Reporting Services, you could follow the steps below as
described in MSDN Online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/ht
m/rss_sampleapps_v1_16g2.asp
- Copy Microsoft.Samples.ReportingServices.FsiDataExtension.dll to the
report server. The default location for report server extensions is
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin.
- Copy the assembly to Report Designer. The default location for
extensions for Report Designer is C:\Program Files\Microsoft SQL
Server\80\Tools\ReportDesigner.
- Add the following entry to both the RSReportServer.config and
RSReportDesigner.config files under the Data element.
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
- To enable the generic query designer for the sample data processing
extension, add the following entry to the RSReportDesigner.config file
under the Designer element.
<Extension Name="FSI"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
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.|||Hi Michael
Thanks for the reply. Please see my questions inline. Thanks in advance!!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you would like to deploy
> FsiDataExtension and then use it in the Report Manager. If I have
> misunderstood your concern, please feel free to point it out.
Yes you're right.
> Based on my knowledge, here is a sample in Reporting Services 2000 but I am
> not sure whether it is available in SQL Server 2005 Reporting Services.
> For SQL Server 2005's issue, please post the question in the link below
> http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
> cid=us
It's available and the steps look the same to me! Anyway, I have posted my
question in that beta newsgroup as well. Thanks!
> For SQL Server 2000 Reporting Services, you could follow the steps below as
> described in MSDN Online
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/ht
> m/rss_sampleapps_v1_16g2.asp
> - Copy Microsoft.Samples.ReportingServices.FsiDataExtension.dll to the
> report server. The default location for report server extensions is
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\bin.
> - Copy the assembly to Report Designer. The default location for
> extensions for Report Designer is C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner.
I interpreted 'Copy the assembly' as 'copy the dll' as in the previous step.
Is this correct?
> - Add the following entry to both the RSReportServer.config and
> RSReportDesigner.config files under the Data element.
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> - To enable the generic query designer for the sample data processing
> extension, add the following entry to the RSReportDesigner.config file
> under the Designer element.
> <Extension Name="FSI"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
>
I did all the above plus the steps in 'To configure code access security for
the sample'. I didn't know where exactly to put the CodeGroup info in the
config files unfortunately. I have tried a few spots and none succeeds. :-(
> 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!
>|||Hi
For you questions
>>I interpreted 'Copy the assembly' as 'copy the dll' as in
>>the previous step. Is this correct?
Yes, I copied Microsoft.ReportingServices.Interfaces.dll from C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Extensions\FsiDataExtension\cs\bin\Debug to the
destination.
>> I did all the above plus the steps in 'To configure code access security
for
>> the sample'. I didn't know where exactly to put the CodeGroup info in
the
>> config files unfortunately. I have tried a few spots and none succeeds.
:-(
snippet from my RSReportServer.config in C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer for your reference.
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
</Data>
snippet from my RSReportDesigner.config file in C:\Program Files\Microsoft
SQL Server\80\Tools\Report Designer for your reference.
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions" />
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
</Data>
<Designer>
<Extension Name="SQL"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="ODBC"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="FSI"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
</Designer>
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.|||Hi there
Thank you for your help, but what I wanted was where to put the following
code group info in both the rssrvpolicy.config and rspreviewpolicy.config.
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="FSICodeGroup"
Description="Code group for my FSI data processing extension">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\bin\Microsoft.Samples.ReportingServices.FsiDataExtension.dll"
/>
</CodeGroup>
Thanks again and I appreciate your help!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi
> For you questions
> >>I interpreted 'Copy the assembly' as 'copy the dll' as in
> >>the previous step. Is this correct?
> Yes, I copied Microsoft.ReportingServices.Interfaces.dll from C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Samples\Extensions\FsiDataExtension\cs\bin\Debug to the
> destination.
> >> I did all the above plus the steps in 'To configure code access security
> for
> >> the sample'. I didn't know where exactly to put the CodeGroup info in
> the
> >> config files unfortunately. I have tried a few spots and none succeeds.
> :-(
> snippet from my RSReportServer.config in C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer for your reference.
> <Data>
> <Extension Name="SQL"
> Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
> oft.ReportingServices.DataExtensions"/>
> <Extension Name="OLEDB"
> Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
> osoft.ReportingServices.DataExtensions"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
> er,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
> soft.ReportingServices.DataExtensions"/>
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> </Data>
> snippet from my RSReportDesigner.config file in C:\Program Files\Microsoft
> SQL Server\80\Tools\Report Designer for your reference.
> <Data>
> <Extension Name="SQL"
> Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
> oft.ReportingServices.DataExtensions" />
> <Extension Name="OLEDB"
> Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
> osoft.ReportingServices.DataExtensions"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
> er,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
> soft.ReportingServices.DataExtensions"/>
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> </Data>
> <Designer>
> <Extension Name="SQL"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="OLEDB"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="FSI"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
> </Designer>
> 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.
>
>|||Oh I see! Thanks for your help. I finally see the File Share Extension in
the list, but when I want to do more with that, I got this error:
"The designer extension FSI could not be loaded. Check the configuration
file RSReportDesigner.config." [OK]
Am I still missing something?
Thanks a lot!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> I have attached rssrvpolicy.config and rspreviewpolicy.config for your
> reference.
> Put the <CodeGroup > like other <CodeGroup> does will be OK. Something like
> this
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="Dundas_Strong_Name"
> Description="This code group grants
> Dundas assemblies. ">
> <IMembershipCondition
> class="StrongNameMembershipCondition"
> version="1"
> PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000
> 10043D98F8A9067EF3BCD442ADE2DD48CC6A6FACBCEB1C42DE2847B0A464096C02EEBF6FD87E
> 3889BEED32B9ABD1525A11A282232CD4C46CC8123F8CC08A113CD435429646220969FF444734
> 8D1C21874670834C7A7E89EA8956FC00E0F84FD3DF6FB3EBF21774438AF9E760414FDE06BC2C
> 3AF35FF3DD87578630ED13FE12CBDBC"
> />
> </CodeGroup>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="FSICodeGroup"
> Description="Code group for my FSI data processing extension">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner\bin\Microsoft.Samples.ReportingServices.FsiDa
> taExtension.dll"
> />
> </CodeGroup>
> 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|||Actually, I have figured it out. I got the Assembly name wrong. Once I
fixed it, I could see it in the list and load it as well. The report preview
looks good too. :-)
Unfortunately, I couldn't deploy the report. The Report Server cannot be
started for unknown reasons. When I browse http://localhost/ReportServer,
the error is
"The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError) "
What did I do wrong? I have tried re-setting these config files but it
still doesn't work. :-(
rssrvpolicy.config
rsreportserver.config
Please help!! Thanks!!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> I have attached rssrvpolicy.config and rspreviewpolicy.config for your
> reference.
> Put the <CodeGroup > like other <CodeGroup> does will be OK. Something like
> this
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="Dundas_Strong_Name"
> Description="This code group grants
> Dundas assemblies. ">
> <IMembershipCondition
> class="StrongNameMembershipCondition"
> version="1"
> PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000
> 10043D98F8A9067EF3BCD442ADE2DD48CC6A6FACBCEB1C42DE2847B0A464096C02EEBF6FD87E
> 3889BEED32B9ABD1525A11A282232CD4C46CC8123F8CC08A113CD435429646220969FF444734
> 8D1C21874670834C7A7E89EA8956FC00E0F84FD3DF6FB3EBF21774438AF9E760414FDE06BC2C
> 3AF35FF3DD87578630ED13FE12CBDBC"
> />
> </CodeGroup>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="FSICodeGroup"
> Description="Code group for my FSI data processing extension">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner\bin\Microsoft.Samples.ReportingServices.FsiDa
> taExtension.dll"
> />
> </CodeGroup>
> 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|||Hi Jenny,
The error message seems to indicate that you do not set congifuration file
rssrvpolicy.config and rsreportserver.config correctly. Please double check
configuration files again and my attachment file is just a sample file for
your reference. You cannot use them directly.
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.