Cluster install failing

When installing SQL 2005 on a 2 node cluster, the install fails saying setup
on the remote machine failed, check the task scheduler log. The log on the
remote machine says "Unable to start task...Access is denied". Any idea how
to get around this?
Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition
I also need to mention that I have Act as part of the operating system and
log on as a service rights on both nodes.
"Brad" wrote:

> When installing SQL 2005 on a 2 node cluster, the install fails saying setup
> on the remote machine failed, check the task scheduler log. The log on the
> remote machine says "Unable to start task...Access is denied". Any idea how
> to get around this?
> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition
|||You have to install using a domain account that is a member of the local
administrators group on each server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:AA1196F9-0113-4844-B2C4-1BEABCAE97F3@.microsoft.com...[vbcol=seagreen]
>I also need to mention that I have Act as part of the operating system and
> log on as a service rights on both nodes.
> "Brad" wrote:
|||Permissions. The account that you are using to install the failover cluster
instance must be a member of the local admin group on each machine. (The
service accounts related to SQL Server do NOT need to be.)
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:F9ED4AEF-08EF-40CD-845E-E86794714C8A@.microsoft.com...
> When installing SQL 2005 on a 2 node cluster, the install fails saying
> setup
> on the remote machine failed, check the task scheduler log. The log on
> the
> remote machine says "Unable to start task...Access is denied". Any idea
> how
> to get around this?
> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition
|||Yes, thank you. The domain account I am using is already a member of the
admin group on both nodes. The error still persists.
"Geoff N. Hiten" wrote:

> You have to install using a domain account that is a member of the local
> administrators group on each server.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brad" <Brad@.discussions.microsoft.com> wrote in message
> news:AA1196F9-0113-4844-B2C4-1BEABCAE97F3@.microsoft.com...
>
>
|||I didn't provide that information up front but the account is a member of the
admin group on both boxes.
"Michael Hotek" wrote:

> Permissions. The account that you are using to install the failover cluster
> instance must be a member of the local admin group on each machine. (The
> service accounts related to SQL Server do NOT need to be.)
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "Brad" <Brad@.discussions.microsoft.com> wrote in message
> news:F9ED4AEF-08EF-40CD-845E-E86794714C8A@.microsoft.com...
>
>
|||Hi,
But is it the LOCAL ADMIN ACCOUNT not domain admin account?
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:56372080-3701-40DA-8CF1-9B002BDC2E11@.microsoft.com...[vbcol=seagreen]
> Yes, thank you. The domain account I am using is already a member of the
> admin group on both nodes. The error still persists.
> "Geoff N. Hiten" wrote:
|||Yes, it is in the local admin group on both machines.
"Nik Marshall-Blank" wrote:

> Hi,
> But is it the LOCAL ADMIN ACCOUNT not domain admin account?
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Brad" <Brad@.discussions.microsoft.com> wrote in message
> news:56372080-3701-40DA-8CF1-9B002BDC2E11@.microsoft.com...
>
>
|||Make sure the task scheduler service is enabled and running on all nodes.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:DC6D365B-B9E9-4A59-947C-0A947C91826B@.microsoft.com...[vbcol=seagreen]
> Yes, it is in the local admin group on both machines.
> "Nik Marshall-Blank" wrote:
|||Did you ever get a resolution on this ? I am having the exact same
problem.
I have checked all the obvious problems, like permissions, task
scheduler service running, etc.
I am going to call Microsoft Support tomorrow if I can't figure this
out.
Brad wrote:[vbcol=seagreen]
> I didn't provide that information up front but the account is a member of the
> admin group on both boxes.
> "Michael Hotek" wrote:
sqlsql

Cluster Failover - Setting Affinity

Hi Folks:
How do you script-o-matically set processor affinity on SQL after a
cluster failure?
The purpose is that I'll be failing to a machine with a different
amount of CPU's (4 instead of 8). I want to control what SQL
instances take what amounts of processor.
Is this even possible?
Thanks!
Not that this will help any, but Datacenter allows for this from the Process
Control program
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"The Researcher" <the_re_searcher@.hotmail.com> wrote in message
news:59fe996a.0408300823.1bfbe5d2@.posting.google.c om...
> Hi Folks:
> How do you script-o-matically set processor affinity on SQL after a
> cluster failure?
> The purpose is that I'll be failing to a machine with a different
> amount of CPU's (4 instead of 8). I want to control what SQL
> instances take what amounts of processor.
> Is this even possible?
> Thanks!
|||... then I wonder if you can do it in WSRM in Win2k3 that allows you to set
percentages etc on processors - it seems to be derived from the Process
Control Tool in Datacenter ?
Andy.
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:eHgTAWrjEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Not that this will help any, but Datacenter allows for this from the
Process
> Control program
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> "The Researcher" <the_re_searcher@.hotmail.com> wrote in message
> news:59fe996a.0408300823.1bfbe5d2@.posting.google.c om...
>
|||Excellent idea Andy! WSRM is not do processors affinity though. It does do
these things:
Set CPU and memory allocation policies on applications. This includes
selecting processes to be managed, and setting resource usage targets or
limits.
Manage CPU utilization (percent CPU in use).
Limit the process working set size (physical resident pages in use).
Manage committed memory (pagefile usage).
Apply policies to users or groups on a Terminal Services application
server.
Apply policies on a date/time schedule.
Generate, store, view, and export resource utilization accounting
records for management, service level agreement (SLA) tracking, and
charge-back purposes.
see
http://www.microsoft.com/windowsserv...fastfacts.mspx
for more on WSRM.
Its a great package and free for EE and DC editions.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Andy Ball" <andy.ball@.remove4spam_greenfell.com> wrote in message
news:O%23xgKBFkEHA.324@.TK2MSFTNGP11.phx.gbl...
> ... then I wonder if you can do it in WSRM in Win2k3 that allows you to
> set
> percentages etc on processors - it seems to be derived from the Process
> Control Tool in Datacenter ?
> Andy.
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:eHgTAWrjEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Process
>
|||Dang English language and spell chuckers! WSRM is not do processors affinity
though - Should be WSRM does not do processors affinity.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:uunBBKJkEHA.3712@.TK2MSFTNGP15.phx.gbl...
> Excellent idea Andy! WSRM is not do processors affinity though. It does do
> these things:
> Set CPU and memory allocation policies on applications. This includes
> selecting processes to be managed, and setting resource usage targets or
> limits.
> Manage CPU utilization (percent CPU in use).
> Limit the process working set size (physical resident pages in
> use).
> Manage committed memory (pagefile usage).
> Apply policies to users or groups on a Terminal Services
> application server.
> Apply policies on a date/time schedule.
> Generate, store, view, and export resource utilization accounting
> records for management, service level agreement (SLA) tracking, and
> charge-back purposes.
>
> see
> http://www.microsoft.com/windowsserv...fastfacts.mspx
> for more on WSRM.
> Its a great package and free for EE and DC editions.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> "Andy Ball" <andy.ball@.remove4spam_greenfell.com> wrote in message
> news:O%23xgKBFkEHA.324@.TK2MSFTNGP11.phx.gbl...
>
|||"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in message news:<eHgTAWrjEHA.1656@.TK2MSFTNGP09.phx.gbl>...
> Not that this will help any, but Datacenter allows for this from the Process
> Control program
ehr, I just checked with the WSRM site and found the following snippet:
It is not recommended that you use WSRM CPU affinity for SQL Server 2000.
That being said, it doesn't appear as though that's going to work.
Any other suggestions?
Thx
sqlsql

CLR Trigger -> Send Insert/Update/Delete Message to Windows Service

Hi,

I have an c# windows service, which is running on the same machine where my mssql server is installed. This service must be informed for each insert/update/delete event on one specific table.

My idea was to create an CLR Trigger for this table which can communicate with this service via .NET remoting. But the problem is, that the system.runtime.remoting assembly is not integrated within the mssql clr enviroment => i can't use remoting.

Are there any other idea's how can i solve this?

Best regards,
Thomas

Hi,

what about using Query Notification ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||I had the same problem as you and I have used two different tecniques: both of them uses CLR stored procs.

1. An OS event set by SqlServer: useful when to have to notify that an event occurred without any param. Each different event must be attached to a different event name.

[SqlProcedure]
public static void SetOsEvent(SqlString eventName) {
try {
EventWaitHandle.OpenExisting((string)eventName).Set();
}
catch (WaitHandleCannotBeOpenedException) {
}
}

2. An UDP Message. Useful for non-reliable and fast messaging system, such as broadcasting the internal net that an event has occurred.

[SqlProcedure]
public static void UdpSend(SqlString address, SqlInt32 port, SqlString message) {
try {
System.Net.Sockets.UdpClient client = new System.Net.Sockets.UdpClient();
byte[] datagram = message.GetUnicodeBytes();
client.Send(datagram, datagram.Length, (string)address, (int)port);
}
catch{
}
}

[SqlProcedure]
public static void UdpBroadcast(SqlInt32 port, SqlString message) {
try {
System.Net.Sockets.UdpClient client = new System.Net.Sockets.UdpClient();
byte[] datagram = message.GetUnicodeBytes();
System.Net.IPEndPoint ep = new System.Net.IPEndPoint(System.Net.IPAddress.Broadcast, (int)port);
client.Send(datagram, datagram.Length, ep);
}
catch {
}
}

Hope that helps.

Cloned Drive

I have a machine named DOG with MSDE (computername=DOG). I clone the machine
to another and rename the machine CAT. When I do this, SQL Server reports
"Your SQL Server installation is either corrupt or has been tampered with
(unknown package id). Please rerun setup." I understand why this happens,
the computername changed.
Is there a way to change the package id to work with the new computername?
Of course I can reinstall MSDE, but that defeats the mai purpose of the
clone.
TIA,
Will
hi Will,
Will T wrote:
> I have a machine named DOG with MSDE (computername=DOG). I clone the
> machine to another and rename the machine CAT. When I do this, SQL
> Server reports "Your SQL Server installation is either corrupt or has
> been tampered with (unknown package id). Please rerun setup." I
> understand why this happens, the computername changed.
> Is there a way to change the package id to work with the new
> computername? Of course I can reinstall MSDE, but that defeats the
> mai purpose of the clone.
to the best of my knowledge, this was a problem with SQL Server 7.0 and MSDE
1.0(http://support.microsoft.com/default...b;en-us;229875), as SQL
Server 7.0 could be "managed" rerunning the setup (
http://databasejournal.com/features/...0894_2194711_3 ),
where no work around was available for MSDE 1.0...
for SQL Server 2000, if you change the computer name, you only need to
delete and re-create the server registration in Enterprise Manager, but as
MSDE doew not provide it, you need nothing on MSDE 2000...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Client-server simple question

In SQL 2000, if I'm running Query Analyzer on a client machine, and do
something like
Select * Into NewTable from OldTable
the data records don't all come from the server to my client machine and go
back to the server, do they? Doesn't all the data movement actually take
place ON the server?
The only reason I ask is that during this operation, the LAN icon "light"
in the system tray is solidly lit up, while it's not usually that way (it
usually blinks on and off). Maybe that's just status communication to QA,
but the icon is lit completely solid during this operation.
Thanks.
David WalkerThe data should not be zooming back and forth across the LAN.
What is probably being sent is the clock updates to the QA.
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in news:OYnpflb#EHA.3368
@.TK2MSFTNGP15.phx.gbl:

> The data should not be zooming back and forth across the LAN.
> What is probably being sent is the clock updates to the QA.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
OK, thanks. That's what I hoped. The "light" being on solid is strange
for clock updates to the QA, but ... thanks.
David Walker

Client-server simple question

In SQL 2000, if I'm running Query Analyzer on a client machine, and do
something like
Select * Into NewTable from OldTable
the data records don't all come from the server to my client machine and go
back to the server, do they? Doesn't all the data movement actually take
place ON the server?
The only reason I ask is that during this operation, the LAN icon "light"
in the system tray is solidly lit up, while it's not usually that way (it
usually blinks on and off). Maybe that's just status communication to QA,
but the icon is lit completely solid during this operation.
Thanks.
David Walker
The data should not be zooming back and forth across the LAN.
What is probably being sent is the clock updates to the QA.
Rick Sawtell
MCT, MCSD, MCDBA
|||"Rick Sawtell" <quickening@.msn.com> wrote in news:OYnpflb#EHA.3368
@.TK2MSFTNGP15.phx.gbl:

> The data should not be zooming back and forth across the LAN.
> What is probably being sent is the clock updates to the QA.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
OK, thanks. That's what I hoped. The "light" being on solid is strange
for clock updates to the QA, but ... thanks.
David Walker

Client-server simple question

In SQL 2000, if I'm running Query Analyzer on a client machine, and do
something like
Select * Into NewTable from OldTable
the data records don't all come from the server to my client machine and go
back to the server, do they? Doesn't all the data movement actually take
place ON the server?
The only reason I ask is that during this operation, the LAN icon "light"
in the system tray is solidly lit up, while it's not usually that way (it
usually blinks on and off). Maybe that's just status communication to QA,
but the icon is lit completely solid during this operation.
Thanks.
David WalkerThe data should not be zooming back and forth across the LAN.
What is probably being sent is the clock updates to the QA.
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in news:OYnpflb#EHA.3368
@.TK2MSFTNGP15.phx.gbl:
> The data should not be zooming back and forth across the LAN.
> What is probably being sent is the clock updates to the QA.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
OK, thanks. That's what I hoped. The "light" being on solid is strange
for clock updates to the QA, but ... thanks.
David Walker

Clients not installing

Getting this error...
SMS Client Configuration Manager cannot connect to the machine
"ComputerName". The operating system reported error 1314: A required
privilege is not held by the client.
Possible cause: The client is not accessible.
Solution: Verify that the client is connected to the network and that the
SMS Service account or (if specified) the SMS Client Remote Installation
account have the required privileges, as specified in the SMS documentation.
Does the account I specified in Connection Accounts need to have local admin
perms? How can I double check?
Jason
Crap wrong group...sorry.
"JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
news:euwoiFFPFHA.3072@.TK2MSFTNGP09.phx.gbl...
> Getting this error...
> SMS Client Configuration Manager cannot connect to the machine
> "ComputerName". The operating system reported error 1314: A required
> privilege is not held by the client.
> Possible cause: The client is not accessible.
> Solution: Verify that the client is connected to the network and that the
> SMS Service account or (if specified) the SMS Client Remote Installation
> account have the required privileges, as specified in the SMS
> documentation.
> Does the account I specified in Connection Accounts need to have local
> admin perms? How can I double check?
> Jason
>

Client/Server Connection

Hi ;

I m trying to create Merge Replication. I was able to create the
replication on the same machine, however my aim is to use client
machine and do all the neessary work on the client machine and then
synchronize to the server. Thus, I have installed client version of SQL
2000, I connected to the database server, the thing is when I go off
line I lose connection. Is there any way to create the subscription in
to the client machine as an off line user then synchronize it ?Or DO I
have create my shopshot on the client machine?
If someone can help me I would really appreciate

Regards
AsI think the problem is with how you are connecting to the server.
Instead of using the network name when you register the server, use
<local> or '.' Your subscription must be created on the server.

Client side printing

Hi
I am trying to print Query Result directly to the printer from Client
machine. I managed to do this on Server machine. Where I had written SP whic
h
accepts SQL as parameter and using osql and xp_cmdShell command I am
outputting CSV file to printer. I want to do same from client machine but I
want print out should get printed on client printer not on Server.
Any ideas or suggestions'
Many thanks in advance.
Regards,
Santoshxp_cmdshell is executed on the server machine, which has no knowledge of the
client who submitted
the SQL command. Perhaps you can specify the printer name using UNC naming s
o the print is done on
the server machine, but the destination is specified as the client?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Santosh" <Santosh@.discussions.microsoft.com> wrote in message
news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
> Hi
> I am trying to print Query Result directly to the printer from Client
> machine. I managed to do this on Server machine. Where I had written SP wh
ich
> accepts SQL as parameter and using osql and xp_cmdShell command I am
> outputting CSV file to printer. I want to do same from client machine but
I
> want print out should get printed on client printer not on Server.
> Any ideas or suggestions'
> Many thanks in advance.
> Regards,
> Santosh
>|||Thanks Tibor, yes what you are suggesting, makes sense.
But I feel it will be better if I drop this idea and look for some different
option. Because if we want to specify UNC naming for printer. I need to make
printer as shared and need to give permissions so it can be accessible from
server by other users. Since printers are getting cheaper and cheaper, almos
t
everyone at client-side got there own printers, so I doubt if client admin
will accept this solution.
"Tibor Karaszi" wrote:

> xp_cmdshell is executed on the server machine, which has no knowledge of t
he client who submitted
> the SQL command. Perhaps you can specify the printer name using UNC naming
so the print is done on
> the server machine, but the destination is specified as the client?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Santosh" <Santosh@.discussions.microsoft.com> wrote in message
> news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
>
>|||I agree with your assessment. Can you do the printing from the client app (w
hich I assume is running
on the client machine already)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"sansaw80" <sansaw80@.discussions.microsoft.com> wrote in message
news:E7FB20CE-CDA7-4334-BA6F-AEAEDA694852@.microsoft.com...[vbcol=seagreen]
> Thanks Tibor, yes what you are suggesting, makes sense.
> But I feel it will be better if I drop this idea and look for some differe
nt
> option. Because if we want to specify UNC naming for printer. I need to ma
ke
> printer as shared and need to give permissions so it can be accessible fro
m
> server by other users. Since printers are getting cheaper and cheaper, alm
ost
> everyone at client-side got there own printers, so I doubt if client admin
> will accept this solution.
>
>
> "Tibor Karaszi" wrote:
>|||Yup I can Print Crystal reports on local client printer through client app.
Now I have written small code in Vb.net which accepts SQL from client PC and
prints result in CSV format on local client printer.
"Tibor Karaszi" wrote:

> I agree with your assessment. Can you do the printing from the client app
(which I assume is running
> on the client machine already)?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "sansaw80" <sansaw80@.discussions.microsoft.com> wrote in message
> news:E7FB20CE-CDA7-4334-BA6F-AEAEDA694852@.microsoft.com...
>
>

Client side printing

Hi
I am trying to print Query Result directly to the printer from Client
machine. I managed to do this on Server machine. Where I had written SP which
accepts SQL as parameter and using osql and xp_cmdShell command I am
outputting CSV file to printer. I want to do same from client machine but I
want print out should get printed on client printer not on Server.
Any ideas or suggestions?
Many thanks in advance.
Regards,
Santosh
xp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done on
the server machine, but the destination is specified as the client?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Santosh" <Santosh@.discussions.microsoft.com> wrote in message
news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
> Hi
> I am trying to print Query Result directly to the printer from Client
> machine. I managed to do this on Server machine. Where I had written SP which
> accepts SQL as parameter and using osql and xp_cmdShell command I am
> outputting CSV file to printer. I want to do same from client machine but I
> want print out should get printed on client printer not on Server.
> Any ideas or suggestions?
> Many thanks in advance.
> Regards,
> Santosh
>
|||Thanks Tibor, yes what you are suggesting, makes sense.
But I feel it will be better if I drop this idea and look for some different
option. Because if we want to specify UNC naming for printer. I need to make
printer as shared and need to give permissions so it can be accessible from
server by other users. Since printers are getting cheaper and cheaper, almost
everyone at client-side got there own printers, so I doubt if client admin
will accept this solution.
"Tibor Karaszi" wrote:

> xp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
> the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done on
> the server machine, but the destination is specified as the client?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Santosh" <Santosh@.discussions.microsoft.com> wrote in message
> news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
>
>
|||I agree with your assessment. Can you do the printing from the client app (which I assume is running
on the client machine already)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"sansaw80" <sansaw80@.discussions.microsoft.com> wrote in message
news:E7FB20CE-CDA7-4334-BA6F-AEAEDA694852@.microsoft.com...[vbcol=seagreen]
> Thanks Tibor, yes what you are suggesting, makes sense.
> But I feel it will be better if I drop this idea and look for some different
> option. Because if we want to specify UNC naming for printer. I need to make
> printer as shared and need to give permissions so it can be accessible from
> server by other users. Since printers are getting cheaper and cheaper, almost
> everyone at client-side got there own printers, so I doubt if client admin
> will accept this solution.
>
>
> "Tibor Karaszi" wrote:
|||Yup I can Print Crystal reports on local client printer through client app.
Now I have written small code in Vb.net which accepts SQL from client PC and
prints result in CSV format on local client printer.
"Tibor Karaszi" wrote:

> I agree with your assessment. Can you do the printing from the client app (which I assume is running
> on the client machine already)?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "sansaw80" <sansaw80@.discussions.microsoft.com> wrote in message
> news:E7FB20CE-CDA7-4334-BA6F-AEAEDA694852@.microsoft.com...
>
>

Client side printing

Hi
I am trying to print Query Result directly to the printer from Client
machine. I managed to do this on Server machine. Where I had written SP which
accepts SQL as parameter and using osql and xp_cmdShell command I am
outputting CSV file to printer. I want to do same from client machine but I
want print out should get printed on client printer not on Server.
Any ideas or suggestions'
Many thanks in advance.
Regards,
Santoshxp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done on
the server machine, but the destination is specified as the client?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Santosh" <Santosh@.discussions.microsoft.com> wrote in message
news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
> Hi
> I am trying to print Query Result directly to the printer from Client
> machine. I managed to do this on Server machine. Where I had written SP which
> accepts SQL as parameter and using osql and xp_cmdShell command I am
> outputting CSV file to printer. I want to do same from client machine but I
> want print out should get printed on client printer not on Server.
> Any ideas or suggestions'
> Many thanks in advance.
> Regards,
> Santosh
>|||Thanks Tibor, yes what you are suggesting, makes sense.
But I feel it will be better if I drop this idea and look for some different
option. Because if we want to specify UNC naming for printer. I need to make
printer as shared and need to give permissions so it can be accessible from
server by other users. Since printers are getting cheaper and cheaper, almost
everyone at client-side got there own printers, so I doubt if client admin
will accept this solution.
"Tibor Karaszi" wrote:
> xp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
> the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done on
> the server machine, but the destination is specified as the client?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Santosh" <Santosh@.discussions.microsoft.com> wrote in message
> news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
> > Hi
> >
> > I am trying to print Query Result directly to the printer from Client
> > machine. I managed to do this on Server machine. Where I had written SP which
> > accepts SQL as parameter and using osql and xp_cmdShell command I am
> > outputting CSV file to printer. I want to do same from client machine but I
> > want print out should get printed on client printer not on Server.
> >
> > Any ideas or suggestions'
> >
> > Many thanks in advance.
> >
> > Regards,
> > Santosh
> >
>
>|||I agree with your assessment. Can you do the printing from the client app (which I assume is running
on the client machine already)?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"sansaw80" <sansaw80@.discussions.microsoft.com> wrote in message
news:E7FB20CE-CDA7-4334-BA6F-AEAEDA694852@.microsoft.com...
> Thanks Tibor, yes what you are suggesting, makes sense.
> But I feel it will be better if I drop this idea and look for some different
> option. Because if we want to specify UNC naming for printer. I need to make
> printer as shared and need to give permissions so it can be accessible from
> server by other users. Since printers are getting cheaper and cheaper, almost
> everyone at client-side got there own printers, so I doubt if client admin
> will accept this solution.
>
>
> "Tibor Karaszi" wrote:
>> xp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
>> the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done
>> on
>> the server machine, but the destination is specified as the client?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Santosh" <Santosh@.discussions.microsoft.com> wrote in message
>> news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
>> > Hi
>> >
>> > I am trying to print Query Result directly to the printer from Client
>> > machine. I managed to do this on Server machine. Where I had written SP which
>> > accepts SQL as parameter and using osql and xp_cmdShell command I am
>> > outputting CSV file to printer. I want to do same from client machine but I
>> > want print out should get printed on client printer not on Server.
>> >
>> > Any ideas or suggestions'
>> >
>> > Many thanks in advance.
>> >
>> > Regards,
>> > Santosh
>> >
>>|||Yup I can Print Crystal reports on local client printer through client app.
Now I have written small code in Vb.net which accepts SQL from client PC and
prints result in CSV format on local client printer.
"Tibor Karaszi" wrote:
> I agree with your assessment. Can you do the printing from the client app (which I assume is running
> on the client machine already)?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "sansaw80" <sansaw80@.discussions.microsoft.com> wrote in message
> news:E7FB20CE-CDA7-4334-BA6F-AEAEDA694852@.microsoft.com...
> > Thanks Tibor, yes what you are suggesting, makes sense.
> >
> > But I feel it will be better if I drop this idea and look for some different
> > option. Because if we want to specify UNC naming for printer. I need to make
> > printer as shared and need to give permissions so it can be accessible from
> > server by other users. Since printers are getting cheaper and cheaper, almost
> > everyone at client-side got there own printers, so I doubt if client admin
> > will accept this solution.
> >
> >
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> xp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
> >> the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done
> >> on
> >> the server machine, but the destination is specified as the client?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> http://www.sqlug.se/
> >>
> >>
> >> "Santosh" <Santosh@.discussions.microsoft.com> wrote in message
> >> news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
> >> > Hi
> >> >
> >> > I am trying to print Query Result directly to the printer from Client
> >> > machine. I managed to do this on Server machine. Where I had written SP which
> >> > accepts SQL as parameter and using osql and xp_cmdShell command I am
> >> > outputting CSV file to printer. I want to do same from client machine but I
> >> > want print out should get printed on client printer not on Server.
> >> >
> >> > Any ideas or suggestions'
> >> >
> >> > Many thanks in advance.
> >> >
> >> > Regards,
> >> > Santosh
> >> >
> >>
> >>
> >>
>
>

Client Machine accesing sqlexpress

This may a silly question but....

I wrote a vb 2005 application that access sqlexpress for data using sqlconnection (.NET). The program works fine. When I run debug on my code that is in my laptop, it access my xp server box with sqlexpress running and I see all my data in my application. My question is..When I compile this program and install it on a client machine that has no sqlexpress tools, no SQLCMD etc....will the application run and access the xp server box, or do I have to install something on the client machine.

thanks

hi,

your "remote client pc" does only need your app and the .Net Framework, which installs all the required libraries to connect to local and remote SQLServer instances..

regards

Client installation of sql server

Hi,
I have both client and server of 2000 version sql server installed on my xp
machine. However, I need to install 2005 sql server client software on the
same machine. After I install this, I cannot see the program. Do I have to
unstall 2000 client software to work on 2005 client software. I would
appreciate any help on this matter.
Thanks in advanceThanks for your help Sailesh. I appreciate it.
"Shailesh Khanal" wrote:
> No, you can use both clients side by side. Check the log file in setup
> bootstarp folder to see if the installation was successful.
> "Jack" wrote:
> > Hi,
> > I have both client and server of 2000 version sql server installed on my xp
> > machine. However, I need to install 2005 sql server client software on the
> > same machine. After I install this, I cannot see the program. Do I have to
> > unstall 2000 client software to work on 2005 client software. I would
> > appreciate any help on this matter.
> > Thanks in advance|||> I have both client and server of 2000 version sql server installed on my xp
> machine. However, I need to install 2005 sql server client software on the
> same machine. After I install this, I cannot see the program.
What "program" is it that you don't see? SQL Server management studio? If so, perhaps you didn't
select to install the workstation components when you installed 2005?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:5A0F5715-35F7-437B-8E5B-3C920DB09FA1@.microsoft.com...
> Hi,
> I have both client and server of 2000 version sql server installed on my xp
> machine. However, I need to install 2005 sql server client software on the
> same machine. After I install this, I cannot see the program. Do I have to
> unstall 2000 client software to work on 2005 client software. I would
> appreciate any help on this matter.
> Thanks in advance|||No, you can use both clients side by side. Check the log file in setup
bootstarp folder to see if the installation was successful.
"Jack" wrote:
> Hi,
> I have both client and server of 2000 version sql server installed on my xp
> machine. However, I need to install 2005 sql server client software on the
> same machine. After I install this, I cannot see the program. Do I have to
> unstall 2000 client software to work on 2005 client software. I would
> appreciate any help on this matter.
> Thanks in advance

Client cant connect to server

We have installed a SQL 2000 server on a windows xp-pro machine and succesfully installed DotNetNuke. Now is the problem that there is no way we can manage to get a client connected. We have tried everything, changing tcp port, setting permissions, changing registry according to document 307197 in the microsoft database and nothing helps.
The only thing we can see is that in the serverlog we get a message stating that "SuperSocket Info : Bind failed on TCP port 1433". Can anyone help?
Regards Ulla & TomI assume you mean MSDE since SQL Server itself won't run on XP Pro. Have you looked at these yet:
http://support.microsoft.com/kb/293107/EN-US/
http://support.microsoft.com/kb/312935/
Have you checked to see if anything else is listening on port 1433? Have you tried using SQL on another port?
Jeff|||first thanx for yor reply - but no - I do mean Microsoft SQL Server 2000 Enterprise (evaluation version) - and it does run on an XP pro SP2 machine...
I am able to connect to the server locally by eg running my DotNetNuke portal and access it via http, but I cant access the portal from other computers in my home network.
I did have a look at the docs you mention. Regarding doc 293107 I have shot down all other software running on the server and it dosnt help. I checked the TCP ports with TCPVIEW and found nothing utilizing port 1433. I also changed the default TCP port for the server.
Regarding doc 312935: this does not refer to the same error message that I receive, however in lack of other good ideas I will try to get hold of the file from MS containing the fix fo that problem....
I hope you have other good ideas to fix my problem......|||

ujep wrote:

I do mean Microsoft SQL Server 2000 Enterprise(evaluation version) - and it does run on an XP pro SP2machine...

Are you 100% certain about that? Do you have a reference? Anything I have ever seen (e.g.Choosing an Edition of SQL Server 2000 andA Comparison of SQL Server 2000 with Access 2000) indicates that Windows XP can only run these versions of SQL Server 2000: Personal, Developer, and Desktop.
|||I downloaded the server from MS herehttp://www.microsoft.com/downloads/details.aspx?FamilyID=d20ba6e1-f44c-4781-a6bb-f60e02dc1335&DisplayLang=en , the documentation states that it can run on XP...
the welcome picture in setup states that this is a Windows 2000 server Enterprise edition....
I still havent found a fix for the problem, hope someone can help|||

ujep wrote:

I am able to connect to the server locally by eg running my DotNetNuke portal and access it via http, but I cant access the portal from other computers in my home network.

Most likely a firewall or security policy issue then. Though I wouldn't think you'd get the SQL port error, since DNN doesn't need to cross the network to reach a local SQL server and the clinet systems don't access SQL directly. Try a simple Hello World HTMP and ASPX page from the clients.
Jeff|||I am able to open html and aspx pages from the cliens - the only thing I can't do is open DNN - so if the problem is a security policy issue then it should then be within the server (or DNN) -|||

Yeah, but DNN works on the server itself, so it isn't a DNN or server problem either. When you opne DNN on the server, can you use the FQDN name justa s you would on the client, or are you just able to use "localhost"?

Jeff