Hi,
I want to build a silent setup/installation of MS-SQL-Server-Express 2005 for installation on customers computers.
I want to integrate it in my own setup/installation routine of my application.
How can I do that?
Where can I get Infos or tutorials? Perhaps here ?
Sorry for my bad english
Regards Tron
Hi,
I'm trying to create a silent installation which will create a new instance of the express version
on my clients machine, the problem is that i can't set the service account to local service
i.e AGTACCOUNT="NT AUTHORITYLOCAL SERVICE"
if im running the normal setup (GUI) i can set this property easly,
but from the command line all i get is
"NT AUTHORITYLOCAL SYSTEM" which is the default i think
how can i do it from the command line???
Thanks
Hi!
I have created a setup in visual studio and set the sql server as a pre-requsites.
now when the setup is run from
setup.exe
it checks whether sql server is installed... if installed then continues otherwise install sql server express edition, now this installation is silent,
I need to set the sa password during installation of sql server . i have no option to set the password during installation, can any one help
I 'm trying to install Sql Server 2005 Express Edition using c# 2.0 by starting a process and launching setup. I also want to informed about installation progress. For instance i want to inform end user if any installation error return or if setup has successfully completed etc. I think i need a callback... I have no problem about silent - unattended install but how can i informed about running installation progress ? and send these info to end user 's form ?
Regards.
Yusuf Incekara
I am writing an application that requires SQL Express to be installed alongside.
So I try to do the following - Before installing my application, I pop-up a link which leads to "SQLEXPR.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLServer <other parameters> /qb " .
But this displays only a basic GUI, which means that the pre-requisite checks for SQL express are not displayed to the user. So if MDAC version 2.8 is not present on the system the installation of SQLexpress fails without any error messages (except in the log files).
( This is not a problem with all pre-requisites :: If .NET is not present on the system, the failure is much more elegant. There is a nice GUI pop-up which requests the user to install .NET 2.0 before installing SQL express.)
On the other hand, If I remove the "/qb" switch, I can get the pre-requisites GUI to display and the end-user can figure out the cause of failure easily enough. But this means that the optional parameters I use, for example the instancename or the authentication mode will not be used during the install
Is there a good commandline switch I can use so that
1) The pre-requisites check screen is displayed
2) All the commandline options are used for installation.
Thanks
Hey all,
Cool place! Has anyone deployed SQL Express silently using one click and an attached a smart client DB from within the app ... would love to see some of the best practices or horror stories! Just kidding... :) I'm about to deploy a smart client using SQL Express and could use some tips from someone who has been there.
Thanks in advance,
Bill
Hi,
I would be very grateful if someone could take a look at my command line install and offer advice on if I am doing it correctly.
The reason I am asking is because I cannot seem to get the server installed without having errors during the installation:
"The SQL Server (MSSQLSERVER) service terminated with service-specific error 17113 (0x42D9)"
Looking at the server error log indicates that master.mdf was not in the data directory (I have however specified a different data directory for ease of backup by our software and this is created during the install but does not have this database in the data directory - it is however in the template data directory!
I also get this error when the SQL Server service is started:
"The SQL Server (SQLEXPRESS) service terminated with service-specific error 3417 (0xD59)."
All advice is welcome. Please see below my batch file. Also, if you think I should do this in a different way then please let me know. I basically want to install SQL server on a customer computer and automate the install so the custoemr does not need to enter any information.
The goal of this install is:
[1] Deply a custom .Net application and SQL server at the same time on the same computer without user input.
[2] Allow remote .Net applications (designed by myself also) to connect over a LAN (and later maybe over a WAN) to the database to the above database.
The command line is this (I have also included the batch file I am usign below). For ease of reading I have put the parameters on a new line below:
setup.exe /qb
username="CustomerUsername"
companyname="OurCompany"
addlocal="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
disablenetworkprotocols="0"
instancename="MSSQLSERVER"
INSTALLSQLDATADIR="c:SqlData"
USESYSDB="c:SqlData"
SAVESYSDB="1"
SQLAUTOSTART="1"
SECURITYMODE="SQL"
SAPWD="#StrongPaSSword#"
======= Batch file Start ======
SET MODE=/qb
SET SETUP_EXE=sqlfilessetup.exe %MODE%
SET SQLDATADIR=c:SqlData
SET SET_USERNAME=username="CustomerUsername"
SET SET_COMPANYNAME=companyname="OurCompany"
SET SET_ADDLOCAL=addlocal="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
SET SET_DISABLENETWORKPROTOCOLS=disablenetworkprotocols="0"
SET SET_INSTANCENAME=instancename="MSSQLSERVER"
SET SET_INSTALLSQLDATADIR=INSTALLSQLDATADIR="%SQLDATADIR%"
SET SET_SAVESYSDB=SAVESYSDB="1"
SET SET_USESYSDB=USESYSDB="%SQLDATADIR%"
SET SET_SQLAUTOSTART=SQLAUTOSTART="1"
SET SET_SECURITYMODE=SECURITYMODE="SQL"
@REM === RE-INSTALL PARAMS - NOT CURRENTLY BEING USED?? SHOULD I ADD THESE ALSO? ===
SET SET_REINSTALLMODE=REINSTALLMODE="omus"
SET SET_REINSTALL=REINSTALL="SQL_Engine,SQL_Data_Files,SQL_Replication,Connectivity,SDK"
SET SET_REBUILDDATABASE=REBUILDDATABASE="1"
SET SET_SAPWD=SAPWD="#StrongPaSSword#"
@REM === START THE SETUP / RE-INSTALL ===
START %SETUP_EXE% %SET_USERNAME% %SET_COMPANYNAME% %SET_ADDLOCAL% %SET_DISABLENETWORKPROTOCOLS% %SET_INSTANCENAME% %SET_INSTALLSQLDATADIR% %SET_USESYSDB% %SET_SAVESYSDB% %SET_SQLAUTOSTART% %SET_SECURITYMODE% %SET_SAPWD%
======= Batch file End ======
Your advice is kindly welcome.
Thank you
Kind regards
Paul
I am using installshield to distribute SQL Server 2005 Express. I have the SQLEXPR.EXE file and I want to run it in /qb mode so the user can see the pretty dialogs pop up but not have to click anything.
View 6 Replies View Related Hi There,
My ASP.Net application needs AJAX and SQL Server to be installed on the server.
How can I make AJAX and SQL Server installation as a part of my application installation?
Is it possible to automate the install of SQL Server? So user dont need to write in anything, all the answers will be prewritten.
I heard, using Microsoft Setup manager we can generate Setup.iss files to automate the silent install of SQL Server. But I cant find information about how to implement and where can I find this tool.
My main motive is to save my client from installation questions of SQL Server.
One version of my application uses SQL Server 2005 Express and another one uses Standard version.
Please help and guide me.
I believe that I mistakenly attempted to apply the Analysis Services component of this update before applying the SQL Server component. The update now fails continuously with the following message:
02/05/2007 17:58:24.990 ================================================================================
02/05/2007 17:58:25.021 Hotfix package launched
02/05/2007 17:58:27.615 Product discovery successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.630 SP Level check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.646 Product language check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.661 Product version check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.677 Command-line instance name check completed during the install process
02/05/2007 17:58:27.693 Baseline build check completed during the install process
02/05/2007 17:58:34.864 Attempting to install instance: MSSQLSERVER
02/05/2007 17:58:34.974 Attempting to install target: CHARLIDEVSRV
02/05/2007 17:58:35.005 Attempting to check for locked files: sqlrun_sql.msp
02/05/2007 17:58:35.052 Attempting to check for locked files: \CHARLIDEVSRVf$44923e05996203228c1608bea1hotfixsqlFilessqlrun_sql.msp
02/05/2007 17:58:35.067 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB918222_sqlrun_sql.msp.out
02/05/2007 18:01:52.978 MSP returned 1635: This patch package could not be opened. Verify that the patch package exists and is accessible, or contact the application vendor to verify that this is a valid Windows Installer patch package.
02/05/2007 18:01:53.009 Unable to check MSP file: \CHARLIDEVSRVf$44923e05996203228c1608bea1hotfixsqlFilessqlrun_sql.msp
02/05/2007 18:01:53.025 The following exception occurred: Unable to install Windows Installer MSP file Date: 02/05/2007 18:01:53.025 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 689
02/05/2007 18:01:53.212 Failed to install instance: MSSQLSERVER
02/05/2007 18:01:53.259
02/05/2007 18:01:53.259 Product Status Summary:
02/05/2007 18:01:53.290 Product: SQL Server Database Services 2005
02/05/2007 18:01:53.306 MSSQLSERVER - Failure
02/05/2007 18:01:53.321
The update fails although I have cleaned the registry of any reference to it. Another article indicated that the hotfix may delete registry keys required, for instance, to operated SSIS if applied in the wrong order. Here, it appears to be preventing the hotfix from being reapplied. I have ensured that all necessary permissions are available and the services are running in domain user accounts with the necessary rights. I'm the administrator on the machine.
Is there a way to get this hotfix applied without having to completely rip and rebuild my server instance?
I have a list of customers in my Customers table. What I am looking to do is to create QR codes for each customer in Reporting Services. I need to include the customer name, address, postcode, telephone number and contact name.
View 5 Replies View RelatedHi,
I'm looking for a solution to run querys (create databases ed) after a silent installation of SQL 2005 Express edition (example with a .sql file). So users can run a installation unattended with all databases installed and so on.
What I got is a document about how to run a silent installation (document " Using Command Prompt Options to install SQL Server Express") but this docs there's no solution how to run querys after the installation.
Thanks
Robert-Paul
Hello,
I'm using the latest version of SQLEXPR32.EXE found here :
http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&DisplayLang=en
Here is the command line that fails :
"sqlexpr32.exe -q /norebootchk /qn reboot=ReallySuppress
INSTANCENAME=MYINSTANCE SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"
Interrestingly, when the following command line is used to launch the setup,
it completes successfully :
"sqlexpr32.exe /norebootchk reboot=ReallySuppress INSTANCENAME=MYINSTANCE
SECURITYMODE=SQL SAPWD=mypassword SQLAUTOSTART=1"
The only difference between the two is the quiet switches used in the first
case : "-q" and "/qn"
After spending some time to understand what is going wrong, it seems that in
quied mode, Setup Prerequisite 'SQL Native Client' is not installed. Then
the remaining part of the setup fails because of this.
Any help appreciated.
I want to refer in a table quotes to customers and itemes from another table.
here is my table list in database:
"Customers"
"PriceList"
I want to create another table which through it I can create qoutes for customers suing a collection of items in PriceList table.
for example I want to be able to create something like this:
Title:
my quote example
QuoteID:
46543
Items (retrieved from PriceList table):
370
474
456
belongsTo (a relation to CustomerID in Cstomers table):
6234876
Discount, Date, WrittenBy, etc.
how many tables do I have to use for it, and what queries I have to write, and do I have to create any special relationships?
regards
SP2 refuses to install for the Database Engine because €śthe previous upgrade did not complete€?, i.e. it detects a suspended installation. The same thing happened to me when I installed SP1. I then remember opening the maintenance dialog and completing the setup, after which SP1 installed just fine.
When I try to do the same thing this time, I€™m presented with the €?complete the suspended installation€? option, which when I run it reports the installation completed successfully. However, in reality the installation still remains in suspended mode for whatever reason. If I reboot and open the maintenance dialog, I€™m still presented with the €?complete the suspended installation€? option. I€™ve even tried to run it more than once, but it doesn€™t help. Needless to say, SP2 still refuses to install.
I don't know why the installation is in a suspended state. I know every part of SP1 installed successfully in the end, and the computer never crashed during the installation. I've been using it every day since then, without any problems. All other parts of SP2 did install successfully.
I created a feedback entry on Microsoft Connect, where you can find the log files created by Windows Installer. The URL is:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=259606
Any ideas what I can do to resolve this problem?
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
Thanks in advance.
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
Thanks in advance.
I have a very strange problem when I try to install SQL Express 2014 on 1 PC on my network.
The setup is blocking on the step "rules of functionnality" (I hope it is the good translation ...).
I ha ve a message that indicates that there is a problem the following checking : "It exists a Internet connection with the download center for Microsoft Framework 4.0". At the beginning I had Framework 3.5 and 4.5 installed on the PC.
When I tried to install manually Framework 4.0 I had a message that indicated that the setup was not possible because there was a Superior version. So I uninstall v4.5 and install v4.0 normally.
I run again SQL 2014 Express setup but I have always the same error. I take a look on Internet to look for the same problem but I found nothing.
I'll install SQL Server Express SP2 on Vista during my Setup.
But the setup beaks with error 110.
In other articles it sounds like an folder access problem.
On a Custom Action Type 210 i start a application which execute the sqlexpress.exe.
I tried some other codes to impersonate or noImersonate but without success.
But i can not use the unpacked files because size is to large(170MB)
An good Idea would be unpack the setup files during setup to an custom folder with right permissions.
But I dont know how unpack files without GUI (SQLEXPRESS x always show the GUI).
Any Idea???????????
Here are the corresponding logfiles:
------------------------------------------------------------------------------------------------
Core.log
...
Unattended=true
WorkDir=e:a3d45fa9ced92ee76a8e8275
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=e:a3d45fa9ced92ee76a8e8275
QuietMode=true
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=e:a3d45fa9ced92ee76a8e8275
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:384}
<Func Name='SnacComp::InstallImp'>
Failed to install SNAC
Failed to install SNAC : (110) {e:sql9_sp2_tsqlsetupsqlcudllsnaccomp.cpp:251}
SCU_SetupMgr:vc() caught exception: Failed to install SNAC : (110) {e:sql9_sp2_tsqlsetupsqlcudllsnaccomp.cpp:251}. SetupMgr: state=ERROR, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
DotNetPatch=
HandleReboots=false
ModuleDir=e:a3d45fa9ced92ee76a8e8275
QuietMode=true
SNACPatch=
SupportPatch=
Unattended=true
WorkDir=e:a3d45fa9ced92ee76a8e8275
}} {e:sql9_sp2_tsqlsetupsqlcudllscusetupmgr.cpp:520}
<EndFunc Name='UpdateComponents' Return='1603' GetLastError='0'>
Component update returned a fatal error : 110
Error Code: 0x8007006e (110)
Windows Error Text: Das System kann das angegebene Gerät oder die angegebene Datei nicht öffnen.
Source File Name: sqlncli.msi
Compiler Timestamp: Thu Oct 5 12:22:33 2006
Function Name: Unknown
Source Line Number: 1583
Error: Failed to add file :"E:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_DEVELOPMENT-PC_.NET Framework 2.0.log" to cab file : "E:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2008/1/7 8:3:25
Failed to launch Watson with error code : 123
Message pump returning: 110
-----------------------------------------------------------------------------------------------------------------------------------------------
SNAC.log
=== Verbose logging started: 07.02.2008 08:03:24 Build type: SHIP UNICODE 4.00.6000.00 Calling process: E:Windowssystem32msiexec.exe ===
MSI (c) (ACC) [08:03:24:840]: Resetting cached policy values
MSI (c) (ACC) [08:03:24:840]: Machine policy value 'Debug' is 0
MSI (c) (ACC) [08:03:24:840]: ******* RunEngine:
******* Product: e:a3d45fa9ced92ee76a8e8275setupsqlncli.msi
******* Action:
******* CommandLine: **********
MSI (c) (ACC) [08:03:24:840]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (ACC) [08:03:24:840]: Grabbed execution mutex.
MSI (c) (ACC) [08:03:24:871]: Cloaking enabled.
MSI (c) (ACC) [08:03:24:871]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (ACC) [08:03:24:903]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (E4:98) [08:03:24:918]: Grabbed execution mutex.
MSI (s) (E4:5C) [08:03:24:918]: Resetting cached policy values
MSI (s) (E4:5C) [08:03:24:918]: Machine policy value 'Debug' is 0
MSI (s) (E4:5C) [08:03:24:918]: ******* RunEngine:
******* Product: e:a3d45fa9ced92ee76a8e8275setupsqlncli.msi
******* Action:
******* CommandLine: **********
MSI (s) (E4:5C) [08:03:24:918]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (E4:5C) [08:03:24:934]: SRSetRestorePoint skipped for this transaction.
MSI (s) (E4:5C) [08:03:24:934]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionPoliciesExplorer 3: 2
MSI (s) (E4:5C) [08:03:24:934]: Note: 1: 1309 2: 5 3: e:a3d45fa9ced92ee76a8e8275setupsqlncli.msi
MSI (s) (E4:5C) [08:03:24:949]: MainEngineThread is returning 110
MSI (s) (E4:98) [08:03:24:949]: No System Restore sequence number for this installation.
Das System kann das angegebene Gerät oder die angegebene Datei nicht öffnen.
MSI (c) (ACC) [08:03:24:949]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (ACC) [08:03:24:949]: MainEngineThread is returning 110
=== Verbose logging stopped: 07.02.2008 08:03:24 ===
Regards Sven
Hi
We have a problem installing SQL Express Edition SP1 on Vista. The installation stops during installation of setup support files with the following message:
Errors occurred during the installation:Error 2 installing Microsoft SQL Server 2005 Setup Support Files. See log file for more detailed information.Det gĂĄr inte att hitta filen. (translated: File not found)
The log file points to the support.log file with the following content:
=== Verbose logging started: 2007-03-13 17:34:23 Build type: SHIP UNICODE 4.00.6000.00 Calling process: C:cd nät40..SQLEXPRSetup.exe ===MSI (c) (C4:F4) [17:34:23:450]: Resetting cached policy valuesMSI (c) (C4:F4) [17:34:23:450]: Machine policy value 'Debug' is 0MSI (c) (C4:F4) [17:34:23:450]: ******* RunEngine: ******* Product: C:cd nät40..SQLEXPRSetupSqlSupport.msi ******* Action: ******* CommandLine: **********MSI (c) (C4:F4) [17:34:23:450]: Client-side and UI is none or basic: Running entire install on the server.MSI (c) (C4:F4) [17:34:23:450]: Grabbed execution mutex.MSI (c) (C4:F4) [17:34:23:591]: Cloaking enabled.MSI (c) (C4:F4) [17:34:23:591]: Attempting to enable all disabled privileges before calling Install on ServerMSI (c) (C4:F4) [17:34:23:607]: Incrementing counter to disable shutdown. Counter after increment: 0MSI (s) (00:10) [17:34:23:622]: Grabbed execution mutex.MSI (s) (00:1C) [17:34:23:622]: Resetting cached policy valuesMSI (s) (00:1C) [17:34:23:622]: Machine policy value 'Debug' is 0MSI (s) (00:1C) [17:34:23:622]: ******* RunEngine: ******* Product: C:cd nät40..SQLEXPRSetupSqlSupport.msi ******* Action: ******* CommandLine: **********MSI (s) (00:1C) [17:34:23:622]: Machine policy value 'DisableUserInstalls' is 0MSI (s) (00:1C) [17:34:23:669]: SRSetRestorePoint skipped for this transaction.MSI (s) (00:1C) [17:34:23:669]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftWindowsCurrentVersionPoliciesExplorer 3: 2 MSI (s) (00:1C) [17:34:23:669]: Note: 1: 1324 2: .. 3: 1 MSI (s) (00:1C) [17:34:23:669]: MainEngineThread is returning 2MSI (s) (00:10) [17:34:23:669]: No System Restore sequence number for this installation.MSI (c) (C4:F4) [17:34:23:669]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1MSI (c) (C4:F4) [17:34:23:669]: MainEngineThread is returning 2=== Verbose logging stopped: 2007-03-13 17:34:23 ===
The funny thing here is that it works fine when the installer is run from a network share, ie \testserversetupsetup.exe but when the same folder is burned to a CD or copied to a local folder it fails. I have verified that the folders are identical.
I'm not sure what info is required to pinpoint the problem but here are some log files and a screen shot of the message.
Any help or pointers would be greatly appreciated.
Regards,
Martin
Could someone tell me what a silent inatallation is please?
Many thanks
Hi:
Is it possible to install a 64 bit SQL Server 2005 silently?. I am wondering what are the command options that are needed to do a quiet Install of Enterprise Edition of SQL Server 2005 (x64) on a x64 OS.
Any info is appreciated.
Thanks
Ankith
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
Thanks in advance.
I have Windows Vista and Visual Studio 2005 Standart Edition.I have wanted to install SQL Server 2005 Express Edition to my PC to use Database applications with my Visual Studio.But there was a problem on the setup,like the below.Please help me.
"SQL Server setup failde to execute a command for server configuration.The error was[Microsoft] [SQL Native Client][SQL Server] Windows NT user or group 'HĂśSEYÄ°N-
PC SQL Server2005MSSQLUser$SQLEXPRESS' not found.Ckeck the name again..Refer to the server error logs and seup logs for detailed error information."
I had Beta 2 of Visual Studio 2005 installed on my computer until the recent release. I followed the uninstall instructions in order, then installed the available 2005 Express editions. Each install showed an error when installing SQL Server 2005 Express.
View 10 Replies View Related
Hi..
i am new to vbscripting.i need to create the vbscript for
( .netframework2.0,MDAC2.7,XML4.0,VC++2005,windowsinstaller3.0,OWC10)
with silent installation via VBscript.before that i need to check the
machine have my pre-requisites or not,which machine does not have my
pre-requisites through script i have to install.
Kindly provide any solution for this.you can reach me at
senthil...@tcs.com.
thanks,
N.senthil
Dear Sir/madam
While installing sql server express 2005 get an error message install latest version using sqlnci.msi . Please let me know from where i can find or download sqlnci.msi
This error comes while installing native client option
With regards
Anil
I have never used SQL Server, except that I did use MS Access, so after I downloading and installing the SQL Server Express 2005 ... I really do not know how to make it works!
1. Let say I would like to create a table at my local computer (1st) as a Server, how I do it (configuration)?
2. Then I have a second PC, as a client how I link to that table?
Might be they are 2 silly questions, but I would like to try out the new SQL Server Express and compare what are the better features with MS Access!
Thanks to any help
When i try to install, the filed are extracted and then i get this error message:
SQL Server Setup unexpectedly failed. For more information, review the Setup summery log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt
I open the file and this is all i get:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional
Service Pack 2 (Build 2600)
Time : Mon Apr 02 15:31:10 2007
I looked in this forum at others peoples threads and it seems as if they all have a lot larger Summary.txt file. I never had any other verson of SQL Server installed on this computer and i just uninstalled .net 2.0 framework and reinstalled it.
My computer runs Windows XP Pro with SP 2, AMD Athlon 64 Processor 3500+ 2.20 GHz, 1.00GB of RAM.
Anyone have any clue why the installation wont even start?
Someone please help me, Im trying to set up SQLServer on my website(IIS v4.0) and I cant seem to get any web apps that use SQL to intall correctly, I get errors like, SQL does not recieve remote connections by default, or just 'Server Not Found'.
This is what I need to know
- How to set SQL to accept incomming remote connections
- Where to find the Name of the SQL instance
- Is it a good idea to have a password on the db, and how do I add one
- A walkthrough on how to set up SQL Express 2005(what to do after the istall is complete)
As you can see Im very new to SQL. So any information you could give to help would be greatly appreciated.
Thanks
Admin @ Something-to-do.com
I have installed sql server 2005 express edition in my PC. Due to some reason i have uninstalled it. Again when i try to install the same, i am not getting the sql server management studio, Business Intellingence. Only configuration tools menu is available in the Programs Menu. I have tried installing several times. But still i am not getting the sql server management studio, Business Intellingence. Pls tell me what is the reason? Pls explain me the correct steps.
Thanx for the help
Hi I am trying to install sql server 2005 express in Windows XP with sp2.I am having problem when I run the SqlServerSetup I am getting error message like this.....
The sql server service failed to start .For more information,see the sql server Books Online topics,
"How to :View Sql Server 2005 Log files "and "starting SQL Server Manually".
Keshab
hello everybody
I've downloaded a free version of ms sql server express 2005
and while I lauch the install file, I Have a bug :
Something like :
"you don't have write and read permission" - conctact administator
but i'm logged on a administator session
if anyone can help me ..
thnx in advance ..
hzben