|
|
You're in the
sql server connect
group:SQL 2000 Cluster Connection Problem
sql server connect:
I have a weird problem. I have a web application that is in ASP.NET 2.0. It
was connected to a SQL 2000 single server no problem. I changed the connection to our SQL 2000 cluster and it won't connect. It gives me this error: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server If I change it to TCP/IP as the provider it gives me this error: provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) The funny thing is it works fine on the other server and all the permissions are correct. Also, if I go to the server that hosts the web site, I can setup an ODBC connection using named pipes, but not TCP/IP. On the SQL cluster TCP/IP and Named Pipes are both enabled and TCP/IP is set to port 1433. Any help would be appreciated. Thanks. --
Hello Vincent
I would like to know if you could setup an alias to connect to the server. 1. Click the SQL Server Client Network Utility. 2. Click the Alias Tab. Then click the Add button. 3. In the Add Network Library Configuration dialogbox, select the TCP/IP in the Network Librabies section. Type the alias you want to use. And then type the server name in the server name box. 4. Click OK and then try to setup a UDL file to connect to the sql server cluster. Please let me know if you could resolve this issue. Sincerely, Wei Lu Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== (This posting is provided "AS IS", with no warranties, and confers no rights.)
I setup the alias and the UDL file. It says it can't find the server or
access denied. How will it find the alias? Does it register it in DNS? Thanks. -- Vincent Wright [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hello Vincent > > I would like to know if you could setup an alias to connect to the server. > > 1. Click the SQL Server Client Network Utility. > > 2. Click the Alias Tab. Then click the Add button. > > 3. In the Add Network Library Configuration dialogbox, select the TCP/IP in > the Network Librabies section. Type the alias you want to use. And then > type the server name in the server name box. > > 4. Click OK and then try to setup a UDL file to connect to the sql server > cluster. > > Please let me know if you could resolve this issue. > > Sincerely, > > Wei Lu > > Microsoft Online Community Support > > ================================================== > > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx. > > ================================================== > (This posting is provided "AS IS", with no warranties, and confers no > rights.) >
Yes, where it says select or enter a server name, that is where I put in the
alias. And it doesn't connect. Maybe I don't understand 100% of what I should be doing. I know I have the alias right, but maybe I am missing something with the UDL file. Thanks. -- Vincent Wright [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hello Vincent, > > Have you tried to specify the alias in the UDL file? > > Sincerely, > > Wei Lu > Microsoft Online Community Support > > ================================================== > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. >
I found this in the SQL error logs: 2007-01-25 13:21:04.65 server
SuperSocket Info: Bind failed on TCP port 1433. That must be why it can't use TCP/IP. I don't see any reason why it won't work on named pipes though. I need to find out what is blocking port. -- Vincent Wright [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hello Vincent, > > Have you tried to specify the alias in the UDL file? > > Sincerely, > > Wei Lu > Microsoft Online Community Support > > ================================================== > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. >
Hello Vincent,
Have you tried to specify the alias in the UDL file? Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
It has been resolved. The problem was IP related. I am not sure exactly
what happened. I went through about 20 KB articles and did several Google searches and nothing I did worked. I started looking through the registry entries for the SQL server. I found a place where there was an IP address and it was 10.0.22.227 and the SQL server is 10.0.22.229. I pinged the other address and it doesn't even ping. I changed the IP to the correct one and restarted the service. I then checked the SQL server error logs and it bound to the correct port. Thanks for your help. -- Vincent Wright [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hello Vincent, > > I would like to know if you get resolved this blocking issue. > > If you still have any question, please feel free to let me know. > > Sincerely, > > Wei Lu > Microsoft Online Community Support > > ================================================== > > When responding to posts, please "Reply to Group" via your newsreader so > that others may learn and benefit from your issue. > > ================================================== > This posting is provided "AS IS" with no warranties, and confers no rights. >
Hello Vincent,
I would like to know if you get resolved this blocking issue. If you still have any question, please feel free to let me know. Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Hello Vicent,
Thanks for the update and glad to hear you resolved this issue. If you have any questions, please feel free to let me know. Sincerely, Wei Lu Microsoft Online Community Support ================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights.
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |