Connect SQL with Active Directory

Hi everybody. I have this problem: I have to access to the Active Directory of a remote server from my computer using SQL and make searches based on the LDAP of the server. Someone told me to use Add Linked Server, but I don't know how to do it with the Active Directory. Thanks for the help.

Please take a look at the link below for the solution:

http://msdn2.microsoft.com/en-US/library/ms190803.aspx

Books Online topics on linked servers are also useful to know. Note that there are however restrictions on what you can do via distributed queries. For example, some of the collection data types in the Active Directory Schema are not supported in SQL Server, number of rows that you can retrieve is restricted by default & so on.

|||

Linking SQL Server to Active Directory is tricky. and Microsoft support/help isn't very intuitive for this.
Check a few things first...
1. two single quotes not double.
2. Make connection w/out security context.

Follow this syntax:
EXEC master.dbo.sp_addlinkedserver @.server = N'ADSI',
@.srvproduct=N'Active Directory Services', @.provider=N'ADsDSOObject',
@.datasrc=N'Servername.domain.com' --AKA the full computer name of the AD server

Then execute the openquery like this:

select * from openquery
(
ADSI,'SELECT name
FROM ''LDAP://Servername.domain.com''
WHERE objectCategory = ''Person'' AND objectClass = ''user''
')

I couldn't find anything on the Internet that would help me.

Connect SQL with Active Directory

Hi everybody. I have this problem: I have to access to the Active Directory of a remote server from my computer using SQL and make searches based on the LDAP of the server. Someone told me to use Add Linked Server, but I don't know how to do it with the Active Directory. Thanks for the help.

Please take a look at the link below for the solution:

http://msdn2.microsoft.com/en-US/library/ms190803.aspx

Books Online topics on linked servers are also useful to know. Note that there are however restrictions on what you can do via distributed queries. For example, some of the collection data types in the Active Directory Schema are not supported in SQL Server, number of rows that you can retrieve is restricted by default & so on.

|||

Linking SQL Server to Active Directory is tricky. and Microsoft support/help isn't very intuitive for this.
Check a few things first...
1. two single quotes not double.
2. Make connection w/out security context.

Follow this syntax:
EXEC master.dbo.sp_addlinkedserver @.server = N'ADSI',
@.srvproduct=N'Active Directory Services', @.provider=N'ADsDSOObject',
@.datasrc=N'Servername.domain.com' --AKA the full computer name of the AD server

Then execute the openquery like this:

select * from openquery
(
ADSI,'SELECT name
FROM ''LDAP://Servername.domain.com''
WHERE objectCategory = ''Person'' AND objectClass = ''user''
')

I couldn't find anything on the Internet that would help me.

Connect SQL Server Express 2005 on a remote Computer

Hello Everyone,

I just got a Virtual Dedicated Server and installed SQL Server Express 2005 on it and while I was installing choose Mix Mode authentication and setup a sa password.....

I want to connect to that database remotely from my machine using VS 2005 or Management Studio....both are encountering the same problems.....

On the Virtual Dedicated machine if I install management studio I run has no problem....it asks me for the server name : something\SQLEXPRESS then username and password and works fine...

The same thing I try to do remotely is not happy with ....I tried to give the IP address of the server same thing no luck.....

Can somebody tell me what I'm doing wrong and where....

Thanks,

Harsimrat

Solved...

Had to do some installations again...

Thanks,

harsimrat

Connect SQL Server 2005 through SQL-DMO

Hi,
I have installed in one computer a named instance of SQL Server 2005
Developer Edition. In that computer there is also a SQL Server 2000 instance
,
which is the default. For SQL Server 2005 I have allowed local and remote
connections through TCP/IP. The SQL Browser service is active too. During th
e
installation I also installed the backward compatibility tools. The operatin
g
system of the server is Windows 2000 Professional.
I am trying to execute an VB.NET app that uses SQL-DMO in order to create a
database and several logins and users in the SQL Server 2005 instance. When
I
execute it on the server, the app works perfectly, but the problems appear
when I try the same from another computer. The client computer is another
Windows 2000 Professional, but just with the SQL Server 2000 client tools
installed, no SQL Server 2005 client tools.
I think that there may be missing some extra steps to configure the server
in order to allow remote connections throug SQL-DMO.
Any suggestions would be greatly appreciated.
Jose Antonio.Hi, Jose
I think you need to install the backward compatibility components on
the client computer. You can download them from:
http://download.microsoft.com/downl...rver2005_BC.msi
Razvan|||I have just installed the components on the client machine and the app now
works perfectly.
Thank you very much for your advice, Razvan.
Jose Antonio.
"Razvan Socol" wrote:

> Hi, Jose
> I think you need to install the backward compatibility components on
> the client computer. You can download them from:
> http://download.microsoft.com/downl...rver2005_BC.msi
> Razvan
>

Connect SQL Server 2005 through SQL-DMO

Hi,
I have installed in one computer a named instance of SQL Server 2005
Developer Edition. In that computer there is also a SQL Server 2000 instance,
which is the default. For SQL Server 2005 I have allowed local and remote
connections through TCP/IP. The SQL Browser service is active too. During the
installation I also installed the backward compatibility tools. The operating
system of the server is Windows 2000 Professional.
I am trying to execute an VB.NET app that uses SQL-DMO in order to create a
database and several logins and users in the SQL Server 2005 instance. When I
execute it on the server, the app works perfectly, but the problems appear
when I try the same from another computer. The client computer is another
Windows 2000 Professional, but just with the SQL Server 2000 client tools
installed, no SQL Server 2005 client tools.
I think that there may be missing some extra steps to configure the server
in order to allow remote connections throug SQL-DMO.
Any suggestions would be greatly appreciated.
Jose Antonio.
Jose Antonio wrote:
> Hi,
> I have installed in one computer a named instance of SQL Server 2005
> Developer Edition. In that computer there is also a SQL Server 2000
> instance, which is the default. For SQL Server 2005 I have allowed
> local and remote connections through TCP/IP. The SQL Browser service
> is active too. During the installation I also installed the backward
> compatibility tools. The operating system of the server is Windows
> 2000 Professional.
> I am trying to execute an VB.NET app that uses SQL-DMO in order to
> create a database and several logins and users in the SQL Server 2005
> instance. When I execute it on the server, the app works perfectly,
> but the problems appear when I try the same from another computer.
> The client computer is another Windows 2000 Professional, but just
> with the SQL Server 2000 client tools installed, no SQL Server 2005
> client tools.
> I think that there may be missing some extra steps to configure the
> server in order to allow remote connections throug SQL-DMO.
> Any suggestions would be greatly appreciated.
> Jose Antonio.
I believe that SQL 2005 comes with DMO for backward compatibility only
and that in order to use DMO on a SQL 2005 serve, you are going to need
either the DMO distributable files from SQL 2005 or have the SQL 2005
client tools installed.
David Gugick
Quest Software
www.quest.com
|||Hi David,
Yes, installing the backward compatibility package on the client computer
solved the problem.
Thanks.
Jose Antonio.
"David Gugick" wrote:

> Jose Antonio wrote:
> I believe that SQL 2005 comes with DMO for backward compatibility only
> and that in order to use DMO on a SQL 2005 serve, you are going to need
> either the DMO distributable files from SQL 2005 or have the SQL 2005
> client tools installed.
> --
> David Gugick
> Quest Software
> www.quest.com
>

Confussions

I would like to know what a computer with these features mean. This computer has the following features:

Solaris
4GL OpenINGRES
HTML+Java over OpenINGRES

Because Im not a person that dominates the databases world these are my guesses to what I think it means (please correct me if Im wrong):

Its a computer that mantains a database.

I think that "Solaris" is the OS where the database is located. Solaris is also an UNIX OS. Is it true?.

I also think that "4GL OpenINGRES" means that their database is OpenINGRES (BTW, which is the company that have made OpenIngres?, Informix?) and that the language that they used to build the database was a 4GL (which I think is that is some kind of SQL language. Is it very different from the normal SQL?. Do you know what are the main differences between 4GL and SQL or do you know of any webpage that tells what are the commands or syntax for 4GL?.

Finally, I think that "HTML+Java over OpenINGRES" means that someone that wants to get any information from the database (OpenINGRES) from the internet uses a combination of HTML and Java code to access the database. For example if I was to access some data from the database I would have to login to a webpage where it asks me for a "username" and a "password". This webpages interacts with the database with HTML and Java. Is it true?.

And the last question. If someone was trying to enter to the database what should he do?:
SQL injection?. Im not sure if this will work if they have the 4GL, although I know that the 4GL is also some kind of SQL. Is it possible to do SQL injection with the features of the computer that I have told you. Or it will have to be a "4GL injection"?. I dont know if "4GL injection" exists but it is just to make me an idea of the possibilities for someone to use "SQL injection" on the database.

English is not my first language so maybe I havent explained me well. If you want me to give more explanataions just ask me for it. I really need to know it.

Thank you in advance.Seems like you have the bones of it there already, howver, 4GL is not a language as such it is known as Fourth Generation Language, MSAccess as example.
User friendly coding like Sql...

Confused about memory limits

Server is Windows 2000 SP4 Advanced Server with 4gb of RAM. "My Computer"
shows 3,669,532KB of RAM. SQL Server 2000 SP3.
I'm a bit confused as to if SQL server can use more memory or not.
In task manager, I see that sql server is using 1.7 gigs of memory (sounds
like 2gb to me).. which I'm reading is the maximum. Even though the server
properties have the minimum set at 0 and the maximum set at 38xxMB.
All the discussion says that setting "awe enabled" will allow SQL Server to
take advantage of memory on servers with more then 4gb of memory.
Well.. I don't have more then 4gb. I have 4. Can I make it use more memory?
Will setting awe enabled to 1 do this? I'm pretty sure this is one of the
causes of some recent performance issues we've been having.
Note that, I guess because it's Windows 2000 AS, I don't have /3gb or /PAE
in my boot.ini at all, I don't think I need that?
Thanks,
GregI would add /3GB but that is only if I had a memory bottleneck.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"greg" <greg@.discussions.microsoft.com> wrote in message
news:706F9484-62C7-4BDC-8AD5-F3079AA77828@.microsoft.com...
> Server is Windows 2000 SP4 Advanced Server with 4gb of RAM. "My Computer"
> shows 3,669,532KB of RAM. SQL Server 2000 SP3.
> I'm a bit confused as to if SQL server can use more memory or not.
> In task manager, I see that sql server is using 1.7 gigs of memory (sounds
> like 2gb to me).. which I'm reading is the maximum. Even though the server
> properties have the minimum set at 0 and the maximum set at 38xxMB.
> All the discussion says that setting "awe enabled" will allow SQL Server
> to
> take advantage of memory on servers with more then 4gb of memory.
> Well.. I don't have more then 4gb. I have 4. Can I make it use more
> memory?
> Will setting awe enabled to 1 do this? I'm pretty sure this is one of the
> causes of some recent performance issues we've been having.
> Note that, I guess because it's Windows 2000 AS, I don't have /3gb or /PAE
> in my boot.ini at all, I don't think I need that?
>
> Thanks,
> Greg|||If your SQL Server is Standard edition, you are capped at 2gb
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"greg" <greg@.discussions.microsoft.com> wrote in message
news:706F9484-62C7-4BDC-8AD5-F3079AA77828@.microsoft.com...
> Server is Windows 2000 SP4 Advanced Server with 4gb of RAM. "My Computer"
> shows 3,669,532KB of RAM. SQL Server 2000 SP3.
> I'm a bit confused as to if SQL server can use more memory or not.
> In task manager, I see that sql server is using 1.7 gigs of memory (sounds
> like 2gb to me).. which I'm reading is the maximum. Even though the server
> properties have the minimum set at 0 and the maximum set at 38xxMB.
> All the discussion says that setting "awe enabled" will allow SQL Server
> to
> take advantage of memory on servers with more then 4gb of memory.
> Well.. I don't have more then 4gb. I have 4. Can I make it use more
> memory?
> Will setting awe enabled to 1 do this? I'm pretty sure this is one of the
> causes of some recent performance issues we've been having.
> Note that, I guess because it's Windows 2000 AS, I don't have /3gb or /PAE
> in my boot.ini at all, I don't think I need that?
>
> Thanks,
> Greg|||What edition of SQL Server 2000 are you using. If it is Standard Edition, you
are limited to 2GB Max.
"greg" wrote:
> Server is Windows 2000 SP4 Advanced Server with 4gb of RAM. "My Computer"
> shows 3,669,532KB of RAM. SQL Server 2000 SP3.
> I'm a bit confused as to if SQL server can use more memory or not.
> In task manager, I see that sql server is using 1.7 gigs of memory (sounds
> like 2gb to me).. which I'm reading is the maximum. Even though the server
> properties have the minimum set at 0 and the maximum set at 38xxMB.
> All the discussion says that setting "awe enabled" will allow SQL Server to
> take advantage of memory on servers with more then 4gb of memory.
> Well.. I don't have more then 4gb. I have 4. Can I make it use more memory?
> Will setting awe enabled to 1 do this? I'm pretty sure this is one of the
> causes of some recent performance issues we've been having.
> Note that, I guess because it's Windows 2000 AS, I don't have /3gb or /PAE
> in my boot.ini at all, I don't think I need that?
>
> Thanks,
> Greg|||SQL Server 2000, Enterprise Edition.
Just found this option that says I should *not* be using 'awe enabled'...
damn this is confusing!
http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx
Help?|||I don't believe this article does suggest that you disable AWE - what is
your reasoning behind this conclusion?
You'll need AWE enabled if you're wanting SQL Server to see more than a few
GB of memory.
"greg" <greg@.discussions.microsoft.com> wrote in message
news:F3795964-7DA6-46DE-8718-9D5FE1BC99B6@.microsoft.com...
> SQL Server 2000, Enterprise Edition.
> Just found this option that says I should *not* be using 'awe enabled'...
> damn this is confusing!
> http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx
>
> Help?
>|||Added /3gb to boot.ini and rebooted this weekend, now using 2.7 gigs of
memory! Sweet.
CPU usage is up now so I guess that's good. Less time thrashing/waiting on
the disk, more time doing actual work.

configuring sql 6.5

**** Post for FREE via your newsreader at post.usenet.com ****
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
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.usenet.com ****
> 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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=|||Darius wrote:
>> 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?
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.usenet.com ****
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
http://www.usenet.com
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.usenet.com...
> **** Post for FREE via your newsreader at post.usenet.com ****
> 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
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=> *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.usenet.com
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

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
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=