SQL Server - Remote Command Line Management
As a Sys Admin, I was wondering - if I have admin rights to a Win2k machine
that is hosting SQL Server 2000, do I have the ability using any
command-line tools such as OSQL or ISQL to add, delete, or change accounts
registered in SQL Server for the various databases if I don't have access to
a specific account within SQL Server?
I ask, because the question that came up was - what if we have a DBA leave
under less than amicable circumstances? Could I, someone who has admin
rights on the machine, be able to log into that machine remotely and somehow
via command line (I don't maintain active SQL clients centrally), change the
SA password, remove an account, and/or add an account with sysadmin rights,
etc?
Thanks in advance for any help -
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Server: Command Line Support
Hello,I would like to know whether it is possible to execute DTS(Data Transformation Services) packages created from withinthe EM (Enterprise Manager) user interface, from the commandline. That is, is it possible to execute a command at the DOSprompt which will execute, and optionally also reconfigure,the DTS package? This would allow invoking DTS packagesfrom within scripts.Thank you for your replies,Neil
View Replies !
Starting && Stopping SQL Server From Command Line
Hello All... I am new to this forum (and new to SQL for that matter), so I hope this isn't a stupid question. I tried searching for the answer but couldn't find it here. I am trying to start & stop SQL server through the command line so I can start & stop it as a scheduled task. Are there any switches for sqlmangr.exe I can use? Maybe another way? Thanks....Dave S. <majordis@weco-group.com>
View Replies !
How Do I Add A Password To A Command Line In A SQL Server Agant Job?
I am running a SSIS package through a SQL 2005 job. The package has encrypted data used to access a FTP account. I changed the package's security protection level to "EncryptSensitiveWithPassword." I also added a password to the package. I then tried to add the password to the jobs command line, and it still failed. Does anyone have a suggestion? I think I may have built the command line wrong. Can I get an example? Thanks
View Replies !
Command Line Parameters Are Invalid In SQL Server Agent
Hi Microsoft confirmed that the error message "The command line parameters are invalid" issue mentioned above is a bug and has been resolved in the next "drop" of SQL Server 2005. has this error been fixed by microsoft. Cos i still get this error!!!!!!!!! I am also trying to run the package from command line and when i click on execute the package it runs half way and hangs. What could be the problem????. But when i run it from my Studio and stored package it works fine!!! Thanks, Jas
View Replies !
SQL Server Express 2005 Command Line Parameters...
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 Replies !
SQL Server 2008 Express Command Line Installation
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 Replies !
Converting .dbf To Sql Server Table...batch File? Command Line?
My client will be receiving a .dbf file which needs to be uploadedinto a sql server database table (as an append) every week. They areNOT computer savvy and I would like to automate this process ratherthan go into enterprise manager and run data transformation.Is there any way to write a batch file or a set of command lines whichwill do this?Thanks.Monica
View Replies !
SQL Server SP2 Command Line Upgrade Switch And Express Version Detection
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 Replies !
Command Line Installation Of SQL Server 2005 Express With Advanced Features
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 Replies !
Installing SQL SERVER 2005 Express Command Line, Problem With Inputs
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 Replies !
Remote Management Of Sql Server 2000
One of my clients is upgrading to Sql 2000. I currently administer her server using a SQL 7 interface but I will need to upgrade that interface to sql 8 now to be able to give her the same level of support. How do I go about installing the required clients on my desktop in such a way as to not interfere with my own installation of MSDE? I use Windows NT workstation 4. If I have a choice do I install developer's edition of SQL2000 or personal edition? We also have pcanywhere access but this is too slow and unsure for my money. Thank you, Bo Graham
View Replies !
Remote Management Of A SQL Server 2005
Hello, One thing I noticed is that Network connections to SQL Server 2005 databasees, updates and other thinks like Insert, Delete via remote are never covered, especially for new programmers. You see, new programmers like myself need special attention. The simplest thing is a big thing to the new programmer. This is why I would like to see a Forum or Topic that looks after the new programmer for remotely connecting to SQL Server 2005 from VB.Net or C#. Thanks.
View Replies !
SQL Server Express Database.mdf - Remote Management
Hi, I have installed an ASP.NET 2.0 application which uses a SQL Server Express database file on a client's network. I am able to connect to my client's network remotely over the internet. I would like to know if there's a way - and if so, how - to manage the Database file remotely. I have VWD Express, SQL Server Manager Studio Express and a trial version of SQL Server 2005 on my development machine. Thanks very much. Regards Gary
View Replies !
Secure Remote Management On Shared SQL Server
I am trying to get my hosting company to provide a way to make secure encrypted connections from my desktop (where I am using Enterprise Manager and Aqua Data Studio) to their shared MS SQL Server. I've seen some references to SSH, but I don't understand how this works or how the host would implement it. I also read that an SSL certificate can be installed on SQL Server, but it doesn't seem as if EM or ADS can make SSL connections to SQL Server. (In case it makes any difference for either of these solutions, the hosting company has port 1433 open, and will not close it because some clients connect to the DB server from web apps on their own intranets.) Finally, if a web-based admin is used instead (like phpMyAdmin for MySQL), then which machine is the software installed on? Can it be on a web server that makes a local connection to the DB server or does it have to be on the DB machine? E.g., if I had a VPS or dedicated server at the same hosting company would I be able to install web-based admin software which would then connect to the host's shared SQL Server? Anyway, my host is giving incomprehensible (to me) objections to all of these ideas. Is there a reasonably simple way to do this on a shared DB server?
View Replies !
Error Connecting To Remote Server Using Microsoft SQL Server Management Studio Express
Dear All, I am trying to connect to a remote sql server 2005. So I have install the Microsoft SQL Server Management Studio Express. When I try to connect I get the error below. 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) (Microsoft SQL Server, Error: 53). Can some one please help. I have even port no 1533 on my pc. Thanks.
View Replies !
Uninstalling SQL Server 2000 Instance On A Mulitple Instance Platform From Command Line
I have a situation where we need to uninstall a SQL Server 2000 instance from the command line using the REMOVE=ALL option along with the INSTANCENAME option in the uninstall process. This must be done from the command line and not through the operating system. We will then install a SQL Server 2005 instance to replace the old SQL Server 2000 instance. My question is whether or not performing an uninstall using the mentioned options will "break" other SQL Server 2000 instances on this server or will they continue to function normally? I know under SQL Server 2005 the REMOVE=ALL option will remove all the shared components and certain instances will be "broken"; does the same thing happen in SQL Server 2000?
View Replies !
Jobs, Packages And &&"Command Line&&" Sql Server Integration Services 2005
I have a package that let me to import data from a excel book to a Sql server data base. When I try to run this package like a step into a SQL server Job it show me the next error. "The command line parameters are invalid. The step failed." the "command line" looks like this /FILE "C:ProjectPackage.dtsx" /CONNECTION ConexionExcel;"Provider=Microsoft.Jet.OLEDB.4.0;Da ta Source=;Extended Properties=""EXCEL 8.0;HDR=YES"";" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI and in my excel conexion is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=;Extended Properties="EXCEL 8.0;HDR=YES"; When i run the "Command Line" in the "Command window" the error is more expecific "EXCEL 8.0;HDR=YES;" is not valid So I chanded the "Command Line" in order to run it in de command window(look the double quote in the excel properties) /FILE "C:ProjectPackage.dtsx" /CONNECTION ConexionExcel;"Provider=Microsoft.Jet.OLEDB.4.0;Da ta Source=;Extended Properties="EXCEL 8.0;HDR=YES";" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI then the package RUN, but when i tried to do the same thing in the sql wizzard, it just dont work and it lost the threat from de package and the errors says this time: Couldn't find the package Some one who knows the answer or has any idea to helpme please? thanks
View Replies !
Command Line
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 Replies !
SQL SEVER Command Line
Hi one and all I have a query for you guys,I was to automate a task on sql. What i need is the command line instructions for the following 5 options for SQL server 2000 1-Stop SQL server (net stop mssqlserver) 2-Start SQL Server (net start mssqlserver) -I have the 2 above done as you can see but however the problem lies beneath!! :-( 3-Change the value of the default Port of the Network Protocol`Default Value Setup for TCP/IP(thi can be changed simply in the interface by going into server Network Utility>>General>>Properties of TCP/IP for enabled protocols 4-I want to be able to Disable the TCP/Ip of above 5- I was to be able to enable the TCP/Ip of above Any help on the above would be very much appreciate as I am really struggling with this one and this is really something quite urgent Thanks Aido123
View Replies !
Command Line And Insert
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 Replies !
MS SQL Command Line Insert
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 Replies !
Creating DB Using Command Line
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 Replies !
BCP (command Line Vs. DTS Package)
Why, oh why, oh why? Why doesn't the GUI BCP seem to work nearly as well as the command line version? Same input/host files and the same format files produce numerous errors in a BCP DTS package (datatype, conversion, and truncation errors), but run without error from the command line. Is it just me, or should no one place any confidence whatsoever in Microsoft's Data Transformation Services? They just don't seem to work very well. On a similar note - Does anyone know a way (or the syntax) to run multiple bcp commands from within a *.bat file? I'd like to write a batch script to load some test databases instead of having to individually type each bcp command. Thanks!
View Replies !
URGENT: Can't Run BCP Via Command Line
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 Replies !
Automating Ftp Command Line
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 Replies !
Can't Set Variable Through Command Line
Hello everyone! Bit of a problem executing a DTS command from a command line. I have the following variables defined in my package: UserVarchar1 UserVarchar2 UserVarchar3 All have a scope of Package, all of the mstrings The command I'm attempting to run in 1 line is: DTEXEC /FILE "C:SSIS PackagesED-CustomersPackage.dtsx" /SET Package.Variables[User::UserVarchar1].value;"10" /SET Package.Variables[User::UserVarchar2].value;"30719" /SET Package.Variables[User::UserVarchar3].value;"BILLTO" Description: The package path referenced an object that cannot be found: "Package.Variables[User::UserVarchar1].value". This occurs when an attempt is made to resolve a package path to an object that cannot be found. DTExec: Could not set Package.Variables[User::UserVarchar1].value value to 10. Any idea why? Thanks for the help!
View Replies !
How To Set SQL Profiler Via Command Line
Hello, How can I set SQL Profiler to capture the logs via command line? This is what I have: I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I need SQL to capture. C:>"C:Program FilesMicrosoft SQL Server90ToolsBinnPROFILER90.EXE" /Sfoo /Dfoo /E /T"c:fooTemplate.tdf" /Oc:mysql.out What other parameters am I missing? Thanks! J
View Replies !
Is It Possible To Run Dbm_monitor From The Command Line ?
Hi All, When you run sqlmonitor.exe from the command line by default it is opened as Replication Monitor Tool. So my question ; Is it possible to use an option or extention xml when running to run the sqlmonitor.exe from the command line which results the first screen will be "Database Mirroring Monitor" instead of the Replication Monitor. i.e without choosing Go and dbm from the top menu ? Regards and have a nice day.
View Replies !
COMMAND LINE PARAMETERS
Hi all, A quick newbie question... I am trying to install SQL Server 2005 Standard and upgrade from Express edition. The Edition Change check tells me I must run the setup from the command prompt "and include the SKUUPGRADE=1 parameter", but I don't know how to enter this from the command line. I've tried "D:setup SKUUPGRADE=1" and "D:setup -SKUUPGRADE=1", as well as "D:setup.exe /SKUUPGRADE=1" without success. Can anyone give me a clue as to where I'm going wrong? Thanks in advance. Slammin!
View Replies !
Command Line Install
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 Replies !
|
TRACKER
