RE: 'SQL server does not allow remote connections' error

Hi Charles

Thanks for making me check the obvious - turns out the web.config file got
mangled somewhere in the transfer. Applied the correct connection string and
save locations to the web.config, and it's back up and running!

Cheers



Dan


"Charles Wang[MSFT]" wrote:

Hi Dan,

I understand that your ASP.NET application failed to connect to your SQL
Server 2005 however another web application could connect to the SQL Server
2005 on the same server.
If I have misunderstood, please let me know.

Since the other ASP.NET application could connect to your SQL Server 2005,
I think that there might be some differences between the two client
connections. I recommend that you check the following:
1. Check if the two connection strings are same;
2. Run "sqlcmd /Snp:<servername>\<instance name> /Usa /P<password>" to
connecto to your SQL Server to see if it can succeed;
3. Run "cliconfg.exe" from command line to add an alias with Named Pipes
protocol and then check if you can connect to your SQL Server with that
alias;
4. If that does not work, try adding an alias with TCP/IP protocol and then
use the alias in your connection string to connect to your SQL Server.
You may refer to:
How to connect to a named instance of SQL Server 2005 or SQL Server 2000 by
using the client tools in the earlier version of SQL Server
http://support.microsoft.com/kb/265808
Creating a Valid Connection String Using TCP/IP
http://msdn2.microsoft.com/en-us/library/ms191260.aspx
Creating a Valid Connection String Using Named Pipes
http://msdn2.microsoft.com/en-us/library/ms189307.aspx

If this issue persists, I also would like to know the startup information
of your SQL Server. Please mail me (changliw_at_microsoft_dot_com) the SQL
Error logs (%ProgramFiles%\Microsoft SQL Server\MSSQL\LOG) for further
research.

Hope this helps. If you have any other questions or concerns, please feel
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


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.
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================


.

Relevant Pages

  • RE: Web Administration Tool Crashes when creating user
    ... It will check if the Role Manager has been enabled. ... It is reusing the default connection string name: ... Microsoft Online Community Support ... nature are best handled working with a dedicated Microsoft Support Engineer ...
    (microsoft.public.vsnet.setup)
  • Re: One Connection String for Multiple Users (SQL)
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ... This uses the> same connection string for all instances of the application. ...
    (microsoft.public.sqlserver.connect)
  • Re: Deployment of DataSets (xsd files)
    ... The class I've developed contained the typed DataSet and is responsible of the communication with the server. ... I don't know how it really works but I know that locally MyClass connected to the database using the local connection string. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.general)
  • RE: security in windows app
    ... If I wanted to change this value or the connection string in the config file ... ASP.NET membership & role APIs in winform application(or other non-ASP.NET ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ODBC connection strings - "ODBC;" prefix?
    ... pre-pended to the connection string. ... Look forward to your response and I would like to work with you on further ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.vc.database)