Can do everything on a collection except check in. Get a "User Not Found: SA" exception

Unanswered Can do everything on a collection except check in. Get a "User Not Found: SA" exception

  • Monday, May 07, 2012 4:35 PM
     
     

    For starters, I am using the Linux client for tfs on ubuntu.

    Our team recently migrated the old collection that I was working on to a new collection.  Both collections reside on the same server.

    I have unmapped the old workfold, created a new profile, created a new workspace, mapped the new workspace.  I am able to sync up, i.e., tf get, with the new collection and even check out files.

    The issue is that I cannot check in my changes.  When I do, with or without the "-login" flag, I get the following exception:

    Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: User not found: SA
    at com.microsoft.tfs.core.internal.db.ConnectionConfiguration.createNewConnection(ConnectionConfiguration.java:233)
    at com.microsoft.tfs.core.internal.db.ConnectionPool.getConnection(ConnectionPool.java:48)
    at com.microsoft.tfs.core.internal.db.ConnectionPool.executeWithPooledConnection(ConnectionPool.java:67)
    at com.microsoft.tfs.core.clients.workitem.internal.metadata.Metadata.<init>(Metadata.java:131)
    at com.microsoft.tfs.core.clients.workitem.internal.WITContext.<init>(WITContext.java:95)
    at com.microsoft.tfs.core.clients.workitem.WorkItemClient.getContext(WorkItemClient.java:359)
    at com.microsoft.tfs.core.clients.workitem.WorkItemClient.query(WorkItemClient.java:521)
    at com.microsoft.tfs.client.clc.vc.commands.CommandCheckin.checkWorkItems(CommandCheckin.java:354)
    at com.microsoft.tfs.client.clc.vc.commands.CommandCheckin.run(CommandCheckin.java:181)
    at com.microsoft.tfs.client.clc.Application.run(Application.java:294)
    at com.microsoft.tfs.client.clc.Application.run(Application.java:144)
    at com.microsoft.tfs.client.clc.vc.Main.main(Main.java:33)
    Caused by: java.sql.SQLException: User not found: SA
    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
    at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
    at org.hsqldb.jdbcDriver.connect(Unknown Source)
    at com.microsoft.tfs.core.internal.db.ConnectionConfiguration.createNewConnection(ConnectionConfiguration.java:218)
    ... 11 more

    I've gone back and started from a clean machine, i.e., removed all tfs assets, deleted all profiles and workspaces on the tfs server, and still get the same error.  Also, I went back and recreated a profile for the old collection that I worked on before and was able to make changes and check those in.  

    Also, our tfs admin has given my account admin privileges, and we still have not had any success.

All Replies

  • Thursday, June 07, 2012 5:34 PM
     
     

    Did you find the solution for this problem?

    If not, could you go ~/.micorosft/Team Explorer/10.0 and do a recursive search for a file with the name teamexplorer.script?

    Open this file and search for "CREATE USER".   The line 'CREATE USER SA PASSWARD ""' should be near the top of this file.  Is it there?

    Thanks,
    Rick