?
Solved

Can UNIX servers with o/s 10 work with MS SQL Server 2005  servers?

Posted on 2008-10-16
2
Medium Priority
?
160 Views
Last Modified: 2013-11-21
Expert: I am looking at installing a Cold fusion 8.0 web application on a Unix server with o/s 10 and Sun web server 7 with a back end MS SQL Serve2005  database server?  However some one mentioned that I would not be able to use  MS SQL Server 2005   as the back end database server since UNIX servers only work with Oracle database.  Is this true?  We would perfer to use MS SQL Server 2005  in lieu of Oracle database?

Please kindly advise...thanks
0
Comment
Question by:tcmmaxt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
MohammedU earned 2000 total points
ID: 22736120
You can't install SQL on unix but definitely you can connect to SQL server from UNIX...

Check the following article from one of the SQL MVP...

Connecting to MS SQL Server from Unix
http://www.sommarskog.se/mssqlperl/unix.html
0
 

Author Comment

by:tcmmaxt
ID: 22742129
Expert MohammedU: thanks for the subject link . For my 3 tier cold fusion web application on unix . Which of the drivers in the list at http://www.sommarskog.se/mssqlperl/unix.html would you suggest I use to connect my solaris 10 o/s to the back end MS SQL Serve2005  database server. I what to make sure I use the right one before I close out of this one. again, thanks
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question