window| Problem Description: Enterprise Manager Connection SQL no problem, but the site is not connected to SQL, prompted as follows:
[Named Pipes] SQL Server does not exist or access denied. (SQL Servers do not exist or access is denied)
[Named Pipes] ConnectionOpen (Connect ()).
Find the following article on Microsoft Technical Support
http://support.microsoft.com/?kbid=839269
Follow the prompts: "Start"-> "Run"-> "Firewall.cpl"
Windows Firewall selected Advanced-> "NET connection Settings"-> "Settings" turned on
In the Advanced Settings dialog box, select Add, as shown in the following properties:
Attribute value Service Description: SQL named pipe (service name) the name or IP address (N) of the computer hosting this server on your network (for example, 192.168.0.12): The current computer IP address or computer name the external port number of this service 445 the internal port number of this service 445
Note that the TCP option is selected in the Service Settings dialog box.
By making file and printer sharing effective, TCP445 port activity is not blocked by firewalls.
Method:
-> "General" enabled in Windows Firewall to ensure that no exceptions are not selected
On the Exceptions tab-> "Programs and Services" (above) "File and Printer Sharing" edit, select "TCP445" in the Edit Service dialog box to "OK" all the way.
After the setup is complete, it still doesn't work.
I found this article.
Http://www.microsoft.com/taiwan/technet/prodtechnol/winxppro/maintain/winxpsp2faq.aspx
Http://www.microsoft.com/china/sql/techinfo/administration/2000/security/winxpsp2faq.asp
I found some special topics and I couldn't find a solution.
So I looked at sql-sp3, and I remember pretending to have been, rogue, on the occasion of opening SP3 installed directory
Random point batch processing files, point to "Setup.bat" Oh, began to install SP3,
No problem, hehe! Previous tried SQL Alias, bind me static port is 1433, I also tried useless, do not understand what is going on. Oh, the advanced inside set the port 445 remove, the same as no problem.
Summary, 445 should be the listening port, open this port is no problem, the next step is to use the Sql3 instantiation Setup.bat (sql3 the root directory of the installation directory) again set the SQL again, should be the problem to be done.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.