LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 04-01-2012, 05:30 PM   #1
rtz
Member
 
Registered: Mar 2012
Posts: 40

Rep: Reputation: Disabled
sql server


how to install sql server in ubuntu.
 
Old 04-01-2012, 06:54 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
SQL Server?

What do you mean? Any relational DBMS?

MS SQL Server?
PostgreSQL Server?
Firebird?
MySQL?
 
Old 04-01-2012, 08:39 PM   #3
rtz
Member
 
Registered: Mar 2012
Posts: 40

Original Poster
Rep: Reputation: Disabled
i have installed mysql-server and mysql-admin but then when i try to connect to the database from my windows machine it gives error


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdN...3&LinkId=20476

i tried changing the port to which the sqlclient on windows machine connects to the sqlserver in ubuntu i.e 3306 but still the results are the same.
 
Old 04-01-2012, 09:32 PM   #4
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
It's still quite unclear as to what you're doing ... from the windows end - what tool
are you using to try to connect to MySQL?


Please be aware of the fact that just about each and any RDBMS uses it's own, and
commonly quite distinctly different means of network communication. So, for example,
lets say you have access set-up to talk to MS SQL Server; you then want to replace
that with MySQL. You can't simply point it at a new machine running a different
OS & RDBMS, that's not going to work.



Cheers,
Tink
 
Old 04-01-2012, 11:51 PM   #5
jschiwal
LQ Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 677Reputation: 677Reputation: 677Reputation: 677Reputation: 677Reputation: 677
You need to download the MySQL manual and read the section on security. You need to drop the sample database and give the mysql root user a password. Then make sure that the mysql service starts on boot, and it running. Also check the firewalls.
 
Old 04-02-2012, 12:38 PM   #6
eantoranz
Senior Member
 
Registered: Apr 2003
Location: Costa Rica
Distribution: Kubuntu, Debian, Knoppix
Posts: 2,076
Blog Entries: 1

Rep: Reputation: 90
Also that it's actually listening on the network. In my case (default config) it's only listening to localhost tcp connections so if you try to connect from another host, it won't work:

Code:
$ sudo netstat -lntp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      1303/mysqld     
.
.
.
To "open up" so that you can start listening to connections from other hosts, change bind-address on my.cnf (or whatever file it is the config file for you).

Last edited by eantoranz; 04-02-2012 at 12:39 PM. Reason: typo
 
Old 04-02-2012, 05:25 PM   #7
rtz
Member
 
Registered: Mar 2012
Posts: 40

Original Poster
Rep: Reputation: Disabled
Unhappy

changing the bind address which was localhost to internal ip address of my machine also didn't worked.
 
Old 04-02-2012, 05:27 PM   #8
eantoranz
Senior Member
 
Registered: Apr 2003
Location: Costa Rica
Distribution: Kubuntu, Debian, Knoppix
Posts: 2,076
Blog Entries: 1

Rep: Reputation: 90
Then I think a nice try to see what's going on with wireshark/tshark will come handy (both on the windows client and the server).
 
Old 04-02-2012, 06:21 PM   #9
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Quote:
Originally Posted by rtz View Post
changing the bind address which was localhost to internal ip address of my machine also didn't worked.
Curious here ... did you actually contemplate what jschiwal and myself suggested above,
are you going down this alley because it takes you down the pleasant garden path? =o)


Cheers,
Tink
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: ITTIA DB SQL Data Distribution Bridges QNX(R) with SQL Server LXer Syndicated Linux News 0 03-14-2012 01:21 AM
Unable to connect MS SQL server 2008 Remote Server through SQUID proxy server samank75 Linux - Server 5 01-19-2012 10:19 PM
SQL update statement to SQL SERVER 2005 scheidel21 Programming 2 11-05-2009 07:30 PM
Problem accessing Windows SQL server from Red Hat Web Server mariap Linux - General 0 12-28-2008 06:46 PM
Migrating from MS-SQL server to My-SQL emailssent Linux - Networking 2 02-07-2005 03:20 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:42 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration