Wednesday, March 7, 2012

Ms SQL 2005 express edition connectivity problem

Hi, i just currently install the MS SQL 2005 express edition in my Window XP home edition and the problem is, when i netstat in the command prompt, i couldnt find any port listening to port:1433

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