Connection String

I have SQL Server 2000 installed on my XP Pro PC and the Client Tools (SQL
Query Analyzer) installed on my 98SE PC. On the 98SE PC, when I start SQL
Query Analyzer, I get a window titled "Connect to SQL Server" but the SQL
Server line is blank and the drop-down arrow is also blank. How do I get the
SQL Server 2000 to show up here? Thanks in advance for any help on this. I
built the 98SE machine especially to access the database files that are on
the SQL Server 2000 but, so far, I have been unable to connect to the
server. Jim.The drop down shows what servers you have connected to not
necessarily what servers are available. Type the server name
in and try connecting.
-Sue
On Sun, 12 Jun 2005 14:15:42 GMT, "Jim Richards"
<JWRichards@.satx.rr.com> wrote:

>I have SQL Server 2000 installed on my XP Pro PC and the Client Tools (SQL
>Query Analyzer) installed on my 98SE PC. On the 98SE PC, when I start SQL
>Query Analyzer, I get a window titled "Connect to SQL Server" but the SQL
>Server line is blank and the drop-down arrow is also blank. How do I get th
e
>SQL Server 2000 to show up here? Thanks in advance for any help on this. I
>built the 98SE machine especially to access the database files that are on
>the SQL Server 2000 but, so far, I have been unable to connect to the
>server. Jim.
>|||Thank you Sue. You said: "Type the server name in and try connecting." The
name of the computer on which the Server resides is "JIMRIC" and is accessed
over a LAN. The name of the Server is "local". Do I type in:
\\JIMRIC\(local) , if not, what do I type in Please.
BTW, I also have the SQL Query Analyzer on the XP Pro PC and I have no
trouble connecting to the server there. The server is entered here as
(local). Jim.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:8msqa1loi5kortnt885spitum19pof9rdj@.
4ax.com...
> The drop down shows what servers you have connected to not
> necessarily what servers are available. Type the server name
> in and try connecting.
> -Sue
> On Sun, 12 Jun 2005 14:15:42 GMT, "Jim Richards"
> <JWRichards@.satx.rr.com> wrote:
>
>|||When it's on the box where you are running the tools, you
can use (local) for the default instance. From other
computers, you need to specify the server name and from the
local server you can specify the server name.
ServerName\OtherName is used for connecting to named
instances.
If you are using (local) from another PC, it's not
connecting to another server in the network. It's connecting
to a SQL Server (or MSDE) instance on that PC.
-Sue
On Mon, 13 Jun 2005 15:26:58 GMT, "Jim Richards"
<JWRichards@.satx.rr.com> wrote:

>Thank you Sue. You said: "Type the server name in and try connecting." The
>name of the computer on which the Server resides is "JIMRIC" and is accesse
d
>over a LAN. The name of the Server is "local". Do I type in:
>\\JIMRIC\(local) , if not, what do I type in Please.
>BTW, I also have the SQL Query Analyzer on the XP Pro PC and I have no
>trouble connecting to the server there. The server is entered here as
>(local). Jim.
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:8msqa1loi5kortnt885spitum19pof9rdj@.
4ax.com...
>|||Thank you Sue and I will show my ignorance and ask then how do I know what
name to type in? TIA, Jim.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:1fgsa1db7tqfqdddqfs1d01510ggrn9m9i@.
4ax.com...
> When it's on the box where you are running the tools, you
> can use (local) for the default instance. From other
> computers, you need to specify the server name and from the
> local server you can specify the server name.
> ServerName\OtherName is used for connecting to named
> instances.
> If you are using (local) from another PC, it's not
> connecting to another server in the network. It's connecting
> to a SQL Server (or MSDE) instance on that PC.
> -Sue
> On Mon, 13 Jun 2005 15:26:58 GMT, "Jim Richards"
> <JWRichards@.satx.rr.com> wrote:
>
>