How To Control SQL Server 2005 Express Installed As A Prerequisite
Jul 4, 2006
Suppose I check "SQL Server 2005 Express Edition" as one of the prerequisites for a custom app in a Windows Setup project.
From reading whatever docs I could get my hands on, it's still not clear to me how to control the installation of SQL Server Express with respect to things like instance name, service account, etc, etc.
In other words, this is stuff that's normally the domain of template.ini. However, there's no clear indication of where I should put template.ini so that the install of "prerequisite" SQL Server Express will see it and configure accordingly...
Thanks in advance to anyone who can help solve this...
I created a mdf file but couldnt for the life of me install it into SQL Sever Express [and when I say install i mean attach]. When I used SQL Server Ent, I had no issues. The only warning I got was that my mdf file was used by another process when I tried to attach with VS 2005 [ which is correct because ent had it]. I think mdf files are pretty touchy. Does anyone have any good articles on best practices? It seems you cant have a db with the same name as your attachment [ which would make sense] or have mdf files in the Data directory of your SQL Server instance you are trying to attach to. You will get the unc share error if you do. I think I need to start using user Instances but I could be wrong. You cant use them in ent but maybe i will solve my issue with attaching db files to express. I noticed that by default express doesnt install in mix auth mode and there might be some issues with access. How does everyone else normally install their mdf files for quick deployment [ say you want to deploy your db with your app so that users can quickly get started] ?
All -- Please help. Is it possible to connect to MDF file without having SQL Server 2005 Express installed on the machine? That is-- can one connect directly to an MDF in the same way and Access MDB file can be used? If no, then is there any way around this? If yes, then are there any limitations? Please advise. Thank you. -- Mark Kamoski
I have prepared an installer with 2 prerequisites for my project using Bootstrapper. It checks .NET framework 2.0 and then SQL Express 2005. The isntaller works fine on XP sp2 and windows server 2003 but when I tested it on Vista, it is giving me an exception. I checked the log file and found this in the log file. "Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': true Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Fail' 'SQL Server 2005 Express Edition' RunCheck result: Fail A prerequisite failed for Package "SQL Server 2005 Express Edition" Package failed with message "This version of SQL Server 2005 Express Edition is not supported for the current processor architecture."
I am using sql server 2005 express edition with SP2. I think it is failing to use sqlexpr32.exe here. Is there any problem of this exe running on vista? Please help..."
I'm an absolute beginner trying to learn SQL and Visual Basic/Visual Web developer.
I've downloaded SQL Express 2005 and want to install it on my laptop (Dell XPS, 2gb Ram) so that I can start doing the tutorials (for SQL and VB/VWS). I dont want any connection to the internet - i only want to have it on my local pc.
I'm confused as I 'm sure I read that I dont need to have the IIS service running, and that it wont require a server...however, I keep reading that IIS, and a server is a MUST, and for installing SQLE2005.
I'm so confused, and frustrated that I dare'nt install SQLE2005...
I attached a SQL database called Cars, using the following code:
Code Block
IF NOT EXISTS( SELECT * FROM sys.databases WHERE name = N'Cars' ) CREATE DATABASE Cars ON PRIMARY (FILENAME = 'C:DataServer FilesCars.mdf') FOR ATTACH GO
I then copied the .mdf and .ldf to another folder, using Windows Explorer.
I then attached the database using the new folder name in my code.:
Code Block
IF NOT EXISTS( SELECT * FROM sys.databases WHERE name = N'Cars' ) CREATE DATABASE Cars ON PRIMARY (FILENAME = 'C:DataNew FolderCars.mdf') FOR ATTACH GO
Now when I go to update my table, I see that I am hitting the .mdf in the new folder.
And, when I do my table updates, I see that I am hitting the .ldf in the old folder.
Two questions: 1. What did I do wrong, that updates are hitting the new .mdf, but the old .ldf? 2. How do I control what .ldf SQL Express uses?
I see references to 'SQL Server Agent' in the help pages, but do not see 'SQL Server Agent' within the application.
I see the reference to the old folder path, within the 'Database Properties Files page', but no possibity to edit the value.
I am creating a windows application that is not going to be used in a controlled environment like a LAN or some other network, so I want to include a local database in the install of this app. Ideally, I would like to use SQL 2005 Express like you would MSDE or Access, but I am not sure if the user must have SQL Server installed on their machine in order for this to work and I don't have a machine without it to test on.
I am interested in installing both SQL Server 2005 Express and SQL Server2005 b2 on the same machine. Can they both be installed on the same machinewithout conflicts? As in two different instances?John Dalberg
I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine.
I would now like to install my application on another workstation and connect remotely to the database located on my development machine.
The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver?
Using the new Visual Studio 2008 I created a setup project for a small program, and added SQL Express 2005 SP2 to the list of prerequisites. I checked the box so the setup project will contain all necessary files in a sub directory of the setup project.
My setup starts nice (on windows vista) prompts me to install SQL Express, setup of SQL Express runs for some time, I get an UAC prompt, then setup fails with error 1706.
The last lines of the setup log file: Installing using command 'C:UserswilfiAppDataLocalTempVSDE5B7.tmpSqlExpresssqlexpr32.exe' and parameters '-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1' Process exited with code 1706 Status of package 'SQL Server 2005 Express Edition SP2 (x86)' after install is 'InstallFailed'
I really would like to install SQL Express as part of the setup project, can someone help me with this problem?
I want to find whether SQL Server 2005 x86 is installed or SQL Server 2005 x64 is installed programatically(Any API would do.) If anyone can recommend a registry key that I can rely on find whether it is a 32 bit or 64 bit SQL Server that would suffice.
I am attempting to install SQL Express 2005 on a laptop that already has MS Sql Server installed.
I downloaded the SQLEXPR_TOOLKIT.EXE from Microsoft's website and let it go through its installation routine accepting all the default answers.
When I open SQL Server Management Studio Express, I can only connect to the SQL 2000 instance. I have issued the 'SELECT @@VERSION' command, and When I try to connect to the instance COMPUTERNAMESQLEXPRESS, the following error message is displayed: Cannot connect to YOUR-F8A010A9D0SQLEXPRESS. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure my be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error locating Server/Instance Specified) (Microsoft SQL Server)
When I go to remove SQL Express 2005 using the add/remove programs, there is a check box that says "Remove SQL Server 2005 instance components" and in the box underneath where it lists all the instances it says: "No instances have been installed"
We have serveral app groups that have installed SQL 2005 Express, but each group have installed different components. How can I determine, specifically if the following components were previously installed.
A simple question. I installed successfully Visual Studio 2008 Standard edition on my VISTA Ultimate 32bits machine. During install process, I also checked SQL Server Express 2005 item.
Which version of SQL Server Express 2005 did it install? Are we talking about SP2? If so, can I install without problem a more complete SP2 package using following links
SQL Server 2005 Express Edition with Advanced Services SP2 http://go.microsoft.com/fwlink/?LinkId=65109 Microsoft SQL Server 2005 Express Edition Toolkit http://go.microsoft.com/fwlink/?LinkId=65111
without screwing the now existing SQL Server Express setup VS2008 installed?
Hi Friends, I have a question. At my home computer i downloaded and installed VWD. As usual it also installed Sqlexpress as part of the installation(i checked the option). Later on i downloaded Management studio separately so i am fine with my home computer as every thing is free. But at work we decided to develop application using VS 2005 and Sqlserver 2005. So we bought and installed VS2005 professional edition at work and it also installed Sqlexpress during the installation as a defualt desktop engine. I am fine with that too. But i am not understing where do i get the Management studio? Is it some thing i could get it off the web for free or what? I am not sure we would have an option while installing the VS 2005 professional that also does install management studio and we need to check that option. I am not sure if we could get the management studion off the web for free and and evelop applications.
I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it.
I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE)
There is an MS article on creating "Custom Prerequisites" (http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx) which speaks to creating product and project manifests.
Has anyone does this for SSMSE? Or am I going about this in the wrong way?
I downloaded and installed Microsoft SQL Server 2005 Express Edition with Advanced Services and Microsoft SQL Server 2005 Express Edition Toolkit. Installs completed successfully, and I can launch the SS Management Studio, but when I launch SS Business Intelligence Development Studio, I get message saying "Windows is searching for devenv.exe". When I search for this file I don't find it on my hard drive.
I thought I'd reinstall the SS Express Edition Toolkit, but I can't find this application in the Control Panel Installed Programs list, so I can't uninstall it.
Any ideas as to how I can get SS Business Intelligence Studio working?
I'm a newbie and I have a problem that i can't solve despite sitting here all day trying to wortk it out.
I have installed SQL Server Express 2005 along with the associated toolkit. Previous to that i installed MS Visulal studio 2005, .NET 2.0 and MSDN.
The problemn is that it appears despite installing everything i don't have SQLExpress services running on my PC. I have admin rights, it installed okay but there is nothing to connect to.
When i run "sqlcmd.exe -s (local)SQLExpress -E" from the command prompt i get the following message:
HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
When i run SQL Server Configuration there is no "SQLExpress" service present under "SQL Server 2005 Servcies" in SQL Server Configuration dialog; just a message saying:
"there are no items to show in this view"
When i run Surface Area Configuration i get the following message:
TITLE: Surface Area Configuration ------------------------------
No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)
------------------------------ BUTTONS:
OK ------------------------------
If you can shed any light on this id be extreamly grateful as i'd been here for hours before stumbling across the toolkit (why this wasn't bundled i don't know) only to realise once i had it that the SQLExpress service isn't running :(
I have downloaded Sql-Server Express Edition along with Visual Studio and Microsoft.Net software. However I cannot see it in my start programs what have I done incorrectly? JT.
I am aware that instances of both can exist on the same machine.
But I assume that is when a different instance of SQL Server Express is installed with an existing instance of MSDE2000
Many moons ago, when the various flavours and betas of SQL Express became available, I upgraded from MSDE2000 - didn't think I would need it again.
I now have an application, Sony Vegas 6, which uses MSDE2000 for it's Media Manager. According to their support it won't install to SQL Server Express 2005.
When I try to install MSDE2000, it always fails with "Setup failerd to configure server..." and rolls back.
In the event log, there is an entry
The description for Event ID ( 19011 ) in Source ( MSSQL$SONY_MEDIAMGR ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: (SpnRegister) : Error 1355.
I have down all the usual things like uninstalling SQL Server Express 2005 (using control panel and msiexec /x {GUID}), patching the registry etc etc
The result is always the same.
The Sony Media Manager is not important and I probably won't use it but it's annoying the hell out of me - I've always claimed, over a good few years, that there was no computer problem that I couldn't finally solve, but presently this has got me beat and I feel undone!!!!!!! :-)
I installed SQL Server Express trail for 3 times each with new instance. Now I came to know that I need to have a default instance. I un-installed the SQL Server Express and tried to install it again. It still says I have installed instances and if I select default instance the option buttons are un-checked and disabled. I tried to delete all the folders related to the SQL Server installationa dn tried but still I see the same thing. Please help me in istalling the default instance.
I installed Visual Studio 2005 Professional then after that was installed and running, I tried to install the the SQL Server 2005 Developer's Edition which installed but I do not get the SQL Server 2005 Studio Manager. I have remove and reinstalled but it never gets installed. Any ideas?
Hi, i have sql server 2005 standard installed on my machine. I want to work on express edition and learn about it but on the installation its gets stuck because a higher version is installed. If the express version is free why cant have both versions installed on my machine. Thank you.
I'm attempting to install SQL Server 2005 Developer Edition Management Tools [only] on my workstation which is running Widows XP Pro SP2. I already have VSTS 2005 installed with SQL Server Express and Management Studio Express Edition.
Attempting to do an advanced install with just the Management Tools specified under Client Components, results in the Version Check warning that setup must be run with SKUUPGRADE=1 specified. When I do that, the installation fails with an unexpected error. Clicking the 'Help' button, displays the following info:
I have built a page with the login control using the default sql server express database that is integrated into the application. I have got it working on my development machine and want to post it on the web with a web hosting company. I did not know if they had to have sql server express installed on that machine for my database to work properly or will it work with sql server 2005 installed. Most web hosting companies that I have called say they only support sql server 2005 and not sql server express. I was unsure if the login would work or not. Please help with this issue. I am new at ASP.net and really enjoy it. However, I want to ensure that my site will work on the web as it does on my machine.
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
Could someone from the SQL Server Express team confirm that SQL Server Express SP2 w/Advanced Services shows up as "SQL Server 2005" in the installed programs list? The "Express" portion seems to be missing. And how would one tell the difference between the Standard Edition and the Express Edition based on this?
hi !!I have just downloaded 180 days trial version....It is not getting installed by me...It shows : minimum hardware requirement does not match. .... I have computer with 512MB RAM and 1.60 Ghz process with XP professional installed on it with SP2.I have just formated my pc and trying to install SQL2005...i have already VS2005 installed in my PC..Any idea???
I've installed the MS SQL Server 2005, and when I click on Start->Programs-> MS SQL Server 2005->Configuration Tools, there are 3 options given:
1.SQL Server Error and Usage Reporting 2.SQL Server Configuration Manager 3.SQL Server Surface Area Configuration
My objective is to have a database where I can play and refresh my skills in T-SQL. I would want to create or view tables and data. I've already downloaded CodePlex's sample database and installed it, but it is not showing. How can I configure these server to show tables and stuff?
I'm not a DBA but a programmer, and don't have the luxury of going through tons of documentation for this thing to get going. Any help would be appreciated.
