In a follow-up to my post on SQL Server migration options I decided to download and try out MS SQL Server Express Beta 2.
The program downloaded no problem but the SQL Server 2005 Express error code 3417 came up on installation: (Click to enlarge)
I checked various newsgroups and ensured that all the requisite components were uninstalled before starting. I installed the .Net Framework 2.0 as recommended on the SQL Server 2005 Express download page - all to no avail.
It is either due to my installing it on a Windows XP SP2 OS or the fact that my copy of Windows XP SP2 is installed on my Apple Powerbook using Virtual PC!
I guess the chances are that it doesn’t like the hardware but I already have Visual Studio .Net, SQL Server Enterprise Manager and Visual Web Developer 2005 Express edition all installed and running fine on it. Maybe when Beta 3 is released - or maybe I’ll just look into another db!
If you enjoyed this post, make sure you subscribe to my RSS feed!
Hi Tom,
We’re expierencing the same problem on the install of the Sql Server Express beta 3. Problem when installing it onto a Windows 2000 SP4 machine. All pre-requisits are fine - although it does warn that the hardware does not meet required spec - although were happy it does.
If anyone has a solution I’d love to hear it .. or more meaning to the error 3417
Someone said it may be a compress directory problme
i met the same problem, which is caused by compress directory of sqlserver 2005
I received the same error, error 3417, when attempting to start the SQL 2005 Express service on a WinXP Pro SP2 machine. Are there any solutions out there for this?
[email protected]
I had exactely the same 3417-problem but it was easy to fix. All you need to do is to run SQLdiag.exe in the \90\Tools\Binn folder
I had the sam error when attempting to start the SQL server on XP pro SP2 machine. Did the following:
Windows control panel -> Performance and maintenance -> Administrative tools -> Services ->right click on SQLEXPRESS -> Properties -> Under Logon tab check Local logon and allow interact with local services…
The start the SQL Express do the same for SQLServer too.
I was having the same problem as well.
The last post about changing the service logon from Network to Local System was the key.
I think some of it had to do with the fact that I installed SQL Server Express a couple of months ago, but just last week finally rejoined my company’s domain. Which almost makes sense because it changes how my computer (XP SP2) interacts with the network…
My 2 cents…
Thanks a lot, Doozie. It worked…
ASH.
Compression was the issue for me. Thanks for the help.
Hey, I have another solution. My event viewer siad something about the Master database being compressed. I checked the data folder, and all database files were blue (meaning compressed, the ‘blue’ setting can be found in folder options). So I selected all files, right clicked, choose properties, clicked advanced and unchecked compressed attributes. After that, I could start the service.
Yes, I had the same issue and after right clicking and decompressing the data files in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data solved the issue.
Compression was the issue. Thanks
P.S. I have SQL 2000 and I checked the db files, those were also compressed, but I was able to start the service MSSQLSERVER and use SQL 2000 normally.
Compressed files were my issue
I had the same issue…Compressed files. Thanks to everyone Moojoo
Compressed Files, thanks!
Thanks for the useful info, decompression was the solution. I’m running SQL Server 2005 on WinXP Sp2.
Compression was the solution for me.
Thanks doozie, u are the best bro! it worked
Thanks very much to Mike
I think his solution is the key
Compression was the solution for me too. Not the whole drive had to be uncompressed by only my data-dir: C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\Data. Thanks for the help
Yep, it was a compression issue! Cheers
No way…same problem but not the same solution.
Can someone help?
I had also problem like that ,now its resolved how?
see-> Windows control panel -> Performance and maintenance -> Administrative tools -> Services ->right click on SQLEXPRESS -> Properties -> Under Logon tab check Local logon and allow interact with local services…
Realy Good One…
Thanks
Sachin
Yep, compression was the issue for me. I solved this issue by going to my SQL Server data folder via windows explorer (mine was: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data), select all the files, right click, click advanced, uncheck, “Compress contents to save disk space”.
Doozie master, thank you
As mentioned above, this may be a permissions issue. If you are trying to run the server with a domain account, make sure it has sufficient priveleges to do it.
In my case, it’s compression issue, too
I know u may not read this since ur post was in 2006 but thx Moojjoo… save me =D
THANKS DOZIE.
Yes, compression was the issue for me. I solved this issue by going to my SQL Server data folder via windows explorer (mine was: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL), select all the files, right click, click advanced, uncheck, “Compress contents to save disk space”.
Thanks Tom for mantain “posts” on your blog.
I tried that Erik Ronne said and works fine.
Congrats.
Windows control panel -> Performance and maintenance -> Administrative tools -> Services ->right click on SQLEXPRESS -> Properties -> Under Logon tab check Local logon and allow interact with local services… worked for mine. But I am using Business Contact Manager and Accounting 2007. So services appears different. Faster way is START > Run type services.msc. Then on SQL Server (MSSMLBIZ)right click and on the LogOn tab select Local System Account and check Allow service to interact with Desktop.
It was a compression issue.
Thx for the help !
Thanks all! Some updates changed the service login. Switching to the Local Service account did it for us.
I found that granting the “Network Service” account Full Permission on the “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data” folder done the trick.
Hope this helps.
Yep, compression issue here too!
compression was the issue on my xp sp2 sql server 2005 dev ed.
select the databases, (master.mdf…)
rigth click, click advanced in properties tab, and remove checkbox on the compression control….
rifat