Dovberman
asked on
Confusion Installing MS SQL Server 2008 R2
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,
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 om/en-us/l ibrary/ms1 43219%28v= sql.105%29 .aspx
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
ASKER
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
When you are trying to login with SQL Server Authentication, use sa as the login.
ASKER
Error:
TITLE: Connect to Server
-------------------------- ----
Cannot connect to ADMIN-PC1\MSSQLSERVER1.
-------------------------- ----
ADDITIONAL INFORMATION:
Login failed for user 'ADMIN-PC1\Dovberman(Dovbe rman)'. (Microsoft SQL Server, Error: 18456)
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.
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked.
Thanks
Thanks
ASKER
Thanks for the useful trouble shooting.
Glad you got it all working!
Granted this is for Sql 2000 but it talks about the difference between 64 and 32.
Hope that helps a little.