Re: Newbie needs code pages for SQL Server 2000 access from asp.net page using vb.net

From: Lori (__---LoriG----__at_yahoo.com)
Date: 09/11/03 

Date: Thu, 11 Sep 2003 10:18:17 -0400

And another thing.
The Microsoft error message is so misleading.
If there is a problem with IIS permissions why the hell does it say
"SQL server does not exist ?" Very helpful if troubleshooting is it not , by
misleading you ?
Also "access denied" by whom by SQL server ? By 2000 Server ? By IIS ?
Can they be anymore vague ?

"S. Justin Gengo" <sjgengo@aboutfortunate.com> wrote in message
news:eNMgDwGeDHA.1748@TK2MSFTNGP10.phx.gbl...
> Lori,
>
> When you are connecting to SQL server in integrated security mode IIS is
> passing SQL server the account used to run the website. If you haven't
> changed the web site to use impersonation (you would do that in the
> web.config file) then the site is passing SQL server the anonymous login
> account which the website would normally run under. Depending on your
needs
> their are multiple ways to configure this.
>
> Here's a good article to get you started:
>
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;q176378
>
> Sincerely,
>
> --
> S. Justin Gengo, MCP
> Web Developer
>
> Free code library at:
> www.aboutfortunate.com
>
> "Out of chaos comes order."
> Nietzche
>
>
> "Lori" <__---LoriG----_@yahoo.com> wrote in message
> news:bjpt0d$li3vt$1@ID-158805.news.uni-berlin.de...
> >
> >
> > I am only trying to connect to a local host .
> > I am on Windows 2000 Server with sql 2000 server.
> >
> >
> > My error is the classic "SQL server does not exist or access denied"
> > I went to the MS site & they tell me what I know......"some"
permissioning
> > issue.
> >
> > I had this code working 2 months ago on a different server but now I
> cannot
> > get it going now on a different
> > machine
> >
> > I can setup ODBC connections every which way to this local server using
> > Integrated mode access
> > using different connectivity methods such as by using "local" or
> > <machinename> or 127.0.0.1 or <machine IP address>. I can also connect
> > using SQL authentication for user sa or some other new user I created.
> > So I am not sure about this access denied BS.
> >
> > I need to connect to Northwind & pubs dbs (the sample dbs that come with
> sql
> > 2000)
> > Please post the complete page in (without code behind crap for now).
> >
> > I went to different sites & they have partial code & they cause
different
> > errors ( I am not a Vb.net guru)
> >
> > The page I used is something similar to below.
> >
> > I am just trying to connect & print the server name & SQL version etc
> >
> > '================
> > Sub Page_Load(Source As Object, E As EventArgs)
> >
> > Dim strConnection1 As String = "server=localhost; database=Northwind; "
&
> _
> >
> > "integrated security=true"
> >
> > Dim objConnection As New SqlConnection(strConnection)
> >
> > Dim strSQL As String = "SELECT FirstName, LastName, Country " & _
> >
> > "FROM Employees;"
> >
> > Dim objCommand As New SqlCommand(strSQL, objConnection)
> >
> > objConnection.Open()
> >
> > Response.Write("ServerVersion: " & objConnection.ServerVersion & _
> >
> > vbCRLF & "Datasource: " & objConnection.DataSource & _
> >
> > vbCRLF & "Database: " & objConnection.Database)
> >
> > dgNameList.DataSource = objCommand.ExecuteReader()
> >
> > dgNameList.DataBind()
> >
> > objConnection.Close()
> >
> > End Sub
> >
> > '==================
> >
> > Can someone tell me what is wrong & also ALL the authentication settings
> > step by step I need in Windows 2000 server / SQL 2000 server ?
> > This is just the freaking local machine & server. I cannot believe this
is
> > so hard.
> > Last time someone in some newsgroup had me play with registry settings
to
> > make this work
> > in addition to some other Windows 2000 user changes
> > (Sorry I did not save it ...did not know this would be so bad)
> >
> > I would prefer a complete code page that does both Integrated Auth (as
> > above) and also
> > SQL auth (using Username / PW).
> > (I know the actual call is a one or two line code but the exact format
> > without syntax or other errors is the key)
> >
> >
> > I don't have VS-7 so I cannot drag & drop the SQL connector control as
> > someone suggested.
> >
> >
> >
> >
> >
> >
> >
>
>

Relevant Pages

  • RE: Log Reader Agent fails: could not execute sp_MSadd_repl_commands27
    ... parameter myself for the same reason. ... little misleading. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Moving mdb Queries to SQL Server or adp
    ... > The title on my previous post was misleading. ... > Is there an easy way to "upsize" mdb QBE queries to SQL Server? ... if you simply upsize the Access back-end database to SQL Server ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trying to determine if SQL Server exists and is running
    ... That is the only way I know how to do it right now, but I'd like to avoid ... the lengthy timeout and just be able to read a status. ... I'd like to know if there is a way to determine if the SQL Server ... sometimes the error is misleading and is actually cauesed by ...
    (microsoft.public.vb.general.discussion)
  • RE: remote SQL dosnt Work
    ... The error may be misleading - Did you manually create the SMS database in SQL Server? ... We found that the SMS installation can't create the database if it is a remote SQL Server. ...
    (microsoft.public.sms.setup)
  • Re: Newbie needs code pages for SQL Server 2000 access from asp.net page using vb.net
    ... www.aboutfortunate.com "Out of chaos comes order." ... > The Microsoft error message is so misleading. ... Justin Gengo" wrote in message ... >> passing SQL server the account used to run the website. ...
    (microsoft.public.dotnet.framework.aspnet.security)
Quantcast