Post reply

Login failedfor user

  • March 12, 2012 at 3:22 pm

    #252889

    Moved from SQL2005 (shared) to SQL2008 (shared). Using ASP Classic. It worked fine in SQL2005 but I get the below error in SQL2008. I've granted every read/write permission to ukk_admin I could find. I login with this exact user with SSMS without issue. I've googled and cannot find any hint as to where I can look further. Suggestions?

    Microsoft OLE DB Provider for SQL Server error 80040e4d

    Login failed for user ukk_admin

    /rvw.asp, line 111

    <%

    'REMOTE CONNECT STRING

    Set MM_SQL31_STRING = Server.CreateObject("ADODB.Connection")

    MM_SQL31_STRING.Provider = "SQLOLEDB"

    MM_SQL31_STRING.Properties("Data Source").Value = "SQLB31.webcenter.com"

    MM_SQL31_STRING.Properties("Network Library").Value = "dbmssocn"

    MM_SQL31_STRING.Properties("Initial Catalog").Value = "ukk"

    MM_SQL31_STRING.Properties("User ID").Value = "ukk_admin"

    MM_SQL31_STRING.Properties("Password").Value = "ukk2000"

    %>

    Set connOrders = Server.CreateObject("ADODB.Connection")

    connOrders.Open(MM_SQL31_STRING) '<-- LINE 111

  • March 12, 2012 at 3:28 pm

    #1458210

    Do you need to use oledb?

    Have you verified the server name is correct?

    Can you change to Provider=SQLNCLI10.1?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 12, 2012 at 3:30 pm

    #1458213

    did you change the password in your configuration you posted to the web?? if not i would go change that now.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • March 12, 2012 at 3:31 pm

    #1458214

    "Login failed for user ukk_admin"

    means you connected to the server, so it's gotta be user/login related.

    on the new server, did you CREATE LOGIN ukk_admin ?

    if you restored a copy of the database, on a new server, you need to migrate the logins, and hten associate the orphaned logins to the users int he database:

    for example:

    create login ukk_admin with password = 'NotTheRealPassword'

    USE ukk;

    ALTER USER ukk_admin WITH LOGIN = ukk_admin

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 12, 2012 at 3:33 pm

    #1458216

    capn.hector (3/12/2012)

    did you change the password in your configuration you posted to the web?? if not i would go change that now.

    yeah - very good idea.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 12, 2012 at 3:56 pm

    #1458230

    I'm wondering what the state of the login failed message was, that might give us a clue.. You could probably get that from the errorlog..

    CEWII

  • March 13, 2012 at 7:31 am

    #1458457

    Do you need to use oledb?

    Yes

    Have you verified the server name is correct?

    Yes. This same string is use on multiple sites, including the present site. I can read on all sites using this string and write on other sites, but not write on this site.

    Can you change to Provider=SQLNCLI10.1?

    MM_SQL31_STRING.Provider = "SQLOLEDB" <-- with this I get the same login error

    MM_SQL31_STRING.Provider = "SQLOLEDB.1" <-- with this I get the same login error

    MM_SQL31_STRING.Provider = "SQLNCLI10" <-- with this I get provider not found

    MM_SQL31_STRING.Provider = "SQLNCLI10.1" <-- with this I get provider not found

    did you CREATE LOGIN ukk_admin

    I created the user ukk_admin through the GUI. I can view all users in the SECURITY section as well as all the dialog boxes for setting permissions.Reminder: I use this login ID when I login with SSMS.

    You could probably get that from the errorlog

    I will have to request this from admin because I'm on a shared server

    thanks!

  • March 13, 2012 at 1:53 pm

    #1458818

    <%

    'REMOTE CONNECT STRING

    Set MM_SQL31_STRING = Server.CreateObject("ADODB.Connection")

    MM_SQL31_STRING.Provider = "SQLOLEDB"

    MM_SQL31_STRING.Properties("Data Source").Value = "SQLB31.webcenter.com"

    MM_SQL31_STRING.Properties("Network Library").Value = "dbmssocn"

    MM_SQL31_STRING.Properties("Initial Catalog").Value = "ukk"

    MM_SQL31_STRING.Properties("User ID").Value = "ukk_admin"

    MM_SQL31_STRING.Properties("Password").Value = "ukk2000"

    MM_SQL31_STRING.open

    %>

    Set connOrders = Server.CreateObject("ADODB.Connection")

    connOrders.Open(MM_SQL31_STRING) '<-- LINE 111

    I found resolve, sort of, but I don't understand it. If I comment out "MM_SQL31_STRING.open", Line 111 will run, but my other recordsets will not run. So, I now have 2 identical connection strings, except for "MM_SQL31_STRING.open" commented out on one, on the same page.

    My question is why is this edit necessary on SQL2008? I'm missing something simple.

    Thanks!

  • March 13, 2012 at 2:13 pm

    #1458835

    shank-130731 (3/13/2012)

    <%

    'REMOTE CONNECT STRING

    Set MM_SQL31_STRING = Server.CreateObject("ADODB.Connection")

    MM_SQL31_STRING.Provider = "SQLOLEDB"

    MM_SQL31_STRING.Properties("Data Source").Value = "SQLB31.webcenter.com"

    MM_SQL31_STRING.Properties("Network Library").Value = "dbmssocn"

    MM_SQL31_STRING.Properties("Initial Catalog").Value = "ukk"

    MM_SQL31_STRING.Properties("User ID").Value = "ukk_admin"

    MM_SQL31_STRING.Properties("Password").Value = "ukk2000"

    MM_SQL31_STRING.open

    %>

    Set connOrders = Server.CreateObject("ADODB.Connection")

    connOrders.Open(MM_SQL31_STRING) '<-- LINE 111

    I found resolve, sort of, but I don't understand it. If I comment out "MM_SQL31_STRING.open", Line 111 will run, but my other recordsets will not run. So, I now have 2 identical connection strings, except for "MM_SQL31_STRING.open" commented out on one, on the same page.

    My question is why is this edit necessary on SQL2008? I'm missing something simple.

    Thanks!

    is this exact copy from your code?? i may not be well versed but should there be a ' after the MM_SQL31_STRING.open or REMOTE CONNECT STRING? and second if this is an exact copy of your code do you have any plans to change the now exposed username and password for your exposed server url?

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • March 13, 2012 at 2:25 pm

    #1458841

    Goto the errorlog on SQL and capture the two lines that show the login failure and post them here. It will help.

    CEWII

  • March 13, 2012 at 2:37 pm

    #1458850

    Username/password are fake.

    Apostrophe for commenting out line understood.

    re: error logs. The admin replied they don't show error logs to shared clients.

  • March 13, 2012 at 3:00 pm

    #1458868

    While I understand full logs you are asking for 2 lines.. It helps to know the exact error number, severity, and state. The state can tell us a lot in many cases.

    CEWII

  • March 14, 2012 at 11:11 am

    #1459375

    Here is one reference to login error 80040e4d:

    The DSN used to connect to the Commerce database is misconfigured to use Windows NT security instead of SQL Server standard security.

    http://support.microsoft.com/kb/222828

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • March 14, 2012 at 11:29 am

    #1459394

    Appreciated, but not using DSN.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply