December 1, 2011 at 1:10 pm
Not able to connect to the Adventure Works database. Currently trying to connect to the appropriate AdventureWorks database via object explorer within Management Studio but haven't had much success...
Somewhat a novice at this and continuing to resolve...
Downloaded and installed Sql Server 2008 Express Edition and AdventureWorks 2008 R2_SR1.exe on personal 64-bit laptop with Windows 7 Vista Home Premium and Office 2010. Then, I installed "Adventure Works2008_SR4.exe."
(Note, although maybe not relevant for the installation of the sample databases, I believe that Office 2010 was setup as a 32-bit application...)
Is it possible to briefly provide the specific steps needed to setup the AdventureWorks database to enable querying of tables and views? Also contemplating the deletion of all of the various versions of the sample databases and re-installing. However, this may have unexpected consequences.
Will continue to troubleshoot and review the internet for solutions but thought that someone may be able to readily provide some valuable insight.
(The ultimate goal is to demo the Power Pivot for Excel 2010 add-in using the data within the Adventure Works database...
Within "Program Files/Microsoft SQL Serveer/100/Tools/Samples" are the following files;
AdventureWorks 2008 Analysis Services Project
AdventureWorks 2008 Data Warehouse
AdventureWorks 2008 LT
AdventureWorks 2008 OLTP
AdventureWorks 2008R2 Analysis Services Project
AdventureWorks 2008R2 Data Warehouse
AdventureWorks 2008R2 LT
AdventureWorks 2008R2 OLTP
AdventureWorks Analysis Services Project
AdventureWorks Data Warehouse
AdventureWorks LTAdventureWorks OLTP
December 1, 2011 at 2:39 pm
lacwill25 (12/1/2011)
Not able to connect to the Adventure Works database. Currently trying to connect to the appropriate AdventureWorks database via object explorer within Management Studio but haven't had much success...Somewhat a novice at this and continuing to resolve...
Downloaded and installed Sql Server 2008 Express Edition and AdventureWorks 2008 R2_SR1.exe on personal 64-bit laptop with Windows 7 Vista Home Premium and Office 2010. Then, I installed "Adventure Works2008_SR4.exe."
(Note, although maybe not relevant for the installation of the sample databases, I believe that Office 2010 was setup as a 32-bit application...)
Is it possible to briefly provide the specific steps needed to setup the AdventureWorks database to enable querying of tables and views? Also contemplating the deletion of all of the various versions of the sample databases and re-installing. However, this may have unexpected consequences.
Will continue to troubleshoot and review the internet for solutions but thought that someone may be able to readily provide some valuable insight.
(The ultimate goal is to demo the Power Pivot for Excel 2010 add-in using the data within the Adventure Works database...
Within "Program Files/Microsoft SQL Serveer/100/Tools/Samples" are the following files;
AdventureWorks 2008 Analysis Services Project
AdventureWorks 2008 Data Warehouse
AdventureWorks 2008 LT
AdventureWorks 2008 OLTP
AdventureWorks 2008R2 Analysis Services Project
AdventureWorks 2008R2 Data Warehouse
AdventureWorks 2008R2 LT
AdventureWorks 2008R2 OLTP
AdventureWorks Analysis Services Project
AdventureWorks Data Warehouse
AdventureWorks LTAdventureWorks OLTP
What do you mean by "not able to connect?" Can you connect to the instance of SQL Server? Tell me EXACTLY what you are doing and what is happening.
Thanks,
Jared
Jared
CE - Microsoft
December 1, 2011 at 4:44 pm
ok.
Trying to setup a SQL Server database for the first time.
At this point, it may be best to uninstall all versions of SQL Server from my laptop and restart.
Just to recap, I am interested in downloading Sql Server, several sample databases and PowerPivot for Excel 2010 to my 64-bit laptop so that I can accomplish the objective - perform queries, review Analysis Services, demonstrate the functionality of PowerPivot for Excel 2010 in extracting data from a Sql Server database.
Yesterday, I downloaded MS Office Professional Academic 2010 onto the laptop.
Outstanding questions;
1. What version of Sql Server is recommended that will provide the latest features and allow me to meet the objective? Sql Server 2008R2 Express Edition or Sql Server 2008 Express with Advanced Services or Sql Server Developer?
2. What is the appropriate AdventureWorks sample database that should be loaded?
3. It appears that FILESTREAM must be enabled and the SQL Full-text Filter Daemon Launcher service must be running to ensure that AdventureWorks2008 or AdventureWorks2008R2 is successfully installed. Any insight regarding the functionality of these two processes/functions?
4. Are there any issues with uninstalling all versions of Sql Server and then reinstalling just one version?
5. Upon reinstalling one version of Sql Server and the sample databases, how does one actually see the tables, views, etc. of one of the sample databases? It appears that one must manually connect by going to SSMS...
December 1, 2011 at 6:16 pm
lacwill25 (12/1/2011)
ok.Trying to setup a SQL Server database for the first time.
At this point, it may be best to uninstall all versions of SQL Server from my laptop and restart.
Just to recap, I am interested in downloading Sql Server, several sample databases and PowerPivot for Excel 2010 to my 64-bit laptop so that I can accomplish the objective - perform queries, review Analysis Services, demonstrate the functionality of PowerPivot for Excel 2010 in extracting data from a Sql Server database.
Yesterday, I downloaded MS Office Professional Academic 2010 onto the laptop.
Outstanding questions;
1. What version of Sql Server is recommended that will provide the latest features and allow me to meet the objective? Sql Server 2008R2 Express Edition or Sql Server 2008 Express with Advanced Services or Sql Server Developer?
2. What is the appropriate AdventureWorks sample database that should be loaded?
3. It appears that FILESTREAM must be enabled and the SQL Full-text Filter Daemon Launcher service must be running to ensure that AdventureWorks2008 or AdventureWorks2008R2 is successfully installed. Any insight regarding the functionality of these two processes/functions?
4. Are there any issues with uninstalling all versions of Sql Server and then reinstalling just one version?
5. Upon reinstalling one version of Sql Server and the sample databases, how does one actually see the tables, views, etc. of one of the sample databases? It appears that one must manually connect by going to SSMS...
Let's start with 5 before you uninstall anything... Open up SSMS, connect to server localhost, and use windows authentication. Once in (assuming you can do this) you should be able to expand databases folder in your object explorer and see databases. You may want to check first to make sure that SQL Server service is running by going to services.msc.
Jared
Jared
CE - Microsoft
December 2, 2011 at 8:50 am
Did try to connect to AdventureWorks via SSMS but cannot connect to (local) with the suggested resolution steps displayed as "Verify that the instance name is correct and that SQL Server is configured to allow remote connections"
Did uninstall all versions of Sql Server
Reinstalled SQL Server 2008R2 Express Edition
Due to "Full Text Search" not being installed, it appears that there is a need to install SQL Server 2008 Express with Advanced Services. Therefore, I downloaded "SQLEXPADV_x64_ENU.exe" and encountered a error dialog indication that there are known compatibility issues (apparently due to Windows 7 on the laptop with Vista Home Premium)
Therefore, I downloaded SQL Server 2008 Express SP3 (SQLEXPR_x64_ENU.exe)
At the Instance Configuration Form, I enter a named instance - "Test"
I am not able to proceed past the "Server Configuration Form" due to validation errors.
Displayed on the Server Configuration Form is;
Service------------------------------Account Name--------Password-------------Startup Type
SQL Server Database Engine------------------------------------------------------Automatic
Service------------------------------Account Name--------Password-------------Startup Type
SQL Server Browser----------------NT Authority\LOCA...------------------------Disabled
Continuing to troubleshoot - over last 2 days...
Any insight regarding resolution of installation issues are appreciated...
December 2, 2011 at 9:07 am
I don't understand the Vista/Windows 7 thing... Are you running Vista or Windows 7?
Don't enter a named instance... Leave it as the default.
If you are a student, go ahead and uninstall all SQL Server stuff, and install Developer edition. Developer Edition is the same as Enterprise.
Make sure you run the prerequisite check before doing the install.
Jared
Jared
CE - Microsoft
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply