April 19, 2016 at 9:32 am
I've got SS 2008 R2 (developer vs I think) and 2014 Express loaded on my machine.
I'm trying to load the Adventureworks 2008 RS info I downloaded from Codeplex, but keep getting errors.
When trying to load into 2008 RS, it says the data is a later version (661) than what the database can handle (612).
When trying to load into 2014 Express, by restoring a backup, it says the database is incorrectly formed.
Thanks, any help much appreciated.
April 19, 2016 at 9:48 am
It may be because AdventureWorks has some Enterprise-level features in it, and you are attempting to restore on Express edition. You can use this link for a script to create the database and objects and import the data from CSV files, and this one for instructions on how to do it. The instructions are actually for the AdventureWorks DW, but you should be able to work out how to do it.
John
April 19, 2016 at 10:00 am
DSNOSPAM (4/19/2016)
I've got SS 2008 R2 (developer vs I think) and 2014 Express loaded on my machine.I'm trying to load the Adventureworks 2008 RS info I downloaded from Codeplex, but keep getting errors.
When trying to load into 2008 RS, it says the data is a later version (661) than what the database can handle (612).
When trying to load into 2014 Express, by restoring a backup, it says the database is incorrectly formed.
Thanks, any help much appreciated.
Can you post the full error message, including error codes, for the 2014 error?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 19, 2016 at 10:03 am
John Mitchell-245523 (4/19/2016)
It may be because AdventureWorks has some Enterprise-level features in it, and you are attempting to restore on Express edition. You can use this link for a script to create the database and objects and import the data from CSV files, and this one for instructions on how to do it. The instructions are actually for the AdventureWorks DW, but you should be able to work out how to do it.John
AdventureWorks can be installed without problems on an Express edition. I would say that now that Developer edition (starting on 2014) is free, it would be a good idea to upgrade.
That being said, can you run SELECT @@VERSION from both of your instances and post the results here?
April 19, 2016 at 10:09 am
I've got that script, trying to run it. I have run SQLCMD since 1988!
I created a new query, went to the Query menu choice, and clicked SQLCMD Mode.
It gave no indication that anything changed.
When I run the code, I get:
A fatal scripting error occurred.
Variable SqlSamplesSourceDataPath is not defined.
It does not allow me to jump to the offending line.
The setvar commands are uncommented, i.e. I removed the :
April 19, 2016 at 10:16 am
version is:
Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)
I've deleted that connection (didn't know I still had 2005 on there)
and now I get this:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
April 19, 2016 at 10:21 am
I can see SQL Server 2014 in my programs list, but can't seem to find an instance of it to connect to from SSMS
April 19, 2016 at 10:26 am
DSNOSPAM (4/19/2016)
version is:Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)
I've deleted that connection (didn't know I still had 2005 on there)
and now I get this:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
For the 2008 instance, are you downloading and following the instructions from here: http://msftdbprodsamples.codeplex.com/releases/view/59211?
April 19, 2016 at 10:28 am
DSNOSPAM (4/19/2016)
version is:Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.1 (Build 7601: Service Pack 1)
I've deleted that connection (didn't know I still had 2005 on there)
and now I get this:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Have a look in your list of Services & you should be able to get the 2014 instance name from there. Once you have the instance name, connect to it by specifying [machine name]\[instance name] as the instance you wish to connect to.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 19, 2016 at 10:32 am
DSNOSPAM (4/19/2016)
I can see SQL Server 2014 in my programs list, but can't seem to find an instance of it to connect to from SSMS
Check the services (in Administrative Tools) to be sure that you have the engine installed.
April 19, 2016 at 10:45 am
Sorry for being such a doofus on this. Only place I know to go look at services is under the Task Manager window after hitting CTL ALT DEL.
I've looked in the menu and icons for SSMS and see nothing that says Administrative tools or services.
I've not run into these issues before.
April 19, 2016 at 10:57 am
DSNOSPAM (4/19/2016)
Sorry for being such a doofus on this. Only place I know to go look at services is under the Task Manager window after hitting CTL ALT DEL.I've looked in the menu and icons for SSMS and see nothing that says Administrative tools or services.
I've not run into these issues before.
Hit Start and type Services.msc, then Enter.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 19, 2016 at 10:58 am
Ok, went to control panel, found administrative tools, found servers, but nothing is giving me any version numbers.
Trying to get an image or a list to post.
April 19, 2016 at 11:02 am
DSNOSPAM (4/19/2016)
Ok, went to control panel, found administrative tools, found servers, but nothing is giving me any version numbers.Trying to get an image or a list to post.
Services, not servers.
You're not looking for version numbers.
Scroll down the list of Names until you find services which start with the text 'SQL Server'.
The text in brackets after SQL Server is the instance name. MSSQLSERVER is the default local instance name.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 19, 2016 at 11:02 am
SQL Server (MSSQLSERVER)Provides storage, processing and controlled access of data, and rapid transaction processing.StartedAutomaticLocal System
SQL Server (SQLEXPRESS)Provides storage, processing and controlled access of data and rapid transaction processing.StartedAutomaticNetwork Service
SQL Server Active Directory HelperEnables integration with Active Directories.DisabledNetwork Service
SQL Server Agent (MSSQLSERVER)Executes jobs, monitors SQL Server, fires alerts, and allows automation of some administrative tasks.ManualLocal System
SQL Server Analysis Services (MSSQLSERVER)Supplies online analytical processing (OLAP) and data mining functionality for business intelligence applications.StartedAutomaticLocal System
SQL Server BrowserProvides SQL Server connection information to client computers.DisabledLocal Service
SQL Server Integration Services 10.0Provides management support for SSIS package storage and execution.StartedAutomaticLocal System
SQL Server Reporting Services (MSSQLSERVER)Manages, executes, renders, schedules and delivers reports.StartedAutomaticLocal System
SQL Server VSS WriterProvides the interface to backup/restore Microsoft SQL server through the Windows VSS infrastructure.StartedAutomaticLocal System
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply