Northwind in Microsoft SQL Server 2012

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.

SQL2012NW

You can download the Northwind.mdf from my skydrive if you want to play with it.

Advertisements

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.
This entry was posted in .Net and tagged , . Bookmark the permalink.

16 Responses to Northwind in Microsoft SQL Server 2012

  1. Prabhu says:

    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

  2. Gary says:

    you didn’t include the log file, or am I missing something?

    • Gary says:

      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.

  3. Bips says:

    hey mate, i am unable to attach your file too in server 2012 😦 help me plz

  4. EC says:

    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)

  5. Jun says:

    My thanks good sir. I wanted to add Northwind to SQL 2012 and its done!

  6. Ken Kennedy says:

    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!!

      • Ken Kennedy says:

        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)

  7. 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

  8. Pingback: Creating ADO.NET Entity Data Model in VS 2012 | Chanmingman's Blog

  9. Pingback: SQL Server fine the duplicate rows | Chanmingman's Blog

  10. Pingback: SSIS find the duplicate rows | Chanmingman's Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s