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 |
|
henrikop
Constraint Violating Yak Guru
280 Posts |
 Posted - 2003-09-01 : 09:56:38
|
| I'm working on a short project to work on some business logic.There's an enterprise webbased application using ASP and ASP.NET.This works on a MS Sql server (2000).I cannot modify records in the production tables, but I have the right to make triggers and additional databases. I have an admin account (sa_sql) in the domain DIENST which has all rights on all database on the sql-server. I made a trigger on a production table which makes a LOG record in the db ESIBS. No I get this error if I try to change a record in the application:[Microsoft][ODBC SQL Server Driver][SQL Server]Server user 'DIENST\sa_sql' is not a valid user in database 'ESIBS'.The user 'DIENST\sa_sql' is explicitly named as an (all rights) user in the ESIBS database. Still I get this message.Does anyone has a suggestion?Henri~~~Success is the ability to go from one failure to another with no loss of enthusiasm |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-01 : 14:20:51
|
| When you log on as that user and try to access the database what happens.Look at sysusers in that databases and check the suid for that user against syslogins.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
henrikop
Constraint Violating Yak Guru
280 Posts |
Posted - 2003-09-02 : 05:13:51
|
| If I log on with the account I can do whatever I want. And I can't find differenes between sysusers and suid in the syslogins. It looks like the application has it's own ways to write data in the database.It's uses an application role, but I can't see any rights given to this application role.I don't know where to search. It looks like the application only has right to 1 database.Henri~~~Success is the ability to go from one failure to another with no loss of enthusiasm |
|
|
|
|
|
|
not a valid user in database