Newbie - Sa Password Error After ACT! Install - Need Pro's Help!!!

Aug 16, 2006

Hello,
I am admittedly new to this, especially sql server and am in need of a pro's assistance.. I installed Microsoft Small Business accounting, which in turn installed and configured a sql server. When I installed ACT! 2005 (v7.0) and tried to create a database, it states that it cannot find the master file.... so I tried to install sql server from Microsofts site - downloaded all the packages, unzipped them and ran them... the error I get is that the sql server needs to have an sa password and to use some switch to change it... for the life of me I am lost here. I can't use ACT! at this point and I have not ideas of how to remove, reinstall or repair the sql server.... Any help you can provide would be greatly appreicated!

View 9 Replies


ADVERTISEMENT

How To Set Password When Installing MSDE (was Newbie To SQL)

Feb 15, 2005

Hi Guys,

I am Access user of both BE and FE. I would like to set my BE with SQL

Therefore, as trial I just downloaded MSDE2000A.Exe a Desktop SQL Engine from Microsoft. I need to install it. But due to some technical aspect (which I might not understand) I could not install it. Bcz whenever I am trying to install its setup file, it ask me a strong password. How to set it ? or how to supply it I dont know...

Any help.

Regards,
Ashfaque

View 4 Replies View Related

Newbie Here With A Newbie Error - Getting Database ... Already Exists.

Feb 24, 2007

Hi there
I sorry if I have placed this query in the wrong place.
I'm getting to grips with ASP.net 2, slowly but surely! 
When i try to access my site which uses a Sql Server 2005 express DB i am receiving the following error:

Server Error in '/jarebu/site1' Application.


Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:



[SqlException (0x80131904): Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.
Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735075
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360



Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
 
 This is the connection string that I am using:
 <connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;Initial Catalog=ASPNETDB;User Instance=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
 
The database is definitly in the folder that the error message relates to.
What I'm finding confusing is that the connection string seems to be finding "aranga"s database.
Is it something daft?
 
Many thanks.
James 

View 1 Replies View Related

HELP: Newbie Install. Can&#39;t Register Server.

Dec 19, 1998

I have installed SQL6.5 on my NT4.0 server.
I go into the enterprise manager. There are currently no registered servers. I try to add a server under the SQL 6.5 group and get the following message:

"Unable to connect to Server(reason [SQL Server Login failed]. Register Anyway?"

The service is running. I can login through the command prompt, but when I type select @@servername it comes back as NULL.
I have tried both my NT SA account as well as the SQLExecutiveCmdExec account. TIA - pwb

View 1 Replies View Related

Install Help For SQL Server 2005 Newbie

Feb 28, 2006

I want to install SQL Server so at least the tables are stored on a D: drive rather than the default C: drive. If I can get the whole thing there, it would be best.

While installing S.S. the first time, I only came across one place to change a directory. After changing it, tables were still placed on the C: drive.

I am working with SQL Server 2005 Standard edition and using default settings, except for the directory of course.

Thanks for your help.

Steve

View 1 Replies View Related

Newbie - New Install Client Config Problem

Feb 13, 2000

Hi,

I've just set up a new installation of SQL 7 in a WinNT4/sp5 machine so I can learn more about this stuff and I'm trying to configure a Win98 client. From the Win98 client all looks well on the surface. Interestingly when I click on the server from within the Win98 MMC/Enterprise Manager it attempts to establish a dial-up connection to my ISP. The only network protocol I have running is TCP/IP.

Also, I can do what ever I want from within Enterprise Manager and SQL Analyzer but if I attempt to execute a script using the OSQL utility at a dos prompt as follows

osql /Usa /P /i "c:sqlimplexercisech02myscript2.sql"

I get the following error

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (connect()).

Any clues as to what I need to do to straighten this out? I have a DSN for the server which tests successfully using TCP/IP on the default port 1433.

View 2 Replies View Related

SP1 Install Problem With Password

Jun 5, 2006

I upgraded an existing SQL 2000 SP4 to SQL Server 2005. This is on a 2003 SP1 server. During the upgrade, the Native Client errored out and gave "password does not meet Windows policy". The Database Services failed to install. This machine is on a domain and the password length and complexity settings cannot be modified by the local computer policy.

I tried the installer a second time and no error was given and the install completed successfully. Both times were using Windows Authentication. From that point on, the SQL server seemed fine. That is until I tried installing SP1. I get the same error when installing SP1 and have yet to find a solution. I have changed the password of my SA account but the error still happens. So I cannot install SP1. Both my windows account and the SA account meet the password policy.

I am using Windows Authentication, but what is the user 'sysadmin' and how do i change its password? I am a member of the sysadmin role thru inheritance not direct membership. Domain Admins->Administrators->sysadmin.

Here is some of the log, a lot has been omitted.

create certificate [##MS_AgentSigningCertificate##]
encryption by password = 'Yukon90_'
with subject = 'MS_AgentSigningCertificate'

IF (@@error <> 0)
RAISERROR('Cannot create ##MS_AgentSigningCertificate## in msdb. INSTMSDB.SQL terminating.', 20, 127) WITH LOG


Originial error was 80073b0c (15116)



MSI (s) (00!08) [09:37:26:359]: Transforming table Error.

MSI (s) (00!08) [09:37:26:359]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!08) [09:37:26:375]: Transforming table Error.

MSI (s) (00!08) [09:37:26:375]: Transforming table Error.

MSI (s) (00!08) [09:37:26:375]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!08) [09:37:26:375]: Transforming table Error.

MSI (s) (00!08) [09:37:26:375]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!08) [09:37:26:375]: Transforming table Error.

MSI (s) (00!08) [09:37:26:375]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 15116
MSI (s) (00!08) [09:37:26:375]: Transforming table Error.

MSI (s) (00!08) [09:37:26:375]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!08) [09:37:26:375]: Transforming table Error.

MSI (s) (00!08) [09:37:26:375]: Transforming table Error.

MSI (s) (00!08) [09:37:26:375]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!08) [09:37:26:375]: Transforming table Error.

MSI (s) (00!08) [09:37:26:375]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!08) [09:37:26:375]: Transforming table Error.

MSI (s) (00!08) [09:37:26:375]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (00!08) [09:37:26:375]: PROPERTY CHANGE: Adding UpgradeInstruction property. Its value is 'Connect to SQL instance LEXDIVYRKS05 as sysadmin'.
SQL Server Setup has encountered the following problem:
Failed to execute the Transact-SQL statement:
/**************************************************************/
/* Sign agent sps and ...
Script file: sqlagent90_msdb_upgrade.sql
The error was: [Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet Windows policy requirements because it is too short.. To continue, correct the problem, and then run SQL Server Setup again.
Loaded DLL:
C:WINDOWSsystem32Odbc32.dll
Version:
3.526.1830.0


MSI (s) (00!08) [09:37:26:391]: PROPERTY CHANGE: Modifying UpgradeInstruction property. Its current value is 'Connect to SQL instance LEXDIVYRKS05 as sysadmin'. Its new value: 'Connect to SQL instance LEXDIVYRKS05 as sysadmin
Launch SQL statement USE master'.
MSI (s) (00!08) [09:37:26:391]: PROPERTY CHANGE: Modifying UpgradeInstruction property. Its current value is 'Connect to SQL instance LEXDIVYRKS05 as sysadmin
Launch SQL statement USE master'. Its new value: 'Connect to SQL instance LEXDIVYRKS05 as sysadmin
Launch SQL statement USE master
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesqlagent90_msdb_upgrade.sql'.
MSI (s) (00!08) [09:37:26:391]: PROPERTY CHANGE: Modifying UpgradeInstruction property. Its current value is 'Connect to SQL instance LEXDIVYRKS05 as sysadmin
Launch SQL statement USE master
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesqlagent90_msdb_upgrade.sql'. Its new value: 'Connect to SQL instance LEXDIVYRKS05 as sysadmin
Launch SQL statement USE master
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesqlagent90_msdb_upgrade.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradexpweb90_upgrade.sql'.
MSI (s) (00!08) [09:37:26:391]: PROPERTY CHANGE: Modifying UpgradeInstruction property. Its current value is 'Connect to SQL instance LEXDIVYRKS05 as sysadmin
Launch SQL statement USE master
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesqlagent90_msdb_upgrade.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradexpweb90_upgrade.sql'. Its new value: 'Connect to SQL instance LEXDIVYRKS05 as sysadmin
Launch SQL statement USE master
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesqlagent90_msdb_upgrade.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradexpweb90_upgrade.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesysdbupg.sql'.
MSI (s) (00!08) [09:37:26:391]: Transforming table _sqlScript.

MSI (s) (00!08) [09:37:26:391]: Note: 1: 2262 2: _sqlScript 3: -2147287038

<other seemingly less important data>

<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: CommitSqlUpgrade
PerfTime Start: CommitSqlUpgrade : Mon Jun 05 09:37:40 2006
<Func Name='ComponentUpgrade'>
There was a failure during installation search up in this log file for this message:
SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet Windows policy requirements because it is too short.. To continue, correct the problem, and then run SQL Server Setup again.
<EndFunc Name='ComponentUpgrade' Return='15116' GetLastError='0'>
PerfTime Stop: CommitSqlUpgrade : Mon Jun 05 09:37:40 2006
Gathering darwin properties for failure handling.
<EndFunc Name='LaunchFunction' Return='15116' GetLastError='0'>
MSI (s) (00:04) [09:37:40:953]: Transforming table InstallExecuteSequence.

MSI (s) (00:04) [09:37:40:953]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (00:04) [09:37:40:953]: Transforming table InstallExecuteSequence.

MSI (s) (00:04) [09:37:40:953]: Transforming table InstallExecuteSequence.

MSI (s) (00:04) [09:37:40:953]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (00:04) [09:37:40:953]: Transforming table InstallExecuteSequence.

MSI (s) (00:04) [09:37:40:953]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (00:04) [09:37:40:953]: Transforming table InstallExecuteSequence.

MSI (s) (00:04) [09:37:40:953]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 9:37:40: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
Action ended 9:37:40: INSTALL. Return value 3.

<other seemingly less important data>

Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet Windows policy requirements because it is too short.. To continue, correct the problem, and then run SQL Server Setup again.
Property(S): UpgradeInstruction = Connect to SQL instance LEXDIVYRKS05 as sysadmin
Launch SQL statement USE master
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesqlagent90_msdb_upgrade.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradexpweb90_upgrade.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesysdbupg.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesqlagent90_msdb_upgrade.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradexpweb90_upgrade.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesysdbupg.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradeprocsyst.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradeu_tables.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradexpstar.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradeweb.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesqldmo.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradeodsole.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesqlmap90_install.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgradesqlagent90_upgrade.sql
Delete file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgrade
epl_master.sql
Delete folder C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLUpgrade
Start service MSSQLSERVER with parameters -r
Stop service MSSQLSERVER
Start service MSSQLSERVER
Connect to SQL instance LEXDIVYRKS05 as sysadmin
Launch SQL statement USE master
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallsysdbupg.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallDbEngine_hotfix_install.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
epl_hotfix_install.sql
Stop service MSSQLSERVER
MSI (s) (00:04) [09:37:41:625]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log.

View 21 Replies View Related

NEWBIE.. SQL EXPRESS Attach During VB.NET Windows Application Install - Oneclick

Oct 16, 2006

Here's what I'm going for:

I have an 05 VB.NET windows application that will be used as a smart client for our folks in the field. The windows application includes 05 SQL Server Express. I have included in the Data Sources of my project and attached file going through the wizard Microsoft SQL Server Database File (SqlClient) ='s (myfile.mdf) and then selected all tables, views, stored procedures, and functions... the corresponding myfileDataSet.xsd with the myfile.mdf are now located in the root of the project. I now recompile the project without error and go to the properties section Publish tab... select the Application Files button and myfile.mdf Publish Status is set to Include and the Download Group set to Requried. With this in place I right click on the myfile.mdf from the Soultion Explorer and under the properties section have set the build action to compile and use the copy always setting for the Copy to Output Directory.

My app.config looks like this:

<configSections>
<sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
<section name="myfile.My.MySettings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
</sectionGroup>
</configSections>
<connectionStrings>
<add name="myfile.My.MySettings.ffgscrmConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|myfile.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

After the publish is completed on the client machine... install for WIndows Installer 3.1, SQL Server Express, and the Windows Application contains no data but everything else works fine.

My problem is that I need to attach the myfile.mdf to the new SQL Server Express instance on the client machine during the installation process so that when the application fires it will be pointed to the above location on the client.

Anyone have any ideas... scripts... includes for an ApplicationEvents.vb, source code on how to do this correctly?

Kind regards,

BillB

View 6 Replies View Related

Newbie Question- SQL Server 2005 Management Studio(how To Install SISS)

Nov 1, 2007



Hi all,

Im currently using SQL server 2005 Management Studio. I need to export files from SQL database to Access database.
But I dun think SISS is installed. Can anyone advise where to look for the file to install? Thks in advance.

Wee

View 5 Replies View Related

How To Install Sql Server 2005 Automatically With Sa Password

May 25, 2007



Hi!



How to install sql server 2005 automatically with sa password



I want to know that i am creating a setup in visual studio 2005, i have set up sql server as prerequsite, by default the sql server installation is silent, it does not ask anything, in MSDE we had the facility of setyp.ini file which automatically creates the database with the settings provided in the ini file. Is there any option like this in sql server 2005 express editon.





[Options]
INSTANCENAME="MSDE"
SECURITYMODE=SQL
SAPWD="admin"






now what can be done in sql server 2005 express edtion

View 1 Replies View Related

NEWBIE: How Do I Embed And Quietly Install Sqlserver Express On A User's Machine Without Their Intervention?

Feb 23, 2007

Hello,

I am kind of new with .Net development and really new with using SqlExpress. Here is my question, I hope it is easy:

I have a shareware program that I have been selling since 2000 and it was written in VB6 using a third party database program. What I would like to do is rewrite this application using C# and SqlServer Express. The program as it stands right now is about 5mb to download and install.

My concerns:

1) How do I embed and quietly install sqlserver express to the end user's computer without them having any intervention?

2) By using sqlserver express as my database how much extra overhead is going to be included in the install package? I want to keep the install package as small as possible and the user experience of installing the program as painless as possible.



Thanks in advance,

View 8 Replies View Related

Double Click SQL Server Express And Install With Sa Password

May 30, 2007

Hi!



Is it possible to double click the sql server express installer, it will install sql server 2005 in silent mode, set sa password..



Just want alternative of command installation on double click



setup.exe /qb INSTANCENAME=<InstanceName> SAPWD=<StrongPassword>



is it possible







thanks in advance

View 4 Replies View Related

SQL Desktop Edition Sa Password Thingy Stopping Install On XP Home

Apr 13, 2004

Help,

the installation process stops almost immediately telling me I need a superduper secure password thingy but when I try the command prompts suggested they don't work... I'm on XP home.

View 11 Replies View Related

SQL Server 2005 Express - Setting Sa Password Fails During Install

Mar 21, 2007

During an install of SQL Server 2005 Express setting the sa password does not work consistently. The install is being run as administrator and I am using an .ini file to pass the settings,

SECURITYMODE=SQL
ADDLOCAL=ALL
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
INSTANCENAME=DBSERVER
SAPWD=Westtech#1

and while most times it works correctly, occasionally, maybe 4 out of 10 times it fails to set the password and I have been unable to find any warnings or errors in the logs it generates.

We are coming up on release and this is causing us some real problems. Does anyone have any ideas, something I could look at?

Thank you,

Kathy Mook

Westbrook Technologies, Inc.

View 6 Replies View Related

Setting Sa Password In SQL Server 2005 Express During Install Works Inconsistently

Mar 21, 2007

When installing SQL Server 2005 Express and using an .ini file that looks like this,

SECURITYMODE=SQL
ADDLOCAL=ALL
SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
INSTANCENAME=DBSERVER
SAPWD=Westtech#1

sometimes the sa password is set correctly, while other times it is not. There does not appear to be any particular environment or system setting when it fails vs. when it works.

We are coming up on a release date and this is causing us a serious problem. Can anyone help?

Thank you,

Kathy Mook

Westbrook Technologies, Inc.

View 1 Replies View Related

Failed To Install And Configure Error On Install

Nov 14, 2007

Hi,

I've tried looking for a solution in other threads but I couldn't find anything that was completely the same as my situation. I got a new pc at work and I've tried installing SQL Server 2005 on it but everytime I try to install it, regardless of services included or excluded with the install, I cannot get through the install without this error. Below is the excerpt from the Summary.txt log file.


Error Code: -2147024894
MSI (s) (74!98) [17:10:55:858]: Product: Microsoft SQL Server 2005 Tools -- Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Mon Nov 12 17:10:55 2007
<Func Name='Do_sqlAssemblyRegSvcs'>
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog.
Error: 2147942402
Error message: The system cannot find the file specified.
Error descrition: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Error Code: -2147024894
Windows Error Text: The system cannot find the file specified.
Source File Name: sqlcasqlassembly.cpp
Compiler Timestamp: Thu Aug 11 01:12:01 2005
Function Name: Do_sqlAssemblyRegSvcs
Source Line Number: 155


I've searched for and found similar problems that deal with the microsoft.sqlserver.notificationservices.dll not being found but I haven't found a fix that worked for me. These are the fixes I've refered to thus far.


http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1651162&SiteID=17

http://support.microsoft.com/kb/940971

http://www.microsoft.com/products/ee/transform.aspx?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlcasqlassembly.cpp@Do_sqlAssemblyRegSvcs@Do_sqlAssemblyRegSvcs@x80131501


The answer that seems to fix this problem for everyone is to set the MSDTC service login as the NT AUTHORITYNetworkService account. The problem for me is that this is already set to this profile and I've tried resetting the services and rebooting the machine. I did not have a problem with my old machine, which as far as I can tell, is the same configuration, so I know this install should work.


I'm running Windows XP SP2. This is not the upgrade to SQL Server 2005 SP2, this is the original disk that came with Visual Studio 2005.


Has anyone else faced this issue where changing the MSDTC login wasn't the solution? Also, this is my first post, so I apologize if I've left anything out. Just let me know if you want any other information.


Thank you in advance.
Tim

View 7 Replies View Related

Newbie Need Help. Export Error, Null Value Error.

Sep 24, 2004

Hey all,

I'm currently using a shopping cart software called .netCart, which is in ASP.NET and VB. I have been trying to import my local "fully working" database to my remote server using Enterprise Manager via the DTS Export/Import Wizard, but then the exported remote database is not working with the software. Unfortunately, I have no prior experiences in MS SQL database at all, nor do I know anything about the scripts they used with the software I purchased.

Error message when attempting to run part of the software (website) with the exported database -

"Cannot insert the value NULL into column 'CustomerID', table 'tablename.dbo.Customers'; column does not allow nulls. INSERT fails. The statement has been terminated. [Customer Table]"

I simply used the DTS wizard to export the database. All settings are left "default" because I don't know what I should do about them....

1) At Specify Table Copy or Quert, "Copy table(s) and view(s) from the source database is selected.
2) Selected all tables. At the "Column Mappings and Transformations" window for all tables, "Create detination table" is SELECTED and "Enable identify insert" is UNCHECKED.
3) At one of the error table (i.e. Customers), the CustomerID int is NOT NULL.

Sorry, I do not know what's wrong with it, and I don't know how to explain it better technically. The software company do not support this as well.

I believe the problem is with the settings in the DTS wizard when I try to export the database. Something is not set right, but I don't know how to do it.

Can anyone please try to solve this problem for me? Thank you very much.

Temjin

View 2 Replies View Related

SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. )

Jun 12, 2007

I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.

Extract from log:

<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).

I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.

Any ideas?

View 3 Replies View Related

Newbie Error

Apr 13, 2004

Hi guys,
Your help please.
First off, I have searched the Forum for answers using the keywords and tried those clues first but with no luck. This one for example: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q282254

I had a copy of MSDE installed on my machine about 12 month ago but never used it so I uninstalled it. Then I downloaded and installed SQL Server 120-day Evaluation edition a few days ago. When I tried to run SQL Server I get
An error 1069 – (The service did not start due to logon failure)…

I’m using Windows XP.

How can I find out what the password is or how can I reset it so the SQL Server logon works?

Any ideas?

Thanks Guys


FB

View 3 Replies View Related

Function Error (newbie)

Jun 16, 2007

eh guys ma kind of newbie n tis ... k like wrote a function like

CREATE FUNCTION [dbo].[GetDetailText]
{
@PackingID int,
@PackingType int
}
RETURNS varchar(100)


AS

BEGIN

DECLARE @DetailText varchar(100)

IF (@PackingType = 1)
BEGIN


SET @DetailText = (SELECT
'Tickness' + ':' + CONVERT(varchar, dbo.KF_PackMaterial.thickness) + '' + CONVERT(varchar, KF_Unit_3.Symbol)
+ ',' + 'Width' + ': ' + CONVERT(varchar, dbo.KF_PackMaterial.width) + '' + CONVERT(varchar, KF_Unit_1.Symbol)
+ ',' + 'InnerDia' + ':' + CONVERT(varchar, dbo.KF_PackMaterial.india) + '' + CONVERT(varchar, KF_Unit_5.Symbol)
+ ',' + 'OuterDia' + ':' + CONVERT(varchar, dbo.KF_PackMaterial.outdia) + '' + CONVERT(varchar, KF_Unit_6.Symbol)
+ ',' + 'Recycle' + ':' + CONVERT(varchar, dbo.KF_PackMaterial.recycle) + ', ' + 'Shade' + ':' + CONVERT(varchar, dbo.KF_PackMaterial.shade)
+ ',' + 'Weight' + ':' + CONVERT(varchar, dbo.KF_PackMaterial.weight) + '' + CONVERT(varchar, KF_Unit_4.Symbol)
+ ',' + 'Perforation' + ':' + CONVERT(varchar, dbo.KF_PackMaterial.perforation) + ' (' + CONVERT(varchar, dbo.KF_PackingMaterial.PackingTypeName)
+ ')'
FROM dbo.KF_CartonImageList RIGHT OUTER JOIN
dbo.KF_PackMaterial INNER JOIN
dbo.KF_PackType ON dbo.KF_PackMaterial.type = dbo.KF_PackType.PackID INNER JOIN
dbo.KF_Unit KF_Unit_1 ON dbo.KF_PackMaterial.widthunit = KF_Unit_1.UnitID INNER JOIN
dbo.KF_PackingMaterial ON dbo.KF_PackMaterial.packmaterialid = dbo.KF_PackingMaterial.Packingid LEFT OUTER JOIN
dbo.KF_Color ON dbo.KF_PackMaterial.ColorId = dbo.KF_Color.ColorId LEFT OUTER JOIN
dbo.KF_Unit KF_Unit_6 ON dbo.KF_PackMaterial.outdiaunit = KF_Unit_6.UnitID LEFT OUTER JOIN
dbo.KF_Unit KF_Unit_5 ON dbo.KF_PackMaterial.indiaunit = KF_Unit_5.UnitID LEFT OUTER JOIN
dbo.KF_Unit KF_Unit_4 ON dbo.KF_PackMaterial.weightunit = KF_Unit_4.UnitID LEFT OUTER JOIN
dbo.KF_Unit KF_Unit_3 ON dbo.KF_PackMaterial.thicknessunit = KF_Unit_3.UnitID LEFT OUTER JOIN
dbo.KF_Unit KF_Unit_2 ON dbo.KF_PackMaterial.lengthunit = KF_Unit_2.UnitID LEFT OUTER JOIN
dbo.KF_Unit KF_Unit_7 ON dbo.KF_PackMaterial.heightunit = KF_Unit_7.UnitID ON
dbo.KF_CartonImageList.CDImageId = dbo.KF_PackMaterial.CDImageId
WHERE (dbo.KF_PackMaterial.id=@PackingID AND dbo.KF_PackMaterial.packmaterialid=@PackingType))
END

return @DetailText
END


buts its throwing syntax error like
"[Microsoft][ODBC SQL Server Driver]Syntax error or access violation
"

... ne idea ????????

View 3 Replies View Related

Newbie Error? Crosstable Query

Mar 30, 2005

I'm struggling with the problem which feels like it shouldn't be taking me this long! Any help would be gratefully received. Simply, there are two tables: Users: userid | username Links: sourceUserId | destUserId sourceUserId and destUserId are both in the users table. I'm trying to write a SP which will output the names of the linked users. eg: Bob | Alice Alice | Geoffrey Peter | Bob Any help gratefully received! Thanks in advance -- Chris

View 2 Replies View Related

Newbie Help: SQL Server Does Not Exist Error

Nov 23, 2004

I've seen this question asked when I searched, but I didn't see an answer that looked like it applied to me, so I'll ask again.....

Making the transition from VB 6 to VB.NET and decided to take a stab at database programming while I'm at it. I bought "Database Programming with Visual Basic.NET and ADO.NET" by Sams Publishing and ran into problems in the first chapter. I've posted some questions on the microsoft.public.vb.database newsgroup and got some help, but it's still not working.

I'll skip some of the boring stuff and dive right in with what I've found out so far:

From MSSQL$VSDOTNETLOGERRORLOG

2004-11-19 02:29:34.71 spid3 SQL global counter collection task is created.
2004-11-19 02:29:34.76 spid3 Warning: override, autoexec procedures skipped.
2004-11-19 02:29:58.87 spid51 Error: 15457, Severity: 0, State: 1
2004-11-19 02:29:58.87 spid51 Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..
2004-11-19 02:29:59.01 spid51 Error: 15457, Severity: 0, State: 1
2004-11-19 02:29:59.01 spid51 Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install..
2004-11-19 02:29:59.46 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

The last suggestion was to uninstall and reinstall. I uninstalled VS and SQL and reinstalled getting the same error message in the log, but the message box said that installation was complete.

On the Server Explorer of the IDE, it shows my computers name (programmer) under Servers. When I expand that and expand SQL Servers, I see PROGRAMMERVSDOTNET. When I try to expand that, I get the SQL Server Login window with Server textbox disabled saying PROGRAMMERVSDOTNET and the Database blank. Under the Login it has James (my sign in name) and asks for a password. When I did the MS-DOS CLI installation, I used "password" as the SAPWD. I tried using password, and tried using the password to log on as James, and get the same error message: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Any help would be appreciated, as long as you remember that I am a COMPLETE newbie at this. I'm fairly computer literate, but I don't know the first thing about databases.....

Thanks again,

James

View 3 Replies View Related

Newbie: Error-message Question

May 16, 2006

I got the error message: "The metadata of the following output columns does not match the metadata of the external columns with which the output columns are associated". What does that mean and how am I supposed to fix the problem?



TIA,

Barker

P.S. The SSIS UI seems extremely slow and sluggish (opening, creating connections). Any performance tweaks known? (I have 9GB of RAM on my box and plenty of HD space so I don't think that is it. I also have sql 2005, sp1 installed.)



View 2 Replies View Related

Newbie Question: Error 9002

May 4, 2007

I'm getting the following msg.



Server: Msg 9002, Level 17, State 2, Procedure spPFW_Get_Financial_Data, Line 145
[Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.



When I use the tools/backup database it will not let me select backup transaction log or fails the bacup of the tempdb database with a msg saying : 'Backup and restore operations are not allowed on database tempdb'



What should I do?

View 5 Replies View Related

Newbie To SQL. Error Connecting To Server

Sep 27, 2007

hy.
i am a newbie to SQL

i downloaded and installed SQL SERVER 2005 EXPRESS.
i tried to convert an "ACCESS" database to sql and got the next error:

: "AN ERROR OCCURED
WHILE ESTABLIDHING A CONNECTION TO THE SERVER. WHEN CONNECTING TO SQL 2005,
THIS FALIURE MAY BE COUSED BY THE FACT THAT UNDER THE DEFAULT SETTINGS SQL
SERVER DOES NOT ALLOW REMOTE CONNECTIONS. PROVIDOR NAMED PIPES ERROR 40 -
COULD NOT OPEN A CONNECTION TO SQL SERVER".

any help apreaciated.

View 1 Replies View Related

Newbie With An Easy Compilation Error Question.

Dec 30, 2003

I've been looking over this and can't see anything wrong. Can anyone shed some light on this for me?
------------------

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0117: 'System.Data.SqlClient.SqlConnection' does not contain a definition for 'ExecuteReader'

Source Error:



Line 16: SqlCommand myComm = new SqlCommand("SELECT users, password FROM users WHERE username='" + username + "' AND password='" + password + "'", myConn);
Line 17: myConn.Open();
Line 18: SqlDataReader myReader = myConn.ExecuteReader();
Line 19: do
Line 20: {


Source File: D:Inetpubhoteladvisor estLogin.aspx Line: 18


void Login(string username, string password)
{
SqlConnection myConn = new SqlConnection ("server = client1; uid = dbadmin; pwd = dbadmin; database = hotels");
SqlCommand myComm = new SqlCommand("SELECT users, password FROM users WHERE username='" + username + "' AND password='" + password + "'", myConn);
myConn.Open();
SqlDataReader myReader = myConn.ExecuteReader();
do
{
while (reader.Read())
{
if (username == myReader.GetString(1) && password == myReader.GetString(2))
{
messages.Text = "Your login was successful!";
}
else
{
messages.Text = " Your login was unsuccessful!";
}
}
}
while (reader.NextResult());
myReader.Close();
myConn.Close();
}
void Submit_Click(Object sender, EventArgs e)
{
Login(username.Text, password.Text);
}


Edit by moderator - NetProfit: Added < code>< /code> tags.

View 7 Replies View Related

How Do You Fix The Ssis XML Password Error

Jun 1, 2006

I have a simple package that I created. it gets information from an excel file using the excel connection and then imports it into a sql2005 table using the ole db connection. the job runs fine in the BI environment. and it will run fine once I've imported it to the server. However when I go to run it as a job step using the line

dtexec /Ser Name /U User /P xxxxx /SQ "SalesSuccess"

it errors out with the following error.

Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.

now i've tried a couple of things with the protection level ie
ServerStorage, EncryptSensitiveWithPassword, EncryptSensitiveWithUserKey

and none of these seem to work correctly. I'm at a loss as to what to do and any help would be greatly apprieciated

View 3 Replies View Related

SQL Authentication Error On Password Change

May 30, 2005

I have instaled SQL Server2000 in Administrator user login.My OS is Windows Adavance Server2000. It works Fine. If i change my Administrator Password and Login with the new Password then Sql Server dosn't Run.It says Authentication error if i try to run from service.
I belive DBA's in this forum can help me out.

View 2 Replies View Related

Sql Server 3.5 Beta 2 Password Error

Aug 9, 2007

When I try to open a 3.5 orcas db with c# express 2008 beta 2 receive error " the specified password does not match the database password".... why?

the password is right!

View 1 Replies View Related

Error Reading Password-protected FM In SQL Server

Jul 28, 2006

I'm trying to pull certain Filemaker 5 tables into SQL Server 2000 inan automated import job using a file DSN. Everything resides locallyon a Windows XP machine. My process works fine on a test FM file withno password, but with the real FM files, all password protected, itfails with this error:******Error Source: Microsoft OLE DB Provider for ODBC DriversError Description: Unspecified error[FileMaker][ODBC FileMaker Pro driver]An error has occurred whiletrying to gather a list of available tables.[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed.Context: Error calling GetRowSet to get DBSCHEMA_TABLES schema info.Your provider does not support all the schema rowsets required by DTS.******This happens whether or not I supply a password to the SQL Server job.It has been nagging me for days and I can't find any documentation onit. Has anyone else encountered this?Thanks very much.Scott

View 1 Replies View Related

Error Code 0xC0202009 + Connection Password

Dec 15, 2005

Hi,

I have developed a .dtsx package than runs normally from my computer. When I import it on the server and assign it to a job it always fails.

I tried also to run it directly from the server (remote desktop) and also faild. I exported the dtsx file on server and refresh the db connections and after that workd fine from the server.

Another work-around was to use windows authentication. Then runs normally from the server.

It seems that connection password is lost when importing the report on server. (The import is done in MSDB not in the filesystem)

But I can not design all the jobs on the server (work-around A) or use windows authentication (work-around B)

What is the problem and what can I do?

I have also played around with "save sensitive information" but with no results.

Thanks

View 10 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







Copyrights 2005-15 www.BigResource.com, All rights reserved