Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
Course Of The Month
9 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Confusion Installing MS SQL Server 2008 R2
Posted on 2013-05-14
I have SQL Server 2008 R2 Developer which I installed on my Windows 7 Ultimate 3 years ago.
It has run well.
Now I have a Windows 8 machine. This is my third attempt to install.
What is the difference between x86 Setup.exe and x64 Setup.exe?
Which Setup.exe should I use and why?
Setup documentation would be helpful.
Thanks,
It has run well.
Now I have a Windows 8 machine. This is my third attempt to install.
What is the difference between x86 Setup.exe and x64 Setup.exe?
Which Setup.exe should I use and why?
Setup documentation would be helpful.
Thanks,
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
4
10 Comments
What are the issues you are having with the install? I found a Microsoft Article on the subject. I would recommend you look at it. It looks like both 32 and 64 bit are able to be installed on windows 8.
Granted this is for Sql 2000 but it talks about the difference between 64 and 32.
Hope that helps a little.
Granted this is for Sql 2000 but it talks about the difference between 64 and 32.
Hope that helps a little.
If you have a 64bit version of windows 8, install the 64bit version of SQL Server. In my experience, however, x64 and x86 are folders in the root dir of the iso and there should be a setup.exe in there. The nonspecific setup.exe in the root will select the best version to install.
Also, you requested some documentation on the installation process. Microsoft's documentation is thorough and exhaustive, so I would direct you here: http://technet.microsoft.c
Also, you requested some documentation on the installation process. Microsoft's documentation is thorough and exhaustive, so I would direct you here: http://technet.microsoft.c
I have carefully documented my installation attempt.
Can you review this and give me a clue?SQL2008InstallIssues.docx
Thanks
SystemConfigurationCheck-Report.docx
Can you review this and give me a clue?SQL2008InstallIssues.docx
Thanks
SystemConfigurationCheck-Report.docx
Error:
TITLE: Connect to Server
--------------------------
Cannot connect to ADMIN-PC1\MSSQLSERVER1.
--------------------------
ADDITIONAL INFORMATION:
Login failed for user 'ADMIN-PC1\Dovberman(Dovbe
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
--------------------------
BUTTONS:
OK
--------------------------
I will uninstall and reinstall but not select Analysis Services.
TITLE: Connect to Server
--------------------------
Cannot connect to ADMIN-PC1\MSSQLSERVER1.
--------------------------
ADDITIONAL INFORMATION:
Login failed for user 'ADMIN-PC1\Dovberman(Dovbe
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
--------------------------
BUTTONS:
OK
--------------------------
I will uninstall and reinstall but not select Analysis Services.
The installation was successful after not selecting Analysis Services.
I can connect to the Database Engine using:
Windows Authentication
Server Name : (local)
Management Studio Object Explorer :
(local) (SQL Server 10.50.1600 - ADMIN-PC1\Dovberman)
I cannot connect to the Database Engine using:
SQL Server Authentication
Please see attachment.
How do I find the Server name and Login name for my installation?
I can connect to the Database Engine using:
Windows Authentication
Server Name : (local)
Management Studio Object Explorer :
(local) (SQL Server 10.50.1600 - ADMIN-PC1\Dovberman)
I cannot connect to the Database Engine using:
SQL Server Authentication
Please see attachment.
How do I find the Server name and Login name for my installation?
The servername, I would just use localhost (you don't need to specify MSSQLSERVER as that's the default instance) - I'm assuming that you are running SSMS from the machine that you installed SQL server on. If you specified mixed authentication during the installation and put in a password at that point, then it would be:
Login: sa
Password: <whatever you specified for sa password during install>
Login: sa
Password: <whatever you specified for sa password during install>
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| When are cursors useful? | 8 | 54 | |
| TDE for SQL Web Edition | 1 | 27 | |
| T-SQL Query | 9 | 30 | |
| Retrieve data for an employee, their immediate reports and hierarchy up to the CEO | 5 | 18 |
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses
Course of the Month9 days, 10 hours left to enroll
740 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.