Skip to main content

3241 Error Using MS SQL 2008

Hi! Guys i found the another solution

I have face the error and every one tell the things different reasons but actually there are two major reasons for this error

1) You restore the version from Lower version to higher version (mean you get the back from SQL 2010 or SQL 2008 and restore in SQL 2005)

2) Your SQL server is 2008 or 2010 instance name on SQL 2005

Which is very rear but its happening with me and i found the solution here
http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/797cbb2a-f339-435c-a46f-79c4fe33d40d
And this solution is providing by IanlovesFrame



How you identify it

Open your sql server and check the instance name

Check out selected area in the screenshot there is a 9.xxxx value that mean this instance name is for SQL 2005

Why this error arrived 
If you have SQL 2005 before and you are installing SQL 2008 then it automatically select the 2005 instance name. Just select the new instance name for 2008 and the problem will be resolved

Regards
Rashid Bilgrami
http://www.bestvisualization.com 

Comments

Post a Comment

Thanks for the Comments , Your review will display soon

Popular posts from this blog

OLEDB jet 4.0 driver In Vista 64bit / he 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

Well i think you must be thankful for me specailly for this research i am really getting the solution after 6 month research that is how to enable the oledb jet 4.0 driver in vista, i read arround 100s of articles and maximum said that is not possible to enable it and ala bla well at the end i got the answer that is so easy Acctually that is correct that oledb jet 4.0 driver is not avaialble for 64 bit but if you run your IIS on 32 bit instead of 64 then Oledb jet will working fine Here are the steps Click on the Start > Program > Administrative Tool > IIS Management panel Select the Computer name Right click on the application pool and select properties Select "TRUE" in Enable 32 Bit Application by default it is false Then this problem will resolve if you need any assitance then feel free to email me rashidbilgrami@hotmail.com Regards Rashid Imran Bilgrami CEO Best visualization www.bestvisualization.com
3 comments
Read more

How to convert and crack windows server 2012 from Evaluation to Full

Dear All This is a way how you Convert Evalution to Full Step1: Open CMD and run following command DISM /online /Get-CurrentEdition <edition ID> is like ServerStandard with out Eval Step 2: DISM /online /Set-Edition:<edition ID> /ProductKey:XXXXX-XXXXX-XXXXX-XXXXX-XXXXX /AcceptEula WINDOWS SERVER 2012 Serial Key Windows Server 2012 DataCenter: 48HP8-DN98B-MYWDG-T2DCC-8W83P Datacenter: Y4TGP-NPTV9-HTC2H-7MGQ3-DV4TW Standard: XC9B7-NBPP2-83J2H-RHMBY-92BT4 Standard R2: DBGBW-NPF86-BJVTX-K3WKJ-MTB6V Server Essentials: K2XGM-NMBT3-2R6Q8-WF2FK-P36R2 For Standard R2 here is a command For R2 its like that DISM /online /Set-Edition:ServerStandard /ProductKey:DBGBW-NPF86-BJVTX-K3WKJ-MTB6V /AcceptEula Regards
Post a Comment
Read more

C# Generate All Dates between starting and ending date

Dear Readers This code  will return a generic list of DateTime containing the dates between a starting date and ending date:  //Here is the function private List<DateTime> GetDateRange(DateTime StartingDate, DateTime EndingDate) {     if (StartingDate > EndingDate)     {         return null;     }     List<DateTime> rv = new List<DateTime>();     DateTime tmpDate = StartingDate;     do     {         rv.Add(tmpDate);         tmpDate = tmpDate.AddDays(1);     } while (tmpDate <= EndingDate);     return rv; } //Here you call this function DateTime StartingDate = DateTime.Parse("02/25/2007"); DateTime EndingDate = DateTime.Parse("03/06/2007"); foreach (DateTime date in GetDateRange(StartingDate,EndingDate)) {    Response.Write(date.ToShortDateString()); } And it will r...
2 comments
Read more