CODEWITHSUNDEEP
sqlsql-server-2008jdbc
user373201
user373201

Reputation: 11435

sql server 2008 express - unable to connect

I just installed sql server 2008 express on xp in vmware. My connection string looks like this 

jdbc:jtds:sqlserver://localhost:1433/DEV

I have enabled TCP/IP

I have started Sql Server and Sql Server Browser service

I have disabled firewall.

In the same machine I installed a sql client - squirrel sql and using the above connection string, I get connection refused.

I am able to connect using SQL Server Management Studio...so I know my sql server is running.

Any help is appreciated.

Upvotes: 0

Views: 3221

Answers (2)

user373201
user373201

Reputation: 11435

I missed to update TCP/IP ip addresses section.. setting the port to 1433 and restarting fixed the issue.

Thanks for all the help

Upvotes: 1

pwizzle77
pwizzle77

Reputation: 31

I would disable named pipes. Also, try the 127.0.0.1 address. I bet the named pipes is giving you problems though.

Upvotes: 1

Related Questions