Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2004
    Posts
    3

    Unanswered: System.Data.SqlClient.SqlException: Login failed for user

    Here's the error stack:

    System.Data.SqlClient.SqlException: Cannot open database requested in login 'MYKYTYNMDB'. Login fails.
    Login failed for user 'OMM_IUSER'.
    at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
    at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
    at System.Data.SqlClient.SqlConnection.Open()
    at DreamweaverCtrls.DataSet.GetConnection(String strConnection)
    at DreamweaverCtrls.DataSet.DoInit()

    i have just exported all objects from one sql server to another and no matter how many times i check the password i keep getting this same error..
    I KNOW for a fact that the password and username are correct and that they have all of the correct permissions..
    what am i doing wrong?

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    What's your connectionstring?

  3. #3
    Join Date
    Jul 2004
    Posts
    3
    <add key="MM_CONNECTION_STRING_OMM_SQL_CONN" value="Persist Security Info=False;Data Source=192.168.0.7;Initial Catalog=MYKYTYNMDB;User ID=OMM_IUSER;Password=password;" />

  4. #4
    Join Date
    May 2003
    Location
    Rochester, NY
    Posts
    135
    have you tried connecting using the userid/password in Query Analyzer to make sure you can connect? If this fails is it possible you have an "Orphaned" userid?

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    This error indicates that you're connecting to non-existing database. Have you checked the spelling? Spaces at the end?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  6. #6
    Join Date
    Jul 2004
    Posts
    3
    rdjabarov: the database is existant, all that i did was change the ip address in the connection string from 192.168.0.9 to 192.168.0.7 the new server at which i had just completed importing all of the data and objects.


    rocket39: I will give that a try and reply with the results.


    thank you for your help

  7. #7
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    This error (Cannot open database requested in login 'MYKYTYNMDB'. Login fails.) can only occur when the database you're trying to connect to does not exist...Unless this situation exists...
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •