Friday, February 24, 2012
Client-side Printing and page hesitation
one report print without any hesitation between pages. My boss prints
reports and gets a lot of hesitation between pages for most of the reports.
If I print to a differnt printer I too get a lot of hesitation betwen pages.
Does SRS print pages as graphics or as text? Are there any settings on the
server that can alter printing performance? Anyone else having issues with
print hesitation and found a solution to the problem?When u want 2 controll the print properties u should set them at the Report
Properties->layout.
All properties in this tab are 4 the print setting.
"Rob 'Spike' Stevens" wrote:
> When printing reports from my normal computer to my default printer, all but
> one report print without any hesitation between pages. My boss prints
> reports and gets a lot of hesitation between pages for most of the reports.
> If I print to a differnt printer I too get a lot of hesitation betwen pages.
> Does SRS print pages as graphics or as text? Are there any settings on the
> server that can alter printing performance? Anyone else having issues with
> print hesitation and found a solution to the problem?
Thursday, February 16, 2012
Client must have root CA certificate?
"SSL encryption works only with instances of SQL Server 2000 running on a co
mputer that has been assigned a certificate from a public certification auth
ority. The computer on which the application is running must also have a roo
t CA certificate from the s
ame authority."
My question is that my client application run on different host from SQL ser
ver and don't have the SQL server root CA
certificated installed on client host. How my client can talk to the SQL ser
ver and packet is encryped?Install the CA's root certificate on the client.
Cheers
Ken
"Ming Cheng" <anonymous@.discussions.microsoft.com> wrote in message
news:C11E32E7-54C3-446F-9697-4361C7605812@.microsoft.com...
: The following get quoted from SQL book on-line.
: "SSL encryption works only with instances of SQL Server 2000 running on a
computer that has been assigned a certificate from a public certification
authority. The computer on which the application is running must also have a
root CA certificate from the same authority."
:
: My question is that my client application run on different host from SQL
server and don't have the SQL server root CA
: certificated installed on client host. How my client can talk to the SQL
server and packet is encryped?
:
:
Client Logo is not display on client computer
When the application is deployed to a client computer and the report is previewed, the report appears but the Client Logo (JEPG Imange) do not.
in place of logo it is displaying cross.
Kindly help me to solve this problem as soon as possible
Regards
Amit JoshiIs it a client server application.
If yes, you need to put the picture on client machine as well or access it from server.
check out the path you specified for image.
Hope this Helps you.|||Thanx for reply.
No This is web based application. while testing it was woking fine in test server but after deploy on client PC (UK) it client logo is not showing.
Kindly help to solve this..
Regards
Amit|||Thanx for reply.
No This is web based application. while testing it was woking fine in test server but after deploy on client PC (UK) it client logo is not showing.
Kindly help to solve this..
Regards
Amit
I would say 90% that it's going to be the file path. either the client PC can't see it or it can't access it.
Check you server logs for 404 errors coming from the client.
Sunday, February 12, 2012
Client can not connect to SQL Express - The Solution
Hi,
When I try to connect to SQL Express from another computer I get error 26.
The setup is as follows:
Server is Windows XP Pro, Firewall turned off.
Client is Windows XP Pro, Firewall turned off.
Both computers are on the same workgroup, no domain or other servers on the network.
The server is configured for network: protocols enabled, browser running.
The client has MS SQL Server Management Studio Express installed. When I try to connect the SSMSE finds the SQL Express on the server (using the Browse for more – Network server option), but the connection fails with error 26.
When I try to connect from MS Access 2003 I get the same error.
Thank for any help
Amihy
I found this link http://www.datamasker.com/SSE2005_NetworkCfg.htm maybe this will help you out.|||Thanks for the link, it helped me understand that all my SQL settings are OK.
So I started to think about the network and at last found that NetBios over TCP\IT was disabled. It did not bother me before since the local network works with NetBEUI protocol.
Once I enabled TCP\IP over NetBios in Local Area Connection-Properties-TCP\IP properties-General-advanced-wins, The client immediatly connected to the server.
Client can not connect to SQL Express
Hi,
When I try to connect to SQL Express from another computer I get error 26.
The setup is as follows:
Server is Windows XP Pro, Firewall turned off.
Client is Windows XP Pro, Firewall turned off.
Both computers are on the same workgroup, no domain or other servers on the network.
The server is configured for network: protocols enabled, browser running.
The client has MS SQL Server Management Studio Express installed. When I try to connect the SSMSE finds the SQL Express on the server (using the Browse for more – Network server option), but the connection fails with error 26.
When I try to connect from MS Access 2003 I get the same error.
Thank for any help
Amihy
I found this link http://www.datamasker.com/SSE2005_NetworkCfg.htm maybe this will help you out.|||Thanks for the link, it helped me understand that all my SQL settings are OK.
So I started to think about the network and at last found that NetBios over TCP\IT was disabled. It did not bother me before since the local network works with NetBEUI protocol.
Once I enabled TCP\IP over NetBios in Local Area Connection-Properties-TCP\IP properties-General-advanced-wins, The client immediatly connected to the server.
Clicking print from Reporting Services report cause computer to re
It runs just fine, and printed fine up until a few days ago. Now, after I
run the report and it displays on the screen, clicking print causes the
computer to reboot. Not all the reports do this, just this one. I don't
know of anything that has changed that could cause this problem. Anyone have
a similar experience? The report uses a stored procedure to build a table.
But, again it did work o.k. until a few days ago.
ThanksSAME PROBLEM HERE !!
Our client called us yesterday, everything worked fine and now clicking the
print button on 1 or 2 reports just REBOOT the computer !
We are using Reporting Services 2000 with SQL Server 2000.
Please help!
"Glenna" wrote:
> I have a report developed using Reporting Services 2005 with SQL Server 2005.
> It runs just fine, and printed fine up until a few days ago. Now, after I
> run the report and it displays on the screen, clicking print causes the
> computer to reboot. Not all the reports do this, just this one. I don't
> know of anything that has changed that could cause this problem. Anyone have
> a similar experience? The report uses a stored procedure to build a table.
> But, again it did work o.k. until a few days ago.
> Thanks|||We rae now having the same issues...SQL RS 2005, SQL 2000...any hotfixes or
patches?
"KhAoS" wrote:
> SAME PROBLEM HERE !!
> Our client called us yesterday, everything worked fine and now clicking the
> print button on 1 or 2 reports just REBOOT the computer !
> We are using Reporting Services 2000 with SQL Server 2000.
> Please help!
> "Glenna" wrote:
> > I have a report developed using Reporting Services 2005 with SQL Server 2005.
> > It runs just fine, and printed fine up until a few days ago. Now, after I
> > run the report and it displays on the screen, clicking print causes the
> > computer to reboot. Not all the reports do this, just this one. I don't
> > know of anything that has changed that could cause this problem. Anyone have
> > a similar experience? The report uses a stored procedure to build a table.
> > But, again it did work o.k. until a few days ago.
> >
> > Thanks|||On Apr 18, 10:36 am, pbriggsiberia
<pbriggsibe...@.discussions.microsoft.com> wrote:
> We rae now having the same issues...SQL RS 2005, SQL 2000...any hotfixes or
> patches?
>
> "KhAoS" wrote:
> > SAME PROBLEM HERE !!
> > Our client called us yesterday, everything worked fine and now clicking the
> >printbutton on 1 or 2 reports justREBOOTthe computer !
> > We are using Reporting Services 2000 with SQL Server 2000.
> > Please help!
> > "Glenna" wrote:
> > > I have a report developed using Reporting Services 2005 with SQL Server 2005.
> > > It runs just fine, and printed fine up until a few days ago. Now, after I
> > > run the report and it displays on the screen, clickingprintcausesthe
> > > computer toreboot. Not all the reports do this, just this one. I don't
> > > know of anything that has changed that could cause this problem. Anyone have
> > > a similar experience? The report uses a stored procedure to build a table.
> > > But, again it did work o.k. until a few days ago.
> > > Thanks- Hide quoted text -
> - Show quoted text -
I am having the same problem. Has anyone found the solution to this?|||Found the solution on another forum!!
The problem come from a recent update patch from microsoft that affects some
printers drivers.
To get rid of the problem, install this hotfix (KB935843) :
http://www.microsoft.com/downloads/details.aspx?familyid=69443B00-F831-4785-B292-DBF8CF002C6A&displaylang=en
More infos : http://support.microsoft.com/?kbid=935843
"jrichardson2@.chkenergy.com" wrote:
> On Apr 18, 10:36 am, pbriggsiberia
> <pbriggsibe...@.discussions.microsoft.com> wrote:
> > We rae now having the same issues...SQL RS 2005, SQL 2000...any hotfixes or
> > patches?
> >
> >
> >
> > "KhAoS" wrote:
> > > SAME PROBLEM HERE !!
> > > Our client called us yesterday, everything worked fine and now clicking the
> > >printbutton on 1 or 2 reports justREBOOTthe computer !
> > > We are using Reporting Services 2000 with SQL Server 2000.
> >
> > > Please help!
> >
> > > "Glenna" wrote:
> >
> > > > I have a report developed using Reporting Services 2005 with SQL Server 2005.
> > > > It runs just fine, and printed fine up until a few days ago. Now, after I
> > > > run the report and it displays on the screen, clickingprintcausesthe
> > > > computer toreboot. Not all the reports do this, just this one. I don't
> > > > know of anything that has changed that could cause this problem. Anyone have
> > > > a similar experience? The report uses a stored procedure to build a table.
> > > > But, again it did work o.k. until a few days ago.
> >
> > > > Thanks- Hide quoted text -
> >
> > - Show quoted text -
> I am having the same problem. Has anyone found the solution to this?
>
Friday, February 10, 2012
cli for MSSQL server?
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
UsarianWhat happens if you try to run DTSWiz.exe from Start -> Run
?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Usarian" <usariankristine@.juno.com> wrote in message
news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
I need to put a series of records in two columns of an
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
Usarian|||File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian
quote:
>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->
Run
quote:|||Then consider installing SQL Server client utilities on this machine.
>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
<anonymous@.discussions.microsoft.com> wrote in message
news:176101c3dfad$1e3e1ff0$a401280a@.phx.gbl...
File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian
quote:
>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->
Run
quote:
>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>
cli for MSSQL server?
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
UsarianWhat happens if you try to run DTSWiz.exe from Start -> Run
?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Usarian" <usariankristine@.juno.com> wrote in message
news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
I need to put a series of records in two columns of an
Excel file into an MSSQL database on a server I am
connected to over a LAN. On my computer I am running SQL
Server service manager. I do not appear to have the
software to insert. I see there are a bunch of
executables in the MSSQL directory, but they do not appear
to accept SQL commands. Please Help!
Usarian|||File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian
>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->
Run
>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>|||Then consider installing SQL Server client utilities on this machine.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
<anonymous@.discussions.microsoft.com> wrote in message
news:176101c3dfad$1e3e1ff0$a401280a@.phx.gbl...
File not found. It does not show in my searches on local
and networked drives either.
thank you for your prompt reply tho!
Usarian
>--Original Message--
>What happens if you try to run DTSWiz.exe from Start ->
Run
>?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>
>"Usarian" <usariankristine@.juno.com> wrote in message
>news:0f2b01c3dfa7$9cf9b990$a101280a@.phx.gbl...
>I need to put a series of records in two columns of an
>Excel file into an MSSQL database on a server I am
>connected to over a LAN. On my computer I am running SQL
>Server service manager. I do not appear to have the
>software to insert. I see there are a bunch of
>executables in the MSSQL directory, but they do not appear
>to accept SQL commands. Please Help!
>Usarian
>
>.
>