(different) error logging onto sql server / database help

When trying to connect to my sql server I get the following error :

Connection Failed :
SQLState:'08001'
SQL Server Error : 17
[DBNETLIB][ConnectionOpen(Connect))(.[SQL Server Does not exist or access denied]

im not sure how to give a user access or give the user the right password

I get the same error when trying to create a database and connect to the server.

Im working on xp pro, and using VS.net. also theres a red x next to the cylinder of the sql server, so im assuming im doing something wrong.Check these two things first:
Make sure the authentication method is the same in your pages as the way it's set up on the server

Also - if it's sql/mixed- make sure the login userID and PWD are correct.|||this is the line i have in the web.config file

<identity impersonate="true" userName="MIKE-\Michael"
password="cuomo23"/
how do I check what method is being used on the pages. and the server is which i choose, either windows nt. or sql? correct?|||is mike-\michael a valid user in the SQL database or the Windows Domain? Looks like a local machine account rather than a domain account. So is you web machine the same as the SQL server machine?

"VS_ISBROKEN" error

[DTS.Pipeline] Error: "component "Source - Query" (1)" failed validation and returned validation status "VS_ISBROKEN".

I'm getting this error in the Data Flow task when exexuting this sql:

SELECT * FROM tbl_ws_stats WHERE pk > pk_var

pk_var is a package variable which I confirmed is being set correctly. The sql is set as a property expression.

What could be causing this?

using SQL Server 2005

Thanks

What is your property expression? it should be something like:

"SELECT * FROM tbl_ws_stats WHERE pk > " + (DT_STR, 100, 1252)@.[pk_var]

-Jamie

|||Verify that you have a good connection to your database. I check by running a simple query in the "lookup" transform. You can also verify with the connection manager.

I routinely see this error when my Oracle listener is down.

"The request failed with HTTP status 401: Unauthorized" SQl server reports

I am using SQL Server Reporting. All reports are deployed on REPORTING SERVER.

I want to implement security roles as same as in Active directory. Currently reports are being accessed using Anonymous user setting in IIS.

I have added users in SQL Server security as well as data base level. But when user accesses report following error occurs:

The request failed with HTTP status 401: Unauthorized

Please reply with solution as soon as possible. I will be very thankful to you

So, this is an IIS error which means that the request doesn't event make it to the Report Server. You can try creating a simple website with a single page in it and configure this website for Windows Integrated security. You will probably get the same error. You need to find why IIS is rejecting the web request.

"Package Failed Validation" error

I'm trying to have a parent package derive the filename for the appropriate child package to execute. The parent package logic manipulates a Filename variable that is then used in the connection string of the Execute Package task: "c:\\Packages\\" + @.[User::Filename]
The error I'm getting is Error 0xC0012050 while loading package file "c:\Packages\test.dtsx". Package failed validation from the ParentPackage task. The package cannot run.
How can I resolve this security/authentication problem?
Why I'm trying to do this? I'm importing dozens of different flat files. Some of the files share a generic import package, but many use their own custom import packages. I've not found a reasonable way to do this kind of branch from within the Control Flow of the parent package. I'm eager for suggestions though!

Thanks

TGrant wrote:

I'm trying to have a parent package derive the filename for the appropriate child package to execute. The parent package logic manipulates a Filename variable that is then used in the connection string of the Execute Package task: "c:\\Packages\\" + @.[User::Filename]
The error I'm getting is Error 0xC0012050 while loading package file "c:\Packages\test.dtsx". Package failed validation from the ParentPackage task. The package cannot run.
How can I resolve this security/authentication problem?
Why I'm trying to do this? I'm importing dozens of different flat files. Some of the files share a generic import package, but many use their own custom import packages. I've not found a reasonable way to do this kind of branch from within the Control Flow of the parent package. I'm eager for suggestions though!

Thanks

Hi,
You can place expressions onto the precedence constraints in your control-flow. This allows for conditional execution of tasks which sounds as though its what you're looking for.

You may want to explore the Foreach loop container which enables you to carry out the same procedure on a collection of files one at a time. (Here's a demo of how to do this: http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx) You can place your conditional logic (as described above) within the Foreach loop container.

Also, if you want to process multiple files which have the same format in exactly the same way, consider using a multiflatfile connection manager!

Hope this helps.|||Is the package available at the time of validation? It may be that the error is telling you that it cannot load the child package. That will fail validation. There are a few things you can do if this is the case, but the easiest is to set "DelayValidation" equal to true on the ExecutePackage task.
There should be a valid package there when validating though.

"login failed for user" message when executing a copy of a working package

I notice when I copy an SSIS package 'A' to a new package 'B', the new package 'B' will generate a "login failed for user" message in the data flow components. To copy I "save copy of Package 'A' as."

Some config info:

Package ProtectionLevel = EncryptSensitiveWithPassword

Connections are Data Sources

Connection strings with password are stored using PackageConfigurations to an SQLServer table. I've verified Package 'A' is in fact using the config table (e.g. it is not using a password or user stored in the package)

Data connectios are all SQLServer Native OLE DB Client

The account is an SQLServer account (not integrated security)

The original Package 'A' works flawlessly and I get success when I test the connections in Package 'B'.

But executing package 'B' I get: The error message I get is: [Connection manager "MyConnection"] Error: An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'dwuser'.".

Does anyone know why this would occur and/or how to work around it? I saw another thread where a potential workaround is to create a new data flow task and copy all the data flow components to that task. That won't work well for us because the data flow is moderately complex and when you copy and paste it, SSIS completely re-orders the layout.

This is a typical data warehouse ETL setup where there is a master package that executes child packages (e.g. 'A', and 'B' mentioned above) that each perform the ETL for a specific dimension or fact table.

Thanks for any help,

Lee Cascio

Some more info and revelation.

Both child packages will run fine if I execute them independently (outside the parent package that calls them). The problem seems to occur when I try to execute them from a parent package. The OLE Db Connections will then fail on validation on both packages with the "login failed" message listed above in addition to the following: [MyTable [1]] Error: The AcquireConnection method call to the connection manager "MyDataSourceConnection" failed with error code 0xC0202009.

An interesting observation is if I disable Package 'B' in the parent package, Package 'A' will execute without flaw with the parent package. If I disable Package 'A' and enable Package 'B', Package 'B' will still have the problem. Another note, the parent package also uses the data source connections.

It appears we have some kind of problem with multiple packages using the same data source. Does anyone know if there are any limitations to this or if it requires special transaction settings?

Thanks,

Lee Cascio

|||I resolved this issue by switching to XML configurations instead of SQL Server table configurations. I'm still not sure of the exact cause but would have been a problem with credentials getting to the SQL Server Table for the configurations (which include connection strings).

"Could not start the SQL Server Integration Services..."

Running MS SQL 2005 SP1 on Windows 2003 Server SP1 (IA32). Upon rebooting, I get an error that this service failed to start, and when I attempt to start manually, I get the same error:

Could not start the SQL Server Integration Services service on the Local Computer.

Error 1053: The service did not respond to the start or control request in a timely fashion.

Any ideas?

Have you looed at http://support.microsoft.com/kb/886695/ ?

Thanks,
Ovidiu Burlacu

|||I also recommend this one - http://support.microsoft.com/kb/918644 :)