|
|
 next
|
  Subject: Cannot create SQL Server datasource
Author: Minollo I.
Date: 29 Dec 2006 10:30 PM
|
This is what I found looking for similar issues; the problem could be that your server is not accepting TCP/IP conections.
To check the enabled protocols for a server, follow these steps:
* In SQL Server 2000, start the SQL Server Network Utility (svrnetcn.exe).
* On the General tab, select the instance of Microsoft SQL Server on which to load an installed server network library.
* Make sure that TCP/IP appears in the Enabled Protocols list.
* To find the port number, in the Enabled Protocols list, click TCP/IP, and then click Properties. The Properties dialog box displays the port number.
There is an known bug: SQL Server May Not Listen on TCP/IP Sockets When TCP/IP is the Only Protocol
In a SQL Server 2000 custom installation, if TCP/IP is the only selected protocol and all other protocols are disabled, SQL Server may not initialize and listen on TCP/IP sockets. The Server Network Utility shows that it is listening only on TCP/IP port 1433 even though it is not. To identify if SQL Server is not listening on TCP/IP, check to see if the value for TcpPort in the following registry key is incorrectly set to blank or empty:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ [Instance Name]\MSSQLServer\SuperSocketNetLib\Tcp\REG_SZ TcpPort=
To work around this problem, follow these steps:
* Start Registry Editor (Regedt32.exe).
* Locate the TcpPort value in the following key in the registry:
* Named instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\[InstanceName]\MSSQLServer\SuperSocketNetLib\Tcp\TcpPort
* Default instance:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
\MSSQLServer\SuperSocketNetLib\TCP\TcpPort
* On the Edit menu, click String. Enter either of the following values:
a. Type the port number you want. -or-
b. Enter a value of 0 to have SQL Server dynamically detect and assign a port the next time SQL Server starts.
* Click OK.
* Quit Registry Editor.
SQL Server 2000 Service Pack 4 (SP4):
You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the Microsoft Windows Server 2003 family. To reduce your computer's vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install SQL Server 2000 Service Pack 3a, or the most recent service pack for Microsoft SQL Server 2000 or MSDE from http://www.microsoft.com/sql/downloads/2000/sp4.mspx.
|
|
|
|
top