I have just installed the MS SQL Server 2005 Express and, of course, I am trying to connect it with my test app but the thing is ... for some reason I cannot connect it I have already checked its port with the CP "netstat -an" but the outcoming list does not contain any 1433 port at all :( The SQL service is running I could check it with the OS Services but its port is unavailable :( I have installed MS SQL Server 2005 Expres开发者_运维问答s Management Studio but for some reason it connected the MS SQL successfuly :(
So the question is... How to install the MS SQL to be able connecting it with a client (Java) app?
For more information: OS: Windows XP x86 SP3 MS SQL Server 2005 Express
Any useful comments are appreciated
Thanks
In Windows Start>All Programs>Microsoft SQL Server ????>Configuration Tools>SQL Server Configuration Manager
In the tree on the left, Select the nodes listed below and make sure that the Status of TCP/IP is "enabled". In truth I'm not sure if they both have to be enabled or just one.
SQL Server Configuration Manager>SQL Server Network Configuration>Protocols for MSSQLSERVER
SQL Server Configuration Manager>SQL Native Client 10.0>Client Protocols
If they aren't enabled, simply right click on them and click "Enable". I'm not positive that this will fix you're problem, because it's been a while since I ran into 'my' problem, but it sounds like the same thing.
You might want to check the following MSDN How To article:
How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)
精彩评论