Posts

Showing posts from February, 2011

MSSql Error 1088 - Cannot find the object "tuition_account_info" because it does not exist or you do not have permissions

Image
Following error is a simple and most easily seen error in transaction replication. The solution is also very simple. Read following blog to solve this in minutes. MSSql Error 1088 - Cannot find the object "tuition_account_info" because it does not exist or you do not have permissions Command attempted: if @@trancount > 0 rollback tran (Transaction sequence number: 0x00025E0E00011BE2000100000000, Command ID: 1) Let's Understand: The problem is that the object doesn't reside at the subscriber. The object is either deleted or was never created. There are two ways to resolve the problem: 1. Either uncheck the object name from the replication object list. 2. Or create the object in the subscriber with similer schema in publisher. Regards, Online Powershell and SQL Classes @ http://tuitionaffordable.webstarts.com

MSSQL Server Error: "Cannot generate SSPI context"

I got following alert on tow of my servers eg Tuitionaffordable11, Tuitionaffordable23: " Cannot generate SSPI context ". This error emerged when i try to connect these servers just like everyday work from other server. Some changes caused the connection broken for Tuitionaffordable11, Tuitionaffordable23. In 90% cases the issue is with spn settings. Let's go ahead and find the spn settings. Use following command to list all the spns setting: C:\>setspn -L TuteUTL12 Registered ServicePrincipalNames for CN=TuteUTL12,OU=General,OU=Terminal Servers,DC=tute,DC=net:         MSSQLSvc/Tuitionaffordable11.prod.tute.net:1433         MSSQLSvc/Tuitionaffordable23.prod.tute.net:1433 You can use following query to list all the spn settings for a particular account. setspn.exe -A MSSQLSvc/Tuitionaffordable11.PROD.tute.net:1433 MSSQLSvc/Tuitionaffordable11 MSSQLSvc/Tuitionaffordable12.prod.tute.net:1433 MSSQLSvc/Tuitionaffordable23.prod.tute.net Resolution : Let

DBCC CheckDB The operating system returned error 21(The device is not ready.)

Will Indian Rupee Cross 55?? Following error can be very difficult to deal with this error if not dealt properly. "DBCC CheckDB The operating system returned error 21(The device is not ready.)" Please follow following steps carefully. 1. run xp_readerrorlog and find the recent errors. 2. run xp_fixeddrives to see if all the drives can be read from sql server. 3. Look for the eventviewer. The issue can be some RAID controller or other h\w sources. 4. Don't detach the DB. 5. Look for restoring the latest backup if the problem is still a panic. 6. Do NOT restart neither your m\c nor your sql service. Along with technical learning I would like to share some great articles for anyone interested in the betterment of his/her family life Quality time with kids: Let's have a Quality Audit Parental guidance how to control your kid in elementary school not obeying teacher Parental guidance for child development post terrible twos Parenta