DTSRun With Userid And Password

Jan 7, 2008

I use DTSRun /Uuserid /Ppassword /Sservername .... in a batch process.
I always get the error message to run with a trusted connection. I can run the same batch process from a command line under my own domain id and it runs as if it had a trusted connection.
Will DTSRun run only with a trusted connection? Do I need to set something in the package to get SQL Server to run with a userid and password? Why does it always default to using a trusted connection. I need to know what I have to set to tell it that I am using a userid and password. I have included an example of how it's coded in the BAT file.

Example:
DTSRun /S"myserver" /Umyuser /Pmypass /N"Load_Data" /L "c:mylogsLoad_Data.log" /W"0"

View 4 Replies

New Database, Set Userid And Password

Jun 11, 2007

I am creating a new application and just created a new database
Application: VB.net 2005/ ASP.net
Database: Sql Server 2005 with four tables
I need to set the userid and password on the database. How do I do that?
I want to be able to create a SQL connection object in my code and I have something like the following:
<CODE>
Dim objcon As New SqlConnection("server=serverName;uid=;pwd=;database=SomeDatabase")
</CODE>
but the "uid" and the "pwd" are not set on my database. what is an easy way to do this? thanks

View 4 Replies View Related

Why It Requires Userid And Password.

Jul 14, 2007

When I tried to browse the reportserver url. The IE 7.0 asks me for Username and password. I feel, its some settings related to security. But other sites created are working fine. The virtual directories created using Repoting services configuration manager only ask me username and password.

Any suggestions.

Murali.

View 3 Replies View Related

Asking Userid And Password While Deploying Reports

May 15, 2007

Hi All,

While deploying reports on the reports server, it is asking to supply user name and password. When I entered the same, it didn't accept them. What do I need to do? Is there any specific setting which I need to configure?

An immediate reply will be highly appreciated.

Thanks

Sekhar

View 6 Replies View Related

How To Create Database Having Userid And Password

Feb 20, 2007

Hi,
I am using the sql server for creating the database. I want to create the database which is having userid and password. This I require since I wanted to restrict acces to database and also only authorise user to database can use the userid and password created at time of creation of database.
So how can I create the database which is having userid and password?

View 6 Replies View Related

Can I Pass SQL Userid Password As Parameter To Report

Apr 2, 2008

Hi,

I have started using SQL Server 2005 Reporting Services. I am using SQl Server authentication where user has to supply username and password .I want to know can I Pass the SQL authentication username and password in the URL as a parameter to report.

Nikhil Jahagirdar

View 1 Replies View Related

Set The UserId And Password For Perticular Database In Sql Server 2000

Jul 27, 2006

I want to set userID and Password for perticular database without affecting sql server userid and password in sql server 2000 :)

View 3 Replies View Related

How To Create A Login Userid And Password For Ms SQL Server 2005 Express?

Oct 30, 2007

My PC is Window XP Pro and I'm using Microsoft SQL Server 2005 Express and Microsoft SQL Server Management Studio Express.
My question is how to create a login userid and password under "SQL Server Authentication"? (as shown in http://www.findingsteve.net/print_screen.jpg)
Any tutorial about this I can read?

View 6 Replies View Related

Using Membership UserId Guids With SqlParameters (Membership UserId Guid)

May 7, 2008

In my site, when a user registers, I need to create rows in additional tables besides aspnet_Users. So, I need to be able to pass the generated userId guid to subsequent SqlCommands. I'm having a terrible time with this. What's the correct way to set up a SqlParameter so that it will accept a guid? I keep getting this error: "Conversion failed when converting from a character string to uniqueidentifier."
I've tried creating the parameter both with and without a SqlDbType.
cmd.Parameters.AddWithValue(paramName, guid);
and
SqlParameter p = new SqlParameter(paramName);p.SqlDbType = SqlDbType.Guid;cmd.Parameters.Add(p);
and I get the same error either way.
Driving me nuts! Any help appreciated.

View 1 Replies View Related

Data Access :: How To Recover Forgotten Password When Remember Password Option Checked

Jul 24, 2015

I have connected to Database using my credentials by checking remember password option. After few days I forgot my password. How can I recover the password as SQL remember it. Is there any way to recover my password instead of resetting it.

View 3 Replies View Related

SQL Server Agent Job Will Not Retain Package Password (encrypt Sensitive With Password)

Apr 1, 2008

I have a package protected by a password - I am already unhappy that to get it to use the configuration file to change connection strings for the production servers I have had to hardcode the password into the config file - very insecure!
However, the package now deploys correctly to the production server and will run from there OK, but NOT if scheduled as a SQL Server Agent Job. Thus is because however often I edit the command line to include the password after the DECRYPT switch (which it has prompted me for when I click on the command line tab), the Job Step will not retain it.
If I open it up after I have edited it and closed it, the password has disappeared.

I know that if I run dtexec plus the code in the Command Line tab (with the password), the package runs OK.

This is driving me insane!
I have read all the other posts and so I tried replacing the SSIS package step with a CmdExec step and pasting that code into there - then I get an OLEDB error..

The code I use is:
DTEXEC /SQL "ImportRateMonitoringTables" /SERVER servername /DECRYPT password /CONFIGFILE "D:Microsoft SQL ServerSSISDeploymentsRateMonitoringImportTasksDeploymentImportRateMonitoringTables_Production.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

and I get

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF

although the same code executes perfectly from a command prompt.

Please does anyone have any experience with a similar problem and if so, how did you get round it?

Thank you

View 9 Replies View Related

SQL 2005 SP2 - Windows 2003 Ent SP1 - Password Does Not Meet The Password Policy DLL

Jun 18, 2007

I am receiving the following error message when attempting to create a new SQL Authenticated login id.

Password validation failed. The password does not meet the requirements of the password filter DLL. (Microsoft SQL Server, Error: 15119)

I have four servers all running SQL Server 2005 SP2 on Windows 2003 Ent. SP1. Of the four servers, only one received the above error message using the same TSQL below.

CREATE LOGIN TEST_LOGIN WITH PASSWORD = 'pvif9dal' MUST_CHANGE, CHECK_EXPIRATION = ON

All four servers are in the same domain, which if I understand correctly, the password policies are therefore inherited at the OS level by the domain. The password being used is within the password policies of the domain.

Any ideas as to a root cause?

View 5 Replies View Related

The Sa Password Must Meet SQL Server Password Policy Requirements.

Jun 30, 2007

I tried to install an ALLDATA database which run with SQL Server 2005 express edition. The data base fails to install becase of the following code that come up which is related to AS password requirement. The error that come up is:

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=28001&EvtType=sqlca%5csqlcax.cpp%40SAPasswordPolicyCheck%40SAPasswordPolicyCheck%40x6d61

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------

I am trying to install this database in a network server operating under Windows Server 2003 R2 with SP2. If anyone knows how to solve this problem, please let me.

Thanks,

Amilcar

View 6 Replies View Related

DTSRUN......

Sep 5, 2001

What is the minimum SQL install required for dtsrun? Can I get away with copying a few files and not installing SQL.

Basically, the central SQL database has a DTS package which I need to enable a number of users to run. What I do not want to do is have to install SQL Server on all the end users computers.

ANy advice would be greatly appreciated.

View 1 Replies View Related

DTSRUN

Dec 7, 1999

We need to schedule a dtsrun batch to run on several servers at the same time. Can
someone tell me how to write this in my command prompt so it will run remotely.

We tried to run it locally but it does not work.

Thanks,
Dianne

View 1 Replies View Related

Dtsrun

Mar 11, 2003

Hi,

Question with DTSRUN
1) I have a batch file which runs a DTS package. Problem is after completion of the package the control doesn't return to command prompt. Any idea how to tackle this.

2) Even on the same server /U /P doesn't work. It errs out saying password is incorrect, Although I can connect to ISQL with same credentials.

Need to fix this asap.

Thanks,

View 4 Replies View Related

Need Dtsrun Help

Apr 13, 2006

I am trying to run two dts jobs using a batch file obviously using dtsrun but im having trouble. I've never attempted this before and it looked easy but not as easy as I thought.

I have two dts jobs, call them package1 and package2. I also saved these as .dts files. I made a .bat file and put it in the same location as the .dts files.

My batch file looks like this:

dtsrun /F package1
dtsrun /F package2
pause

This does not work and I get the following:

C:WINDOWS>dtsrun /F package1
DTSRun: Loading...

Error: -2147287038 (80030002); Provider Error: 0 (0)
Error string: The system cannot find the file specified.

Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 704

Can anyone help and tell me what I am doing wrong?

Thanks

Neil.

View 4 Replies View Related

DTSRUN

Feb 4, 2008

Hello all,
I am trying to run a DTS package from a .DAT file and in my file this is my code:

DTSRun /S ServerName /E /N "Promo Point Adjust - Import promo file"/
But when I run that the data in the table is not being updated. my question is
-how to I step through the to see what the disconnect is?
-Or if there is an error that is happening but being displayied?

Can anyone help me

View 1 Replies View Related

About Dtsrun

Nov 23, 2005

when I run the following in sql Analyzer :dtsrun /S"Local" /Ntestemail /UExternalRO /P"changmail"got this error:Server: Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near '/'.Is the command right?And how to run this dts package in commandline?Thanks

View 1 Replies View Related

Relationship To UserId

Nov 22, 2006

Hi there everyone, this is my first post so go easy on me :)
Basically I am trying to get my database to copy the value in the UserId (unique identifier field) from the aspnet_Users table to a foreign key UserId in a table called userclassset. I have made this field the same datatype and created a relationship between the two. Unfortunately, when I add a user using the ASP.Net configuration tool it does not automatically copy this value into my own custom table. I have noticed it is however automatically copied into the aspnet_Membership table. Any pointers on how to solve this would be great!
Thanks :)

View 2 Replies View Related

How To Generate Userid?

Feb 15, 2008

Hello everyone.

i need to auto generate the user id in id colunm in my sqldatabase table.i want it to generate in this fashion.(mycompanyname-todaydate-number.)eg (ibm-15thfeb-1) (ibm-15thfeb-2) (ibm-16thfeb-1)here i need this user id to be automatically displayed in my web form when doing registration of new user,then only after clicking the savebutton i want all the data along with user id to be inserted into the table in sqldatabase.thanksjack.

View 38 Replies View Related

How To Get DB UserID From ConnectionString

Mar 5, 2008

HiI've my ConnectionString in web.config... I want to display the DB UserID on my webPage and UserID is specified in ConnectionString... Can any one help me in this caseThanksNasir Ibrahim

View 2 Replies View Related

Sqldatasource Where UserId=

May 13, 2008

I am trying to configure a sqldatasource control using the where clause to grab a single record with a certain UserId. Teh UserId is stored in a variable of type System.Gui and I cant seem to figure out how to do this. Can someone give me a hand please?

View 3 Replies View Related

Sorting By UserID

May 24, 2006

I'm trying to sort by domain user id, I can pull the user id fine but now I want to sort my SELECT by that name. How do I put the value of getUserIdentity into my SELECT statment.
Thanks
<script language="C#" runat="server">    protected string getUserIdentity()    {        return HttpContext.Current.User.Identity.Name.ToString().Replace("DOMAIN\", "");    }
    protected void Page_Load(Object sender, EventArgs e)     {        username = getUserIdentity();                SqlConnection myConnection = new SqlConnection("Data Source=CLIENTELE;Initial Catalog=forms;Integrated Security=True");        SqlDataAdapter myCommand = new SqlDataAdapter("SELECT * FROM formTable WHERE userID = @username ORDER BY status DESC", myConnection);
        DataSet ds = new DataSet();        myCommand.Fill(ds, "names");
        MyDataGrid.DataSource=ds.Tables["names"].DefaultView;        MyDataGrid.DataBind();    }
</script>

View 1 Replies View Related

Using UserName As A PK VS. UserId

Jan 6, 2005

Hello

Currently, I am using a varchar "UserName" as a primary key instead of an Identity or GUID.

System Info:
When user's sign up they provide the "UserName" that is used as a PK.
Creating a message board type web application.
UserNames will never change.
UserNames are used extensively as FK's in other Tables.
We want to scale well.

Does anyone know the implications?
I understand Joins are faster on numerical values than strings but we will not be performing many joins.

In my case is it better to use Identity as a PK or is it better to use a varchar for a "Users" table?

Thanks
jenn

View 1 Replies View Related

Userid And Machine Id

Mar 29, 2007

I wrote trigger to insert old data before update or delete .
Now while inserting i want to insert userid and machine id
for user id ia tried the following query as

SELECT CURRENT_USER;
it retuns o/p as dbo
Please give me solution

Malathi Rao

View 3 Replies View Related

Asking For Userid And Passwords On 28

Feb 28, 2008

I have installed Sql Server 2000 Reporting Services.
I desinged report in VS 2003.When press F5 key.Every time it is asking for user id password then only it is giving List of Report Names.

Is there any way to avoid giving user id and pwd every time.
Regards.

View 1 Replies View Related

DTSRun: Error

Mar 20, 2002

I have SQL Server 7.0 desktop installation and I installed SQL Server 2000 clinet.

Now, when I execute DTSRun from the command prompt, I am getting error message
dtsrun.exe Entry Point Not Found in dynamic link library SQLRESLD.dll

Can some one help on this.

Thanks

View 1 Replies View Related

DTSRun Error

Mar 20, 2001

Hello

I have created a very simple DTS package to transfer data from one database to another on the same server. I am able to successfully execute the package from DTS. But if i try to schedule the package and run it from SQL agent it fails. The job that is created by the SQL agent appears as follows -

'DTSRun /~Z0x2939C85E61C391613034D42DC85BA5E18B1E12D06DC31F 242542405E07594E436B58219AC124F29B80EDEB464ACB52BA 977BF7A0E59BE9C183507AF7CDA9EB1033C1E04009EC5D4467 E1955FB83FA31BC185F4D4398F51F008BDE6677D23F9C5571A 4C3010B0ED1943C234'

and the error message i get is invalid switch .... DTS command invalid options

Please help!

Thanks
aruna

View 1 Replies View Related

DTSRUN Utility

Apr 9, 2001

Hello everyone,

I have a question about dtsrun hoping someone have an answer. Does anyone know if there is a switch that I can turn onoff so that it will suppress the output result when I execute the dtsrun ulitity?

This is what I ran:

master..xp_cmdshell 'dtsrun /Sclancy /E /N ExpDispute'

I get the following result back after it's done:

output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DTSRun: Loading...DTSRun:Executing...DTSRun OnStart: Copy Data from Results to [Transplus_TestArchive].[dbo].[SG_DISPUTE] Step DTSRun OnProcess: Copy Data
from Results to [Transplus_TestArchive].[dbo].[SG_DISPUTE] Step; 14 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 14 DTSRun OnFinish: Copy Data from Results to [Transplus_TestArchive].[dbo].[SG_DISPUTE] Step DTSRun:
Package execution complete.
(6 row(s) affected)

Thank you in advance for any help.

Mai Nguyen

View 2 Replies View Related

Dtsrun Error

Jul 31, 2001

Hello!
Here's a problem I'm having with user's laptop.
I installed SQL Server 7.0 client tools long time ago so she was able to use dtsrun utility.
Recently we moved our production database to the new server.
The difference between new server and old one is SP.
The old server had SP1 for MSSQL Server 7.0 and new server has SP2.

The DTS packages were copied from old server to new one and recreated accordingly.

Then when user was trying to run dtsrun utility she was getting error "Parameter is incorrect".
Then I applied SP2 to her SQL installation.
After that we've got different error message "Can not create COM server to load DTS package.
Class not registered".

I tried to register following files dtsffile.dll,dtspkg.dll,dtspump.dll,axscphst.dll using regsvr32 but I coudn't-I was getting errors.

Then I reinstall SQL client tools and applied SP2 again-still same error about COM server.

Any ideas what else can be done or changed to fix it?
Thank you

P.S.this user has another computer.
Applying SP2 to her SQL client installation fixed "Incorrect parameter" error and dtsrun works fine on this machine.

Lena

View 1 Replies View Related

DTS - DTSRUN Error

Jul 12, 2000

Hi,

Thanks for any help on this matter in advance.
I have a DTS Package that when I run from within the MMC it runs fine but when I schedule the job from the DTS design window or create a new job via SQL Agent and use dtsrun.exe with the correct parameters I get the following error:

DTSRun: Loading . . . Error -2147008511 (80074001) Provider Error: 0 (0)
Error String: Not implemented

Dts Owner is sa
Sa is also listed as owner for the job.
I tried changing the provider to ODBC for SQL Server since error message indicated a provider error and that did not work.
I searched Technet for 4001, provider error, dtsrun and got nothing relative. It would seem like a rights issue but SQL Agent Logs on as a local administrator for the SQL box which is also the PDC.

Any insight?

Thanks

Paul Kelly
like_dbaguy@hotmail.com

View 1 Replies View Related

DTSRun Erro

Jan 9, 2001

Hi everyone,

I am using SQL Server 2000 and I get this error.

I get the following error when I attempt to run DTSRun from the command prompt:

C:>DTSRun /S (local) /U sa /N "ACPAY_New" /R "ThedaCare1"
DTSRun: Loading...

Error: -2147217355 (80041035); Provider Error: 0 (0)
Error string: General error -2147217355 (80041035).
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 705

This error makes no sense to me. I also get the following message too

C:>DTSRun /S local /U rrojas /N ACPAY_New /R ThedaCare1
DTSRun: Loading...

Error: -2147217390 (80041012); Provider Error: 0 (0)
Error string: [Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen (Connect()).
Error source:
Help file:
Help context: 0

What I have done is created a package called ACPAY_New and saved the package
in two places, the SQL Server and the Meta Data Services (Repository). The
name of the Database is ThedaCare1, the name of the server itself is local or rrojas, the user name is rrojas. I have no idea as to what this error message
means. If I run the job in SQL Server Agent, the job does not run at all.

If I run the package on it's own within Data Transformation Services, by
right clicking and execute it runs fine.

Please help.

Thanks,

Rey

View 1 Replies View Related