Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
themuffinman_swe
Starting Member
3 Posts |
 Posted - 2005-06-13 : 09:50:53
|
| Hi!I'm working with a Java web app which is connected to a SQL server. The web app is running under tomcat. I have two databases that I'm working with, i.e two logical db's in the Enterprise Manager. A user, testUser, is supposed to have access to these.I can access and retrieve stuff from one of the db's, but not the other one. U can see the SQL Server error log at the bottom of the page. The tomcat error log produces a similar message.SQL Server is authenticating in mixed mode; both Win and sql server.Does anyone have a clue as to why this is happening?regardsJohan43:16.34 logon Login succeeded for user 'testUser'. Connection: Non-Trusted.2005-06-13 13:43:16.71 logon Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.2005-06-13 13:43:16.84 logon Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-13 : 10:45:06
|
| Does the sql server login have a user account in both DBs?Sean Roussy |
 |
|
|
themuffinman_swe
Starting Member
3 Posts |
Posted - 2005-06-13 : 11:04:50
|
| I think so, but how can check it to be sure? |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-13 : 11:29:50
|
| In sql em, expand your instance, expand databases, expand your database, double click on users.in sql qa login to the db and execute sp_helpuser with no arguments.Sean Roussy |
|
|
|
themuffinman_swe
Starting Member
3 Posts |
Posted - 2005-06-14 : 08:46:53
|
| Hi, yes my testuser appears in both tables. When i run the command in qa, my user is the db_owner. However, there are two more users, dbo and testuser2. The first one is also db_owner. The second one is db_datareader. Their Loginname and DefDBName are 'NULL' however. Could this make a difference? |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-14 : 10:47:24
|
| That sounds a little strange to me. It sounds like the server logins were disassociated with the db usernames but it is not the case with the userid we are concerned with. I might try fixing those accounts anyways.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
|
|
|
|
|
login failed for user'(null)' Not associated with