Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Crowandazi
Starting Member
9 Posts |
 Posted - 2005-06-03 : 11:12:11
|
| Hi y'all, I just got a new server for our website and am trying to tighten security on my DTS packages. I'm trying to use Windows Authentication instead of hard coded passwords to access my SQL database via an Active X Script, but my package fails whenever I try to connect to the database. I'm using the same connection string that I know works for the ASP pages on my website. However, in that instance I had to grant the IUSR account access to the database in order for it to work. Do I have to do something similar in this situation?I am sysadmin of the database, I created the package, I scheduled the package, and I thought all of that meant that package had the same rights as my account. So what am I missing?Help would be appreciated, and since I don't understand this stuff well, I might have omitted some important information. Let me know if I need to provide more. Thanks! |
|
|
amitja
Starting Member
7 Posts |
Posted - 2005-06-06 : 08:16:04
|
| I am not sure If I understood your question. I tried this connection string in my dts package to connect to the sql server on my m/c and it connects well.set objConn = CreateObject("ADODB.Connection")strConn = "Provider=SQLOLEDB.1;Data Source=ServerName;Initial Catalog=DBName;Trusted_Connection=yes" objConn.open strConn |
 |
|
|
|
|
|
Using trusted connection with DTS scripts