accessing files on a shared folder

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 2005 Forums

SQL Server Administration (2005)

accessing files on a shared folder

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2008-01-07 : 13:39:46

can sql server 2005 access files on a shred folder (which sql 2000 was not able)?
thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-01-07 : 14:09:18

Ummm, SQL 2000 can and so can SQL 2005. What problem were you having in SQL 2000?

What method would you like to use? xp_cmdshell?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sqlsquirrel
Starting Member

21 Posts

Posted - 2008-01-07 : 19:03:22

When you mention "access files on a shared folder" like Tara mentioned to do file manipulation, etc. First make sure the SQL Server accounts are domain administrators and have the rights to log on as a service. This will allow the SQL Server and SQL Server Agent services to access files on another server. Besides xp_cmdshell you could use the sp_oa* stored procedures or with the FileSystemObject via VB script.

I hope this helps..

Good luck!

Brett Davis
Senior SQL Server DBA
For more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-01-07 : 20:03:36

I 100% disagree that the SQL service account(s) should be domain administrators. They should be only local admin and then have access to the network shares.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources