INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

new to sql server and have a couple of questions

new to sql server and have a couple of questions

(OP)
I'm not familiar with microsoft sql server, and have a few questions...

- i'm guessing MSSQL sits on a windows OS server only, and the application is not cross compatible with other OS's? Is there a linux version?

- is it possible to remote access MSSQL from an sql client? for example, an SQL client working on OS X?

- or in general, is it possible to use a variance of remote connections, or is MSSQL limited, does it have many blockages or challenges compared to other DB apps we all know and love?

- looking at the MSSQL screen shots it looks very cumbersome... is it mostly configurable via it's GUI interface, or can we interface, manage and send queries to it using the traditional SQL client or SSH methods?

RE: new to sql server and have a couple of questions

You are correct. MSSQL only runs on a windows platform. No linux version exists.

MSSQL is accessible through most of the same protocols that other database server software can be accessed with. JDBC will likely be how you connect from OS X. There may be ways to connect via ODBC as well, so check the documentation for the language you are using.

All database software will have its quirks that you will have to get used to. Unless you are secretly a fan of another RDBMS, you would not find more or less problems with MSSQL.

MSSQL can be mostly configured with SQL commands. There are a few things that end up in the registry, but you never hit them that often. Typically, you set a thing up once, and the server runs like that for the rest of its life.

RE: new to sql server and have a couple of questions

(OP)
cheers yelworcm!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close