mssql connection

zolf
zolf used Ask the Experts™
on

hello there,

i am trying to connect via hamachi vpn to a java application but i get error saying.please help


C:\Users\Zolf>sqlcmd -d expPooyesh -S 5.128.255.194:1433
HResult 0x57, Level 16, State 1
SQL Network Interfaces: Connection string is not valid [87].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

C:\Users\Zolf>sqlcmd -d expPooyesh -S 5.128.255.194,1433
HResult 0x274C, Level 16, State 1
TCP Provider: A connection attempt failed because the connected party did not pr
operly respond after a period of time, or established connection failed because
connected host has failed to respond.

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
>>Connection string is not valid <<
a) Could it be that you have a syntax error in the connection string? Can you post it here?
b) Are you using Windows Authentication? If so, try switching to SQL authentication and enable remote connection in the SQL server. See this link:
 http://support.microsoft.com/kb/914277
Also, more info on connecting to SQL over VPN here.
http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/ef063bed-5daa-41a8-9323-7c2be8ef2bf3 

Author

Commented:
C:\Users\Zolf>sqlcmd -S 5.128.255.194,1433

HResult 0x274C, Level 16, State 1
TCP Provider: A connection attempt failed because the connected party did not pr
operly respond after a period of time, or established connection failed because
connected host has failed to respond.

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
Have you read any of the links I've suggested?
Can you please elaborate on what have you tried so far?
 

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial