Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 SQL Express Installation in 64 bit Windows

Author  Topic 

rogerstenson
Starting Member

2 Posts

Posted - 2011-05-17 : 16:22:23
Hi
I am wanting to use this product as part of VB10 where it is the default provider for membership services. I have had excellent experiences with this product in 32 bit machines in this role. However myy current machine is Windows 7 Ultimate 64 bit and I am having problems with installation
To install it I first made sure my machine was clear of all other SQL products. I then installed SQL Express Advanced Products. This product gave me no choices 32 v 64. However I noticed most of the stuff going into the X86 Program Files. Confused by this I then attempted to apply SP4 in both versions and thought I noted that not all the product was updated
The function runs OK using the default tables installed by Visual Studio. However I want to expand the database. There is no access to the SQL Server Tools Publisher Wizard and the package is reported not to have installed correctly. The system also reports that it can not find the SQL Server Management SDK
I am at a complete halt and would be grateful for some advice on sorting out this mess
Roger Stenson

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-17 : 16:28:47
Here you go: http://go.microsoft.com/fwlink/?LinkID=83387

For more information, check out Mike Wachal's post: http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/8a89ed5c-a81f-43d1-bde6-9c33416b6a85

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rogerstenson
Starting Member

2 Posts

Posted - 2011-05-18 : 02:44:01
Hi Tara
Thanks for you help. I have read all the posts and wonder about the age of those in Mike Wachal's post
I have tried the following
Uninstall all
Install the 64 bit Native client
Then run SQLExpr.EXE
Then run Service pack 4
This failed to overcome my problems so I deleted the client and again reinstalled the 64 bit native client
My basic condition remains
The basic SQL Machjinery executes OK with the VB2010 tools but when I try to open the tables I am told that the system can not find "SQL Server Management.sdk.sfc version 10.0,0.0
I am also told that the SQL Server Tools Publisher Wizard did not install correctly
I think versions 10 relate to SQLExpres 2008 which was installed earlier in my machine. However I removed it because VB2010 tools specifically calls for SQLExpress2005
Does this information give you any clues on my problem
Roger Stenson
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-18 : 14:12:11
You may need to contact Microsoft or reimage your machine.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jp2code
Posting Yak Master

175 Posts

Posted - 2011-05-27 : 09:44:44
For SqlServerCE, you need to install the 32-bit version first, as it is required, even on 64-bit systems. After the 32-bit install, then hit up the 64-bit.

I'm not sure if this is required for your install, but it might be something to look into.

~Joe
Avoid Sears Home Improvement (read why)
Go to Top of Page
   

- Advertisement -