SQL 2005 Security Issue SA

[knockyo]

(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

 

[cjard]

Nice to see you included the error messages...

 

[knockyo]

Nice to see you included the error messages...

so? what you means?

 

[damxuanthai]

(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

(Object references not xxxxx) What is xxxxxx error

 

[knockyo]

Object reference not set to an instance of an object​

 

[damxuanthai]

Please check the SQLconnection String, May be it cause Error.