I get cannot find data type datetime2 error

If you get an error similar to this:

"Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Column, parameter, or variable #6: Cannot find data type datetime2." 

You likely have an error with having a 2005 version of SQL. To fix this you will need to follow these steps:

  • Uninstall 2005 Instance of SQL
  • Install 2008 R2 or Newer Version of SQL Instructions
  • You may need to add users
  • Enable Named Pipes and/or TCP/IP. 
    • On the server, click Start / All Programs / Microsoft SQL Server 2008 R2 / Configuration Tools / SQL Server Configuration Manager.
    • Here, drill into SQL Server Network Configuration.
    • Highlight Protocols for your SQL Server instance name
    • On the right side of the split, verify that Named Pipes is Enabled.
    • On the right side of the split, verify that TCP/IP is Enabled.
  • Update Database Again Instructions



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk