471,092 Members | 1,561 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

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
Jul 20 '05 #1
1 2262
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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Tom Loredo | last post: by
28 posts views Thread by grahamd | last post: by
5 posts views Thread by sandy | last post: by
1 post views Thread by Aliandro | last post: by
2 posts views Thread by G2 | last post: by
1 post views Thread by GaryDean | last post: by
3 posts views Thread by eschneider | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.