sql server & .NET application issue... Chalanachithram.com | Topics | Search
Hide Clipart | Log Out | Register | Edit Profile

Last 30 mins | 1 | 2 | 4 hours     Last 1 | 7 Days

Chalanachithram.com DB » TF Industry related » Archive through October 17, 2008 » sql server & .NET application issue « Previous Next »

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this 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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

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?
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

why dont u turn on sql profiler and see whats the sql statements are executing.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Basky_indya:




friday kadha early vasthe early ga exit kottochani :-)
but Highly paid kadhu !
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Hp1:


very early today
mY Telugu Divine www.gurugeetha.blogspot.com
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


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 !
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Ntr_fan:

era taadi matta


Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Taurus:




era taadi matta..bagunnava..
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


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.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

DB ki unte aa db lo unde pathee table ki access unnattenaa?
In this db, there's always someone watching you!!
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Jodhaa:




adhi veru idhi veru
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

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!!
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Jodhaa:

BTW DB ki naaku Admin access vundi..still getting error




CCDB ki admin access vunda woww password enti
HASTA LA VICTORIA SIEMPRE
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

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

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x9ec4648){Movie Clipart}
Show / Hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  


Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: