MS SQL Issues

[Tom]

Hi there I am hoping for some direction in posting this. We have a web
appication that is running on ASP>NET framework with IIS that will
access a 2 gig sql data base. The issue here that we can not get the
application to connect with SQL at all. Here are the errors we are
getting

Exception Details: System.Data.SqlClient.SqlException: SQL Server does
not exist or access denied.

Source Error:
Line 121: da = New SqlDataAdapter(SQL, m_ConnectionString)
Line 122: da.SelectCommand.CommandTimeout = 30
Line 123: da.Fill(ds)
Line 124:
Line 125: If ds.Tables(0).Rows.Count > 0 Then

I have double checked the services and everything seems fine we have
uninstalled and reinstalled SQL and we have tried different users and
passwords including the System Accounts. No luck here is what happens
further down the page
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection
connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
DataRoster.User.GetUser(String UserName, String pwd) in
c:\dataroster\User.vb:123
DataRoster.frmLogin.btnGo_Click(Object sender, EventArgs e) in
c:\dataroster\default.aspx.vb:34
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData)
+33
System.Web.UI.Page.ProcessRequestMain() +1277
We have evrything running on one server so named pipes aren't the
issue because we have the the application looking towards the loopback
adpter, so I take that the SQL Server (2000) and the application are
not even trying to talk. We have double and triple checked the ports.
We have applied SP3 to SQL and uopdated the MDAC to 2.8. any
suggestion would be greatly appreciated.
Thank You
Tom

[Erland Sommarskog]

Tom (to******@hotmail.com) writes:

Hi there I am hoping for some direction in posting this. We have a web
appication that is running on ASP>NET framework with IIS that will
access a 2 gig sql data base. The issue here that we can not get the
application to connect with SQL at all. Here are the errors we are
getting

Exception Details: System.Data.SqlClient.SqlException: SQL Server does
not exist or access denied.

Source Error:
Line 121: da = New SqlDataAdapter(SQL, m_ConnectionString)

So what does the connection string looks like?

Can you connect to the server from Query Analyzer?

If you look in the Client Network Utility and the Server Network
Utitilty, what do you see? Is Shared Memory check in the Client
Network Utility?

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp