Re: SQL Server does not exist or access denied

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: olivogt (olivogt_at_discussions.microsoft.com)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 03:45:05 -0700

Hi,
Thanks for the reply. The strange thig is that I do access the SQL server
for the login but not from any other page ....

Any ideas?

SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

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

Source Error:

Line 268:
Line 269: Sub bindgrid()
Line 270: SqlDataAdapter1.Fill(Me.DataSet11, variable1)
Line 271: SqlDataAdapter2.Fill(DataSet11, variable2)
Line 272: DataGrid1.DataSource =
Me.DataSet11.Tables(variable2).DefaultView
 

Source File: C:\Inetpub\wwwroot\itprofiling\company.aspx.vb Line: 270

Stack Trace:

[SqlException: SQL Server does not exist or access denied.]
   System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction) +484
   
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
   System.Data.SqlClient.SqlConnection.Open() +384
   System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection,
ConnectionState& originalState) +44
   System.Data.Common.DbDataAdapter.FillFromCommand(Object 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, String srcTable) +36
   itprofiling.company.bindgrid() in
C:\Inetpub\wwwroot\testapp\company.aspx.vb:270
   itprofiling.company.Page_Load(Object sender, EventArgs e) in
C:\Inetpub\wwwroot\testapp\company.aspx.vb:257
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +731

"http://www.visual-basic-data-mining.net/" wrote:

> You could catch the exception where it is being thrown and output the error
> message, that way you will be clearer on which part of your code is throwing
> the exception and what the error message is saying
>
> --
> data mining and .net team
> http://www.visual-basic-data-mining.net/forum
>
>
> "Olivogt" <Olivogt@discussions.microsoft.com> wrote in message
> news:810BF812-E429-44A5-AC6A-0B8EDB9EF34B@microsoft.com...
> > Hello,
> > I was just puting an application on the web server but it did not work as
> > usual...
> > - I do develop on my notebook and move released applications to the Web
> server
> > - both have Sql Server 2000
> > - In this particular application I have a form login based on
> > Username/Password from a database table
> > - the start page of the application has a datagrid, both pages are
> accessing
> > ONE database but an other table
> > - It seems that the username and password are checked and validated
> against
> > the db (otherwise it would not try to load the next page) but for any
> reason
> > the SQL connection for any following page can not be established
> > - Some pages come up with "SQL Server does not exist or access denied "
> BUT
> > other have"tem.Data.SqlClient.SqlException: Could not find stored
> procedure
> > 'xxxxSelectCommand'
> >
> > Did anybody have something like this?
> > Thank you very much in advance.
> >
> > Cheers Oli
> >
>
>
>

Relevant Pages

  • ASP .Net connection to Sql Server
    ... It is connecting via a connection string similiar to: ... string to our production SQL server and everything runs fine. ... startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ...
    (microsoft.public.sqlserver.connect)
  • Re: ASP.NET/C# Accessing a SQL DB
    ... > on the webform. ... > SQL Server does not exist or access denied. ... > CommandBehavior behavior) +304 ... > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.data.ado)
  • Re: SQL Server does not exist or access denied - Solved
    ... The strange thig is that I do access the SQL server ... > Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ... >> You could catch the exception where it is being thrown and output the error ... >> the exception and what the error message is saying ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Databases in sql
    ... The second error looks like the connection string is wrong -either the ... Make sure your Sql Server is using Mixed mode ... > startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ...
    (microsoft.public.dotnet.languages.csharp)
  • SQL Server does not exist or access denied.
    ... am trying to run a simple .net code thro visual studio in which i just want ... to display table data into datagrid from sql server running on my local pc. ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.sqlserver.connect)