To make sure where exactly the problem is, Can you please...

Well, the best place to start is SQL Server Books On Line under topic "SSIS".:-)

vchawla-1033989 (9/17/2009)

---

Vishal,

That's the best practice.But in my scenario, it's not like that and even we can't do without appropriate permissions & all....Now what can be done to resolve that problem...

Default instance name is always same to your machine name. for example if your server name is mydbprodsvr, the default instance name will be same as SQL Server (mydbprodsvr).

That's why TempDB should have more than one data file across disk drives.

Sergey Vavinskiy (9/16/2009)

---

You don't need a separate job for logins mapping.

I believe you have a scheduled job for you nightly restore.

So, just add one more last step to this job...

Or incase you have anightly restore, you can use the below script for an automated...

Check what all jobs are running during night. Anything, related to Audit or users.

I would suggest you read "Alter Table" topic in SQL Server Books onLine.

It has almost everything you need.

Or Query sys.SQL_logins table.

SanthoshViswanathan (9/16/2009)

---

Vishal,

What I meant by Non-privileged users was users other than sysadmin users(DBA's)... Ofcourse the Non-privileged users have access to SQL Server...

Sorry if I was not clear on that... 🙂

Now...

SanthoshViswanathan (9/16/2009)

---

Security audit was done by a third party... I believe they used some tools for this purpose... In their final output to the management they gave this point that...

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/25a44245-e28d-41b5-ad65-7778d50c42ea.htm

This is pretty much thorough.

Duplicate post.

Please post on

http://www.sqlservercentral.com/Forums/Topic788812-146-1.aspx?Update=1

Firstly, Can you elaborate it how come a user who doesn't have privilege is able to discover the DTS password?