SQL Express Prerequisite On Vista
Feb 12, 2007
Kedar writes "Hi,
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..."
View 2 Replies
ADVERTISEMENT
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...
Josh
View 3 Replies
View Related
Feb 12, 2008
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?
Thanks in advance,
Sam
View 8 Replies
View Related
Jan 24, 2007
We have SQL 2005 SP1 and SMS SP2 on a W2K server. Each time we try to install DCM 2.0 report engine, we get a prompt:
Prerequsiste not met, please install SQL reporting services
Being new to SQL 2005, it appears that reporting services and Visual Studio both installed with no problems. Have we missed something? Please advise. Thanks.
View 1 Replies
View Related
Feb 26, 2007
Hi,
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?
Thanks in advance,
Keith
View 3 Replies
View Related
Jan 24, 2008
hi,could sqlexpress be installed to vista starter?thanks in advance
View 2 Replies
View Related
Jan 24, 2008
hi,
could sqlexpress be installed to vista starter?
thanks in advance
View 1 Replies
View Related
Apr 11, 2008
Hello
Does anyone know the download link for a 64-bit version of sql express? This has to be for Vista 64-bit.
Thanks
Jack
View 20 Replies
View Related
May 6, 2007
Good day
I was just wondering if the 2005 express editions can be used on the new windows operating system" vista"
Regards
Rob
View 1 Replies
View Related
Aug 14, 2007
Greetings,
anyone know of any issues related to installing and running SQL Express on Vista? Please provide a link or some tips I need to consider for deployment.
I have heard something about the windows authentication not working unless you connect the windows login to a sql server login.
Regards.
Harald Hedlund
View 1 Replies
View Related
Sep 11, 2007
Actually I should have said #22 but this is beyond the point. It seems the errors pop up and then go away for no reason, then appear again.
I had Sql Server Express with Advanced Features set up all right as far as I can see. It is the connection issue that is causing the headache.
Currently when I try to make a connection with an Sql database I get an error in Visual Studio:
Generating user instance in Sql Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.
So I go to Sql Server, log in, open a new query and type:
sp_configure 'user instances enabled'
GO
I get a table where I can see that
name minimum maximum config_value run_value
user instances enabled 0 1 1 1
Are they enabled? I think, yes. I go back to Vsisual Studio and get the same error. It is possible that I will have to log out in order for all this security garbage to take effect and I will try it but in the meantime, how can I set more than one instance.
I want to complain that these new security provisions that came apparently with SP2 and Vista are totally unnesessary for my applications. I do not have any high security info to worry about, e.g. social security numbers, etc. I would not mind to turn all this stuff off if it is possible at all.
So, how can I set up 3 user instances?
Thanks.
View 9 Replies
View Related
Dec 11, 2006
I am developing a web site in asp.net 2.0 using visual studio 2005 and SQL express.
I tried to add a new Sql database using right click on the App_Data folder and adding the DB.
I get an error that the VS could not find a sql Express installed.
I want to clarify that I have installed the SQL express SP2 for vista version and that I can connect to SQL express db using management studio.
I think it is a vista issue probably that UA.
What can I do?
pls do not recommend the next step I already tried itL
If I create the DB on XP and transfer the project to my vista machine the db is there but I cannot connect to it.
View 4 Replies
View Related
Feb 7, 2007
SQL Express CTP 2 provides a checkbox that will enrol the user installing the software as a database administrator. If the user fails to check this box, they run as an ordinary user, and hence are not allowed to perform functions such as create database.
In the process of deploying an application via ClickOnce, if SQL Express is not present it will be installed automatically. Also, in the process of deploying a ClickOnce application, we should usually expect to need to create a new database. Currently, if the user takes the default install of SQL Express they will not be a database administrator and will not be able to create the database. The installation will thus fail.
Is anything being done with SQL Express for ClickOnce applications deploying to Vista that will allow us to automatically enrol the user installing SQL Express as a database administrator?
View 7 Replies
View Related
Oct 6, 2007
i've a new laptop with windows vista and i've installed vwd express edition, framwork, asp.net and sql expresse edition, but once i try to use the sql connection from the vwd, i receive an error msg "Échec de la création d'une instance d'utilisateur SQL Server en raison d'une défaillance du démarrage de processus pour l'instance d'utilisateur. Fermeture de la connexion." it's in french sorry
sql can't creat a user instance because of a process startup....
is that any update i have to download for windows vista?
thanks
mehdi
View 3 Replies
View Related
Dec 4, 2007
Hi,
Vista Business, SQL 2005 Express SP2
I am a big time newbi to SQL 2005 Express any help appriciated.
When I add a new data base to my asp.net page I get this >>>
"Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."
Any suggestions?
Thank you for reading my mail any repliers.
View 6 Replies
View Related
Dec 24, 2007
I am having issues with adding a new database in vwd 2008 as i keep getting the error
“Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.�
I have tried most of the tips on the net already including changing SQLEXPRESS Built-in account to Local System instead of Network Service, running as a administrator and going into surface area to add new admin and adding priveledges to my account. None of these have helped.
I can create a database in the management studio but can't create it in vwd and also the asp.net applications doesn't run either. can anyone help as i have no idea what to do.
View 1 Replies
View Related
May 21, 2008
I'm having issues talking to Vista Sql Express, but selectivly.
The following diagram shows you what works, and what doesn't :
http://www.craznar.com/junk/sqlissue.png
As you can see, the Vista/Express server is running - has all the required connectivity enabled, however we cannot talk from the Windows Server 2003 SQL to the Vista SQL.
The error that is given suggests issues with remote access enabling on Vista - but this is working alsoVista's firewall turned off (We can connect to it).
All machines are on the same subnet, behind the same firewall - Neptune and Headoffice are on a domain, Neptune points to Headoffice for DNS, Headoffice forwards DNS requests to the same DNS all other machines use.
File sharing and Ping work from Headoffice to Neptune ... just can't get SQL connection to work.
Any help appreciated.
Thanks
View 8 Replies
View Related
Jun 18, 2006
Greetings!
I tried installing SQL Server 2005 Express on my VISTA Beta 2 Box but before doing so, I checked if IIS is already installed and running. During the assesment of my current configuration, SQL Server 2005 Express is still looking for IIS. Are the conflicts regarding IIS 7.0 to SQL Server Express or the feature is not yet available. I will be continuing to do experiments with this one and hope there will be people who can share their experiences too.
Thanks!
View 9 Replies
View Related
Nov 28, 2006
We are in the process of converting our MSDE-enabled products to using SQL Express for compatability with Vista. With help from the msdn article at http://msdn2.microsoft.com/en-us/library/ms165716.aspx I've been able to create a test install that works fine under XP, but fails under Vista. We have our application installing under the "Program Files" directory, and are copying the database's MDF file into the same directory. We are using AttachDbFileName to connect to the database and under XP the LDF file is created fine. Under Vista we receive an error that the database cannot be attached and I've noticed that the LDF file is not being created. I was receiving the exact same error under XP until I removed the LDF file from the install and allowed SQL Express to create it. I'm guessing that it is an issue in the permissions necessary to write the LDF file out to the applications directory, but that's just a guess. So, I was wondering what the Microsoft recommended method for doing a SQL Express XCopy deployment under Vista was?
View 2 Replies
View Related
May 17, 2008
Hi
I'm trying to install sql express sp2 2005 in my laptop but i can't, give me this error
Machine : W7J
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_W7J_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515
I'm choosing Windows autentication mode, so i don't know it says "sa" user.
can you help me?
Thanks
View 1 Replies
View Related
Oct 26, 2007
Hi,
I'm preparing to install VS2005 along with SQL Server 2005 express on VISTA. Honestly, I just hope nothing will get screwed up...
- After installing VS2005, I will first install SQL Server 2005 express from my VS2005 DVD
- I will then install SQL Server 2005 express with Advanced services SP2 as well
as SQL Server 2005 express toolkit SP2 upgrades.
A few technical questions:
1. Considering the fact that I have Office2007 as well as Outlook 2007 installed on my VISTA machine, is there any install issues regarding SQL Server 2005 and Office2007? I remember having read posts reporting install problems... Any feedback would be appreciated.
2. After I install SQL Server 2005 Express from VS2005 DVD, do I need to install SQL Server 2005 Express SP1 before installing SP2?
Thanks all for your help,
Stéphane
View 4 Replies
View Related
Aug 30, 2007
i can't install sql server express in vista, i 've downloaded sp2, and it's still not working... HELP!!!!
View 1 Replies
View Related
Apr 5, 2008
I purchased a Dell laptop with Vista. I then downloaded MSSQL Express Edition with Advanced Services (after first downloading .NET 3.5) and when it tried to run the executable, it gave an error that it was not a valid win32 app.
How to I correct this and successfully install MSSQL Express?
Margie
View 4 Replies
View Related
Jul 9, 2007
I have written a custom executable thats purpose is to find and uninstall a named instance. It works as intended on PC's running XP and Vista with UAC turned off. However when I try to run the exe on a Vista Machine with UAC on, it does not fully remove the named instance.
It leaves behind in the folder path: "C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQL" three folders: "Data", "LOG", and "Template Data". However it does remove all of the registry entries and all of the services attached to that named instance.
Why oh why does it have permission to remove everything else besides these 3 folders, and how (programmatically) can I give it the proper admin rights?
the code that does all the work from the cmd:
msiexec /x "ProductCode" /passive
The removal of these three folders is important b/c when you try to reinstall the namedinstance it gives an error message saying files already exist inside the "Data" Folder.
View 3 Replies
View Related
Jun 12, 2007
I have been trying to get Visual Basic 2005 Express and Visual Web Developer Express to work with SQL Server 2005 Express. I am using Windows Vista.
I am running VB as an administrator. SQL Server SP2 is installed and working, and I can use SSMSEE to connect to it, create databases etc.
But VB and Web Developer cannot connect to it. Can anyone tell me how to get these products working on Vista (or do they in fact simply not work on Vista)?
View 1 Replies
View Related
Dec 18, 2006
Hi there,
Can someone tell me what I need to get Express on Vista, I see a lot of contradictory information. Michael Otey notes in his column SP1, but then I here SP2.... Do I have something I can run today ...if not when..
Thanks.
View 4 Replies
View Related
Jan 17, 2008
I installed SQLE 2005 on vista home prem, and when I go to the studio and attempt to create a database, I get the message below. I am running under an admin account, but the system sees me as a standard user.
Do I need to re-install and tell the system to allow me to log on via. an ID/PW?
Is there a vista patch?
Should I re-install XP?
Also, not having this issue with the same SQLE version and an XP machine.
Thanks
TITLE: Microsoft SQL Server Management Studio Express------------------------------Create failed for Database 'test'. (Microsoft.SqlServer.Express.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476------------------------------
View 1 Replies
View Related
Jan 12, 2007
Hi!
We use SQL Express in our Applikation in file mode. Users can create databases in different folders and pathes. Each time a user loggs into our applikation, we attach the db he choosed, and every time he closes the applikation, we detach the db.
While this works fine in Windows XP, we have serious problems with Windows Vista.
We tried a connectiong string with "attachdbfilename", "sp_attach_db" and SMO server.AttachDatabase
Where could we get some more advice for our problem. It is in fact an issue of UAC.
Best regards,
Reinhold
View 1 Replies
View Related
Apr 8, 2007
ok, today i upgraded to Vista, but i can't create database.
create database permission denied in database master. ("Microsoft sql server Error 262")
it must be the Vista thing because i don't have any problem with xp. yes, i the patch installed. I use SQl server management studio with Windows Authentication
View 4 Replies
View Related
Apr 19, 2007
When I install SQL Express on my XP Machine, the registry keys under local machine (ie, MSSQL.1, etc) show up, but on my Vista 64bit machine, the MSSQL.1 etc keys are not there. SQL Server still works, but the reg keys are missing.
View 1 Replies
View Related
Jun 5, 2007
Code Snippet[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,03:21:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,11:30:05] Microsoft SQL Server 2005 Express Edition x86: [2] Error code 258 for this component means "The wait operation timed out.
"
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Return from system messaging: The wait operation timed out.
***EndOfSession***[05/30/07,17:59:59] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[05/30/07,18:00:02] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/04/07,21:30:31] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/04/07,21:30:34] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,03:21:33] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,03:21:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,11:30:05] Microsoft SQL Server 2005 Express Edition x86: [2] Error code 258 for this component means "The wait operation timed out.
"
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
[06/05/07,11:30:06] Microsoft SQL Server 2005 Express Edition x86: [2] Return from system messaging: The wait operation timed out.
[06/05/07,11:30:10] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition x86 is not installed.
[06/05/07,11:52:13] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value.
***EndOfSession***
I try to install it from visual studio net professional 2005, every time it fails. Any idea?
View 4 Replies
View Related
Jul 13, 2007
Alright I glanced over the forums to see if there was an answer for this and I didn't see one. I saw a few similar issues however nothing that fixes my issue. Here is my problem.
I installed SQL Server 2005 Express on my Vista partition along with Visual C# Express. For some reason I cannot get the SQL Server 2005 Express to function correctly. Back when installed this on XP it worked flawlessly, and I don't even recall doing anything special...I installed it and it worked. I do know that you have to manually add the user account to the admin list for the SQL server on Vista, and I did that. I chose the option to have it do it during installation as well as through the SQL Server Surface Area Configuration just to be sure.
I am just trying to get the basics of it working right, and that is connecting to the server using C# and filling a dataset...it shouldn't be this hard. This morning when I started with this I could connect and fill my DataSet programmatically however it wouldn't pass the test through the Data Source Configuration Wizard. When I did it manually, as I said it worked and filled the DataSet with the info I asked for below in the code sample. After getting annoyed by it not working through the wizard I decided that maybe I had my permissions wrong and I may have messed up when installing it. So I uninstalled everything to do with SQL Server 2005 and reinstalled it fresh.
This time when I installed it I made sure to set it up to use Windows Authentication. Now it will pass the Test in the Data Source Configuration Wizard and everything is working by doing it that way. However now it doesn't work when I do it manually with the code below(same code as before when it worked...lol). When I use the code below it crashes with the error: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)". When I go through it with the debugger it throws that error at the call dataAdapter.Fill(...). The code is the following:
Code Snippet
string connStr = "server=localhost;Trusted_Connection=yes;database=northwind";
string commandStr = "Select CompanyName, ContactName from Customers";
SqlDataAdapter dataAdapter = new SqlDataAdapter(commandStr, connStr);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet, "Customers");
DataTable dataTable = dataSet.Tables[0];
foreach(DataRow dataRow in dataTable.Rows)
lbCustomers.Items.Add(dataRow["CompanyName"]+
" ("+dataRow["ContactName"]+")");
Why doesn't that work yet I can basically ask for the same information and it will work if I do it through the wizard? If it works 1 way I wouldn't think there could be any issues with the server being accessed remotely, right?
Thanks
Danny B
View 1 Replies
View Related
Oct 5, 2007
I've tried everything that I can find on this forum and elsewhere. I CAN'T INSTALL MS SQL 2005 Express on Vista Home Premium 32bit!!!!!! Please! Can someone help??
The error I receive is as follows:
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine NOTPIT-PC Error:2147749907 (0x80041013).
I'm dying here, my productivity is shot... I'm thining about cleaning out my system and going back to XP Pro...
View 11 Replies
View Related
