VS_NEEDSNEWMETADATA - SECURITY
Jan 22, 2008
I've made a SSIS-package in which I collect SQL-server metadata from different SQL-servers, all SQL2005, same edition.
This package works under the SQLagent account of 1 particular server.(all sql-servers have a different account under which sql-agent runs)
So there is 1 connection which must be changed to connect to the different SQL-servers.
The problem is that I receceive an error VS_NEEDSNEWMETADATA on the OLE-DB datasource which I use to connect to the different sql servers. The fact is that this happens on a stored procedure which is exactly the same on all servers.
So the metadata must be Equal.
The problem must be a security issue, because when I make the account under which the SSIS-package runs sysadmin on all the servers this package works fine.
=> I don't like it to let this account be sysadmin on all SQL-servers.
=> does anyone know which are the strict necessary rights which I must give to this account.
View 6 Replies
ADVERTISEMENT
Sep 14, 2007
Hello:
I need some help figuring out the true source of the following error:
"
Executed as user: EPSILONSYSTEM. ...ion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:53:09 PM Error: 2007-09-14 12:53:09.59 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSassword" 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. End Error Error: 2007-09-14 12:53:10.50 Code: 0xC020837F Source: Data Flow Task Source - icsp [1] Description: The data type of "output column "user2" (138)" does not match the data type "System.String" of the source column "user2". End Error Error: 2007-09-14 12:53:10.50 Code: 0xC004706B Source: Data Flow Task DTS.Pipeline Description: "component "Source - icsp" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA". The package execution fa... The step failed."
Reading the error it appears that the issue is with a datatype mismatch with field "user2". It is coming in as a unicode string and being sent into a varchar field. But so are a whole bunch of other userX fields as well. So why is my package having an issue with this specific field. Moreoever the package was running fine until a few days ago and runs successfully in BIDS!
I first figured that the source has changed, as there was some work being performed on the source ERP system. The package had failed a month ago and when I updated the metadata I thought it fixed the problem.
I appreciate your assistance in helping me resolve this issue!
View 9 Replies
View Related
May 2, 2008
Hello rooom,
I tried to execute SSIS package that created by a sql developer contractor.
There are several errors that i am not familiar with:
-Error at Get results to faw file [DTS Pipeline]: input column "" (221) has lineage ID 32 that was not previously used in the Data Flow task.
- Error at Get results to raw file [DTS.Pipeline]: "component "Raw File Destination" (208) failed validation and returned validation status "VS_NEEDSNEWMETADATA".
-Error at Get result to raw file (DTSipeline): One or more components failed validation.
(Microsoft Data TransformationServices VsIntegration).
Can someone guide me since I am consider myself a newbie to SSIS.
Regards,
TJ
View 1 Replies
View Related
Aug 11, 2007
Hi guys, wonder if you could help.
Ok, basically, my SSIS flow gets data from different excel worksheets and puts in the db.
For some reason its being very incosistent. I fixed all the problems I was having but one component keeps coming up with the [ component "Excel Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA" ] error.
So, I click on the component, it asks if i want to fix the metadata stuff, I say yes, it fixes it, I run the app, everything's cool.
The I run the app again and again it comes up with this f** error?
Is there anyway SSIS can't just ignore this metadata stuff??
thanks!
View 5 Replies
View Related
Dec 4, 2014
I use from sql server 2008. and c#
what is the best connectionstring?
I don't know if i use Persist Security Info and Integrated Security or not?
And if yes then their value must be true or false?
View 1 Replies
View Related
Oct 14, 2005
Hello there I have trying to figure out for days how to enable FullTrust for my Reporting Services security extension.
View 9 Replies
View Related
Jul 31, 2007
Hi,
I have posted this issue for a week, haven't got any reply yet, I posted it again and desperately need your help.
The article http://msdn2.microsoft.com/en-us/library/ms365343.aspx says:
Model Item Security can be set for differnt security filters, but when I use SQL Server Management Studio to set Model Item Security, it seems "Permissions" property surpass "Model Item Security" property. -- My report server is using Custom Authentication.
For example, in "Permissions" property of the model, if I checked "Use these roles for each group or user account" without setting any user or group, no matter what users I added to "Model Item Security" with "Secure individual model items independently for this model" checked, NO one user can see the model on report manager and report builder;
in above situation, if I added "user1" and gave role such as "Browser" role to "user1" in "Permissions" property, if I checked "Secure individual model items independently for this model" in "Model Item Security" property, even I did NOT grant "user1" to root model and any entities under the model, the "user1" is able to access the model and all entities in report builder.
My question is on the same report model, how to set "AdminFilter" (empty security filter) for administrator permissions and set "GeneralFilter" (filtered on UserID) for general user based on their UserID?
The article also says:
"Security filters are always applied, even for users who have Content Manager or Administrator permissions to the model. To allow administrators or other users to see all rows of an entity on which row-level security is defined, you can create an empty security filter (which always returns True) and then use the filter to grant those users access to all the rows."
So I defined 2 filters "GeneralFilter" and "AdminFilter" for "Staff" entity for my report model "SSRSModel", I expect after I deployed the report model, the administrator users use report builder to build reports with all rows available, and the non-admin users can only see rows based on their UserID.
I can only get one result at a time but not both:
either the rows are filtered or not filtered at all, no matter how I set the "SecurityFilter" for the entity: I tried setting both "AdminFilter" and "GeneralFilter" for SecurityFilter at the same time, combination of "DefaultSecurityFilter" and "SecurityFilter", or one at a time.
Your help is highly appreciated!
Desperate developer
View 1 Replies
View Related
Apr 26, 2007
hi i want to know what is the differance between
Persist Security Info=False;Integrated Security=Yes;
View 1 Replies
View Related
Oct 18, 2015
Is there any possibility to schedule SQL job execution as Windows Security Group? I need to run powershell script through SQL job with one of this group member's permissions.
View 4 Replies
View Related
Jul 6, 2007
I have Sql Server Express installed on Vista (service pack 2)
I have Visual Studio 2005 with an application that I'm trying to access it with within a WCF service.
The login ID of the service is added to the database.
The database has remote access turned on.
The ID is granted access to all databases within the server.
The thread is being set with WindowsProvider and the services set their thread to WindowsProvider.
The dataserver is set with using Windows Authentication for security.
When I open my connection to the database, though, it reports the typically useless message that the connection is not allowed and that the server may not allow remote connections.
How to I get past this? I've done everything right.
View 1 Replies
View Related
Jun 18, 2007
I want to use an Active Directory security group that is a Distribution List for a new role assignment for an existing report. Can someone tell me if this is possible? I get an error each time I try:
The user or group name <DLName> is not recognized. (rsUnknownUserName)"
View 1 Replies
View Related
Jul 20, 2005
Is there anybody out there with a MS SQL 2K Security Baseline orSecurity Checklist. Where can I get one????Thanks in advanceDavid
View 1 Replies
View Related
Feb 28, 2008
Hi;
I am looking for a way to log all security related events for SQL in Windows Security Log. I am trying to use SCOM for monitoring SQL and I am looking at ways to generate alerts in my SCOM Console for specific events in SQL e.g. A table is deleted, user is modified, deleted, etc. Is this possible and if yes how do I achieve the same?
Rgds;
View 6 Replies
View Related
Aug 3, 2006
In an environment where there are many initaitors speaking to a central target with frowarders in between, from what i can understand this best policy is to disable encryption on the endpoints, since dialog encryption will be enforced this is all that is really required, is this correct.
If the endpoints used encryption the message would need to be encrypted and decrypted at each forwarder resulting in slower perfromance, where as dialog encryption would only encrypt at the sender and decrypt at the target, so is this the best way to go?
Secondly is it best practice to open a dialog initally and send messages over this dialog for years never ending the conversation? This way the services only have to authenticate eachother once, if there are no reboots etc that is of course.
I would think performance wise sending each message and ending the conversation each time is a much greater overhead ? So would it be best practice to keep dialogs open and keep sending messages ?
Initally when i was learning service broker i thought that one must send a message and end the dialog until the next message, but i think the other way is the best option ?
Is this correct ?
Thanx
View 1 Replies
View Related
Feb 19, 2007
Hi
I'm designing a distributed application where I will have SQL Server 2005 distributed databases replicating data to my central hub which is again a SQL Server 2005 database using SQL Service Broker. Data will be sent from the central hub to the distributed sites and vice versa. I need to authenticate the communication and also secure the communication by encrypting the messages. Which security shall I use? Where do I configure the type of security being used? What is the difference between transport security Vs dialogue security - Full security model?
Thanks
View 4 Replies
View Related
Jun 19, 2000
Hi:
Can anybody tell me the advantage and disadvantage to use NT security for SQL Server 7.0? For a corporation with 400 users, what is your recommendation for the SQL Server security management. Thanks.
Joan
View 1 Replies
View Related
Jul 30, 2004
What's the better security to use? Currently I'm always registering using the Windows authentication. When I'm trying to register using SQL authentication I always get "Login failed for user 'sa'" error....
View 1 Replies
View Related
Jan 19, 2007
I have setup a linked server on the same computer but different instances of sql. When I call the sprocs an error occurs... The message is...
The OLE DB provider "SQLNCLI" for linked server LINKEDSQL does not contain the table ""product"."dbo"."AccountTable". The table either does not exist or the current user does not have persmissions on that table.
I've checked the table "AccountTable" and it does exist. The database exist also which is "product". I also configure the linked server's RPC to "true" and timeout to "200". The linked server is also configured to use a single username and password which exist on the instance of sql that the linked server is connecting. Also, I enabled the instances of sql to allow remote connections and use mixed authentications.
The mode of access is that different client pc will call a method created with .NET, which in turn, call the sprocs on the linked server. Should I add all the client pc that will be calling the method? Why I'm getting this error? Help please? Thanks
View 1 Replies
View Related
Feb 1, 2002
I would like to trap all of the hosts connecting to one of my sql servers and then determine if one of the hosts is not on my list of approved hosts. If the host is not approved, I would process an alert.
I have written a stored proc that queries the sysprocesses table and then raises the alert. The problem is that sysprocesses only includes entries for the length of the connection. Someone could access the server quickly in between my proc running and I would not capture it. I thought about putting a trigger on sysprocesses to write to a history table but I do not like to put triggers in the master db.
Has anyone tackled this issue before or know where I could get a history of all connections to the sql server?
View 1 Replies
View Related
Apr 3, 2002
We have a 3rd Party system running on SQL Server that has presented us with a security problem.
All logins are handled by the application but the end result is each user has an easily identifiable login and password on the sql server box itself.
At a basic level there is nothing to stop a user linking through Microsoft Access and deleting table contents. We could live with that as Access knowledge is very limited.
Unfortunately a couple of developers now have Enterprise Manager and Query Analyzer installed on their workstations and they have already begun poking their noses where they are not welcome. The possiblity of data edits without an audit trail is now much higher.
Is there something I can do to block access?
I have found a stored procedure sp_MSSQLDMO70 in the master database which when execute is denied the user cannot log on through EM but is there anything similar for QA?
Help, they are getting a bit too eager to take my job!!
Andy
View 1 Replies
View Related
May 6, 2002
when u run a job using sql agent, say like a backup job, which security account does SQL use to run the job ?
also how does it differ if you execute the same job from
the command prompt or query analyzer ?
Thanks
View 1 Replies
View Related
Mar 27, 2001
Hi there,
Is there a way of restricting users' access to the content of DTS packages?
Thanks,
Michael Gagne
View 1 Replies
View Related
Sep 28, 2001
Hi All,
Is there any script/TSQL I can run to list all the
users and their access on a database???
I'd like to document all the access on our server.
Thanks,
David.
View 1 Replies
View Related
Dec 29, 2000
We are currently deciding what security model to use for SQL 2000.
I would like to know the advantage and disadvantage between
Winnt Authentication vs. Mixed Authentication.
Thank You
View 1 Replies
View Related
Jun 23, 2000
When giving access to users, an application they are using will normally update tables correctly.
If the user connects with another product such as Access or Excel, they may be able to make invalid updates.
One way to prevent this seems to be to use Application Secrurity provided in SQL 7.0.
Is there a way to give users read access to tables when they are not using the main application, and update access when they are using the main application?
View 5 Replies
View Related
Jun 27, 2000
New to MS SQL, using v7.0. Need a way to allow developers to create, modify, delete stored procedures in a database. I've tried several things but can't seem to get it. Anyone doing this? Do not want to give them dbo, company wants DBA's to have authority for all objects in a database, but developers have only authority on developing Stored procedures. thanks in advance.
View 2 Replies
View Related
Oct 25, 2000
How can I institute a passwd for a DTS load packages, so
no unauthorized loading takes place?
View 1 Replies
View Related
Oct 15, 1999
I have 30 databases resides on SQL Server 7.o. These databases will be accessed from the outside from 30 different DBA's.
How can I eliminate their privileges so they can only work with their own database and see the other databases grayed out?
Knowingly that each of them will have the DBO privilege on their database.
I'm very confused between the server roles, dbo permissions that I can't change.
Thanks in advance
View 2 Replies
View Related
Sep 29, 1999
Hi everyone,
Here is my situation:
I have 2 NT workstation 4.0 in a Test_PDC domain. One of the workstation(Test1) has SQL server 7.0 installed. On my other workstation(Test2) I would like to access the SQL Server. My workstations do not log into the Test_PDC domain, they logged on their own domain. I would like for Test2 users to access Test1 SQL Server through ODBC connection without creating an NT user account for Test2 users on Test1 User Manager. Is this possible? Another word, I want to use SQL Server security mode instead of NT.
Thanks in advance...
Binh
View 2 Replies
View Related
Mar 24, 1999
I need your opinion.
If you change default standard security to integrated and forgot register
all NT accounts in SQL Security Manager... and no more access to SQL Server.
What to do?
Thanks,
Irana
View 3 Replies
View Related
Sep 18, 2001
Hi Everybody Experts There,
I Am presently hanging on One Sql server.
Now Probably there are lots of user in near future and then
if there is some problem with the server which is running.
i want to run parallel second sql server which have all
information currently having first one.i mean to save second server
have all data that much of first server.
At the time of failure in first one i automatically want to
connect into second server without any problem
how can i do all this and also how can i put that server parallel to
first one.
please tell me as early as possible
waiting please
View 1 Replies
View Related
May 27, 1999
I installed SQL 6.5 using standard security. I would like to change the security to NT authentication. (We use it in SQL 7.0 and works real good).
Is it possible to change the security option after installtion?
I changed to mixed, (from the configuration panel) but when I create a new login it doesn't give me the option to specify NT authentication.
Any ideas????
View 2 Replies
View Related
