Re: SQL Server 2000 Client

Thanks again Jens, for your help.
I did not install a named instance, just the default.
OSQL -L from the 98SE PC gets me "None".
OSQL -L from the XP Pro PC gets me "Server: (local)"
I have set up mixed mode authentication on the XP Pro PC.
I have the Client Services set up on the XP Pro PC because I did not have
the second 98SE PC until just recently. When I start the "SQL Query
Analyzer" from the XP Pro PC, I have no trouble connecting to the SQL Server
using sa and password *******.
I didn't find any help on the link that you furnished. Jim.

"Jens Süßmeyer" <Jens@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:%231LXKaYTFHA.1404@xxxxxxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxx> schrieb im Newsbeitrag
> news:DmLce.34492$h6.4863@xxxxxxxxxxxxxxxxxxxxxxx
>> 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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote
>> in message news:OyA6KVPTFHA.2676@xxxxxxxxxxxxxxxxxxxxxxx
>>> Ok, got it, but you have to provide some error message to help you.
>>>
>>>
>>> "Jim Richards" <JWRichards@xxxxxxxxxxx> schrieb im Newsbeitrag
>>> news:oCvce.30571$AE6.5739@xxxxxxxxxxxxxxxxxxxxxxx
>>>> 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@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
>>>> wrote in message news:uWFZj1OTFHA.3056@xxxxxxxxxxxxxxxxxxxxxxx
>>>>> 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@xxxxxxxxxxx> schrieb im Newsbeitrag
>>>>> news:hXsce.32280$h6.9052@xxxxxxxxxxxxxxxxxxxxxxx
>>>>>> 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.
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Login failed for user (null).
    ... authenticated connection with SQL server. ... Whether or not the remote service accepts the authentication from client ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Enterprise Manager Server Registration General Network Error
    ... I can ping the server by name from the affected client. ... I can register the server by name using SQL Authentication (rules out name ... Verify that the instance of SQL Server is listening Correctly ... I use Active Directory Account on Windows 2000 machine. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot open remote connection to Dql Server
    ... be guest logging in under windows authentication. ... The user is not associated with a trusted SQL Server ... Services And Connections. ...
    (microsoft.public.sqlserver.setup)
  • Re: ASP.NET + SQL Server Windows authentication
    ... Windows Integrated Security with IIS, ASP.NET, SQL Server across multiple ... | is a way around it other than using SSL and Basic Authentication. ...
    (microsoft.public.dotnet.framework.aspnet.security)