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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DSN Creation

Author  Topic 

natishkc
Starting Member

29 Posts

Posted - 2009-10-08 : 05:17:25
Hi Giants,

Is there any possibility to create batch file or anything like to create a DSN with secure sa.



Natish

natishkc
Starting Member

29 Posts

Posted - 2009-10-08 : 05:42:22
The following script will work, pls let me know....

odbcconf.exe /a {CONFIGSYSDSN "SQL Server" "DSN=DSNNAME|Description=description|SERVER=yourservername|loginid=yourUID|password=yourpassword"}



Natish
Go to Top of Page
   

- Advertisement -