Hi I am new to SSIS and using the BIDS for practicing SSIS package development. At first while creating the connections to any task the server name selection the list of servers are displayed (drop down list)...But from few days that list was not displaying to select server..empty list was appearing .... But when if i gave the server name by hand it is getting connected to that sqlserver instance and working fine...what may be the problem for not displaying the list of servers...What i need to do for displaying the list while establishing the connection.. (For example...i am using TransferSqlServerObjects task. For establishing a new SMO connection.->Smo connection Manage Editor ->At server name At server name the drop down list was not displaying..Previously when i started working with the SSIS it worked fine..and it listed all the servers it connected..But now it is showing the empty list.. when i used existing the connection to the database was present and executing the task fine..i don't know whether i did any changes to any settings..) Please suggest me to get out of this problem...if u any queries let me know .. thanks in advanceSUNIL PARISI

Check in the SQL Server configuration manager if the SQL Browser service is still running.MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

hi Koen, I checked in the SQL server Configuration manager --SQL Browser service is in running state... Even i am not getting the server listed on the list... SUNIL PARISI

Did you change anything in your configuration the last few days? Firewall? Security settings somewhere? Changed ports for SQL Server? If not, you'll have to learn the name of your server by hard :)MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

Hi Koen, Recently i changed the properties of Distributed Transaction Coordinator(DTC).... Is there any link between these two (Getting server's list and security settings)?? SUNIL PARISI

Recently i changed the properties of Distributed Transaction Coordinator(DTC).... Is there any link between these two (Getting server's list and security settings)?? I would be surprised if there is a link. Honestly, I never use the dropdown list, it usually doesn't give accurate information. Or too much information, so it makes me wait a few minutes before I see any results.MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

Hi Koen, Thanks alot for u r quick reply and for trying to give me the answer .... I am also currently using same way as u said....but i would be great if the list was present ..it helps to select the sql server instances on the network... Once again thanksSUNIL PARISI

No. The DTC service and drop down popultaing values are not related.Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

Hi Jhawar, What may be the reason for not populating the server list ??? Do you have any idea ..please suggest me if u have any... thank u SUNIL PARISI

Hi SUNIL, Typically the SQL Server should be listed in the dropdown list of the connection manager if SQL Server Browser services is running and the 'Hide Instance' flag is set to 'No' on the server. SQL Server uses the SQL Server Browser service to enumerate instances of the Database Engine installed on the computer. This enables client applications to browse for a server, and helps clients distinguish between multiple instances of the Database Engine on the same computer. You may wish to run the SQL Server Browser service to expose some instances of the Database Engine, but still hide other instances. Use SQL Server Configuration Manager to hide an instance of the Database Engine. See http://msdn.microsoft.com/en-us/library/ms179327.aspx for more informations regarding how to hide an Instance of SQL Server Database Engine. Regards, Jerry