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 |
|
sven2
Yak Posting Veteran
57 Posts |
 Posted - 2010-04-09 : 16:18:54
|
| Hello,I want to use a remote server to connect a database using an ODBC connection.I enabled the browser service on the server and I have opened port 1433.When I make an ODBC connection on the server, there is no problem. When I make an ODBC connection on my laptop and I use the server verification login and password I can't connent to the server.I use system DSN, SQL server, SQL server verification, clientcofiguration TCP/IP dynamic port enabled.I get error 64 and 17.Any help is welcome.Thanks in advance,Sven. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-04-09 : 19:42:59
|
| what is the error message? |
 |
|
|
sven2
Yak Posting Veteran
57 Posts |
Posted - 2010-04-10 : 03:42:29
|
| error 64: not able to connecterror 17: does not exist or access is denied |
|
|
|
thewebhosting
Starting Member
17 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-04-11 : 06:50:06
|
| 1)Are your network protocols on server turned on ?Either Named Pipe or TCP\IP must be turned on?If you've has to turn them on - restart the SQL Browser Service?2)On Client side - can you ping the server? can you telnet the server with correct server and port number?3)As an extra check , if you have SQLCMD on your client machine - try : SQLCMD -U myusername -P mypassword -S server\intsnace can you log on?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
sven2
Yak Posting Veteran
57 Posts |
Posted - 2010-04-11 : 11:51:22
|
| Hello,Both network protocols on the server are turned on (named pipes and TCP\IP must be turned on)I can you ping the serverI can logon using rdp, I just can't logon with the database using odbc!!Sven. |
|
|
|
|
|
|
ODBC connection SQL server 2005