Cluster Upgrade SP2 2005

Have recently performed an in-place upgrade of a 2 instance sql cluster from 2000 to 2005. The upgrade process went relatively smoothly. However, I am running into problems installed sp2. The first problem that I run into is that I have resrcmon.exe locked. I can click next, which is fine, but once I get past that point I get stuck during the installation process. I am updating DatabaseServices and Integration Services. It gets stuck on 'Awaiting first complete passive cluster node SQL-Test'. Does anyone have any ideas?
Thanks,
TimFor what it's worth I'm experiencing the same issue as described above. I'm using VMWare Server and have a Windows 2003 Enterprise Edition cluster with SQL Server 2005 Standard Edition clustered on top. This works well but in trying to apply SP2 it is stuck "Awaiting first complete passive cluster node". Slight difference from that described above, I had no locked files.

Any info that anyone could provide would be greatly appreciated.

Cheers,

Ian
|||Unbelievable. Typically just as I finish writing the above, the process moved on. However it failed at the "Database Services" product. Everything else seemed to go okay but I'll have to check and will come back with any info I find.

Cheers,

Ian
|||I got my issue resolved...after talking to MS Support for half of a day. There are a lot of things that you have to make sure is just right. For example, when you install the services, it is easier to have the first node control both instances. From there, make sure you install the client tools on the default instance first. You also cannot have remote connections to the 2nd node in the cluster (will cause it to fail). Mine failed on installed the database services as well. Another thing we had to change was that when the network guys setup the cluster, the distributed transaction coordinator wasn't created as a clustered resource...it needs to be. let me know if this helps any.
Tim|||Tim,

Did you manage to continue with resrcmon.exe locked or did you find a way to stop it (it's part of the cluster so, short of stopping the cluster services I wasn't sure how else to stop it)?

We've got the DTC in place in our production cluster but I forgot to add it with my virtual one. I've done this now and will give it another go shortly.

Cheers,

Ian
|||At first I seen that resrcmon.exe was locked, and it did concern me. However, I don't think that it really matters if it is locked or not. If it is locked, you can still go through with the install, but it will prompt you to reboot later in the process. Try to kill all remote connections to either cluster node, place both instances on one node, and try to install that way. That will likely unlock resrcmon.|||I actually only have one instance, it is on the node from which I'm running the SP. WRT remote connections, I can't see anything apart from the clustering services that would be connecting remotely to the second node.

That said, I've only got resrcmon.exe locked now so am gonna proceed with the SP and see where I get - beauty of VMs is that I can just roll 'em back any time I like :-)
|||

I had the exact same issue. Installing the client tools on both nodes, and then moving the inst1 over to the passive node and running the SP2 from there seemed to do the trick.

|||I've finally had some level of success with this on my virtual cluster. But it was kinda forceful. I basically downed node 2, installed the SP onto node 1 (twice as it had "reboot required" on the SQL Server engine the first time). Then brought up node 2, failed over and downed node 1. Did the same to node 2 (twice) and brought node 1 back up. Testing seems to confirm this has gone okay. However, as we're in the process of trying to get a test cluster (for exactly this kind of thing - good as VMWare is, it's not the real thing) I'm not going to apply this to production until that's happened.

Cheers,

Ian
|||

Hi Ian,

Please help - when you downed the one node - was it shutdown or did you stop cluster service on the node or did you pause the node?

Thanks in advance :-)

|||

Hi there,

Basically I did the following.

Node 1 was up, node 2 was shutdown completely. I upgraded node 1 to SP2, then brought node 2 back online and failed over by shutting down node 1. I then upgraded node 2 to SP2, brought node 1 back online, failed over manually to confirm all as expected and left it at that. Bear in mind this was on virtual machines so is not a perfect test. I've yet to do this on our production cluster and am currently trying to get a proper physical test cluster in place to run through this for real.

Hope this helps!

Cheers,

Ian

Cluster Upgrade SP2 2005

Have recently performed an in-place upgrade of a 2 instance sql cluster from 2000 to 2005. The upgrade process went relatively smoothly. However, I am running into problems installed sp2. The first problem that I run into is that I have resrcmon.exe locked. I can click next, which is fine, but once I get past that point I get stuck during the installation process. I am updating DatabaseServices and Integration Services. It gets stuck on 'Awaiting first complete passive cluster node SQL-Test'. Does anyone have any ideas?
Thanks,
TimFor what it's worth I'm experiencing the same issue as described above. I'm using VMWare Server and have a Windows 2003 Enterprise Edition cluster with SQL Server 2005 Standard Edition clustered on top. This works well but in trying to apply SP2 it is stuck "Awaiting first complete passive cluster node". Slight difference from that described above, I had no locked files.

Any info that anyone could provide would be greatly appreciated.

Cheers,

Ian
|||Unbelievable. Typically just as I finish writing the above, the process moved on. However it failed at the "Database Services" product. Everything else seemed to go okay but I'll have to check and will come back with any info I find.

Cheers,

Ian
|||I got my issue resolved...after talking to MS Support for half of a day. There are a lot of things that you have to make sure is just right. For example, when you install the services, it is easier to have the first node control both instances. From there, make sure you install the client tools on the default instance first. You also cannot have remote connections to the 2nd node in the cluster (will cause it to fail). Mine failed on installed the database services as well. Another thing we had to change was that when the network guys setup the cluster, the distributed transaction coordinator wasn't created as a clustered resource...it needs to be. let me know if this helps any.
Tim|||Tim,

Did you manage to continue with resrcmon.exe locked or did you find a way to stop it (it's part of the cluster so, short of stopping the cluster services I wasn't sure how else to stop it)?

We've got the DTC in place in our production cluster but I forgot to add it with my virtual one. I've done this now and will give it another go shortly.

Cheers,

Ian
|||At first I seen that resrcmon.exe was locked, and it did concern me. However, I don't think that it really matters if it is locked or not. If it is locked, you can still go through with the install, but it will prompt you to reboot later in the process. Try to kill all remote connections to either cluster node, place both instances on one node, and try to install that way. That will likely unlock resrcmon.|||I actually only have one instance, it is on the node from which I'm running the SP. WRT remote connections, I can't see anything apart from the clustering services that would be connecting remotely to the second node.

That said, I've only got resrcmon.exe locked now so am gonna proceed with the SP and see where I get - beauty of VMs is that I can just roll 'em back any time I like :-)
|||

I had the exact same issue. Installing the client tools on both nodes, and then moving the inst1 over to the passive node and running the SP2 from there seemed to do the trick.

|||I've finally had some level of success with this on my virtual cluster. But it was kinda forceful. I basically downed node 2, installed the SP onto node 1 (twice as it had "reboot required" on the SQL Server engine the first time). Then brought up node 2, failed over and downed node 1. Did the same to node 2 (twice) and brought node 1 back up. Testing seems to confirm this has gone okay. However, as we're in the process of trying to get a test cluster (for exactly this kind of thing - good as VMWare is, it's not the real thing) I'm not going to apply this to production until that's happened.

Cheers,

Ian
|||

Hi Ian,

Please help - when you downed the one node - was it shutdown or did you stop cluster service on the node or did you pause the node?

Thanks in advance :-)

|||

Hi there,

Basically I did the following.

Node 1 was up, node 2 was shutdown completely. I upgraded node 1 to SP2, then brought node 2 back online and failed over by shutting down node 1. I then upgraded node 2 to SP2, brought node 1 back online, failed over manually to confirm all as expected and left it at that. Bear in mind this was on virtual machines so is not a perfect test. I've yet to do this on our production cluster and am currently trying to get a proper physical test cluster in place to run through this for real.

Hope this helps!

Cheers,

Ian

sqlsql

Cluster Upgrade SP2 2005

Have recently performed an in-place upgrade of a 2 instance sql cluster from 2000 to 2005. The upgrade process went relatively smoothly. However, I am running into problems installed sp2. The first problem that I run into is that I have resrcmon.exe locked. I can click next, which is fine, but once I get past that point I get stuck during the installation process. I am updating DatabaseServices and Integration Services. It gets stuck on 'Awaiting first complete passive cluster node SQL-Test'. Does anyone have any ideas?
Thanks,
TimFor what it's worth I'm experiencing the same issue as described above. I'm using VMWare Server and have a Windows 2003 Enterprise Edition cluster with SQL Server 2005 Standard Edition clustered on top. This works well but in trying to apply SP2 it is stuck "Awaiting first complete passive cluster node". Slight difference from that described above, I had no locked files.

Any info that anyone could provide would be greatly appreciated.

Cheers,

Ian
|||Unbelievable. Typically just as I finish writing the above, the process moved on. However it failed at the "Database Services" product. Everything else seemed to go okay but I'll have to check and will come back with any info I find.

Cheers,

Ian
|||I got my issue resolved...after talking to MS Support for half of a day. There are a lot of things that you have to make sure is just right. For example, when you install the services, it is easier to have the first node control both instances. From there, make sure you install the client tools on the default instance first. You also cannot have remote connections to the 2nd node in the cluster (will cause it to fail). Mine failed on installed the database services as well. Another thing we had to change was that when the network guys setup the cluster, the distributed transaction coordinator wasn't created as a clustered resource...it needs to be. let me know if this helps any.
Tim|||Tim,

Did you manage to continue with resrcmon.exe locked or did you find a way to stop it (it's part of the cluster so, short of stopping the cluster services I wasn't sure how else to stop it)?

We've got the DTC in place in our production cluster but I forgot to add it with my virtual one. I've done this now and will give it another go shortly.

Cheers,

Ian
|||At first I seen that resrcmon.exe was locked, and it did concern me. However, I don't think that it really matters if it is locked or not. If it is locked, you can still go through with the install, but it will prompt you to reboot later in the process. Try to kill all remote connections to either cluster node, place both instances on one node, and try to install that way. That will likely unlock resrcmon.|||I actually only have one instance, it is on the node from which I'm running the SP. WRT remote connections, I can't see anything apart from the clustering services that would be connecting remotely to the second node.

That said, I've only got resrcmon.exe locked now so am gonna proceed with the SP and see where I get - beauty of VMs is that I can just roll 'em back any time I like :-)
|||

I had the exact same issue. Installing the client tools on both nodes, and then moving the inst1 over to the passive node and running the SP2 from there seemed to do the trick.

|||I've finally had some level of success with this on my virtual cluster. But it was kinda forceful. I basically downed node 2, installed the SP onto node 1 (twice as it had "reboot required" on the SQL Server engine the first time). Then brought up node 2, failed over and downed node 1. Did the same to node 2 (twice) and brought node 1 back up. Testing seems to confirm this has gone okay. However, as we're in the process of trying to get a test cluster (for exactly this kind of thing - good as VMWare is, it's not the real thing) I'm not going to apply this to production until that's happened.

Cheers,

Ian
|||

Hi Ian,

Please help - when you downed the one node - was it shutdown or did you stop cluster service on the node or did you pause the node?

Thanks in advance :-)

|||

Hi there,

Basically I did the following.

Node 1 was up, node 2 was shutdown completely. I upgraded node 1 to SP2, then brought node 2 back online and failed over by shutting down node 1. I then upgraded node 2 to SP2, brought node 1 back online, failed over manually to confirm all as expected and left it at that. Bear in mind this was on virtual machines so is not a perfect test. I've yet to do this on our production cluster and am currently trying to get a proper physical test cluster in place to run through this for real.

Hope this helps!

Cheers,

Ian

cluster SSAS and SQL

Hi,
We have a default clusterd SQL server 2005 with sp2 installed in one cluster
group and then I have installed a default SSAS clustered instance in another
cluster group and it works fine (can failover and user can connect). However,
when I applying the sp2 to SSAS instance (with SSAS checked only) and it
failed; it not noly just failed but also take down my default clustered sql
server! We have to call MS to get our server up. It seems that, somehow,
registry for default sql server got messed up by SSAS sp2. My question are:
1.Is it possible or supported to install a default SQL server and a default
Analysis server on a cluster (each one in its own cluster group) with sp2;
2.why applying sp2 on a default AD instance in one cluster group affect a
default sql instance in another cluster group.
thanks much in advance.
Zack.
The answer is that SQL services share some common components. Plus, the
installer has some generic setup logic. Finally, are you using the same
service account for both services? If so, then permissions can get hosed
during a broken update.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"dp" <dp@.discussions.microsoft.com> wrote in message
news:90BAC728-916F-4497-B293-55920962EDE8@.microsoft.com...
> Hi,
> We have a default clusterd SQL server 2005 with sp2 installed in one
> cluster
> group and then I have installed a default SSAS clustered instance in
> another
> cluster group and it works fine (can failover and user can connect).
> However,
> when I applying the sp2 to SSAS instance (with SSAS checked only) and it
> failed; it not noly just failed but also take down my default clustered
> sql
> server! We have to call MS to get our server up. It seems that, somehow,
> registry for default sql server got messed up by SSAS sp2. My question
> are:
> 1. Is it possible or supported to install a default SQL server and a
> default
> Analysis server on a cluster (each one in its own cluster group) with sp2;
> 2. why applying sp2 on a default AD instance in one cluster group affect a
> default sql instance in another cluster group.
> thanks much in advance.
> Zack.
>
|||Zack, were you ever able to upgrade your SSAS in the cluster?
We are having the same or similar issues. We upgraded our cluster from SP1
to SP2. The SQL Server components upgraded to SP2, but the SSAS failed and
is still at SP1. After the upgrade one of our clustered instances did not
come back online. Error logs read something like, "...Cluster IP/Network
resource already in use..."
Well, I called MS because our production SQL 2005 cluster was hosed. The
issue, reg key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft SQL
Server\MSSQL.1\Cluster\ClusterName" had the incorrect instance name for the
MSSQL.1 instance (in our case). We had to run some cluster commands to
remove the MSCS checkpoint, changed the key value to the correct instance
name, then reapply MSCS checkpoint.
This got our SQL Server instance back online. But we still can't update
SSAS to SP2. Maybe the two issues are not related, but I have a gut feeling
they are. The incorrect 'ClusterName' value happened to be the instance name
for our SSAS.
I still have the MS support ticket open trying to determine if the cluster
registry keys are in the correct state on both nodes.
Anyone else having issues with failover cluster anaylsis server upgrade to
SP2?
"dp" wrote:

> Hi,
> We have a default clusterd SQL server 2005 with sp2 installed in one cluster
> group and then I have installed a default SSAS clustered instance in another
> cluster group and it works fine (can failover and user can connect). However,
> when I applying the sp2 to SSAS instance (with SSAS checked only) and it
> failed; it not noly just failed but also take down my default clustered sql
> server! We have to call MS to get our server up. It seems that, somehow,
> registry for default sql server got messed up by SSAS sp2. My question are:
> 1.Is it possible or supported to install a default SQL server and a default
> Analysis server on a cluster (each one in its own cluster group) with sp2;
> 2.why applying sp2 on a default AD instance in one cluster group affect a
> default sql instance in another cluster group.
> thanks much in advance.
> Zack.
>

Cluster problem

An installation of sql2k5 sp2 to one node of a three node
active/active/active cluster has failed. It cannot proceed beyond the
beginning of the sql2k5 sp2 installation. It fails because it can't install
sqlsupport.msi. It seems to want to put the files in the wrong place.
We can't get the sp to install after a lot of trying and want to 1) fail the
instance the node normally hosts to a partner 2) disconnect the node from
the cluster heartbeat and public networks and 3) run a SQL de-install of the
problematic instance on the disconnected node to clear off SQL and then
reinstall it, bringing it up to SQL2K5 SP2 4) reconnect the node to the
network and 5) fail the instance on the partner node back.
I don't think this will work because during the de-install the add/remove
routine will ask to remove code from san drives it can't find because
they're no longer accessible to it, since it has been disconnected from the
network and SAN. I think a manual removal may be all that can work.
After the node has been reconnected, and SQL installation commenced I will
be asked to create a new instance, a local or clustered instance, neither of
which I want. Can I avoid this by running SQL Setup on the reconnected node
and asking to manage a virtual instance instead of installing a fresh one?
Will I need, at some point, to evict the disconnected node from the cluster?
I know on a previous occasion, I couldn't get the node, once evicted, to
rejoin. Once it's out, it's out for good, isn't it?
"Robert Hindla" <rhindla@.panix.com> wrote in message
news:C38733A0.1BA20%rhindla@.panix.com...
> An installation of sql2k5 sp2 to one node of a three node
> active/active/active cluster has failed. It cannot proceed beyond the
> beginning of the sql2k5 sp2 installation. It fails because it can't
> install
> sqlsupport.msi. It seems to want to put the files in the wrong place.
Are you installing the first instance or the second instance?
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Jan 18 - 31 in Denver
Mar 10- 13 in Denver
|||The virtual SQL instance I'm proposing to de-install and then re-configure
using the setup program in 'manage' mode (instead of 'setup' mode) is one of
two named instances. It isn't the default instance.
The default instance functions satisfactorily, but only after a lot of
backing and filling, such as returning the native client to RTM level and
then re-running the installation of the client tools.
On 12/17/07 1:25 PM, in article
351AA24D-A3AA-4812-9682-F36BAFB1BC14@.microsoft.com, "Russ Kaufmann [MVP]"
<russ@.clusterhelp.com> wrote:

> "Robert Hindla" <rhindla@.panix.com> wrote in message
> news:C38733A0.1BA20%rhindla@.panix.com...
> Are you installing the first instance or the second instance?
|||"Robert Hindla" <rhindla@.panix.com> wrote in message
news:C38DA216.1BACB%rhindla@.panix.com...
> The virtual SQL instance I'm proposing to de-install and then re-configure
> using the setup program in 'manage' mode (instead of 'setup' mode) is one
> of
> two named instances. It isn't the default instance.
> The default instance functions satisfactorily, but only after a lot of
> backing and filling, such as returning the native client to RTM level and
> then re-running the installation of the client tools.
So, it sounds to me like things are seriously hosed (to use a highly
technical term) with your cluster. I would consider a complete rebuild over
the holidays if it were me.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Jan 18 - 31 in Denver
Mar 10- 13 in Denver

cluster error

We have a one node cluster that is receiving the below error messages in the cluster.log and the Event Viewer. In the SQL Server 2005 SP2 job that fails we receive a slighlty different message. The OS is Windows 2003 SP1. This is not a 64-bit box. We have checked the permissions of the cluster service account in SQL Server to be sure they are correct. Can anyone please help with this issue.

00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.

00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] OnlineThread: QP is not online.
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

I'am having the same issue.|||

Moved to High Availablity forum...

(Please do not 'cluster' bomb so many forums with the same posting. Pick one, and give it time.)

|||What type of server (HP, Dell)?|||Anyone have any Ideas on this. I am having the same problem.

cluster error

We have a one node cluster that is receiving the below error messages in the cluster.log and the Event Viewer. In the SQL Server 2005 SP2 job that fails we receive a slighlty different message. The OS is Windows 2003 SP1. This is not a 64-bit box. We have checked the permissions of the cluster service account in SQL Server to be sure they are correct. Can anyone please help with this issue.

00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.

00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] OnlineThread: QP is not online.
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

I'am having the same issue.|||

Moved to High Availablity forum...

(Please do not 'cluster' bomb so many forums with the same posting. Pick one, and give it time.)

|||What type of server (HP, Dell)?|||Anyone have any Ideas on this. I am having the same problem.

Client-side printing hangs IE

Hi,
When I try to print a report using client-side printing in SP2, I get the
Print dialog fine, then when I click 'OK' I get the 'Printing now...' popup,
but IE hangs instantly. I've tried removing the ActiveX component and
reregistering it but to no avail. However, it works fine on other machines
that we have. Rendering to PDF works fine, so the report itself must be OK.
Is anyone else seeing the same problem, or have any ideas about what could
be causing it?
Thanks,
Chris.I found that being logged in as Administrator works perfectly, so it seems
to be some sort of permissions issue on the server. Do I need to change any
security settings in IIS or folder security on the report server?
Interestingly, the Export feature doesn't work unless the user has
administrative rights on the local machine.
Any ideas?
Chris.
"Chris Childs" <chris@.nospam.nowhere.com> wrote in message
news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
> Hi,
> When I try to print a report using client-side printing in SP2, I get the
> Print dialog fine, then when I click 'OK' I get the 'Printing now...'
> popup, but IE hangs instantly. I've tried removing the ActiveX component
> and reregistering it but to no avail. However, it works fine on other
> machines that we have. Rendering to PDF works fine, so the report itself
> must be OK.
> Is anyone else seeing the same problem, or have any ideas about what could
> be causing it?
> Thanks,
> Chris.
>|||It sounds like a permissions issue. Can you export to Web Archive as a non
admin? Both of these features use the users temp directory for storing some
data, can you see if the users has write permission on his %temp% directory?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Childs" <chris@.nospam.nowhere.com> wrote in message
news:d4qeda$h40$1$8300dec7@.news.demon.co.uk...
>I found that being logged in as Administrator works perfectly, so it seems
>to be some sort of permissions issue on the server. Do I need to change
>any security settings in IIS or folder security on the report server?
> Interestingly, the Export feature doesn't work unless the user has
> administrative rights on the local machine.
> Any ideas?
> Chris.
> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> When I try to print a report using client-side printing in SP2, I get the
>> Print dialog fine, then when I click 'OK' I get the 'Printing now...'
>> popup, but IE hangs instantly. I've tried removing the ActiveX component
>> and reregistering it but to no avail. However, it works fine on other
>> machines that we have. Rendering to PDF works fine, so the report itself
>> must be OK.
>> Is anyone else seeing the same problem, or have any ideas about what
>> could be causing it?
>> Thanks,
>> Chris.
>>
>|||Even when the user has full administrative rights on the local machine,
client-side printing still doesn't work. The user has full access to the
temp directory, and can export to both PDF and Web Archive formats.
Client-side printing only works when the user has administrative rights to
the domain. Maybe it is a setting in IIS, any ideas?
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:OkAdGcDTFHA.2520@.TK2MSFTNGP09.phx.gbl...
> It sounds like a permissions issue. Can you export to Web Archive as a
> non admin? Both of these features use the users temp directory for
> storing some data, can you see if the users has write permission on his
> %temp% directory?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> news:d4qeda$h40$1$8300dec7@.news.demon.co.uk...
>>I found that being logged in as Administrator works perfectly, so it seems
>>to be some sort of permissions issue on the server. Do I need to change
>>any security settings in IIS or folder security on the report server?
>> Interestingly, the Export feature doesn't work unless the user has
>> administrative rights on the local machine.
>> Any ideas?
>> Chris.
>> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
>> news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> When I try to print a report using client-side printing in SP2, I get
>> the Print dialog fine, then when I click 'OK' I get the 'Printing
>> now...' popup, but IE hangs instantly. I've tried removing the ActiveX
>> component and reregistering it but to no avail. However, it works fine
>> on other machines that we have. Rendering to PDF works fine, so the
>> report itself must be OK.
>> Is anyone else seeing the same problem, or have any ideas about what
>> could be causing it?
>> Thanks,
>> Chris.
>>
>>
>|||It is doubtful that it is an IIS setting. Are there any policies that block
ActiveX controls?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Childs" <chris@.nospam.nowhere.com> wrote in message
news:d4sq3p$od8$1$8302bc10@.news.demon.co.uk...
> Even when the user has full administrative rights on the local machine,
> client-side printing still doesn't work. The user has full access to the
> temp directory, and can export to both PDF and Web Archive formats.
> Client-side printing only works when the user has administrative rights to
> the domain. Maybe it is a setting in IIS, any ideas?
> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> news:OkAdGcDTFHA.2520@.TK2MSFTNGP09.phx.gbl...
>> It sounds like a permissions issue. Can you export to Web Archive as a
>> non admin? Both of these features use the users temp directory for
>> storing some data, can you see if the users has write permission on his
>> %temp% directory?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
>> news:d4qeda$h40$1$8300dec7@.news.demon.co.uk...
>>I found that being logged in as Administrator works perfectly, so it
>>seems to be some sort of permissions issue on the server. Do I need to
>>change any security settings in IIS or folder security on the report
>>server?
>> Interestingly, the Export feature doesn't work unless the user has
>> administrative rights on the local machine.
>> Any ideas?
>> Chris.
>> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
>> news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> When I try to print a report using client-side printing in SP2, I get
>> the Print dialog fine, then when I click 'OK' I get the 'Printing
>> now...' popup, but IE hangs instantly. I've tried removing the ActiveX
>> component and reregistering it but to no avail. However, it works fine
>> on other machines that we have. Rendering to PDF works fine, so the
>> report itself must be OK.
>> Is anyone else seeing the same problem, or have any ideas about what
>> could be causing it?
>> Thanks,
>> Chris.
>>
>>
>>
>|||No, the ActiveX control installs fine, and I get the print dialog, but then
it hangs when I print (or print preview) after that. We have no problems
with other ActiveX controls.
Chris.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:e$CvMMNTFHA.3848@.TK2MSFTNGP10.phx.gbl...
> It is doubtful that it is an IIS setting. Are there any policies that
> block ActiveX controls?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> news:d4sq3p$od8$1$8302bc10@.news.demon.co.uk...
>> Even when the user has full administrative rights on the local machine,
>> client-side printing still doesn't work. The user has full access to the
>> temp directory, and can export to both PDF and Web Archive formats.
>> Client-side printing only works when the user has administrative rights
>> to the domain. Maybe it is a setting in IIS, any ideas?
>> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
>> news:OkAdGcDTFHA.2520@.TK2MSFTNGP09.phx.gbl...
>> It sounds like a permissions issue. Can you export to Web Archive as a
>> non admin? Both of these features use the users temp directory for
>> storing some data, can you see if the users has write permission on his
>> %temp% directory?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
>> news:d4qeda$h40$1$8300dec7@.news.demon.co.uk...
>>I found that being logged in as Administrator works perfectly, so it
>>seems to be some sort of permissions issue on the server. Do I need to
>>change any security settings in IIS or folder security on the report
>>server?
>> Interestingly, the Export feature doesn't work unless the user has
>> administrative rights on the local machine.
>> Any ideas?
>> Chris.
>> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
>> news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
>> Hi,
>> When I try to print a report using client-side printing in SP2, I get
>> the Print dialog fine, then when I click 'OK' I get the 'Printing
>> now...' popup, but IE hangs instantly. I've tried removing the
>> ActiveX component and reregistering it but to no avail. However, it
>> works fine on other machines that we have. Rendering to PDF works
>> fine, so the report itself must be OK.
>> Is anyone else seeing the same problem, or have any ideas about what
>> could be causing it?
>> Thanks,
>> Chris.
>>
>>
>>
>>
>|||Try this...I think you may be missing RSClientPrint.Authenticate = false;
function Print()
{
RSClientPrint.MarginLeft = .5 * 25.4;
RSClientPrint.MarginTop = .5 * 25.4;
RSClientPrint.MarginRight = .5 * 25.4;
RSClientPrint.MarginBottom = .5 * 25.4;
RSClientPrint.Culture = 1033;
RSClientPrint.UICulture = 1033;
RSClientPrint.PageWidth = 11 * 25.4;
RSClientPrint.PageHeight = 8.5 * 25.4;
RSClientPrint.Authenticate = false;
RSClientPrint.Print('http://unisys1/reportserver',
'/Test/LMMISInquiry/RECIPIENTREIMBURSEMENT/ReportsAndLetters/AvgTurnaroundTime', 'AvgTurnaroundTime');
}
"Chris Childs" wrote:
> No, the ActiveX control installs fine, and I get the print dialog, but then
> it hangs when I print (or print preview) after that. We have no problems
> with other ActiveX controls.
> Chris.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:e$CvMMNTFHA.3848@.TK2MSFTNGP10.phx.gbl...
> > It is doubtful that it is an IIS setting. Are there any policies that
> > block ActiveX controls?
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
> > "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> > news:d4sq3p$od8$1$8302bc10@.news.demon.co.uk...
> >> Even when the user has full administrative rights on the local machine,
> >> client-side printing still doesn't work. The user has full access to the
> >> temp directory, and can export to both PDF and Web Archive formats.
> >> Client-side printing only works when the user has administrative rights
> >> to the domain. Maybe it is a setting in IIS, any ideas?
> >>
> >> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> >> news:OkAdGcDTFHA.2520@.TK2MSFTNGP09.phx.gbl...
> >> It sounds like a permissions issue. Can you export to Web Archive as a
> >> non admin? Both of these features use the users temp directory for
> >> storing some data, can you see if the users has write permission on his
> >> %temp% directory?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> >> news:d4qeda$h40$1$8300dec7@.news.demon.co.uk...
> >>I found that being logged in as Administrator works perfectly, so it
> >>seems to be some sort of permissions issue on the server. Do I need to
> >>change any security settings in IIS or folder security on the report
> >>server?
> >>
> >> Interestingly, the Export feature doesn't work unless the user has
> >> administrative rights on the local machine.
> >>
> >> Any ideas?
> >>
> >> Chris.
> >>
> >> "Chris Childs" <chris@.nospam.nowhere.com> wrote in message
> >> news:d4qc2t$3ni$1$8302bc10@.news.demon.co.uk...
> >> Hi,
> >>
> >> When I try to print a report using client-side printing in SP2, I get
> >> the Print dialog fine, then when I click 'OK' I get the 'Printing
> >> now...' popup, but IE hangs instantly. I've tried removing the
> >> ActiveX component and reregistering it but to no avail. However, it
> >> works fine on other machines that we have. Rendering to PDF works
> >> fine, so the report itself must be OK.
> >>
> >> Is anyone else seeing the same problem, or have any ideas about what
> >> could be causing it?
> >>
> >> Thanks,
> >>
> >> Chris.
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>

Client-side printing from NT with SP2

We have installed SP2 and client-side printing from the browser is working
fine for our users on XP/IE6. However, we have some users with NT4/IE6 on
their machines. They are able to view reports, but when they click the Print
icon, nothing happens (no error, no prompt, nothing).
Is the ActiveX control for printing included in SP2 supported for clients
using NT4?Ah, crap...
Same here. That's a show stopper!!!
"MELMEL" <MELMEL@.discussions.microsoft.com> wrote in message
news:DDFF5917-13B1-44D2-8138-EB44818B579D@.microsoft.com...
> We have installed SP2 and client-side printing from the browser is working
> fine for our users on XP/IE6. However, we have some users with NT4/IE6 on
> their machines. They are able to view reports, but when they click the
Print
> icon, nothing happens (no error, no prompt, nothing).
> Is the ActiveX control for printing included in SP2 supported for clients
> using NT4?|||When a product is given end of lifetime that really does mean that. It might
work or it might not but MS spends 0 time testing with it. It is not part of
their test suite. Extended support expired almost a year ago. I assume the
users can continute to export to PDF and print that way.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Fredrick Bartlett" <rick_bartlett@.WeDoNET.net> wrote in message
news:Os2pNyPUFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Ah, crap...
> Same here. That's a show stopper!!!
> "MELMEL" <MELMEL@.discussions.microsoft.com> wrote in message
> news:DDFF5917-13B1-44D2-8138-EB44818B579D@.microsoft.com...
> > We have installed SP2 and client-side printing from the browser is
working
> > fine for our users on XP/IE6. However, we have some users with NT4/IE6
on
> > their machines. They are able to view reports, but when they click the
> Print
> > icon, nothing happens (no error, no prompt, nothing).
> >
> > Is the ActiveX control for printing included in SP2 supported for
clients
> > using NT4?
>|||We didn't test on NT4. We tested on XP, Win 2003, Win 2000, Win 98 and
WinME.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O8w1aIYUFHA.580@.TK2MSFTNGP15.phx.gbl...
> When a product is given end of lifetime that really does mean that. It
> might
> work or it might not but MS spends 0 time testing with it. It is not part
> of
> their test suite. Extended support expired almost a year ago. I assume the
> users can continute to export to PDF and print that way.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Fredrick Bartlett" <rick_bartlett@.WeDoNET.net> wrote in message
> news:Os2pNyPUFHA.3184@.TK2MSFTNGP15.phx.gbl...
>> Ah, crap...
>> Same here. That's a show stopper!!!
>> "MELMEL" <MELMEL@.discussions.microsoft.com> wrote in message
>> news:DDFF5917-13B1-44D2-8138-EB44818B579D@.microsoft.com...
>> > We have installed SP2 and client-side printing from the browser is
> working
>> > fine for our users on XP/IE6. However, we have some users with NT4/IE6
> on
>> > their machines. They are able to view reports, but when they click the
>> Print
>> > icon, nothing happens (no error, no prompt, nothing).
>> >
>> > Is the ActiveX control for printing included in SP2 supported for
> clients
>> > using NT4?
>>
>

Client Side Printing SQL Report

Can anyone explain and maybe post some code on how to print a SQL Report in asp .net - I'm using SQL Reporting sp2 and I just can't find anything that works out there. Your help would be greatly appreciated... I tried RSClientprint.dll and had no luck...

thanks
rich

We're using "OfficeWriter" by a company called SoftArtisans. Note, it's not cheap.|||

I see - I'm looking for the ability to print the report only no need for all the other features - Thanks for your reply...

rich

|||

rperreta wrote:

Can anyone explain and maybe post some code on how to print a SQL Report in asp .net - I'm using SQL Reporting sp2 and I just can't find anything that works out there. Your help would be greatly appreciated... I tried RSClientprint.dll and had no luck...

thanks
rich

Why aren't you using the exporting features from RS? The client can preview and then export to the available formats, with the capability to save them AND print them.|||You can try Windows Script Host for clientside object creation and printing. It is Free by Microsoft.
http://msdn.microsoft.com/library/en-us/script56/html/wsconswitchingnetworkedprintersonoff.asp?frame=true
Regards,
Hemchand|||Hello!
I may not understand on "How To Print a Report in SQL Report in Asp.Net" but in the latest Service Pack 2 for Reporting Services there was an Active X control that displays an Icon on the toolbar that provides for direct printing of a Reporting Services report directly to any printer on your network.
From MS www site:
Key Functional EnhancementsReports can now be printed directly from within Internet Explorer. A Microsoft ActiveX control is provided to support a rich client-side printing experience including full page preview.|||

hi,

i would like to check where do u find the RSClientprint.dll? i try search my pc for the dll file but invalid.

if any1 can tell mi where to find it..greatly appreciated

your regards

angela

|||Hello:
There is a CAB file RSCLIENTPRINT in
(at least on my server) c:\Program files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin
I just then moved the dll's to the bin directory within the same directory structure above.
Best Reagrds,
|||hi,
i know of the active x print that will call the print frm RSClientPrint but the main issue that i concern is how can i not display the print dialog box where by it prompt the user to select the printer and print. Because i want to print the report automatically once i evoke a print button on my .net application. is there any ways to do it?
cheers
Angela|||

hooligannes97 wrote:

rperreta wrote:

Can anyone explain and maybe post some code on how to print a SQL Report in asp .net - I'm using SQL Reporting sp2 and I just can't find anything that works out there. Your help would be greatly appreciated... I tried RSClientprint.dll and had no luck...

thanks
rich

Why aren't you using the exporting features from RS? The client can preview and then export to the available formats, with the capability to save them AND print them.

RS? Microsoft Reporting Services?|||

rperreta wrote:

RS? Microsoft Reporting Services?

Correct

Client Side Printing

We just installed SP2 on our SRS server. However, the client-side printing
is returning an error. How can we disable this feature?You can do that by deactivating the function with a property called
EnableClientPrintControl. Due to untested I refer only to that post:
http://groups.google.de/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/9bf4cd750acf0237/d6cb4e15cb1b7d57?q=disable+print+OR+printing+Control&rnum=1&hl=de#d6cb4e15cb1b7d57
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"TechnoSpyke" <technospyke@.yahoo.com> schrieb im Newsbeitrag
news:eJFeS$gWFHA.3540@.TK2MSFTNGP15.phx.gbl...
> We just installed SP2 on our SRS server. However, the client-side
> printing is returning an error. How can we disable this feature?
>|||Ok, the error was due to an older control (downloaded the beta version).
After removing that, and downloading a new one, the error is gone.
Still, I dont know where to enable/disable client-side printing. The SP2
document says there is a new Report Server system property called
EnableClientPrinting with a default value as True. I don't see this
property on any of the config files for ReportServer. Where will I change
this?
TIA.
Marlon
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:eJFeS$gWFHA.3540@.TK2MSFTNGP15.phx.gbl...
> We just installed SP2 on our SRS server. However, the client-side
> printing is returning an error. How can we disable this feature?
>|||Found this on the support articles: How to disable client-side printing
http://support.microsoft.com/kb/897121/
Works, but, I was surprised I had to write a little console app to set RS
system properties. Adding/changing config settings would have been more
convenient.
Marlon
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:eZQnjWhWFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Ok, the error was due to an older control (downloaded the beta version).
> After removing that, and downloading a new one, the error is gone.
> Still, I dont know where to enable/disable client-side printing. The SP2
> document says there is a new Report Server system property called
> EnableClientPrinting with a default value as True. I don't see this
> property on any of the config files for ReportServer. Where will I change
> this?
> TIA.
> Marlon
> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
> news:eJFeS$gWFHA.3540@.TK2MSFTNGP15.phx.gbl...
>> We just installed SP2 on our SRS server. However, the client-side
>> printing is returning an error. How can we disable this feature?
>

Client Side Printing

Ok, for the life of me I can't seem to get this to work. Whenever I used the client-side print for SRS2000 SP2 it will always print out a blank page at the end.

At first I thought it was the margins, because not matter what I did the right-most column would always get chopped off. It would preview and look great, but as soon as I printed the page the last column would be chopped in half and print on a separate page.

So to troubleshoot I created a table that had only one column that was placed in the center of the page (using padding). Event after doing this the column STILL got chopped in half and printed out in two pages. Yet previewed and looked like it would print out ok.

Any help would be greatly appreciated. This one is driving me crazy.

Ok scratch this one. Turns out I wasn't accounting for the margins that were being set somewere. Once I reduced the body and table width by .1 inch then the right hand column isn't chopped and the correct number of pages prints out (no blanks).

There report has no margin and when printing I was sure to set the margins to 0 there as well.

Anyone tell me where this margin is coming from? Is this printer specific?

Thanks

|||

Have you tried to go to REPORT PROPERTIES for the specific report?

and establish the width in CM or inches?

Did you also look at report headers and footers

How large is your "print frame"

Are you using RS 2000 or RS 2005?

Can Help u!

|||

RS 2000.

The body of the report is 8.5" x 11". In the report properties->layout the page width is also 8.5" x 11". In the same section all margins are set to 0. My table is the entire width of the body (i.e. also 8.5" wide).

Now when I print the report using the Active X client side print component there is a margin added to the report that I hadn't accounted for. This margin was chopping the right column off and having it print on a separate page. This margin exists even though no margins are set for the report and when printing there are no margins set there as well.

What had been confusing me was that no matter how wide I made the table it still printed two pages. What I didn't realize is that I had to reduce the width of the body as well.

So by setting the width of the body to 8.45" and the width of the table to the same 8.45" the report prints on one page as expected.

Now, that we are on the same page, where did this margin come from knowing that I did not set it anywhere? The printer, RS2000, the client side Active X control...?

Thanks

|||

Hi,
I rather experience a very peculiar problem. I have developed a page in asp.net, which has a Print button by itself. It has to take the user to the printer window (I have used window.print()). When the user selects the printer and says print the first and the third page ( third page being the last page) gets printed properly where as the second page will have problems with the right side margin. This page is getting created on the run depending on the user's inputs. When I view the print preview, I found that the text in the next line of the page also comes to the previous page resulting in the loss of datain the II page content alone.

For example,

In the actual page, if I have

When a page from the web is printed, sometimes the right
hand side centremeter will be cut off.
Microsoft has a knowledge base article about this problem:

The text in the print preview would be,

When a page from the web is printed, sometimes the right hand side centremeter will be cut off. Microsoft has a
knowledge base article about this problem:

therefore resulting in the loss of data. I have tried adjusting the right and left side margins, but without luck.

This happens even if i print it with/without back to back option.
Even if i ask for the II page alone to be printed twice instead of the whole web page content, both the pages have the right side margin lost.

The same content that appears in the II page if made to appear in the III page does not affect the right margin of the III page. Thus, it does not have any content related issues.

Printing with landscape option wont be a reasonable option for the user. So, that can be ruled out.

Please advise what could be the work around at teh earliest as i have to get back to the user.

Client attaches to wrong server

Hello All,
I am running SQL server 7 sp4 on an NT4.0 SP6a, I'll call it machin2. I =
am=20
also running SQL server 7 sp2 on an NT4.0 SP6a, I'll call it machine 1. =
Two=20
databases. I am trying to move the database on machine 1 to the server=20
machine 2. I have installed sql and installed all of the patches ( i =
think) for=20
SQL7 sp4 on machine 2. I copied over a back up of the original=20
database(just the data) running on machine 1 to machine 2 after a clean=20
install. Then ran all the patches and updates to get machine 2 to SQL7 =
sp4.=20
Now my problem is if both servers are running my clients will only =
connect=20
to machine 1 no matter what. I have tried specifying ip address in the =
Client=20
utility and still no connection to machine 2. IT connects just fine with =
no=20
errors but it is machine1 not machine2. I f I stop sql services on =
machine1=20
and try to connect to machine2 I get the eror : native SQL error 10004.=20
Cannot locate or connect to SQL server. I can connect to both machines =
with=20
the enterprise utility, but from the client I can only connect to =
machine 1. If I=20
am at the console I can connect to machine 2, but that is the only way I =
know of. I can ping machine2 by name and it resolves correctly if I use =
the=20
-a option when I ping also.
I think I have all of the patches installed to fix everything in SP4 =
but I'm=20
not certain. Any help would be great.
Thanks
Robert SmithCheck the client machines for aliases under the
MSSQLServer\Client\ConnectTo key.
Otherwise, make network traces from the client machine.
run ipconfig /flushdns
ipconfig /registerdns
then start Microsoft Network Monitor or network sniffer.
Then attempt a connection from Query Analyser.
Review the trace and verify that the tcp session is connecting to the
correct machine.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks! That took care of it. Fpr some reason the connect to key was=20
referencing the wrong server.
Thanks again for the help!

>--Original Message--
>Check the client machines for aliases under the=20
>MSSQLServer\Client\ConnectTo key.
>Otherwise, make network traces from the client machine.
>run ipconfig /flushdns
>ipconfig /registerdns
>then start Microsoft Network Monitor or network sniffer.
>Then attempt a connection from Query Analyser.
>Review the trace and verify that the tcp session is connecting to the=20
>correct machine.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and confers no =
rights.
>
>.
>|||You're welcome!
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Client attaches to wrong server

Hello All,
I am running SQL server 7 sp4 on an NT4.0 SP6a, I'll call it machin2. I =
am=20
also running SQL server 7 sp2 on an NT4.0 SP6a, I'll call it machine 1. =
Two=20
databases. I am trying to move the database on machine 1 to the server=20
machine 2. I have installed sql and installed all of the patches ( i =
think) for=20
SQL7 sp4 on machine 2. I copied over a back up of the original=20
database(just the data) running on machine 1 to machine 2 after a clean=20
install. Then ran all the patches and updates to get machine 2 to SQL7 =
sp4.=20
Now my problem is if both servers are running my clients will only =
connect=20
to machine 1 no matter what. I have tried specifying ip address in the =
Client=20
utility and still no connection to machine 2. IT connects just fine with =
no=20
errors but it is machine1 not machine2. I f I stop sql services on =
machine1=20
and try to connect to machine2 I get the eror : native SQL error 10004.=20
Cannot locate or connect to SQL server. I can connect to both machines =
with=20
the enterprise utility, but from the client I can only connect to =
machine 1. If I=20
am at the console I can connect to machine 2, but that is the only way I =
know of. I can ping machine2 by name and it resolves correctly if I use =
the=20
-a option when I ping also.
I think I have all of the patches installed to fix everything in SP4 =
but I'm=20
not certain. Any help would be great.
Thanks
Robert Smith
Check the client machines for aliases under the
MSSQLServer\Client\ConnectTo key.
Otherwise, make network traces from the client machine.
run ipconfig /flushdns
ipconfig /registerdns
then start Microsoft Network Monitor or network sniffer.
Then attempt a connection from Query Analyser.
Review the trace and verify that the tcp session is connecting to the
correct machine.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Thanks! That took care of it. Fpr some reason the connect to key was=20
referencing the wrong server.
Thanks again for the help!

>--Original Message--
>Check the client machines for aliases under the=20
>MSSQLServer\Client\ConnectTo key.
>Otherwise, make network traces from the client machine.
>run ipconfig /flushdns
>ipconfig /registerdns
>then start Microsoft Network Monitor or network sniffer.
>Then attempt a connection from Query Analyser.
>Review the trace and verify that the tcp session is connecting to the=20
>correct machine.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and confers no =
rights.
>
>.
>
|||You're welcome!
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.