Installing SQL Express From Command Line AND SQL Authentication
Aug 8, 2007
Hello,
I'm installing SQL express from command line, and using something like that:
/qb INSTANCENAME="SQLEXPRESS" ADDLOCAL="All" SECURITYMODE="SQL" AGTACCOUNT="konrad" AGTPASSWORD="*******" SQLBROWSERACCOUNT="konrad" SQLBROWSERPASSWORD="*******" SQLACCOUNT="konrad" SQLPASSWORD="*******" SAPWD="********"
but after installation process security mode is still set to windows authorization
I realy don't know what is wrong
View 4 Replies
ADVERTISEMENT
Sep 27, 2007
Hello, I'm currently trying to install SQL SERVER 2005 Express through the command line and I'm having problems.
The command I'm currently giving is:
SQLEXPR32.EXE /qb INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL SQLACCOUNT=name SQLPASSWORD=password AGTACCOUNT= name AGTPASSWORD=password SQLBROWSERACCOUNT=name SQLBROWSERPASSWORD=password
Everything goes on fine until the SQL Server Database Sersvices configuring and a pop-up says the following:
SQL Server Setup could not validate the service accounts. Either the service accounts have not been
provided for all of the services being installed, or the specified username or password is incorrect. For
each service, specify a valid username, password, and domain, or specify a built-in system account.
I have no idea how to come over this.
Any help would be appreciated.
PS I don't know what AGTACCOUNT or AGTPASSWORD is, so maybe the error might be there. If not, anybody willing to explain to me what it is, it would be GREATLY appreciated.
View 2 Replies
View Related
Apr 25, 2006
Greets everyone...
I am using the Command Line to install SQL Server Express (SSE) on client machine. Below is long Command Line we are using.
setup /qb ADDLOCAL=SQL_Engine,Connectivity SQLXML SECURITYMODE=SQL SAPWD=#SmartPlus01# INSTANCENAME=SPSERVER DISABLENETWORKPROTOCOLS=0
When I try to connect to SSE from a client's machine using the 'sa' account, I get a connection failure message. Interesting enough, when I fire up Management Studio, it shows (under the server properities) that the server is still using "Window Authentication". I want to force Mix-mode authentication. According to SQL-BOL I need the SECURITYMODE=SQL and the SAPWD =<StrongPassword> params to use MixMode. Am I missing something in the command line to use MixMode authentication?
Another pair of eyes looking at this would be great.
P.S. Although Windows Authentication is the prefered method, sometimes it just doesn't fit for everything we need to do.
Thanks in advance
-Juan Garcia, MCP
Arbitron, Inc
juan.garcia@arbitron.com
View 1 Replies
View Related
Nov 8, 2006
I keep getting sqlbrowser service could not be validated when I try to run slqservr32 from a vbscript on the commit event. I basically need to create an instance on the customers local machine, and give them say a sql login and password with sqlbrowser and everything else required so I can connect to it and create the databases we have. I use the following command line args.
Sqlserv32 /q /qn instancename=someinstance addlocal=all sapwd=@StrongPwd Sqlaccount=anaccount sqlpassword=pass agtaccount=anaccount agtpassword=pass sqlbrowseraccount=abrowseraccount sqlbrowserpassword=pass disablenetworkprotocols=0 securitymode=sql
Im not sure what to do. I cant configure anything or start the sqlbrowser service because its not installed yet. I need to create new logins hence im using the command line install. Does anyone have any suggestions? im stuck.
View 1 Replies
View Related
Oct 4, 2007
Hello everyone.
I'm not very experienced with SQL Server Express. As a matter of fact, I've been with it for less than a week.
I'm currently working on a project in which I need to distribute SQL Server Express in a fast and comfortable way to install to users that aren't quite computer-abled and to prevent confusion for them, we want to prepare a simple batch file that installs everything through commandline, with all the inputs already given.
The type of installation that we want to achieve is as follows:
-We want it to be in the default instance
-We want the service to be SQL server, using the built-in System account, using the Local system
-We want to use the Authentication Mode to be the Mixed Mode, using the following password for the "sa" account: mySentences
-We want to disable the access of all users who aren't the "sa" user
The command line that I'm currently using I'm sure that is incorrect:
SQLEXPR32.EXE" /qb INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL SQLACCOUNT= AGTACCOUNT= SQLBROWSERACCOUNT=
I've been notified that osql could serve useful as well, but I'm having some problem with that too.
My osql command that i'm running are:
osql -E -s%COMPUTERNAME% -Q"ALTER LOGIN [sa] WITH PASSWORD=N'mySentences', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON"
osql -E -s%COMPUTERNAME% -Q"EXEC sys.sp_addsrvrolemember @loginame = N'sa', @rolename = N'sysadmin'"
osql -E -s%COMPUTERNAME% -Q"DENY CONNECT SQL TO [BUILTINUsers]"
osql -E -s%COMPUTERNAME% -Q"DENY CONNECT SQL TO [BUILTINAdministrators]"
Any help would be greatly appreciated. Thanks in advance!
View 2 Replies
View Related
Jan 31, 2008
Hello,
Can anyone tell me how to install SQL Server 2005 from command line, so that sqlservr.exe would log on as "Local System" and not as "Network Service"?
Regards.
View 3 Replies
View Related
Dec 1, 2006
Hi,
I want set a specific port number of SQL Server(express) during installation not by Configuration Manager after install.
Is it possible?
View 1 Replies
View Related
Feb 16, 2008
I can't find a command line where to write the queries for SQL Server express.
Can someoane give me a link with some documentation?
Thank you.
View 1 Replies
View Related
Mar 10, 2008
Hi,
I am trying to setup my install script to install SQL Express 2005 using the SQL Security Mode
and setting the SA Password by passing in parameters from the command line.
setup.exe SECURITYMODE=SQL SAPWD="123456"
This runs the install, but still prompts me during the installation to enter an SA Password.
Thanks.
Same problem with
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194313&SiteID=1
View 6 Replies
View Related
Mar 25, 2008
Hi
I need to Install the SQL server 2008 express with Instance name and Sa password parameter in silent mode . I tried couple of command line arguments for this. but It didn't work, I got the setup failure error message
"The setting 'QB' specified is not recognized.Error code 0x84B40003."
Can any one help me with this?
These are the commands I tried.
1) sqlexpr.exe /qb instancename="MACHINENAMESQLEXPRESS2008" SCCCHECKLEVEL=IncompatibleComponents:1;MDAC25Version:0 ERRORREPORTING=1 SQLAUTOSTART=1 SAPWD="PWD" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0"
2)SQLexpr.exe /qb /ACTION=Install /FEATURES=SQL /instancename="MACHINENAMESQLEXPRESS2008" SAPWD="PWD" SECURITYMODE=SQL
Thanks in advance.
Regards,
Nav.
View 1 Replies
View Related
Nov 9, 2007
What is the correct command line parameters to SQLEXPR32.exe that will default the Log On As: properties for the instance to use the Built-in account of Local System & Local Service?
I need it to be set to Local System immediately on install without having to go into the configuration manager. When I run the SQLEXPR32.exe right now I get the Network Service defaulted.
Thanks for any help,
Greg
greg@ram-software.com
View 4 Replies
View Related
Mar 9, 2007
Our application installation setup needs to be able to detect:
Is SQL Server 2005 Express Installed?
If false, run the SP2 Installation
Is SQL Server 2005 Express or SQL Express SP1 Installed?
If false, run the SP2 Installation with Update Switch
Is SQL Server 2005 (not Express) Installed
If true, abort installation with a mesage.
Can you direct me to some documentation about testing for these environments or just if someone has some scripts that will run in InstallShield, that would be great.
ALSO, can you direct me to information about using the command line update switch for the Express SP2 Installer?
Thanks.
Pat
View 1 Replies
View Related
Oct 19, 2006
Hi,
I'm trying to install SQL Express 2005 with Reporting Services using Install Shield 11.5. The command line parameters which i am using is:
/qn ADDLOCAL=SQL_Engine,SQL_Data_Files,RS_Server,RS_Web_Interface,Client_Components SECURITYMODE=SQL SAPWD=<password> DISABLENETWORKPROTOCOLS=0 RSCONFIGURATION=Default RSSQLLOCAL=1 AUTOSTART=1
It installs the SQL Server and Reporting Services. It configures (creates Virtual Directories for report server and database) but it is not initializing the Report Server.
Having done the installation when i check the Report Server Status it was running and everything seems to be OK except it wasn't initialized.
Any idea??
Thanks,
Moby.
View 4 Replies
View Related
Mar 21, 2007
Hi,
I need to install a customed SQL server express instance on the client's computer by using the Command prompt installation. I've already defined the security settings and everything i need but i was wondering if is possible to attach a mdf database during the installation. Perhaps there is a paramenter i can include in the in the ini file.
Thank you
View 6 Replies
View Related
Sep 21, 2007
I just started using SQL 2005 and having a bit of struggle.
I'm having difficulty trying to use the .ini file to install sql express. This is the command I use in Command Prompt:
start /wait expresssetup.exe /settings setup.ini /qn
echo %errorlevel%
Then I get an error level of €˜-204€™, which I couldn€™t find the meaning on the internet or anywhere else.
But when I move the parameters from the .ini file to the batch file and the process worked. SQL started installing, until it comes to the SQL Server Database Services component. Then I get the following error message:
SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account.
Here is how my batch file looks with parameters:
start /wait expresssetup.exe /qb
INSTANCENAME=€?EXAMPLE€?
ADDLOCAL=All SAPWD="difficult"
INSTALLSQLDIR="C:Program FilesMS"
INSTALLSQLDATADIR="C:Program FilesMSData"
SECURITYMODE="SQL" SQLACCOUNT="user"
SQLPASSWORD="password"
AGTACCOUNT="user"
AGTPASSWORD="password"
SQLBROWSERACCOUNT="user"
SQLBROWSERPASSWORD="password"
Please, can anyone help? I don't know what to do anymore.
Thanks.
Regards,
Akwest
View 3 Replies
View Related
Dec 12, 2005
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
Feb 20, 2008
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
View 2 Replies
View Related
Nov 29, 2006
When attemping to install SQL 2005 Express using the following command line arguments
/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE
or
/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE SECURITYMODE=SQL SAPWD=MY_PASSWORD
the following error occurs.
Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
The following version and editions have been verified.
1. .NET 2.0 installed
2. Windows XP SP2
3. MSDE 8.00.2039(SP4)
4. all MSDE databases are owned by sa
5. Instance and SQLAgent running under user that is member of Administrators
What are the possible reasons this error is occurring?
View 4 Replies
View Related
Aug 22, 2007
I folks.I Have installed sql server 2005 express and choosed windowsauthentication on instalation, but i make a mistake and now i needmixed authentication, how can i modify this whithout uninstall andinstall again the application?thanks for the help.
View 2 Replies
View Related
Jul 23, 2005
Using Query Analyzer, I can right click on an object and select "scriptobject to new window as create" and I get the text of the object'sdefinition (schema). Can I get same result from command line, i.e., fromosql, I can get text output for the definition of the object (something likedefncopy under Sybase)? If so, what is the command or store procedure name?Thanks in advance.
View 2 Replies
View Related
Apr 2, 2008
Is there any command line that I can use to do select from databases (SQL 2005)
View 4 Replies
View Related
Mar 14, 2007
I'm getting the message
Your account information could not be verified
Press Ok to return .....
For setup to verify your credentials the servcies must be startable, connectable, and you must be a SQL Server administrator.
I'm running and instance of sql server called development if that helps any.
thanks.
View 10 Replies
View Related
May 1, 2001
hi I would appreciate if someone demonstrate how to automate ftp in a command line from within a batch file. I do want to move certain files from one server to another via ftp command line in an automatic fashion via running the batch periodically.
thanks
Ali
View 1 Replies
View Related
Jun 13, 2000
hi: I can't seem to run BCP thru the command line.
bcp pubs..authors out c:authors.txt -c -Usa -P
error:
Msg 170, Level 15, State 1, Server Y47SA, Procedure , Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near'.'.
I've been trying to run BCP thru command line all day. I tried OSQL, ISQL. I find this utility very
frustrating. btw - I have installed SP2.
any thoughts would be much appreciated.
TIA
deanna
View 5 Replies
View Related
Sep 25, 2002
Anyone know where I can find some command line tools such as RCMD etc.. Thank you.;)
View 1 Replies
View Related
Sep 22, 2005
I'm trying to insert into a table 2 values one of which is an
exec master..xp_cmdshell @command where I have assigned @command with a value
this statement gives me the result into a 1 col. table fine:
insert into mytable99(col1) exec master..xp_cmdshell @command
now what I want to do is put col2 in there as well!!
ie. insert into mytable99(col1,col2) values (exec master..xp_cmdshell @command, '123')
I get a sytax error ... on the exec ??
Could anyone help re the proper way of doing this ... thanks in advance
View 1 Replies
View Related
Oct 13, 2005
I use a similar command below to insert into a temp table the result of a large command line call to an exectable with many parameters passed in the command of which the result passed back contains many items. I then parse the response string to get my results...
set @command = 'dir'
insert into tsverisign(response) exec master..xp_cmdshell @command
My question is our can I insert two values at the same time to this same table one of which is my "exec master..xp_cmdshell @command"
similar to insert into tables (field_a, feild_b) values ('1','2')
Something like (and I know this does not work):
insert into tsverisign(response,trans_id)
values (exec master..xp_cmdshell @command, '123')
Any help would be greatly appreciated .... PS I'm new to MS SQL 2000 and proper syntax etc. etc. so I need full example so I can try. :rolleyes:
View 1 Replies
View Related
Jun 11, 2007
Hi All,
I was given a task of coming up with the script to recreate an existing database using a command line. I would use this script in case when the server is down and I can't get to Query Analyzer or EM to recreate it. I am not sure where to start. Any ideas are greatly appreciated.
Thanks.
View 5 Replies
View Related
May 21, 2004
What ius the synthax to backup an SQLServer DB from the command line ?
Thanks
View 1 Replies
View Related
Jan 29, 2008
Can someone give me the command to restart SQL?
Thanks
View 1 Replies
View Related
Jul 23, 2005
I want to restore a backup copy of a database from the command line. Canthis be done?Thanks, Tom.
View 2 Replies
View Related
Jul 20, 2005
Hi Sir:Is any possible to run DTS package from Command Line ?Lucas
View 1 Replies
View Related
May 4, 2007
I am trying to create an quiet install for SQL Server Express. The install is being run under a local administrators account. However, when a user, who is only in the local users group, accesses the application using ClickOnce deplolyment, it says SQL Server Express Edition is not installed.
-Dan
View 1 Replies
View Related
