Re: Login failed for user

Line 42: connOrders.Open(MM_SQLD3_STRING)
The above is line 42. I can read in the whole site. Profiles,
recordsets,etc. But when I try to write anything to a table, I get the
error.

thanks



"Aaron Bertrand [SQL Server MVP]" <ten.xoc@xxxxxxxxxxxxxx> wrote in message
news:C6626D43.1D7F3%ten.xoc@xxxxxxxxxxxxxxxxx
What is line 42? This error SHOULD happen on the .open line for the
connection itself, so should have absolutely nothing to do with whether
you
are reading or writing.




On 6/20/09 10:30 AM, in article ueWHKLb8JHA.2120@xxxxxxxxxxxxxxxxxxxx,
"shank" <shank@xxxxxxxxxxxxxxx> wrote:

I'm on a shared server and don't have access to the logs. Support said
they'd send them overnight. Didn't happen. Here's what's happening...

1) I'm using the same connect string as on all my other sites. This
particular site is on a different network than all others. I don't think
that makes a difference though.

2) I can login with SSMS using the below user/password. I can also
edit/update a record in the same tables I'm accessing with SSMS.

3) But from the website, I can only read. I cannot write. That's when I
get
the error.

4) The DB owner is 'chic' and the schema name is 'abn'.

5) The table I'm trying to write to is: STH > Properties > Permissions >
View schema permissions > View database permissions > Effective
permissions
and for user 'chic' I have it appears all permissions including delete,
insert, update.

6) The table I'm trying to write to is: STH > Properties > Permissions >
View schema permissions > Effective permissions and for user 'chic' I
have
it appears all permissions including delete, insert, update.

What can I do to troubleshoot further?

Schema Name: abn
Owner: chic

Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'Chic'.
/rev.asp, line 42

Connect string in Dreamweaver:
<%
'REMOTE CONNECT STRING
Set MM_SQLD3_STRING = Server.CreateObject("ADODB.Connection")
MM_SQLD3_STRING.Provider = "sqloledb"
MM_SQLD3_STRING.Properties("Data Source").Value =
"SQLD3.sqlcontrolcenter.com"
MM_SQLD3_STRING.Properties("Network Library").Value = "dbmssocn"
MM_SQLD3_STRING.Properties("Initial Catalog").Value = "MyDB"
MM_SQLD3_STRING.Properties("User ID").Value = "Chic"
MM_SQLD3_STRING.Properties("Password").Value = "password"
MM_SQLD3_STRING.open
%>

thanks
====================================
"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:%23Gra9IL8JHA.4820@xxxxxxxxxxxxxxxxxxxxxxx
shank
Has the user mapped to to the login? Do you connect succefull from SSMS?
Please look at the state of the error from ERROR.LOG which you have not
provided


"shank" <shank@xxxxxxxxxxxxxxx> wrote in message
news:%23EuWlnH8JHA.1740@xxxxxxxxxxxxxxxxxxxxxxx
I'm using classic ASP and trying to insert an order into SQL2005
tables.
I've done this many times using the same connect string on other sites.
On this site I'm getting the below error. One big difference between
this
site is it's on a totally different host than the others. But I don't
think that should be an issue.

Schema Name: abn
Owner: chic

Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'Chic'.
/rev.asp, line 42

Connect string in Dreamweaver:
<%
'REMOTE CONNECT STRING
Set MM_SQLD3_STRING = Server.CreateObject("ADODB.Connection")
MM_SQLD3_STRING.Provider = "sqloledb"
MM_SQLD3_STRING.Properties("Data Source").Value =
"SQLD3.sqlcontrolcenter.com"
MM_SQLD3_STRING.Properties("Network Library").Value = "dbmssocn"
MM_SQLD3_STRING.Properties("Initial Catalog").Value = "MyDB"
MM_SQLD3_STRING.Properties("User ID").Value = "Chic"
MM_SQLD3_STRING.Properties("Password").Value = "password"
MM_SQLD3_STRING.open
%>

Suggestions on possible things I have wrong?
How do I troubleshoot?

thanks!








.

Relevant Pages

  • Re: Login failed for user
    ... I'm using the same connect string as on all my other sites. ... The DB owner is 'chic' and the schema name is 'abn'. ... View schema permissions> View database permissions> Effective permissions ... Microsoft OLE DB Provider for SQL Server error '80040e4d' ...
    (microsoft.public.sqlserver.programming)
  • Re: Login failed for user
    ... I'm using the same connect string as on all my other sites. ... The DB owner is 'chic' and the schema name is 'abn'. ... View schema permissions> View database permissions> Effective permissions ...
    (microsoft.public.sqlserver.programming)
  • Re: Permissions
    ... Do the objects have the same owner ... I have a table, myTable, in a schema named Schema1. ... The permissions on Schema1.myTable are left unchanged (no ... This is Sql Server 2005 Standard, ...
    (microsoft.public.sqlserver.server)
  • Default permissions for schema owner
    ... Can someone please list down the set of default permissions that the ... owner of a schema gets by default? ... Atleast the very basic and ...
    (microsoft.public.sqlserver.security)
  • Re: Cross-database execution permissions with certificates and sch
    ... around the service broker activated user. ... I agree that this is a good use of schema as a security boundary. ... The comment about schema scoped permissions not being applicable in my ... the certificate is a trusted authenticator because you granted AUTHENTICATE ...
    (microsoft.public.sqlserver.security)
Quantcast