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

From: S. Justin Gengo (sjgengo_at_aboutfortunate.com)
Date: 09/11/03 

Date: Thu, 11 Sep 2003 08:52:58 -0500

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: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: DCOM Error - Event 10009
    ... using SQL Server Management Studio 2005. ... Whenever we first launch SQL ... when connecting to a different registered server, it will hang again for 5 - ... I have checked DCOM Config using dcomcnfg, ...
    (microsoft.public.sqlserver.clients)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Heres a weird one for all of you...
    ... SQL: SQL 2005 Demo ... SQL 2005 Processor Licensed (connecting via port 14330) ... Additional Major S/W on that server: ... logs showed was an operation timeout error, ...
    (microsoft.public.sqlserver.connect)