ASP.NET 2.0 deployment (w/ SQL Srvr 2005) error

G

Guest

I have the following setup:
1. ASP.NET 2.0 web app hosted on a web server (inetpub directory
hosting physical files of the web site on a different drive name, E:
than the SQL Server Instance, which is on C:)
2. SQL Server on the same server, with security settings enabling
ASPNET group and groups containing users allowed to interact with the
website added to SQL Server Instance security settings.
3. Impersonation = true, i.e. ASPNET worker process will impersonate
the user who has been authenticated by IIS

I am continiously getting this error:
========================


An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified)


The stack trace and event log is at the end of this post.


I tried the following:
1. enabled TCPIP and Pipes for remote connection via the SQL Server
Configuration Manager
2. enabled remote and local connections via the SQL Surface area
Configuration (TCPIP and named pipes)
3. totally disabled the firewall (even if it is enabled, both the
sqlbrowser, and sqlserver are added as exceptions)
4. enabled the SQL Server Browser Service (to start automatically)


I've tried doing everything i came across on the net.
Nobody seems to have a solution but a lot of people have encountered
this problem.


If anybody out there does have a solution, PLEASE reply to this post.


Thanking you in advance


Part of the stack trace:
--------------------------------
[SqlException (0x80131904): An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default settings SQL
Server does not allow remote connections. (provider: SQL Network
Interfaces, error: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +734995


System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObje­ct
stateObj) +188
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
Boolean& failoverDemandDone, String host, String failoverPartner,
String protocol, SqlInternalConnectionTds connHandler, Int64
timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
+820


System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnectio­n
owningObject, SqlConnectionString connectionOptions, String
newPassword, Boolean redirectedUserInstance) +628


System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdenti­ty
identity, SqlConnectionString connectionOptions, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean
redirectedUserInstance) +170


System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOpt­ions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningConnection) +130


System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConne­ction
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
+28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) +424


System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) +496


Part of the Event Log (Application)
------------------------------------------------
Process information:
Process ID: 5600
Process name: w3wp.exe
Account name: EUSRCMW309\IWAM_EUSRCMW309


Exception information:
Exception type: SqlException
Exception message: An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default settings SQL
Server does not allow remote connections. (provider: SQL Network
Interfaces, error: 26 - Error Locating Server/Instance Specified)


Request information:
Request URL: http://138.85.90.253/psdb/main.aspx
Request path: /psdb/main.aspx
User host address: 138.85.90.253
User: EAMCS\EUSJESadm
Is authenticated: True
Authentication Type: Negotiate
Thread account name: EUSRCMW309\IWAM_EUSRCMW309
 
G

Guest

I'll reply to my own post.

I was on the phone with MSDN support for over 3 hours before we figured
it out. The connection string was ok. The problem was with a web part
that I was using in the Master page.

<asp:webpartmanager id="WebPartManager1" runat="server"
Personalization-Enabled="false" />


I was using the WebPartManager to display some data in the master page,
based on some information in the Session populated by clicking on a
GridView row. However it seems that by default, if you don't disable
'Personalization-Enabled' attribute, it is true. In that case, it will
try to locate the DB in SQL Server 2005 default to personalization
(which of course I had not set up using the script supplied). Note: I
had nothing to do with personalization in my web app. All I wanted to
do was to use the web part to display some data.
So when I disabled this attribute, everything started working properly.


I tried all permutation and
combinations of connection strings before I finally decided to make a
udl file on my desktop, connect to the DB, and then copy the string
created by it. We then ran a script on the website that Microsoft
support gave to make sure that everything was ok in terms of the
connection string. The finally, we homed in on the problem by looking
at the stack trace, which continiously gave a call to Personalization
api that was erroring out. That's how we homed in on the problem.


So lesson learnt. If you use WebParts in a website, Personalization is
enabled by default. To make sure we don't error out, we have to switch
it off.


John Shadel said:
I have the following setup:
1. ASP.NET 2.0 web app hosted on a web server (inetpub directory
hosting physical files of the web site on a different drive name, E:
than the SQL Server Instance, which is on C:)
2. SQL Server on the same server, with security settings enabling
ASPNET group and groups containing users allowed to interact with the
website added to SQL Server Instance security settings.
3. Impersonation = true, i.e. ASPNET worker process will impersonate
the user who has been authenticated by IIS

I am continiously getting this error:
========================


An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified)


The stack trace and event log is at the end of this post.


I tried the following:
1. enabled TCPIP and Pipes for remote connection via the SQL Server
Configuration Manager
2. enabled remote and local connections via the SQL Surface area
Configuration (TCPIP and named pipes)
3. totally disabled the firewall (even if it is enabled, both the
sqlbrowser, and sqlserver are added as exceptions)
4. enabled the SQL Server Browser Service (to start automatically)


I've tried doing everything i came across on the net.
Nobody seems to have a solution but a lot of people have encountered
this problem.


If anybody out there does have a solution, PLEASE reply to this post.


Thanking you in advance


Part of the stack trace:
--------------------------------
[SqlException (0x80131904): An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default settings SQL
Server does not allow remote connections. (provider: SQL Network
Interfaces, error: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +734995


System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObje­ct
stateObj) +188
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
Boolean& failoverDemandDone, String host, String failoverPartner,
String protocol, SqlInternalConnectionTds connHandler, Int64
timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
+820


System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnectio­n
owningObject, SqlConnectionString connectionOptions, String
newPassword, Boolean redirectedUserInstance) +628


System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdenti­ty
identity, SqlConnectionString connectionOptions, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean
redirectedUserInstance) +170


System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOpt­ions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningConnection) +130


System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConne­ction
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
+28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) +424


System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) +496


Part of the Event Log (Application)
------------------------------------------------
Process information:
Process ID: 5600
Process name: w3wp.exe
Account name: EUSRCMW309\IWAM_EUSRCMW309


Exception information:
Exception type: SqlException
Exception message: An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default settings SQL
Server does not allow remote connections. (provider: SQL Network
Interfaces, error: 26 - Error Locating Server/Instance Specified)


Request information:
Request URL: http://138.85.90.253/psdb/main.aspx
Request path: /psdb/main.aspx
User host address: 138.85.90.253
User: EAMCS\EUSJESadm
Is authenticated: True
Authentication Type: Negotiate
Thread account name: EUSRCMW309\IWAM_EUSRCMW309
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I best fix this error 4
Using data from SQL in C# 4
Accessing an SQL Server database file 4
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data. 3
reboot each day to connect to a SQL Express Database 1
SQL Server connection issue 4
Exception when accessing mdf file when using IIS and aspnet_wp.exe 4
Error occurred during the pre-login handshake 0

Top