Why does opening SDE Workspace Factory ask for credentials again?

Question

I'm trying to open SDE Workspace Factory using IWorkspaceFactory.Open I give the complete Property set in the code to open. IWorkspaceFactory workspaceFactory = new ESRI.ArcGIS.DataSourcesGDB.SdeWorkspaceFactory(); IWorkspace workspace = workspaceFactory.Open(propertySet,0);ESRI.ArcGIS.esriSystem.IPropertySet propertySet = new ESRI.ArcGIS.esriSystem.PropertySetClass(); propertySet.SetProperty("SERVER", "myServer"); propertySet.SetProperty("INSTANCE", "myinstance"); propertySet.SetProperty("AUTHENTICATION_MODE", "DBMS"); propertySet.SetProperty("DATABASE", "myDatabase"); propertySet.SetProperty("USER", "sde"); propertySet.SetProperty("PASSWORD", "sdePassword"); propertySet.SetProperty("VERSION", "sde.DEFAUALT"); But When the workspaceFactory.Open is called, a dialogue box is opened to ask for credentials again. Why does this happen? Also, Can someone tell me what does the second parameter of IWorkspaceFactory.Open "hWnd" represent? I couldnt find a proper explanation in the documentation.

MichaelBarsky · Answer

I had the same problem, until i try to set the "instance" property to "sde:sqlserver:MY_SQLSERVER_NAME". And is all right.

JeffMatson · Answer

Are you attempting to pass in Direct-Connect parameters in your property set?  If so you likely need to add several parameters, and also make sure your Instance parameter is correct.  (We have an Oracle database and the Instance parameter to be passed in via PropertySet is different than what ArcCatalog reports - not sure if that is the same for your SQL Server database or not...)

Muhammad_TayyabMir · Answer

Hi there. Thank you for your response.
Yes this is a copy of the original code. These are variables,coming as parameters, in the original code. So I changed them here for the clarity of code. The spellings are correct in the original code.

One tricky property for me is the "instance". I'm not really sure which is the correct value to use.
If I right click my ArcSDE database in ArcCatalog, and click on "Connection Properties", the instance value is same as my Server name (raecgissql)

But when I open the connection properties from the SQL Server Management Studio, The Instance is shown to be empty.

When I use, empty string in my code. No exception is thrown, but it asks for the credentials again.
When I use "raecgissql" (similar to ArcCatalog) then an exception is thrown , something like "SDE not found in the listings".