Window Batch Shell
Jul 20, 2006how do I write a batch script that can tell whether sql express already exist with some instance on the current machine?
View 4 Replieshow do I write a batch script that can tell whether sql express already exist with some instance on the current machine?
View 4 RepliesI am not a local administrator on a machine and there is sql server isntalled.
I am logging into the server as a guest user. How do i run the xp_cmdshell??
Is there any way??
Sandu.
hello all,
how can run my application as a first application?
i mean before start up programs.
I am attempting to execute xp_cmdshell with a non-sysadmin db login. I have created a Windows account and the associated proxy account in SQL Server. I have verified SQL Server is showing the proxy account credentials. I am still getting the following error. What am I missing? Guidance is very appreciated.
Microsoft OLE DB Provider for SQL Server error '80040e09'
EXECUTE permission denied on object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.
My trigger should launch a shell.
The shell should be launch by a domain administrator.
I don't want that the password can be read by other DBA.
How can I do ???
Does anyone know if DTEXEC runs in its own command shell area? The reason I am asking this question is that we have hundreds of old DTS packages that fetch data from Source Progress double-byte and standard databases. When we fetch from a double-byte Progress database, the first thing we do is to set System Environment variables and within the same command prompt session invoke DTS packages via DTSRUN utility. THis method works like a charm using the old DTS packages. We are trying to accomplish the same thing using SSIS and are unable to do so. The SSIS package works fine while fetching data from a non Double Byte Progress database but fails miserably while using a Double Byte Progress database. Has anyone experienced something like this? Any solution for this problem?
Thanks
Jagannathan Santhanam
I have a unix shell script. I need to establish connection to the MS SQL server to execute packages and jobs. Could you please help me out on how to establish this connection as I am new to SQL server. I am using SQL Server 2000.
Thanks,
T.
Hi all ,
i am preaparing POC Document for SSIS and also compare with already created Job in Oracle Using Data Stage Server. The follwing List tasks are we can do in Data Stage Sever.
"
1. Unix Shell scripts can be called before/after the job runs.
2. Programming can be done through:
a. Routines
b. Macros
c. Subroutines
d. Functions
e. Expressions
3. Programming can be done in Mainframe jobs and COBOL code and JCL files can be generated.
4. The DataStage Reporting Tool is flexible and allows you to generate reports at various levels within a project, for example, entire job, single stage, set of stages, etc. "
The above Task will we do in SSIS Pacakge or not ? pls any one give me the correct answer?
Thanks & Regards,
Jeyakumar.M
Hi, all...I have a sizeable database running under Oracle 9.2.0.4 under AIX5.2.0.I am faced with an impending move to a Windows environment, runningunder SQL 2000.Currently, we are heavy users of shell scripts, for exports, backups,etc.I am looking for viable scripting options under W2K/W2K3. Maybe sh/kshemulators, VB, Perl...?Scheduling of script operations is also required.Anyone been through this kind of move, who could offer some wisdom?Thanks!DW
View 19 Replies View RelatedDear members,
In MSDN, it says that it is recommended to use windows authentication to connect to SQL Server rather than use mixed authentication.
I create user deltasqluser on windows OS, and I specify in my webform ASP.NET script below :
protected System.Web.UI.WebControls.Label Label1;
private string _connString = @"data source=deltasql2000;initial catalog=northwind;integrated security=false;user id=deltasqluser";
/*
comment : I login to my windows as deltakoronx, and I want to every user (including me), connected to sql server through IIS, will be identified as deltasqluser not as user's login (impersonate)
*/
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection(_connString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select suser_sname()";
conn.Open();
string userName = cmd.ExecuteScalar() as string;
conn.Close();
conn.Close();
Label1.Text = userName;
}
at web.config, I add :
<identity impersonate="false" userName="deltasqluser" password="" />
at IIS webApplication1's properties, tab "Directory Security", at "Authentication and access control" section, I checked "enable anonymous access" with user : DELTAIUSR_DELTA and checked "Integrated Windows Authentication",
at query analyzer, I login as "sa" and execute script below :
exec sp_grantdbaccess 'deltasqluser','northwind'
when I run the ASP.NET script, error at conn.Open(); with error message :
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
What should I do so that IIS login to SQL Server as user deltasqluser not as "NT AUTHORITYNETWORK SERVICE" ?
Regards,
Koronx
All,
I have a simple package in SSIS that reads approx 2.5million rows from SQL2k5 source and exports it into 4 Foxpro files.
The way I do it is as below
1) use and oledb source to read data from SQL2k5
2) use a conditional split component to divide the source into 4 streams ( I do a recId % 4 = 0, 1, 2, 3 to give 4 streams)
3) use an OLEDB destination to export to the 4 prexisting foxpro tables.
This thing runs amazingly fast when I run(F5) it from Business Inteligence studio, but it is atleast 10 times slower when rightclick the package and execute using dtexec.exe
I can't figure out why! any clues??
I would elimiate the 64 bit /32 bit problems because export to foxpro only works in 32 bit mode and my package has been configured to run in 32 bit mode.
Appreciate any insights
Thanks,
Saptagiri Tangudu
PNT Marketing Services
Hi,
I am using SSRS Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00. I want to open linked report in new window.
I tried whats mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=240172&SiteID=1 but i get an error on Window.Open method.
How do I solve the problem?
Thanks
HELP,
I need to take a variable from a tabel in SQL Server pass to a Batch file and execute the batch file. Right now I can exec the batch file with XP_CMDSHELL but how can I pass the variable to the batch file and loop through all the variables.
Please help
Phil
I am using the following batch file to execute a script that creates a db and all its objects in the local sql express:
sqlcmd -S (local)SQLExpress -i C:CreateDB.sql
This works fine, but I'm wondering if there's an easy way to put the script in the batch file, so users don't have to worry about putting the script in the C drive. I tried getting rid of the i parameter and pasting the script from the sql file into the batch file, but it didn't work.
Thanks,
Dave
made my first web application using vb script. I am trying to use window authentication for my web page and try to give all permission based on window domain user account. Here is the connecting string I was using to connect to the sql server and it was working fine.
Protected Const sql_connection_string As String = _
"workstation id= DATA-02;" & _
"packet size=4096;" & _
"user id=ASP;" & _
"password=ASP;" & _
"data source=ARENS-DATA-01;" & _
"persist security info=True;" & _
"initial catalog=SupplierTrack;"
I made couple of changes so it run on based on window domain user.
1) my server is set on window and sql server
2) Web.config file – I set Authentication mode = “ Window�
3) I also added under set <authorization>
<deny users="?" />
</authorization>
4) change the connecting string to : ( Added "Integrated Security=True;" and removed line for user and password)
Protected Const sql_connection_string As String = _
"workstation id= DATA-02;" & _
"packet size=4096;" & _
"Integrated Security=True;" & _
"data source=ARENS-DATA-01;" & _
"persist security info=True;" & _
"initial catalog=SupplierTrack;"
5) run the application and now I am getting error said “Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.�
I was expecting window pop up log in to enter domain user and password and then verity the user and password against sql server and the take it from there. Where I made mistake. Need help.
How can I call the SQL Server environment from a MS DOS window ?
Is there a command to do that ?
I know i type SVRMGR23 using Oracle...
Thank you.
I need to make a homemade Search form for my users....one that they can press a button type in lastname or TM#, FirstName or SSN and BAM!!!!!! theres the results populated on the form. Anyone know of any good sites where I can obtain some info on how to create one of these or something??
View 9 Replies View RelatedRunning sql server 2005 standard edition (SP1).
Server properties, permissions window seems to be different to what it should be.
In this window I do not see System Administrator and System User column. I see a different window i.e. permission, Grantor, Grant, WithGrant, Deny columns.
Any thoughts please?
Thanks
hi frnds,
i want to view the runtime variable value in the watch window while the package is running,
how i will get that watch window. i searched all the menus but i didnt get it.
im using Microsoft Visual Studio 2005 for SSIS package.
Hello Guys,
One of the fields in my report is a web address (i.e. http://www.yahoo.com). Navigation property for this field is "Jump to URL". Users will access the report with a browser, using a "sharepoint-like" application. Default behavior of "Jump to URL" seems to be to open the link in the same window (or tab in IE7). Is there a way to force the link to be open in the new window?? Please let me know if you have any suggestions. Thanks!!
I honestly don't see where to view the watch window. Can someone please advise.
Thanks
hi, I got a problem with reporting services 2005.
I have to create a link activated by clicking on an image.
In the image navigation properties I inserted the link in "jump to url" but the problem is that no new window is opened, the url is opened in the initial report page.
I tried to use jscript this way:
javascript:window.open("myurl","", "scrollbars=yes,width=800,height=600,left=0,top=0");
but in this case the url opens in a new window but a blank page is shown in the report page.
How can I solve this problem and open the url in a new window without changing the report page?
Thanks in advance and sorry for my english
Hi,
In my report, I would like to have the following functionality :
The report will have a table with table header columns. If the user clicks on the header column, a window or text box should show up specifying the rules how that cloumn is calculated.
I can do that through sub-report, but I cannot use subreport, according to our specifications.
Please help me
thanks
I have areport which needs to jump to another report when clicking on a text box.
I have used the following code in the jump to url
= "javascript:void(document.open('http://houapps277/ReportServer/Pages/ReportViewer.aspx?%2fIMS-Reports%2fCR000619','_blank'))"
This does not open any page and when i rightclick to open in new page it gives the url as
javascript:void(document.open('http://houapps277/ReportServer/Pages/ReportViewer.aspx?%2fIMS-Reports%2fCR000619','_blank'))
This works fine though when I give this in jump to url and google opens
= "javascript:void(window.open('http://www.google.com/','_blank'))"
What am I doing wrong here.
Thanks
Hello All,
I am wondering if someone can shed some light on how to display "Variables" window in Integration Services. I am trying to add a new variable by clicking SSIS menu, and choosing Variables. However, the Variables window never showed up. Is there some property settings that I need to set before I could view the Variables window?
Your help is much appreciated!
-Lawrence
I just upgraded to Windows Vista and now am told that it does not support SQLServer 2000 nor will it. My question is; will I be able to write code for my website which runs off of a remote SQL 2000 using Visual Studio 2005? From what I have read Microsoft seems to be saying that SQL 2000 is not and will not be supported and that only ODBC drivers and providers will function with either classic ADO.Net or ADO.Net 2.0, am I misunderstanding? I am particularly wondering if I can still create stored procedures etc. I have re-loaded my VS 2005 and I do not see any of my SQL 2000 connection objects in the Server Window. Sure looks to me like a major disaster for anyone upgrading to Windows Vista that is using SQL 2000. I hope I am wrong.
View 1 Replies View RelatedWhen I start the server agent - it opens up a black (command prompt type) window that seems to serve no purpose - that I know of yet.
What is this and can I stop it opening up all the time?
Thanks
JB
Is there anyone can help me to run window when after done with installation, i wana open but i got message" this installation package could not be opened. verify that the package exists and that you can access it. or contact the application vedor to verify that this is a valid Windows Installer package" My comp is running w/ Win home XP. thanks
View 1 Replies View RelatedI have an desktop app that uses a system DSN to access SQL Server 7. I backed up a database from another machine and restored it on my machine. Now when my app starts, it prompts for login/pw for SQL Server. I have checked my ODBC connection, and the login and pw are correct. I have also used Enterprise Mgr to check it in SQL Server. Does anyone have any thoughts on why it is now popping up? Drop me a line at bcarlson@documentsolutions.com, and I can answer any questions. I was wondering if any info about the prev machine exists for the database (on the restore)?
Thanks,
Brian
Hi,
On sql server 6.5 running on a win/nt platform my Current Activity window comes up blank when I click on it. Everything else seems to be working fine. This is a new problem, it just stopped reporting any info when I click on it.
Any suggestions would be greatly appreciated.
Thanks,
Jerry
Hi,
It happened to my sql server 5 times in three weeks. The window just froze and no response to any thing for my sql server. I need reboot server everytime to bring the server back. No any error log in SQl or window, Does any one can help on this one?
Helen
i m new to sql server , can any one help me how to install sql on window xp professional service pack 2.
View 6 Replies View RelatedI had a clients dba send me a peice of sql from the Last T-SQL command window from the process info screen under current activity in the enterprise mangler. It was a select query from a large table with no where clause.I setup profiler for all of the xxxx:completed events for the T-SQL and Stored Procedure Event Classes. I played with that part of the app for a while. I could not find my sql in the trace. I finally gave in and open the Mangler and I was able to reproduce it once but I still could not find the sql profiler. It is not in syscomments and I have a developer running a FIND in the app code.EDIT: I know the sql the query processor uses is not always the sql you send it.I am kind of confused about what that window shows I rarely use it for something like that. Anyone have any light to shed?
View 5 Replies View Related