Results 1 to 5 of 5

Thread: [2005] Login failed to database error

Threaded View

  1. Mar 8th, 2007, 11:22 AM #1
    super_nOOb
    super_nOOb is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2006
    Posts
    375

    [2005] Login failed to database error

    Hey guys,

    My issue is as follows. I had my application working fine.
    My connection was the following
    "Provider=SQLNCLI;Server=W02\SQLEXPRESS;Database=db1;Trusted_Connection=yes"

    Then i dicided to add a datasource. After adding the datasource i think it created a user instance in the SQL Express database. And now im getting this error

    Code:
     Login failed for user 'a\me'.
Cannot open database "db1" requested by the login. The login failed.
    Whenever i do the con.Open()

    How can i fix that?

    Now when i opend the SQL mgmt to see the database i can only see its name, but the tables are gone

    EDIT:
    I deleted the database from the SQL Express and deleted the dataset from VB.NEt and added the database again to the SQL Express. Now i can open the connections again in the VB.NET, but if i add the datasource again samething will happen. Im lost here
    Last edited by super_nOOb; Mar 8th, 2007 at 11:31 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width