Re: SQL Server 2000 Client

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

  • Security strategy: Access client/SQL Server
    ... I will be creating an application using MS Access as a client to SQL ... SQL Server resides. ... permissions for group X to open form A, users would need to get a new ...
    (comp.databases.ms-access)
  • RE: Failed upgrade to SCCM
    ... When you only see 2 actions, that generally means that the client cannot ... I recently started the upgrade our SMS 2003 SP3 Server to SCCM. ... SQL Server security mode and as we require the SQL server to be in SQL & ... however fails at "Install SMS provider components". ...
    (microsoft.public.sms.setup)
  • SQL and Bandwidth use
    ... Dell PowerEdge server, Dual Xeon 2.4GHz processors, 4 GB ... Run Query against database, in Great Plains Client ... bandwidth usage by ... Client PC is on same segment as SQL server (not passing ...
    (microsoft.public.sqlserver.connect)
  • RE: Monolith -> layered client/server?
    ... That way you can put as many logical layers (data access, business rules, ... whatever) on a server talking to your SQL Server... ... Client would require db connection info. Using a windows app on the ... > to a layered .NET SQL server version. ...
    (microsoft.public.dotnet.general)
  • Re: error setting up ODBC for remote sqlexpress database
    ... We were able to get it to work with the ODBC native client driver. ... Server could be stopped in the client. ... is to install Management Studio for SQL Server 2005 Express ...
    (microsoft.public.sqlserver.odbc)
Loading