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.Sql Client.SqlExcep tion: SQL Server does
not exist or access denied.

Source Error:


Line 121: da = New SqlDataAdapter( SQL, m_ConnectionStr ing)
Line 122: da.SelectComman d.CommandTimeou t = 30
Line 123: da.Fill(ds)
Line 124:
Line 125: If ds.Tables(0).Ro ws.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.Sql Client.Connecti onPool.GetConne ction(Boolean&
isInTransaction ) +472
System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString
options, Boolean& isInTransaction ) +372
System.Data.Sql Client.SqlConne ction.Open() +384
System.Data.Com mon.DbDataAdapt er.QuietOpen(ID bConnection
connection, ConnectionState & originalState) +44
System.Data.Com mon.DbDataAdapt er.FillFromComm and(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77
System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet) +38
DataRoster.User .GetUser(String UserName, String pwd) in
c:\dataroster\U ser.vb:123
DataRoster.frmL ogin.btnGo_Clic k(Object sender, EventArgs e) in
c:\dataroster\d efault.aspx.vb: 34
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
+33
System.Web.UI.P age.ProcessRequ estMain() +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]

Re: MS SQL Issues

Tom (tom_ruiz@hotma il.com) writes:[color=blue]
> 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.Sql Client.SqlExcep tion: SQL Server does
> not exist or access denied.
>
> Source Error:
>
>
> Line 121: da = New SqlDataAdapter( SQL, m_ConnectionStr ing)[/color]

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, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp