| Author |
Message |
   
Jodhaa
Side Hero Username: Jodhaa
Post Number: 6591 Registered: 02-2008 Posted From: 75.185.75.109
Rating: N/A Votes: 0 (Vote!) | | Posted on Friday, October 17, 2008 - 12:29 am: |
    |
Gotcha:u r using which account to search. does the application impersoante as a sql account or is it using windows account? does that account have dbo access?
sql account..Yes, it have DBO access. No one can make you feel inferior without your permission, remember they are no better |
   
Gotcha
Comedian Username: Gotcha
Post Number: 1584 Registered: 02-2008 Posted From: 24.1.161.76
Rating: N/A Votes: 0 (Vote!) | | Posted on Friday, October 17, 2008 - 12:13 am: |
    |
u r using which account to search. does the application impersoante as a sql account or is it using windows account? does that account have dbo access? |
   
Jodhaa
Side Hero Username: Jodhaa
Post Number: 6581 Registered: 02-2008 Posted From: 75.185.75.109
Rating: N/A Votes: 0 (Vote!) | | Posted on Friday, October 17, 2008 - 12:08 am: |
    |
Gotcha:why dont u turn on sql profiler and see whats the sql statements are executing.
idhi on chesey trace chesthunna kani..asalu DB ney hit avvatam ledhu when I open the application & trying to search for a customer..  No one can make you feel inferior without your permission, remember they are no better |
   
Gotcha
Comedian Username: Gotcha
Post Number: 1583 Registered: 02-2008 Posted From: 24.1.161.76
Rating: N/A Votes: 0 (Vote!) | | Posted on Friday, October 17, 2008 - 12:03 am: |
    |
why dont u turn on sql profiler and see whats the sql statements are executing. |
   
Jodhaa
Side Hero Username: Jodhaa
Post Number: 6579 Registered: 02-2008 Posted From: 75.185.75.109
Rating: N/A Votes: 0 (Vote!) | | Posted on Friday, October 17, 2008 - 12:01 am: |
    |
Gotcha:did u restore the db from one server onto another sever maybe user ids orphan ayayi emo if u did restore from a different server. use sql profiler to verify.
nope, DB restore cheyyaledhu..Erwin nunchi schema generate chesi with all the tables & relations 2008 lo kotha DB create chesam..already working DEV DB vundi..dhaaniki link chesthey app working fine kani kotha DB ki vachetappatiki issues start ayyaye... points to remember 1. Konni tables data import cheyyaledhu from old DB , becs it has junk data. So junk data ni avoid chesam. 2. Few master/REF tables are empty. No one can make you feel inferior without your permission, remember they are no better |
   
Gotcha
Comedian Username: Gotcha
Post Number: 1582 Registered: 02-2008 Posted From: 24.1.161.76
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 11:51 pm: |
    |
did u restore the db from one server onto another sever maybe user ids orphan ayayi emo if u did restore from a different server. use sql profiler to verify. |
   
Hp1
Junior Artist Username: Hp1
Post Number: 406 Registered: 05-2008 Posted From: 203.17.68.1
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 06:50 pm: |
    |
Basky_indya:
friday kadha early vasthe early ga exit kottochani  but Highly paid kadhu ! |
   
Basky_indya
Hero Username: Basky_indya
Post Number: 11050 Registered: 10-2007 Posted From: 65.30.78.134
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 06:44 pm: |
    |
Hp1:
very early today mY Telugu Divine www.gurugeetha.blogspot.com |
   
Hp1
Junior Artist Username: Hp1
Post Number: 405 Registered: 05-2008 Posted From: 203.17.68.1
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 06:43 pm: |
    |
Basky_indya:check the PRIVILIGES for the SQL USER in MASTER TABLE.
naku thelisndhi kooda inthe... intha kante okka mukka ekkuva gani thakkuva gani naku thelvadhu jodha...... Itlu neeku emi help cheyyaleni oo chelli  but Highly paid kadhu ! |
   
Jodhaa
Side Hero Username: Jodhaa
Post Number: 6571 Registered: 02-2008 Posted From: 208.11.223.20
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 05:17 pm: |
    |
Taurus:sql profiler turn on chesi chudu, asalu db ki connect avutundo ledo telustundi, connect avvakapote application debug cheyyi.
Yep idhi chesa..asalu DB ki connect avvatam ledhu..let me ask dev folks to debug the application.. No one can make you feel inferior without your permission, remember they are no better |
   
One
Comedian Username: One
Post Number: 1248 Registered: 09-2008 Posted From: 66.67.114.55
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 04:59 pm: |
    |
Ntr_fan:era taadi matta
 |
   
Ntr_fan
Hero Username: Ntr_fan
Post Number: 10180 Registered: 02-2008 Posted From: 68.214.12.93
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 04:48 pm: |
    |
Taurus:
era taadi matta..bagunnava.. |
   
Basky_indya
Hero Username: Basky_indya
Post Number: 11024 Registered: 10-2007 Posted From: 65.30.78.134
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 04:45 pm: |
    |
JOdha, web.config lo DB setting lo, Trusted_connection = true ani chesi choodu. if doesnt work then it could be in sqlserver issue, check the PRIVILIGES for the SQL USER in MASTER TABLE. GRANT ALL execute permisions for select,update,etc on all Tables. mY Telugu Divine www.gurugeetha.blogspot.com |
   
Taurus
Junior Artist Username: Taurus
Post Number: 110 Registered: 03-2008 Posted From: 74.176.89.147
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 04:42 pm: |
    |
Jodhaa:Dev team ki clean & working DB ivvataaniki try chesthunna..kaani application ki na DB hook chesi test chesthuntey, konni services distable aye vunnaye..like AddnewCustomer one. & when I am trying to search for a customer..exception vasthundhi..You dont have privilege to search for a customer ani..what could be the problem? any ideas?
sql profiler turn on chesi chudu, asalu db ki connect avutundo ledo telustundi, connect avvakapote application debug cheyyi. |
   
Mallik
Junior Artist Username: Mallik
Post Number: 215 Registered: 10-2008 Posted From: 69.27.233.254
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 04:38 pm: |
    |
DB ki unte aa db lo unde pathee table ki access unnattenaa?  In this db, there's always someone watching you!!  |
   
Siloan
Side Hero Username: Siloan
Post Number: 5086 Registered: 03-2008 Posted From: 155.201.35.54
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 04:37 pm: |
    |
Jodhaa:
adhi veru idhi veru |
   
Jodhaa
Side Hero Username: Jodhaa
Post Number: 6570 Registered: 02-2008 Posted From: 208.11.223.20
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 04:36 pm: |
    |
Jodhaa:DB ki naaku Admin access vundi..still getting error
Mallik:Nuvvu connect ayye userid ki nee local db ki access previleges sekking seyyi...
No one can make you feel inferior without your permission, remember they are no better |
   
Mallik
Junior Artist Username: Mallik
Post Number: 210 Registered: 10-2008 Posted From: 69.27.233.254
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 04:23 pm: |
    |
Naa field idi kaadu.. but naa intelligent brain suggestions.. Nuvvu connect ayye userid ki nee local db ki access previleges sekking seyyi... In this db, there's always someone watching you!!  |
   
Mass
Side Hero Username: Mass
Post Number: 4639 Registered: 04-2008 Posted From: 12.168.68.11
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 03:47 pm: |
    |
Jodhaa:BTW DB ki naaku Admin access vundi..still getting error
CCDB ki admin access vunda woww password enti HASTA LA VICTORIA SIEMPRE |
   
Jodhaa
Side Hero Username: Jodhaa
Post Number: 6555 Registered: 02-2008 Posted From: 208.11.223.20
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 03:37 pm: |
    |
BTW DB ki naaku Admin access vundi..still getting error No one can make you feel inferior without your permission, remember they are no better |
   
Jodhaa
Side Hero Username: Jodhaa
Post Number: 6554 Registered: 02-2008 Posted From: 208.11.223.20
Rating: N/A Votes: 0 (Vote!) | | Posted on Thursday, October 16, 2008 - 03:26 pm: |
    |
Dev team ki clean & working DB ivvataaniki try chesthunna..kaani application ki na DB hook chesi test chesthuntey, konni services distable aye vunnaye..like AddnewCustomer one. & when I am trying to search for a customer..exception vasthundhi..You dont have privilege to search for a customer ani..what could be the problem? any ideas? No one can make you feel inferior without your permission, remember they are no better |