I am trying to add a printer on a local machine to our SQL server.
The SQL server is not on the domain so I am having some problems.
Here is what I've done so far.

1. Added a HP 1200 Laserjet locally to a Win 2000 machine. Shared
the printer on the network to add it to other PCs on the domain.

2. Tried adding the printer to the SQL server running Win 2000 server
edition. Tried adding a printer method but it did not work obviously
since it is not on the domain so I went to Network Neighborhood and
connected to that PC and connected to shared printer which added it to
the installed printers but I was unable to print or manage the printer
(ie print test page).

3. Tried adding the user account from the SQL server to the security
access on the Win 2000 machine to no luck.

I am pretty sure what I am trying to do can be done I am just not sure
of how to specifically. Can someone please help me out?

It sounds like you were on the right path with adding a matching user
account and password on the Print server as you use on the SQL server. After
you added that account, did you verify that account has permissions to
printer?

Are you just trying to print while logged into the console of the SQL box or
are you trying to get SQL to print to the printer?

Denny


"Brett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am trying to add a printer on a local machine to our SQL server.
> The SQL server is not on the domain so I am having some problems.
> Here is what I've done so far.
>
> 1. Added a HP 1200 Laserjet locally to a Win 2000 machine. Shared
> the printer on the network to add it to other PCs on the domain.
>
> 2. Tried adding the printer to the SQL server running Win 2000 server
> edition. Tried adding a printer method but it did not work obviously
> since it is not on the domain so I went to Network Neighborhood and
> connected to that PC and connected to shared printer which added it to
> the installed printers but I was unable to print or manage the printer
> (ie print test page).
>
> 3. Tried adding the user account from the SQL server to the security
> access on the Win 2000 machine to no luck.
>
> I am pretty sure what I am trying to do can be done I am just not sure
> of how to specifically. Can someone please help me out?
>

Enable guest account on the non domain joined machine.

--
Alan Morris
Windows Printing Team
Search the Microsoft Knowledge Base here:
http://support.microsoft.com/default.aspx?scid=fh;[ln];kbhowto

This posting is provided "AS IS" with no warranties, and confers no rights.

"jokes54321" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> It sounds like you were on the right path with adding a matching user
> account and password on the Print server as you use on the SQL server.
> After you added that account, did you verify that account has permissions
> to printer?
>
> Are you just trying to print while logged into the console of the SQL box
> or are you trying to get SQL to print to the printer?
>
> Denny
>
>
> "Brett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I am trying to add a printer on a local machine to our SQL server.
>> The SQL server is not on the domain so I am having some problems.
>> Here is what I've done so far.
>>
>> 1. Added a HP 1200 Laserjet locally to a Win 2000 machine. Shared
>> the printer on the network to add it to other PCs on the domain.
>>
>> 2. Tried adding the printer to the SQL server running Win 2000 server
>> edition. Tried adding a printer method but it did not work obviously
>> since it is not on the domain so I went to Network Neighborhood and
>> connected to that PC and connected to shared printer which added it to
>> the installed printers but I was unable to print or manage the printer
>> (ie print test page).
>>
>> 3. Tried adding the user account from the SQL server to the security
>> access on the Win 2000 machine to no luck.
>>
>> I am pretty sure what I am trying to do can be done I am just not sure
>> of how to specifically. Can someone please help me out?
>>
>
>