if I want to use the Compact version?
BTW, how do I convert an Access database to an SQL Compact database? Thanks for helping a newbie.
View Complete Post
We currently install SQL Server 2005 Express silently during our installation, using the following switches
/qn ADDLOCAL=all REBOOT=ReallySuppress DISABLENETWORKPROTOCOLS=2 SQLAUTOSTART=1 SECURITYMODE=SQL SAPWD=123
We also attach a 2005-created database immediately after using the following command line (^ is a path concat operator in Installshield):
sqlcmd.exe -S .\\SQLEXPRESS -E -i \"" + svConfigPath ^ "SetupUapDB.sql\" -vmdfpath=\"" + svConfigPath ^ "UapCfg.mdf\" -vldfpath=\"" + svConfigPath ^ "UapCfg_log.ldf\" -o \"" + svConfigPath ^ "SqlCreateDB.txt\" -e
Note that we do not specify an instance name. We ran into a situation where someone had installed SQL Server 2008 on a box using a default instance name and our install then failed. I am considering 2 possible fixes, and have questions for both.
Fix #1: Specify an instance name. Ideally this would install SQL Server 2005 Express side by side with SQL Server 2008, create a unique instance name and we'd be good to go right? If yes, what is the accepted convention for specifying instance
Fix #2: Not sure if this is possible. Can we detect if SQL Server 2008 is on the box, and if yes, apply our 2005 database to it instead? In this case (tell me
Hi have been trying without any success to install Mircosoft Server 2008 32 Bit Trail version on my Windows Vista 32 Bit Desktop at home. Below are the error messages that I received both times.
Database Engine Services
SQL Server Replication
Can anyone out there please tell me what I am doing or not doing correctly? Any suggesti
According to edition requirement (http://blogs.technet.com/b/sbs/archive/2009/03/23/requirements-for-installing-sql-2008-standard-edition-for-small-business.aspx),
I thought I met the requirements but this link tells me not only I need both the standard edition AND in a domain?? I have Windows 2008 Standard R2 edition.
This is a standalone server and there's no domain. I can promote it to be a domain controller but don't want that. Is it the "R2" part that its failing. I can downgrade to the non-R2 with SP2. (Windows Server 2008 with sp2).
How do I identify if the SQL Server 2008 R2 version that is installed is 32 bit or 64 bit. I see that the are some files in Program Files directory and some others in Program Files(x86) directory on an Windows Server 2008 R2 OS.