How do I remove a folder called credentials in security manangment studio

• ROLLIE MOE

  Newbie

  Points: 5

  More actions

  May 9, 2007 at 7:49 am

  #178286

  Hello and good day to all.  I'm new to sql server, I hope you will be kind and pactient with me.  I was wondering how I could remove a folder called credentials in the security of management studio, i typed in a t sql statement similar to create credential [mycredential] with identiy ect.   not very good with t sql as of yet.

  I was trying to eventually create a linked server from our as400 to sql 2005.  Any help would be greatly appreciated. 

   

  Rollie

• Bill Richards-377350

  SSChasing Mays

  Points: 660

  More actions

  May 10, 2007 at 6:30 am

  #705463

  I am not sure what you are asking in the first part of your question.  But we have made linked servers to the AS400 using Iseries.

  After setting up the iseries odbc connection and creating the linked server, you must reconfigure SQL Server 2005 with the following commands.

  sp_configure 'ole automation procedures',1

  reconfigure with override

  sp_configure

  Bill Richards, MCSE, MCDBA

  Senior Database Analyst

• bledu

  SSChampion

  Points: 12335

  More actions

  May 14, 2007 at 4:58 am

  #706173

  DROP CREDENTIAL mycredential

  you can not delete the folder

  ---

  Everything you can imagine is real.
  

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  July 3, 2007 at 1:39 am

  #716771

  DROP CREDENTIAL mycredential

  this just drop any credentails that you have created and will not delete the folder which is sql server default and that cant be deleted.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com