> Hello. I have recently installed a second PC and it is connected via a
> LAN. I have SQL Server 2000 installed on my main PC but I wanted to access
> the SQL databases in the server from the other PC. Main PC running XP Pro,
> other PC running 98SE. I have installed the client tools on the 98SE but
> am unable to connect to the Server on the XP machine. Is there
> instructions somewhere on how to set up the client on a second machine?
> TIA, Jim.
>

> Please provide service pack level and error description oder message here.
>
> Or look here, if the artiles can help ou with your problem.
>
> http://support.microsoft.com/kb/841249/en-us
>
> Jens Suessmeyer.
>
>
> "Jim Richards" <JWRichards@satx.rr.com> schrieb im Newsbeitrag
> news:hXsce.32280$h6.9052@tornado.texas.rr.com...
>> Hello. I have recently installed a second PC and it is connected via a
>> LAN. I have SQL Server 2000 installed on my main PC but I wanted to
>> access the SQL databases in the server from the other PC. Main PC running
>> XP Pro, other PC running 98SE. I have installed the client tools on the
>> 98SE but am unable to connect to the Server on the XP machine. Is there
>> instructions somewhere on how to set up the client on a second machine?
>> TIA, Jim.
>>
>
>

> Thank you Jens, but the link that you furnished is how to set up the SQL
> Server on XP. I need to set up the client on 98SE. Can you help on this?
> TIA, Jim
>
> "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote
> in message news:uWFZj1OTFHA.3056@TK2MSFTNGP14.phx.gbl...
>> Please provide service pack level and error description oder message
>> here.
>>
>> Or look here, if the artiles can help ou with your problem.
>>
>> http://support.microsoft.com/kb/841249/en-us
>>
>> Jens Suessmeyer.
>>
>>
>> "Jim Richards" <JWRichards@satx.rr.com> schrieb im Newsbeitrag
>> news:hXsce.32280$h6.9052@tornado.texas.rr.com...
>>> Hello. I have recently installed a second PC and it is connected via a
>>> LAN. I have SQL Server 2000 installed on my main PC but I wanted to
>>> access the SQL databases in the server from the other PC. Main PC
>>> running XP Pro, other PC running 98SE. I have installed the client tools
>>> on the 98SE but am unable to connect to the Server on the XP machine. Is
>>> there instructions somewhere on how to set up the client on a second
>>> machine? TIA, Jim.
>>>
>>
>>
>
>

> Ok, got it, but you have to provide some error message to help you.
>
>
> "Jim Richards" <JWRichards@satx.rr.com> schrieb im Newsbeitrag
> news:oCvce.30571$AE6.5739@tornado.texas.rr.com...
>> Thank you Jens, but the link that you furnished is how to set up the SQL
>> Server on XP. I need to set up the client on 98SE. Can you help on this?
>> TIA, Jim
>>
>> "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote
>> in message news:uWFZj1OTFHA.3056@TK2MSFTNGP14.phx.gbl...
>>> Please provide service pack level and error description oder message
>>> here.
>>>
>>> Or look here, if the artiles can help ou with your problem.
>>>
>>> http://support.microsoft.com/kb/841249/en-us
>>>
>>> Jens Suessmeyer.
>>>
>>>
>>> "Jim Richards" <JWRichards@satx.rr.com> schrieb im Newsbeitrag
>>> news:hXsce.32280$h6.9052@tornado.texas.rr.com...
>>>> Hello. I have recently installed a second PC and it is connected via a
>>>> LAN. I have SQL Server 2000 installed on my main PC but I wanted to
>>>> access the SQL databases in the server from the other PC. Main PC
>>>> running XP Pro, other PC running 98SE. I have installed the client
>>>> tools on the 98SE but am unable to connect to the Server on the XP
>>>> machine. Is there instructions somewhere on how to set up the client on
>>>> a second machine? TIA, Jim.
>>>>
>>>
>>>
>>
>>
>
>

> Ok, i think you messed up something, you have to procide the name of the
> sqlserver not the UNC Path to it.
> So try to set up the connection to
>
> Server: JIMRIC
> Username: sa
> Password: *******
>
>
> If you installed a named instances this should be
> Server: JIMRIC\NameoftheInstance
> Username: sa
> Password: *******
>
> If you are not sure if you can conenct from the client to the server you
> can run the command line util which makes a broadcast in the network to
> determine the active SQL Servers. it is --> OSQL -L (works well if you
> di´dn´t hide the servers)
>
> SQL Authentication won´t work if you didn´t set up mixed mode
> authentication on Sql Server.
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp
>
>
> If you have further questions, don´t hesitate asking. As i don´t know how
> long i will monitor this post, you can also write me an EMail, i will post
> the answers right to the group then.
>
>
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>
>
>
>
>
>
>
>
> "Jim Richards" <JWRichards@satx.rr.com> schrieb im Newsbeitrag
> news:DmLce.34492$h6.4863@tornado.texas.rr.com...
>> Jens, in the Client machine, in the window "Connect to SQL Server", I use
>> SQL Server authentication with Login name: sa and the Password: *******.
>> When I click OK, I get this error message: Unable to connect to
>> \\JIMRIC\SQL Server
>> Server Mssg 17, Level 16, State 1
>> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
>> access denied. Since I am the Administrator on both of my machines, I
>> believe it is the [ODBC SQL Server Driver] that is the cause of my
>> failure to connect to the server but I do not know how to correct it. Can
>> you tell me, please? I have not done this before so I need instructions
>> for an idiot (step by step). \\JIMRIC\ is the name of the computer that
>> has the SQL Server 2000 installed on it. TIA, Jim.
>> "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote
>> in message news:OyA6KVPTFHA.2676@TK2MSFTNGP10.phx.gbl...
>>> Ok, got it, but you have to provide some error message to help you.
>>>
>>>
>>> "Jim Richards" <JWRichards@satx.rr.com> schrieb im Newsbeitrag
>>> news:oCvce.30571$AE6.5739@tornado.texas.rr.com...
>>>> Thank you Jens, but the link that you furnished is how to set up the
>>>> SQL Server on XP. I need to set up the client on 98SE. Can you help on
>>>> this? TIA, Jim
>>>>
>>>> "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de>
>>>> wrote in message news:uWFZj1OTFHA.3056@TK2MSFTNGP14.phx.gbl...
>>>>> Please provide service pack level and error description oder message
>>>>> here.
>>>>>
>>>>> Or look here, if the artiles can help ou with your problem.
>>>>>
>>>>> http://support.microsoft.com/kb/841249/en-us
>>>>>
>>>>> Jens Suessmeyer.
>>>>>
>>>>>
>>>>> "Jim Richards" <JWRichards@satx.rr.com> schrieb im Newsbeitrag
>>>>> news:hXsce.32280$h6.9052@tornado.texas.rr.com...
>>>>>> Hello. I have recently installed a second PC and it is connected via
>>>>>> a LAN. I have SQL Server 2000 installed on my main PC but I wanted to
>>>>>> access the SQL databases in the server from the other PC. Main PC
>>>>>> running XP Pro, other PC running 98SE. I have installed the client
>>>>>> tools on the 98SE but am unable to connect to the Server on the XP
>>>>>> machine. Is there instructions somewhere on how to set up the client
>>>>>> on a second machine? TIA, Jim.
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

> Please turn off temporary the firewall to see if it is a problem of closed
> ports, but do not only deactivate it, stop the servive to be sure that its
> not running.
>
> Did you really checked out that articles for help :
>
> 841252 How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL
> Server 2000
>
> 839980 How to use a script to programmatically open ports for SQL Server
> to use on systems that are running Windows XP Service Pack 2
>
> 839269 You may not be able to connect to an instance of SQL Server that is
> configured to use the Named Pipes server network library on a computer
> that is running Windows XP Service Pack 2
>
> Check in the server network utility if TCP/IP is enabled and the server is
> not hided, open up the appropiate ports on the XP Workstation (could be
> blocked to the network) and try again. If you are not sure of this is a
> Windows 98SE problem (guess it isn´t) try connected with a third
> workstation (if you have one) to the server to see wehter it is a problem
> with closed ports from the firewall.
>
>
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>

> Jens, in the Client machine, in the window "Connect to SQL Server", I use
> SQL Server authentication with Login name: sa and the Password: *******.
> When I click OK, I get this error message: Unable to connect to
> \\JIMRIC\SQL Server
> Server Mssg 17, Level 16, State 1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access denied. Since I am the Administrator on both of my machines, I
> believe it is the [ODBC SQL Server Driver] that is the cause of my failure
> to connect to the server but I do not know how to correct it. Can you tell
> me, please? I have not done this before so I need instructions for an
> idiot (step by step). \\JIMRIC\ is the name of the computer that has the
> SQL Server 2000 installed on it. TIA, Jim.
> "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote
> in message news:OyA6KVPTFHA.2676@TK2MSFTNGP10.phx.gbl...
>> Ok, got it, but you have to provide some error message to help you.
>>
>>
>> "Jim Richards" <JWRichards@satx.rr.com> schrieb im Newsbeitrag
>> news:oCvce.30571$AE6.5739@tornado.texas.rr.com...
>>> Thank you Jens, but the link that you furnished is how to set up the SQL
>>> Server on XP. I need to set up the client on 98SE. Can you help on this?
>>> TIA, Jim
>>>
>>> "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> wrote
>>> in message news:uWFZj1OTFHA.3056@TK2MSFTNGP14.phx.gbl...
>>>> Please provide service pack level and error description oder message
>>>> here.
>>>>
>>>> Or look here, if the artiles can help ou with your problem.
>>>>
>>>> http://support.microsoft.com/kb/841249/en-us
>>>>
>>>> Jens Suessmeyer.
>>>>
>>>>
>>>> "Jim Richards" <JWRichards@satx.rr.com> schrieb im Newsbeitrag
>>>> news:hXsce.32280$h6.9052@tornado.texas.rr.com...
>>>>> Hello. I have recently installed a second PC and it is connected via a
>>>>> LAN. I have SQL Server 2000 installed on my main PC but I wanted to
>>>>> access the SQL databases in the server from the other PC. Main PC
>>>>> running XP Pro, other PC running 98SE. I have installed the client
>>>>> tools on the 98SE but am unable to connect to the Server on the XP
>>>>> machine. Is there instructions somewhere on how to set up the client
>>>>> on a second machine? TIA, Jim.
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

> Please turn off temporary the firewall to see if it is a problem of closed
> ports, but do not only deactivate it, stop the servive to be sure that its
> not running.
>
> Did you really checked out that articles for help :
>
> 841252 How to manually enable TCP/IP on Windows XP Service Pack 2 for SQL
> Server 2000
>
> 839980 How to use a script to programmatically open ports for SQL Server
> to use on systems that are running Windows XP Service Pack 2
>
> 839269 You may not be able to connect to an instance of SQL Server that is
> configured to use the Named Pipes server network library on a computer
> that is running Windows XP Service Pack 2
>
> Check in the server network utility if TCP/IP is enabled and the server is
> not hided, open up the appropiate ports on the XP Workstation (could be
> blocked to the network) and try again. If you are not sure of this is a
> Windows 98SE problem (guess it isn´t) try connected with a third
> workstation (if you have one) to the server to see wehter it is a problem
> with closed ports from the firewall.
>
>
> HTH, Jens Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>