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 |
|
knockyo
Yak Posting Veteran
83 Posts |
 Posted - 2007-04-09 : 22:39:09
|
| (1) I have web program (asp.net) and using database SQL 2005.(2) My program that generate result need pass through with stored procedure.Here is my problem:- I can run and no problems at my local PC- If bring to company server, it have a problem at my coding. (Object references not xxxxx)- My local PC, User is using SA- My company server, User is not using SA- If using SA at server, will not causing any errors.i know that is my database setting problems.Somebody know the reasons?Thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-09 : 23:39:32
|
what's the exact error msg?and good for you for not wanting to login as SA in production. even better would be if you didn't develop it that way to begin with...
www.elsasoft.org |
 |
|
|
knockyo
Yak Posting Veteran
83 Posts |
Posted - 2007-04-09 : 23:56:59
|
| hi jez,actually just occur error msg at my coding "Object references not xxxx", in the SQL server did not appear.So, i suspect is the Security setting problems, have any idea?Thanks |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-10 : 00:28:37
|
well, it sounds like your code is dereferencing null. I suggest you debug your code and find out.
www.elsasoft.org |
|
|
|
knockyo
Yak Posting Veteran
83 Posts |
Posted - 2007-04-10 : 01:50:44
|
| code? i think not, why?reason:WORKS- i at local PC can work and using SA owner.- i use SA owner at company server can workFAILED- i use xxx owner did not work.So.... |
|
|
|
|
|
|
SQL Security Issue