mssql connection
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.
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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