Finally SQL server 2012 is working and able to attach Northwind database to it. I am able to enable SQL authentication.
What are the out coming bugs I will find??? Stay tuned.
You can download the Northwind.mdf from my skydrive if you want to play with it.
About chanmingman
Since March 2011 Microsoft Live Spaces migrated to Wordpress (http://www.pcworld.com/article/206455/Microsoft_Live_Spaces_Moves_to_WordPress_An_FAQ.html) till now, I have is over 1 million viewers. This blog is about more than 50% telling you how to resolve error messages, especial for Microsoft products. The blog also has a lot of guidance teaching you how to get stated certain Microsoft technologies. The blog also uses as a help to keep my memory. The blog is never meant to give people consulting services or silver bullet solutions. It is a contribution to the community. Thanks for your support over the years.
Ming Man is Microsoft MVP since year 2006. He is a software development manager for a multinational company. With 25 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He has been using Visual Studio (.NET) since the Beta back in year 2000. He and the team have developed many projects using .NET platform such as SCM, and HR based applications. He is familiar with the N-Tier design of business application and is also an expert with database experience in MS SQL, Oracle and AS 400.
Hi Ming, Thanks for the post. When I tried to download the NORTHWIND MDF 2012 from the link provided above from skydrive, it does not take me to the right location. Please do the needful. Thanks
you didn’t include the log file, or am I missing something?
Sorry, didn’t realize you could just delete the the attach for the log. It installed and so far so good. Thanks for making this available.
hey mate, i am unable to attach your file too in server 2012 😦 help me plz
Is this https://chanmingman.wordpress.com/2012/08/20/unable-to-open-the-physical-file-cdatabasedatabase-mdf-operating-system-error-5-5access-is-denied/ similar to your problem?
Im getting this error… i removed the log file when im attaching the database and still…please help Thanks.
TITLE: Microsoft SQL Server Management Studio
——————————
Attach database failed for Server ”. (Microsoft.SqlServer.Smo)
——————————
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
——————————
Could not open new database ‘northwind’. CREATE DATABASE is aborted.
File activation failure. The physical file name “D:\Database\NORTHWND_log.ldf” may be incorrect.
The log cannot be rebuilt when the primary file is read-only. (Microsoft SQL Server, Error: 1813)
Try check this.
My thanks good sir. I wanted to add Northwind to SQL 2012 and its done!
Could you please help me? I see that you have the file that i need. I am looking for the northwind sample database for sql 2012. i have been trying to update the northwind file to be 2012 but just keep running into headaches. If you have 2012 compatiable version that i can download off your skydrive i would love to download it. i have clicked on your link above but it doesn’t seem to take me to your skydrive. so any help in retriveing it from you drive would be helpful. thanks in advance for all you hard work in getting this file in the first place and thank you for any help you can give me in getting it to me. thank you!!
You can get it here:
http://archive.msdn.microsoft.com/northwind/Release/ProjectReleases.aspx?ReleaseId=1401
Thank you for your link. I downloaded your sample database and I still get the same error. i am pasting the error info here to see if i can get some more guidance. I am trying to attach the northwind database in sql2012. heres the error:
Attach database failed for Server ‘KKENNEDY-LAPTOP\MSSQLSERVERGSK’. (Microsoft.SqlServer.Smo)
——————————
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476
——————————
Program Location:
at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.Attach()
at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SendDataToServer()
===================================
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
——————————
Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Server.AttachDatabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files)
===================================
Database ‘Northwind’ cannot be upgraded because its non-release version (539) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.
Could not open new database ‘Northwind’. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)
——————————
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=950&LinkId=20476
——————————
Server Name: KKENNEDY-LAPTOP\MSSQLSERVERGSK
Error Number: 950
Severity: 20
State: 1
Line Number: 1
——————————
Program Location:
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
Upgrade the database and see
you can get “a little bit modified version that included some features of SQL 2005+”
or for the other Databases too .
http://code.google.com/p/northwindextended/downloads/list
Pingback: Creating ADO.NET Entity Data Model in VS 2012 | Chanmingman's Blog
Pingback: SQL Server fine the duplicate rows | Chanmingman's Blog
Pingback: SSIS find the duplicate rows | Chanmingman's Blog
Pingback: ADO.NET with .NET Core CRUD | Chanmingman's Blog
Pingback: Microsoft SQL Server SQL Injection | Chanmingman's Blog
Pingback: PowerShell Execute SQL Server Stored Procedure | Chanmingman's Blog
Pingback: Power Automate Desktop RPA retrieve data from database | Chanmingman's Blog
Pingback: PowerShell Delete Row from SQL Server | Chanmingman's Blog
Pingback: Windows Subsystem for Linux (WSL) access to SQL Azure using C# | Chanmingman's Blog
Pingback: SQL Server List Constraint using T-SQL | Chanmingman's Blog
Pingback: Find all datetime columns in SQL Server database | Chanmingman's Blog
Pingback: SQL Server List Constraint using T-SQL – Günlük Notlarım
Pingback: Find all datetime columns in SQL Server database – Günlük Notlarım
Pingback: SQL Server Insert Columns in The Middle of The Database Table using T-SQL. | Chanmingman's Blog
Pingback: SQL Server Insert Columns in The Middle of The Database Table using T-SQL. – Günlük Notlarım
Pingback: SQL Server Insert Columns in The Middle of The Database Table using T-SQL.
Pingback: SQL Server List Constraint using T-SQL
Pingback: SSIS Execute Stored Procedure using Execute SQL Task component | Chanmingman's Blog
Pingback: SQL Statement instead of Power BI | Chanmingman's Blog
Pingback: How to Create Microsoft SQL Server Stored Procedure | Chanmingman's Blog
Pingback: Write a C# Program to Export Database Table in MS SQL Server to PDF | Chanmingman's Blog
Pingback: Consolidate database tables from different databases that have the same unique identifier | Chanmingman's Blog