惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

酷 壳 – CoolShell
酷 壳 – CoolShell
H
Hacker News: Front Page
P
Palo Alto Networks Blog
T
ThreatConnect
Apple Machine Learning Research
Apple Machine Learning Research
博客园_首页
T
True Tiger Recordings
P
Privacy & Cybersecurity Law Blog
B
Blog
IT之家
IT之家
Last Week in AI
Last Week in AI
F
Full Disclosure
Hacker News: Ask HN
Hacker News: Ask HN
C
Comments on: Blog
Microsoft Azure Blog
Microsoft Azure Blog
C
Cybersecurity and Infrastructure Security Agency CISA
Microsoft Security Blog
Microsoft Security Blog
博客园 - 【当耐特】
N
News and Events Feed by Topic
NISL@THU
NISL@THU
腾讯CDC
雷峰网
雷峰网
Security Latest
Security Latest
李成银的技术随笔
M
Microsoft Research Blog - Microsoft Research
L
LangChain Blog
L
Lohrmann on Cybersecurity
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
C
Check Point Blog
Y
Y Combinator Blog
Recent Announcements
Recent Announcements
博客园 - Franky
N
News | PayPal Newsroom
V
V2EX
A
About on SuperTechFans
The Register - Security
The Register - Security
月光博客
月光博客
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
Google Online Security Blog
Google Online Security Blog
MyScale Blog
MyScale Blog
Cisco Talos Blog
Cisco Talos Blog
Vercel News
Vercel News
WordPress大学
WordPress大学
C
Cyber Attacks, Cyber Crime and Cyber Security
The Hacker News
The Hacker News
IntelliJ IDEA : IntelliJ IDEA – the Leading IDE for Professional Development in Java and Kotlin | The JetBrains Blog
IntelliJ IDEA : IntelliJ IDEA – the Leading IDE for Professional Development in Java and Kotlin | The JetBrains Blog
爱范儿
爱范儿
A
Arctic Wolf
L
LINUX DO - 最新话题
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More

博客园 - eFeng.Leung

枚举Exchange Server、SotreGroups和MailStore Single Sign-On for everyone 关于AD编程的一些资料 zz 不同的asp.net web应用程序间共享Session/Application - eFeng.Leung - 博客园 Code Project中几篇关于DNN的文章 Authenticate a user against the Active Directory using the user ID and password User Object User Interface Mapping Lists all entries in the Active Directory Using Active Directory Active Directory and .NET - eFeng.Leung LDAP, IIS and WinNT Directory Services 无法破解的软件注册码算法 使用HTTP访问2003表单登录页 (转) FYI: Getting Started with WebDAV 遭遇 对路径“C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files\aa\……”的访问被拒绝 - eFeng.Leung 网络负载平衡部署 Group Panel 在DataGrid里显示Excel文件数据 鼠标移动,改变datagrid里行的色
SQL2K集群 绑定在 TCP 端口 1433 上失败
eFeng.Leung · 2006-03-15 · via 博客园 - eFeng.Leung

用IP+port不能连接到数据库。查看日志:
server SuperSocket Info:Bind failed on TCP port 1433

NETSTAT -AN 也没有看到侦听1433端口。

CAUSE
Changing the Virtual SQL Server IP address with the Cluster Administrator tool. For a 
default instance of virtual SQL Server, the following registry value points to a previous IP address: 

HKLM\Software\Microsoft\MSSQLServer\Cluster

For a named instance of 
virtual SQL Server, the following registry value points to a previous IP address: 

HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name\Cluster\ClusterIpAddr 
    (我的确是在群集管理器里直接更改过SQL群集IP.…………)

RESOLUTION
To resolve the problem, follow the steps 

in Microsoft Knowledge Base article Q244980 for the correct way to change the Virtual SQL Server IP address. When you get to step 7 in the "More Information" section of the article, select Remove and replace an existing IP Address: 
244980 (http://support.microsoft.com/kb/244980/) HOW TO: Change the Network IP Addresses of SQL Server Virtual Servers 
If you are using SQL Server 2005, follow the steps described in the "How to: Change the IP Address of a SQL Server 2005 Failover Cluster" topic in SQL Server Books Online to resolve the problem.

.
1. Insert the SQL Server 2000 Enterprise Edition CD, and then click SQL Server 2000 Components. 
2. Click Install Database Server. 
3. On the Welcome screen, click Next.
4. Type the name of the virtual server that you want to modify, and then click Next. 
5. Click the Advanced options tab, and then click Next. 
6. Click Maintain a Virtual Server for Failover Clustering, and then click Next. 
7. In the Failover Clustering dialog box, you can: • Add an IP address for additional networks.
• Remove and replace an existing IP address.
• Remove IP addresses that you do not need. 
After you make these changes, click Add, and then click Next.

Note Assign only one IP address for each network and one network for each network adapter. SQL Server requires that each IP address that is assigned to it have its own unique subnet mask. SQL Server does not support multiple IP addresses on the same subnet because this may result in duplicated names on the network. For example, if you have a public network and a private network and you want to assign an additional IP address to your SQL Server virtual server, you must add another network adapter to each node to create a new network. You can then assign the additional IP address to the new network. 
8. Make any changes to the nodes, and then click Next. 
9. Verify the requested user information and password, and then click Next.