Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Major security problems - urgent

3 posts in Windows NT Last posting was on 2000-03-20 22:13:11.0Z
Matthew Rogers Posted on 2000-03-20 22:13:11.0Z
From: "Matthew Rogers" <mrogers@conexsys.aca.ca>
Subject: Major security problems - urgent
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <mPuB4.36295$Jz3.379252@nnrp1.uunet.ca>
Date: Mon, 20 Mar 2000 14:13:11 -0800
Organization: UUNET Canada News Reader Service
Newsgroups: comp.databases.ms-sqlserver,sybase.public.sqlserver.nt
NNTP-Posting-Host: penny.tagonline.com 198.138.69.45
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2400
Article PK: 1089855

Normally I'm not this frantic, but I have to have this problem resolved by
the end of today. I need to access my SQL Server (7.0) from my Web Server,
BUT this error comes up:

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
Reason: Not associated with a trusted SQL Server connection. My code looks
like:

<%@Language=VBScript %>
<%

Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "conexWeb"

set rs=server.CreateObject("adodb.recordset")
rs.Open "register",Conn,2,2

Where conexWeb is the ODBC connection on the WebServer. Even if I try
adding in the administrator account:

Conn.Open "conexWeb", "Administrator","WhateverPassword"

That doesn't help. The error will say "... Login failed for user
'Administrator'..."; or whatever other user I try to add in.

Facts:
------
- I tried using the KB articles, but they didn't help.
- 2 books I have don't help.
- My Intranet can access the database prefect.
- Intranet IIS and SQL Server reside on the same computer
- ODBC setup on web server generates the above error as well, during set up,
and when I test data source.
- Tried ODBC using WinNT and SQL Security; same result - no trusted
connection
- Company network uses Novell Client
- Website is accessed through a firewall.


If anyone can offer ANY suggestions, it would be a life saver. It seems
like I've tried everything and I'm gong around in circles.

Thanks for the help,


Matt Rogers


Jason Froebe Posted on 2000-03-20 21:15:57.0Z
Message-ID: <38D6950D.DBD31C97@sybase.com>
Date: Mon, 20 Mar 2000 15:15:57 -0600
From: Jason Froebe <jfroebe@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Matthew Rogers <mrogers@conexsys.aca.ca>
Subject: Re: Major security problems - urgent
References: <mPuB4.36295$Jz3.379252@nnrp1.uunet.ca>
Content-Type: multipart/mixed; boundary="------------19F2885200AAD4F88FECB8A8"
Newsgroups: comp.databases.ms-sqlserver,sybase.public.sqlserver.nt
Lines: 62
NNTP-Posting-Host: jfroebe-desktop.sybase.com 157.133.46.52
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2399
Article PK: 1089851


Matthew Rogers wrote:

> Normally I'm not this frantic, but I have to have this problem resolved by
> the end of today. I need to access my SQL Server (7.0) from my Web Server,
> BUT this error comes up:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
> Reason: Not associated with a trusted SQL Server connection. My code looks
> like:
>
> <%@Language=VBScript %>
> <%
>
> Set Conn=Server.CreateObject("ADODB.Connection")
> Conn.Open "conexWeb"
>
> set rs=server.CreateObject("adodb.recordset")
> rs.Open "register",Conn,2,2
>
> Where conexWeb is the ODBC connection on the WebServer. Even if I try
> adding in the administrator account:
>
> Conn.Open "conexWeb", "Administrator","WhateverPassword"
>
> That doesn't help. The error will say "... Login failed for user
> 'Administrator'..."; or whatever other user I try to add in.
>
> Facts:
> ------
> - I tried using the KB articles, but they didn't help.
> - 2 books I have don't help.
> - My Intranet can access the database prefect.
> - Intranet IIS and SQL Server reside on the same computer
> - ODBC setup on web server generates the above error as well, during set up,
> and when I test data source.
> - Tried ODBC using WinNT and SQL Security; same result - no trusted
> connection
> - Company network uses Novell Client
> - Website is accessed through a firewall.
>
> If anyone can offer ANY suggestions, it would be a life saver. It seems
> like I've tried everything and I'm gong around in circles.
>
> Thanks for the help,
>
> Matt Rogers

Hi Matt,

You should post your question in the microsoft.* newsgroups as the sybase.*
newsgroups are entirely different.

thanks

Jason


Download VCard jfroebe.vcf


Ivan Santhumayor Posted on 2000-03-20 20:21:55.0Z
From: Ivan Santhumayor <ivan.santhumayor@gs.com>
Subject: Re: Major security problems - urgent
Date: Mon, 20 Mar 2000 15:21:55 -0500
Organization: Goldman Sachs & Co.
Lines: 58
Message-ID: <38D68863.7D1E77CD@gs.com>
References: <mPuB4.36295$Jz3.379252@nnrp1.uunet.ca>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.03 [en]C-CPT_1.1.0 (WinNT; I)
Newsgroups: comp.databases.ms-sqlserver,sybase.public.sqlserver.nt
NNTP-Posting-Host: penny.tagonline.com 198.138.69.45
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2398
Article PK: 1089852

Your MS-SQLServer needs to be configured to accept Standard security (SQLServer
and Windows NT) as well.
Also, Edit your ODBC DSN setting, and uncheck the trusted connecting setting.
That should make the authentication purely on sqlserver login/passwd which
should solve the problem.
If this does not work, you may have to granted trusted access to Adminstrator
using xp_grantlogin

Matthew Rogers wrote:

> Normally I'm not this frantic, but I have to have this problem resolved by
> the end of today. I need to access my SQL Server (7.0) from my Web Server,
> BUT this error comes up:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
> Reason: Not associated with a trusted SQL Server connection. My code looks
> like:
>
> <%@Language=VBScript %>
> <%
>
> Set Conn=Server.CreateObject("ADODB.Connection")
> Conn.Open "conexWeb"
>
> set rs=server.CreateObject("adodb.recordset")
> rs.Open "register",Conn,2,2
>
> Where conexWeb is the ODBC connection on the WebServer. Even if I try
> adding in the administrator account:
>
> Conn.Open "conexWeb", "Administrator","WhateverPassword"
>
> That doesn't help. The error will say "... Login failed for user
> 'Administrator'..."; or whatever other user I try to add in.
>
> Facts:
> ------
> - I tried using the KB articles, but they didn't help.
> - 2 books I have don't help.
> - My Intranet can access the database prefect.
> - Intranet IIS and SQL Server reside on the same computer
> - ODBC setup on web server generates the above error as well, during set up,
> and when I test data source.
> - Tried ODBC using WinNT and SQL Security; same result - no trusted
> connection
> - Company network uses Novell Client
> - Website is accessed through a firewall.
>
> If anyone can offer ANY suggestions, it would be a life saver. It seems
> like I've tried everything and I'm gong around in circles.
>
> Thanks for the help,
>
> Matt Rogers