i have an application wanting to connect to the MS SQL but it came out:
Error connecting to database using: "jdbc:jtds:sqlserver://localhost:1433"
i dunnu what the problem is but im suspecting it is not listening to port:1433
anyone can help me please....
MS SQL 2005 express only allow local connection by default. No TCP. You need to enable TCP. One mean is to use sql server configuration manager.
For general sql express troubleshooting,
http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx
No comments:
Post a Comment