How to conenct Ms-Sql server from Unix box.

Hi,
How do conenct Ms-Sql server from Unix/Sun box. currently I am running Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql server from Unix by using Sybase isql utility but it seems with new version of Sql-Server, it's not working.
Is there any open client /utility provided by Microsoft to connect server from unix machine.
Thanks,
-Uttam
Are you writing a program?
Do you have an ODBC driver installed? You should be able to connect over
that driver through TCP/IP.. Port 1433 is SQL Server's default port to
listen to incoming traffic.
Using the old Sybase method uses the SQL Server/Sybase Tabular Data Stream
format to communicate. (Probably much faster than using standard ODBC, but
ODBC will work). Try looking around for FreeTDS. I think it will support
SQL 2000. I know it supports through SQL Server 7.0.
There may be some security issues as well. You may need to ensure that the
SQL Server is using Mixed Authentication. If it is NT Authentication only,
then you will need a Windows Account mapped in to SQL Server. IIRC
kerberos can be helpful here to validate your UNIX login with an Active
Directory login.
I'm sure someone will correct me if I'm wrong. =)
Rick Sawtell
MCT, MCSD, MCDBA
"Uttam" <Uttam@.discussions.microsoft.com> wrote in message
news:E829C6EF-A04D-41FD-A2A4-ECB935CA9868@.microsoft.com...
> Hi,
> How do conenct Ms-Sql server from Unix/Sun box. currently I am running
Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql
server from Unix by using Sybase isql utility but it seems with new version
of Sql-Server, it's not working. Is there any open client /utility provided
by Microsoft to connect server from unix machine.
> Thanks,
> -Uttam

How to conenct Ms-Sql server from Unix box.

Hi,
How do conenct Ms-Sql server from Unix/Sun box. currently I am running Ms-Sq
l 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql serve
r from Unix by using Sybase isql utility but it seems with new version of Sq
l-Server, it's not working.
Is there any open client /utility provided by Microsoft to connect server f
rom unix machine.
Thanks,
-UttamAre you writing a program?
Do you have an ODBC driver installed? You should be able to connect over
that driver through TCP/IP.. Port 1433 is SQL Server's default port to
listen to incoming traffic.
Using the old Sybase method uses the SQL Server/Sybase Tabular Data Stream
format to communicate. (Probably much faster than using standard ODBC, but
ODBC will work). Try looking around for FreeTDS. I think it will support
SQL 2000. I know it supports through SQL Server 7.0.
There may be some security issues as well. You may need to ensure that the
SQL Server is using Mixed Authentication. If it is NT Authentication only,
then you will need a Windows Account mapped in to SQL Server. IIRC
kerberos can be helpful here to validate your UNIX login with an Active
Directory login.
I'm sure someone will correct me if I'm wrong. =)
Rick Sawtell
MCT, MCSD, MCDBA
"Uttam" <Uttam@.discussions.microsoft.com> wrote in message
news:E829C6EF-A04D-41FD-A2A4-ECB935CA9868@.microsoft.com...
> Hi,
> How do conenct Ms-Sql server from Unix/Sun box. currently I am running
Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql
server from Unix by using Sybase isql utility but it seems with new version
of Sql-Server, it's not working. Is there any open client /utility provided
by Microsoft to connect server from unix machine.
> Thanks,
> -Uttam

How to check which service pack is installed?

Hi,

I have the subject question both related to MS-SQL Server (desktop version) AND MS-Analysis services.

When I do do Help | About in the Analysis Manager, I get
Version: 8.00.382

And doing the same in Enterprise Manager, I get:
Version: 8.0

Is this indicating that SP3 (which I think is the latest) has been installed or??

Thanks.Originally posted by Joozh
Hi,

I have the subject question both related to MS-SQL Server (desktop version) AND MS-Analysis services.

When I do do Help | About in the Analysis Manager, I get
Version: 8.00.382

And doing the same in Enterprise Manager, I get:
Version: 8.0

Is this indicating that SP3 (which I think is the latest) has been installed or??

Thanks.

to determine the version and sp for ms-sql server use
select @.@.version in QA

check this link :
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp|||I'd use:SELECT ServerProperty('ProductLevel')-PatP|||Thanks :)|||to determine the version and sp for ms-sql server use
select @.@.version in QA


Hi,

When I run the @.@.version command in teh Query Analyzer, I get the following error message:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '@.@.Version'.


Any clues?|||Originally posted by Joozh
Hi,

When I run the @.@.version command in teh Query Analyzer, I get the following error message:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '@.@.Version'.


Any clues?

SELECT @.@.VERSION|||Thanks harshal. Select @.@.Version returned the results :)

On a side note, while trying to install SP3 on my Desktop, I've just discovered that this itself is like a mini project... when I try to run the setup file (for SP3) I get a message shown in the attached file... and while trying to solve this I was referred to 2 different KB articles... I tell you; learning MS SQL is turning out to be quite an ordeal :mad:

Hopefully I'll feel differently after couple of months and once I get a bit more comfortable. Any clues/shortcuts here :confused:|||Originally posted by Joozh
Thanks harshal. Select @.@.Version returned the results :)

On a side note, while trying to install SP3 on my Desktop, I've just discovered that this itself is like a mini project... when I try to run the setup file (for SP3) I get a message shown in the attached file... and while trying to solve this I was referred to 2 different KB articles... I tell you; learning MS SQL is turning out to be quite an ordeal :mad:

Hopefully I'll feel differently after couple of months and once I get a bit more comfortable. Any clues/shortcuts here :confused:

hi Joozh,

By default, the MSDE 2000 SP3a setup will not install a new instance of MSDE 2000 unless you use the SAPWD parameter to specify a strong sa password. By default, the MSDE 2000 SP3a setup will not upgrade an existing instance of MSDE 2000 unless you have assigned a strong password to the sa login. You should assign a strong password to the sa login, even when upgrading an existing instance, unless the application using your instance of MSDE depends in some way on a null sa password. Even if the instance of MSDE 2000 is running in Windows Authentication mode, the sa login becomes immediately active if the instance is ever switched to Mixed Mode. A null, blank, simple, or well-known sa password could be used for unauthorized access. If you need to assign a strong sa password before upgrading your instance of MSDE 2000 to SP3a.

check out the readme file at:
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp

Harshal.