I have taken over an existing SQL 7.0 server. It has current production systems running on it.
I need to *confirm* what the SQL Agent password is; what simple task or job can I setup that will require me to provide the SQL Agent password so that I can confirm that what I have been told it correct?
Or does someone have another technique.
Thanks,
Bobby
bobby@teamcomfluent.com
Looking for opinions here on what is the best way to programmatically test that a password change to a credential has occurred successfully.
The password change was made using Alter Credential, and I can see in sys.credentials that the credential was updated by the tool that handles these updates. I would just like to be able to confirm that all of the credential updates were successful (in other words, they authenticate correctly) before anything starts to fail.
Assume that the number of SQL Servers is too great to manually check them even if the whole team worked on it together.
Thanks in advance!!
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
Hi;
I have built packages on SQL Server 2005 using the Import/Export wizard. The basic aim is to import a table from an Oracle database into my SQL database. It was running fine until recently when they Oracle database was upgraded to 10g (i think), and now something is wrong. If I run the saved package as administrator, it runs fine, but when I run it as part of a Agent schedule job, it seems to loose the password. The error message is not very descriptive ("The job has failed."), so i might be mistaken.
Help anyone ?!
Jaco
Hi..
Isn't this a bug?
Step 1) Create a package with ProtectionLevel = EncryptAllwithPassword or EncryptSensitivewithPassword, and set password in package.
Step2) In SQL Server Agent, Create a Job to call a package.
Step 3) IN SQL Server Agent, Scripting Job. In script, package password shows up...
---------------------------------------------------------------------------------------------------------------------------
USE [msdb]
GO
... ...
@os_run_priority=0, @subsystem=N'SSIS',
@command=N'/FILE "D:PackageWithPassword.dtsx" /DECRYPT "P@ssw0rd" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF',
@database_name=N'master',
@flags=0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
... ...
I'm having a problem with saving a password in a SSIS package that is accessing an Oracle database as an external data source. I experienced the problem that many people have had with the SSIS package not saving the Oracle password as expected. I successfully saved the Oracle datasource password (Password #1) using the "Encrypt sensitive with password" security setting and then setting a separate/new password (Password #2) for the SSIS package. I've imported this package into my Integration Services installation, and I can get it to run successfully by manually entering Password #2 when I open the package.
Now I want to pull the SSIS package into a SQL Job Agent, along with some other steps, to run on an automatic schedule. My question -- how/where do I embed Password #2 (the one for the SSIS package) in the settings for the SQL Job Agent step that I use to run the SSIS package? The SQL Job Agent step settings box prompts me for Password #2 before it will let me edit settings for the package, but it doesn't save that password. So when I actually run the whole job, the SSIS package always fails.
If you backup the transaction log (today at Noon)
and then take a backup copy that's a month old of the same
database and restore it to your current database [which is possible],
Can you then apply the transaction log that you took at noon to that
same database which you restore with last month data?
I wouldn't think so because you have a month worth of
transaction log, your LSN wouldn't be matching.
Is that correct???
Hi,
How can I "confirm" that I am running sp3a ???
When I run @@version I get:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
But I should get:
Microsoft SQL Server 2000 - 8.00.760.09 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Can somebody confirm that the .09 does not show up on the 3a SP (or) was SP3 later released (as I think I recall reading) which incorporated 3a ???
I know we are at 3a I just can't confirm it via these queries :confused: .
Thanks in advance,
Nancy
Server Error Message:
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1010818663, index ID 0: Page (1:305381) could not be processed. See other errors for details.
Server: Msg 8944, Level 16, State 1, Line 1
Table error: Object ID 1010818663, index ID 0, page (1:305381), row 34. Test (offsetNull >= BASEOFFSET) failed. Values are 0 and 4.
I've just finished installing the Developer Edition of SQL Server 2005 over the Eval Edition. I'm happy to say that, despite a few hiccups, I seem to have everything running smoothly now. However, I have read about a few cases where, although it appeared the installation was successful, various components of the Eval Edition were not properly upgraded, the time limit was reached and the eval expired.
How can I confirm a full and successful installation of the Developer Edition? (Help... About only gives me version numbers, not "editions.")
Thanks for any help,
Ken
How do we will come to know, whether file group is currupted or not
View 1 Replies View RelatedHow can i confirm that the data entered within the standard controls and after the click event for the particular sql query the data is been stored in the database tables (depending insert,update,delete).I want to display the different messages on the click event and that after the changes made into the tables.How can i do it ?? I m using ASP.Net with C#,VB and the sql server to store data.I also want to know where are the database tables exactly get stored which are made in the Microsoft SQL Server Management Studio Express.I want to use as the existing item in .Net but could not find.. Thanxs...
View 2 Replies View RelatedDuring startup one of my servers, containing a default and a named instance of 2005, receives the following error.
Message
Service Broker is disabled in MSDB or MSDB failed to start. Server level event notifications can not be delivered. Event notifications with FAN_IN in other databases could be affected as well.
The system databases for both instances were restored using backups from another instance. How do I confirm if Service Broker is enabled or disabled and why would I get this message? Is it due to restoring master or msdb?
Thanks, Dave
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 RelatedI 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?
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
when I run a package from a command window using dtexec, the job immediately says success.
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 3:37:41 PM
Finished: 3:37:43 PM
Elapsed: 2.719 seconds
However the Job is still in th agent and the status is executing. The implications of this are not good. Is this how the sql server agent job task is supposed to work by design.
Thanks,
Larry
On the login prompt for Report Server, there is a checkbox option to "Remember my Password." I check this, login successfully... but when returning to the Report Server, I am again prompted for the password, although the user name is saved. No matter how many times I do this, the password will not save in IE7. I have tried this on 3 different computers with IE7. In IE 6, I do not even get the checkbox as an option, just the user name/password prompt. In Firefox, the password saves fine. Any ideas what would be causing this?
Thanks,
Brian
Hi All,
I would appreciate any help here at all. I am pulling my hair out!
I am unable to start the snapshot agent or log reader agent from within SQL management studio. it fails on executing step 2 with unknown username or bad password.
I have checked all account details and they are correctly using my domain admin account. I can connect to SQL using teh same account and it also has sysadmin permissions.
If i copy the step 2 paramters and start from the cmd prompt (again logged in using the same domain account) they both start fine.
Any ideas would be gratefully received.
I am testing peer to peer replication in our environment. I simulated a three node peer to peer topology and a local distributor.
For some wierd reason I cannot get the Log Reader Agent and snapshot agent to start. The domain account under which SQL Server Agent runs has administrator previlage on the box. I also use a domain account for SQL Server Service. (none of the passwords changed).
This is the error I am getting - "Executed as user: abc. A required privilege is not held by the client. The step failed"
Any ideas???
Also this domain account is a member of
SQLServer2005MSSQLUsers$ServerName$MSSQLSERVER
SQLServer2005MSAgentUser$ServerName$MSSQLSERVER
We just moved source server to newer, bigger box ... Windows 2003 and Active Directory ... Snapshot agent worked but distribution failed ... Same login as on older machine, login is sysadm, used DCOMCNFG to allow ability to launch process ... What are we missing?
View 4 Replies View RelatedI put this together to export the user name /password to a csv file to test my SP to output the user name/password.
DECLARE @user_name varchar(50)
DECLARE @psswrd varchar(10)
SELECT @user_name ,@psswrd
FROM ngweb_bulk_enrollments
EXEC master.dbo.xp_cmdshell 'bcp NGDevl.dbo.ngweb_bulk_enrollments out C: est.csv -Sserver1 -T -t, -r
-c'
This works but I don't get the headers in the file. How can I include the headers?
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).
Is any has the same problem ?
I have an internal Project Management and Scheduling app that I wrote internally for my company. It was written to use MySQL running on a Debian server, but I am going to move it to SQL Server 2000 and integrate it with our Accounting software. The part I am having trouble with is the user login portion. I previously used this:
PHP Code:
$sql = "SELECT * FROM users WHERE username = "$username" AND user_password = password("$password")";
Apparently the password() function is not available when accessing SQL Server via ODBC. Is there an equivalent function I could use isntead so the passwords arent plaintext in the database? I only have 15 people using the system so a blank pwd reset wouldn't be too much trouble.
I am building a website in Dreamweaver. I have tried and tried to get a connection to SQL 2005. Everything works on the web except the stuff that requires the use of my SQL tables. With OPEN_Conn ="Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=master" I get an error at the bottom of my page saying this:
Microsoft OLE DB Provider for SQL Server error '80004005'
Invalid authorization specification
When I add a password and ID to the string the pages become very slow and I get this error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Using windows authentication when logging into SQL Server doesn't have a user id or password so maybe I just don't know what to put there. I have tried a mix of all the passwords and ID's I use on this computer. Do I even have to have the user ID and password and if not how do I fix the first error? All help appreciated.
Hi All.
Have a nice day.
in my project asp.net web.config file has
<connectionStrings> <add name="MyDbConn" connectionString="Data Source=NAVEEDSQLEXPRESS;Initial Catalog=QADB_2005;Persist Security
Info=True;User ID=db1;Password=12345;" providerName="System.Data.SqlClient" /> </connectionStrings>
I want to change password of database, how can i change. please can you assist.
Thanks.
Zahyea.
Hello ,
Is is correct that the 'sa ' passoword is stored in one of the files of the SQL Server and is easily readable if the location of the file is known ?
If not , then is the password encrypted when i try to connect to the SQL server on the Internet ?
Thanks.
Sameer.
I am designing a DTS package which i need to update every so often to change the name of the source file(it's a text import). Every time that i change this, then click save, the DTS job begins to fail, with password errors. I put the password back in correctly( i still don't know why it gets lost in the first place), and click save - same result. this is getting tremendously frustrating, so i really appreciate any answers.
View 3 Replies View RelatedI will like to Change the SA Password, Do i have to go thru all the DTS packages and Jobs to change it too?
Thanks
I need to get a password out of SQLServer 6.5. The account is a user account. I need to get the password so that I can create a development database. The DBA's that know the password have left the company, and I can not just change the password. Please HELP!!!
View 1 Replies View RelatedRecently my husband has taken the position of IS Manager for a major hotel Firm.
The IS Manager that was there before him had a SQL Server which held some of the hotels data.
He did not leave the SA password. How do you find out what the SA password is
if you do not have it? I do not know what to tell him. Does anyone out there
have any idea what he can do?
Thanks in advance for your help.
Dianne
Can someone tell me if there is a password in Entereprise manager.
I've been having trouble with Scheduled tasks.
There are not running anymore.
THANK YOU.
Hi!
When I try to set password for any login begining from 'sa' using Enterpr. Manager or sp_password I get error message:
'Server: Msg 552, Level 16, State 1, Procedure sp_password, Line 63
CryptoAPI function 'CryptAcquireContext' failed. Error 0x80090006: Invalid Signature.'
What does it mean?
Thank you,
Elena.