Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jrome
Starting Member
1 Post |
 Posted - 2008-10-05 : 14:24:16
|
| Hello everyone, first post here. I'm trying to connect to a SQL server running on a linux machine from SQL Server management studio running vista on the same network. I have already done the following on the SQL linux machine:1. Grant rights to a username:grant all privileges on *.* to remoteuser@192.168.1.100 identified by "userpassword";2. edit my.cnfand comment out the bind-address line3. restart your MySQL serverthen, when I go back to my Vista machine running SQL management studio I try to connect with:Server type: Database EngineServer name: 192.168.1.97(Linux)Authentication: SQL AuthenticationUser Name: rootPassword: ********and I get a connection error:An error has occured while establishing a connection to the server. (Provider: Named Pipes Provider, error: 40 -Could not open a connection to SQL Server) (Microsoft SQL Server, Error:53)Can anyone please point me in the right direction or advice? Thank you |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-05 : 17:07:48
|
| Though this forums is for Microsoft MS SQLTry, for other versions other than expressServer type: Database EngineServer name: 192.168.1.97,1433Authentication: SQL AuthenticationUser Name: rootPassword: ******** If using Express.Server type: Database EngineServer name: 192.168.1.97,2433Authentication: SQL AuthenticationUser Name: rootPassword: ******** also change your protocol to named pipes and TCP/IP |
 |
|
|
|
|
|
Connect to SQL Server on Linux from Windows??