Re: Cannot connect to MSDE on SBS 2003
- From: Alister Wong <alister.wong@xxxxxxxxxx>
- Date: Thu, 11 Aug 2005 16:40:52 -0700
Michael,
I had this exact problem on one of my SBS 2003 machines running MSDE.
Often 3rd party backup software like Veritas Backup Exec, attaches to
SQL/MSDE and modifies settings. Sometimes all communication protocols
are disabled.
To fix this, on the server run 'svrnetcn' and make sure that at least
one protocol is enabled. As you checked port 1433 I assume you want to
use TCP/IP, so ensure that at least TCP is in the 'Enabled Protocols'
section.
You also need to confirm that SQL is configured to communicate via this
protocol on the client machines. To do this, run 'cliconfg' on the
client machines. You will see a similar configuration tool to the
server. Make sure the 'Enabled Protocols' match the server, ie
confirm/add TCP.
Good luck, Al.
*** Sent via Developersdex http://www.developersdex.com ***
.
- Prev by Date: blob and network packet size
- Next by Date: Please Help! CryptAPI Error - Connection issue.
- Previous by thread: blob and network packet size
- Next by thread: Please Help! CryptAPI Error - Connection issue.
- Index(es):
Relevant Pages
|
