configuring sql 6.5

**** Post for FREE via your newsreader at post.mcse.ms ****
Hi,
I can't see SQL 6.5 server installed on other computer. I am trying to
connect to it using SQL 2000, ODBC, ADO and none of this is helping. I
haven't experienced the same problems with SQL2000 installation. I have
installed it and all went ok. I do not change anyu network setting on this
computer and install SQL 6.5 and then i can't see this server. Maybe there
is some quick guide how to set SQL 6.5 as it seems to me that default
configuration do not work.
darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=Darius wrote:

> I can't see SQL 6.5 server installed on other computer. I am trying to
> connect to it using SQL 2000, ODBC, ADO and none of this is helping. I
> haven't experienced the same problems with SQL2000 installation. I
> have installed it and all went ok. I do not change anyu network
> setting on this computer and install SQL 6.5 and then i can't see
> this server. Maybe there is some quick guide how to set SQL 6.5 as it
> seems to me that default configuration do not work.
Tibor already answered the EM question in your previous thread (please do
not create new threads if it is not needed). 7.0 or 2000 EM cannot work
against 6.5 or earlier. You need EM 6.5 for that.
Please post the connection string for ODBC/ADO approach.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||**** Post for FREE via your newsreader at post.mcse.ms ****

> Tibor already answered the EM question in your previous thread (please do
> not create new threads if it is not needed). 7.0 or 2000 EM cannot work
> against 6.5 or earlier. You need EM 6.5 for that.
I know. I have asked one more question in last thread but I didnt get any
answers, so I created new thred. I've asked what do you mean EM 6.5? do you
mean new SQL 6.5 installation or only enterprise manager 6.5?
darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||Darius wrote:
> I know. I have asked one more question in last thread but I didnt get
> any answers, so I created new thred. I've asked what do you mean EM
> 6.5? do you mean new SQL 6.5 installation or only enterprise manager
> 6.5?
Tibor answered that:
If you want to administer a 6.5 machine from another machine, you only need
to do a client install on that machine.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||**** Post for FREE via your newsreader at post.mcse.ms ****
Hello,

> If you want to administer a 6.5 machine from another machine, you only
need
> to do a client install on that machine.
I still have some problems and I will be very thankful for any help. I can't
see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
problem is. Intergrated WinNT security setting is ok. Please help.
Darius
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.mcse.ms
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||On Fri, 5 Mar 2004 08:54:34 +0100, "Darius" wrote:

>I still have some problems and I will be very thankful for any help. I can'
t
>see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
>problem is. Intergrated WinNT security setting is ok. Please help.
G'day Darius,
How can't you see them? Or put another way, with what can't you see
them?
Can you ping the server that SQL 6.5 is on?
Can you connect to that server with SQL Query Analyser?
Can you create an ODBC DSN for this server and test it successfully?
cheers,
Ross.
--
"It's not the right time to be sober,
Now that the idiots have taken over" - NOFX|||In Integrated Security, a 6.5 server can only listen to Named Pipes. And on
MDAC 2.6 and later, a client that work against a pre-2000 server will only
connect using the top most protocol in Client Network Utility, which is IP
by default. On the client, using Client Network Utility: Either move IP to
the top or create an alias for the 6.5 server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Darius" <darius.ram@.takas.lt> wrote in message
news:404823e8@.post.mcse.ms...
> **** Post for FREE via your newsreader at post.mcse.ms ****
> Hello,
>
> need
> I still have some problems and I will be very thankful for any help. I
can't
> see my SQL 6.5 servers from any computer. I'm stuck I don't know where the
> problem is. Intergrated WinNT security setting is ok. Please help.
> Darius
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** mcse.ms - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.mcse.ms
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=