September 27, 2015 at 1:57 pm
Hello there,
Anyone has seen this issue before? I've scoured the Internet but only found a few things on this matter. I don't understand any of the technical stuff there. http://kalcik.net/2014/04/04/problems-with-the-installation-of-sql-server-2014-after-the-windows-8-1-update/
Especially this link above. It shows you the screen but doesn't give you a step by step instruction as to how to get to the screen.
Anyway, I had Windows 8.1 with SQL Server 2014 installed and I had a database server there working nicely but after I've installed Windows 10 everything stopped working with SQL Server 2014.
Could someone furnish a step by step recipe to fix this. At least I need to get to the old databases and back it up and recover to the new 2014 installation that I have. Yes, I've downloaded the service pack. An instance of 2014 is running but I can get to my previous databases.
Could you also reply to kai_tham@yahoo.com?
Thanks,
Kai
September 27, 2015 at 4:17 pm
Did you try reinstall SQL server from scratch?
September 27, 2015 at 5:24 pm
I reinstalled once after win 10 upgrade sans removal of existing SQL server 2014 installation. Then I found sp1 package & installed that. The I was able to get SQL server up but can't see my existing server or databases. Not sure how I could get access to them.
Thanks
Kai
September 27, 2015 at 5:36 pm
Do you still have a backup of the database? If you placed your Data and Log files to a non default path during the setup, then you could attach them back via SSMS.
September 27, 2015 at 6:00 pm
No b
September 27, 2015 at 6:27 pm
I don't have backups. But I do see my .mdb files. How do I open them using the new SQL 2014 instance?
September 27, 2015 at 6:47 pm
What happens if you go into SSMS and attach? Right-click on the databases folder and choose Attach... then do you see your files when you browse?
September 27, 2015 at 6:57 pm
Mdb is a MS Access file extension, not SQL server. Perhaps try using MS access and see if you can open them.
September 27, 2015 at 6:57 pm
Mdb is a MS Access file extension, not SQL server. Perhaps try using MS access and see if you can open them.
September 27, 2015 at 7:02 pm
Sorry, I meant .mdf files & .ldf files.
I'm trying to look at my source code to recreate some of the tables so that I could start to collect data again.
But I think that futile.
September 27, 2015 at 7:06 pm
You mentioned that I could move all these files from the standard directory, which is C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA to a non-default location.
Where might that be? And what should I do after that?
My SQL Server installation knowledge is zero.
I just use SQL and code and nothing else. It was a miracle that I was able to install and create some databases.
September 27, 2015 at 7:12 pm
Nevertheless, if you are able to see your mdf files then follow this link to attach them back. I assume that you are familiar with SQL server management studio.
September 27, 2015 at 7:20 pm
Thanks let me try will let u know if I succeed tmrw
September 27, 2015 at 7:35 pm
Wow, it's already tomorrow. I could see those .mdf files from the Windows Explorer (File Manager) or DOS but when I cut&paste the directory to the Attach dialog in studio it beeps and nothing is shown in the file list. I think that tells me that something is wrong. It just refused to let me get to those files from SQL Server 2014. That is only step #3 that I could get past.
September 27, 2015 at 7:38 pm
I actually get Create file encountered operating system error 5(Access denied) ... Error 5123.
This is after I typed in the direct path & the .mdf.
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply