SqlDataSourceEnumerator.Instance; not returning all instances

SQL Server SMO/DMO

Index ‹ SQL Server

- Previous
  - 1
    - Load/Run SSIS Packages on the server from a .net exe exception:Microsoft.SqlServer.Dts.Runtime.DtsPipelineException: Retrieving. Hi I am using a webservice for same. But facing the error Code Snippet " Microsoft.SqlServer.Dts.Runtime.DtsPipelineException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. ---> System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. at Microsoft.SqlServer.Dts.Runtime.Application..ctor()" Can u please help me. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 2
    - Date time Hello all I am having a hard time in solving this My application gives me a date in the format Ex: Tue Oct 16 13:23:04 CDT 2007 coming to Oracle db as a string This date(String) is going to SQL Server into three differnt Colunm Col1 will have : 2007 - 10 - 16 Col2 will have : 1:23:04 (Military time has been changed to 12 hr format) Col3 will have : PM (Since its was 13 hour it PM) The format I am getting from application is giving me trouble. How can I do this Please advice! Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 3
    - Error The set in the WHERE clause cannot contain multiple measures It is an error message bug. Unfortunately it is unlikely to get a hotfix for it. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 4
    - Microsoft.SqlServer.Dts.Pipeline.BlobColumn Look at the type of the object, it is not a string type or something that supports casting top a string. It is a complex type, a Microsoft.SqlServer.Dts.Pipeline.BlobColumn class actually. Take a closer look at the methods on Row.DataPnts, I think there should be so read and write methods. Use them to get the data you want. Just bear in mind that this is a big texttype, not a string, and you don't want it leaving up to 2GB of data in a string for you! Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 5
    - Excel 2007 DataMining Add-in Database on SQL Server 2005 destroyed by using SQL Server Managment Studio? Hello, good hint! When leaving Excel and re-opening Excel another time the connection is established automatically with the SQL Server 2005 AS and I don’t have looked at the connection properties which where changes from DMAddInDB to default (or "Standard" in the german version). An with this hint I have finally found the solution for another problem I have searched for today. I was not able to construct a Mining Modell on Analysis Services Database, I was not able to choose the right database/datasource. I have seen another AS Database (perhaps the default one) an could not change to another database. When I have changed the dataMining connection to the right database as actual I could use my analysis services database. Really helpful, thanks a lot! Berenice Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 6
    - Select Statement i would like to select only those that have statusdates that are later than statusdates with statusky 'A'. Table1 PaperID StatusID StatusDate StatusKey 0001 4566 2003-09-03 00:00:00.000 D 0001 4222 2003-09-03 00:00:00.000 C 0001 4132 2003-09-01 00:00:00.000 A 0002 4222 1999-04-14 00:00:00.000 C 0002 4132 1999-04-14 00:00:00.000 A 0003 4132 1986-08-03 00:00:00.000 A 0003 4566 1986-07-29 00:00:00.000 D 0004 4135 1999-08-27 00:00:00.000 A 0004 2000 1999-08-30 00:00:00.000 C And i would like to have a result of : PaperID StatusID StatusDate StatusKey 0001 4566 2003-09-03 00:00:00.000 D 0001 4222 2003-09-03 00:00:00.000 C 0001 4132 2003-09-01 00:00:00.000 A 0004 4135 1999-08-27 00:00:00.000 A 0004 2000 1999-08-30 00:00:00.000 C I do not want to select 0003 because it has the correct data (statusdate with statusky 'A' is later than the other status dates) as well as 0002 because the dates are the same. What is the best query to use thanks. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 7
    - remove SQLserver2005 problem hi all, what is the best way to remove SQLSERVER2005 from my computer running XP-sp2 when i try to remove from tha ADD and Remove program from the control panel it's start the wizard but going to stuck.. thankx Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 8
    - insufficient access rights error when doing backup Thanks a lot. It fixed my problem. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 9
    - FileProperty and sp_spaceused Hi All I am trying to execute the following set of commands: select fileproperty('master','SpaceUsed')*8; select sum(reserved)*8 from master.dbo.sysindexes where indid in (0,1,255); exec sp_spaceused ; I am getting different values from fileproperty and the sp_spaceused. I am wondering why this is happening. I am sure that there is a valid reason behind this. Can anyone explain why this is happening I also tried using DBCC updateusage('master') with count_rows and sp_updatestats. Thanks Vijay Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 10
    - Vista SQL 2005 SP2 client to Windows XP SQL 2005 (non-sp2) workstation. (Take 2 w/ Workaround) This issue has not been "resolved" as I can tell. But there is a workaround w/o using sql authentication (hate sql authentication) http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1528018&SiteID=1 I found out that it doesnt matter which combination you use for the server as long as the client is Vista... If you are using a windows account, lets say "jondoe" on your vista box acting as a sql management studio client to a sql server on an xp or w2k3 box using windows authentication.... IT WILL work if both the vista box and the xp/w2k3 box BOTH have "jondoe" accounts, and both "jondoe" account passwords are the same!!! SOOOooo.... Apparently when vista runs the program under jondoe (when you launch the shortcut) it runs it under that context (no-duh) but EVEN if you establish a network connection (using net use) beforehand with alternate credentials (lets say on the xp/w2k3 box the user is jonsmith) and then use sql management studio you are assuming that it will just use those trusted credentials.... you are wrong... it wont anymore in vista by default. WTF Why because apparently sql management studio 2005 no longer is allowed to retrieve stored credentials to impersonate jonsmith when connecting to the xp/w2k3 box.... this is where the infamous "no user is associated with this trusted connection". I also got this error with Visual Studio 2005 Web Express Edition... hmmm... a correlation i see SOOOoooo... Workaround 1 (more secure): Create the windows account "jonsmith" on your vista box, set the password to the same exact password for the server's user account. then run the sql management studio application under the jonsmith account using "runas". Result: it works just as it supposed to... using windows authentication. Workaround 2 (less secure): Create the account "jondoe" on the xp/w2k3 box, set the password to the same exact password for the server's user account. then run the sql management studio application under the jonsmith account using "runas". Result: it works just as it supposed to... using windows authentication. Workaround 3: Use sql authentication. works like a charm but not as secure as 1 and 2. FYI: these apply to workgroup connections. domain computers are exempt cause security is handled by domain controllers. I think there must be a security setting (registry option) that would allow this process to work w/o the workaround, but I have yet to figure it out... I'm like a pitbull sniffing around for clues and the only leads i have is that its vista SSPI and that if there is an option, it would be in local security policy AND/OR undocumented registry option. Note: I hate workarounds unless there is a clear cut reason why we have to do it this way. Either because there was a design oops or security consideration when accounts are hijacked.... either way anyone from Microsoft have an explanation of this Oh... firewall enabled/disabled doesnt matter, all systems patched up the yinyang and what nots do not change the end result. All I did was create matching accounts on both ends (using either workaround 1 or 2) and it worked just fine. SOOOOoooo... my question is..... why can't SQLM2K5 MS and VSWD2K5 express grab the existing alternate credentials that i've established (through net use) and run with the ball BTW: I've tried using that "Alert Me" option below. Doesn't work. page takes a nose dive on the POST. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 11
    - Unable to create maintenance plan When i tried to create a maintenance plan for my db - it's just a full db backup task, it gave a weird error "Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)." Any idea what is wrong is there anywhere i can find details about the error Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 12
    - SP2 Report Builder and default save location Sorry if the information I gave you does not work. I don't have a better answer for you, but I can give you some more information. The "SAVELOCATION" parameter is only supported in Sharepoint mode. It is the argument that is passed to report builder when you launch Report Builder from the "New" menu in sharepoint, and is intended to be the initial location where reports are to be saved at. "SAVELOCATION", "MODEL", and "REPORTITEM" parameters where intented to be mutually exclusive. When a Model or a Report Item is passed in as an argument, then their location is used as the initial save location. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 13
    - Create Subscription For Rpt Service with Windows integrated security !!! Yep, it sure does. A big pain. You could have multiple copies of the one report and change the data source of each report. Then secure the report via user groups. A pain, but if you only had a few users it might be ok. If you have hundreds however...... Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 14
    - Problem Configuring Reporting Service Hey there, im having a problem that a few people seemed to have had already. The problem is again related to the Web Service Identity. Windows Server 2000, IIS 5.0, SQL Server Express 2005 Adv, and Microsoft.Net 2.0 after installing SQL Server Express 2005 when i launch the Reporting Service Configuration it could not connect to the Server as the Reporting Service was not running. In order to get the Reporting Service running i had to modify the rsreportserver.config file in the C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer directory. Here i modified the added the following <WebServiceAccount>IWAM_SKYREV</WebServiceAccount> this was due to no SKYREV\ASPNET account being available on the server machine. (based on this article http://support.microsoft.com/default.aspx/kb/911846 ) Once i changed this i could now get the Reporting Service running and access the configuration tool. So now we come to my current problem. In the Web Service Identity it shows an exclamation. Here the ASP.net as SKYREV\ASPNET and when i attempt to apply this i get the following error: ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias. at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool) Any one have any ideas for me... Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 15
    - How to return multiple values from stored procedures thanx Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 16
    - Cannot see Local Database template in Add New Item Dialog box Per MSDN instructions I downloaded the folliwng: .NET Framework 2.0, SQL Server 2005, SQL Server Compact 3.5, and Visual Basic Expess Edition. When following the tutorial to create a database, I was never able to see the Local Database template. I am taking the programming lessons in VB, and I am up to Creating Your First Datatbase. It is a requirement that SQL Server Compact 3.5 be installed. Which I have done. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
- Next
  - 1
    - Drillthrough (beginner) I have created two reports. One links to the other with a drillthrough. The linking works fine, but no values show up in the fields besides the group titles and column titles. Why is this happening The user is given a list of Counties with values. The Counties(in a matrix) are clickable for a drillthrough of Ages and Genders in the Counties. Looks something like this: Years Counties Total Crashes Fatalities Cook 85 98 Manchester 2850 258 Sagamon 987 526 So when a user clicks a county, such as "Cook", this is displayed Years Age Gender Total Crashes Fatalities 0-8 Female 25 8 Male 55 15 9-15 Female 850 258 Male 185 35 16-22 Female 87 526 Male 10 35 But I am getting this in : Years Age Gender Total Crashes Fatalities 0-8 Female Male 9-15 Female Male 16-22 Female Male Whats going on Can anyone make any suggestions Just to let you know its based off of an Analysis Services Cube and not relational tables. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 2
    - DBCC TableResults Anyone know where I can find the "TableResults" table definition in order to create a table for the DBCC command I can't seem to find it in BOL... Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 3
    - How can I get AS 2005 to use more than 2GB? AS should be able to see and use 3Gb even in Standard Edition 32-bit, once you've set the /3Gb switch. See: http://technet.microsoft.com/en-us/library/ms175672.aspx and http://support.microsoft.com/default.aspx scid=kb;en-us;291988 What is your TotalMemoryLimit server property (for details see http://www.microsoft.com/technet/prodtechnol/sql/2005/ssasproperties.mspx ) set to I have a vague recollection that there might be something special you have to do to get AS to use the extra memory, but that could be my imagination. Alternatively, the error message you're seeing might just be wrong about how much memory AS can see. You can stop the error by altering the MemoryLimitErrorEnabled server property (see the previous link) but it sounds like you do need to upgrade to 64-bit to process whatever it is you're trying to process. HTH, Chris Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 4
    - AS2005 Cube Excel 2007 Filtering Issue Hello Mosha. It would be interesting to know about the features in Excel 2007 that are disabled before SSAS2005 SP2 Is this something that you have mentioned in your Blog(multiselect) or something else Do you mean internal features like the MDX being generated from Excel2007 Are these new features being enabled by an update on the client Kind Regards Thomas Ivarsson Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 5
    - Apparent Memory Leaks in ODBC We have created a multithreaded application that reads result sets from MS SQL Server (both 2000 and 2005). The MS SQL Server app and our app reside on the same machine. We are using the latest version of ODBC32.DLL (3.526.1830.0) and SQLSRV32.DLL (2000.86.1830). Our application is written in C++ using the Visual C++ 6.0 compiler and libraries. Our app runs as a service, therefore the apparent memory leak is a real problem. Our app needs to run on a server in a closet without human intervention. We are kicking off many user threads that each can read from the database tables. Each of the reads from the database occurs within a critical section to minimize the threads stepping on each other. The ODBC interface class follows all the steps defined in the ODBC application developers documention (see code below). We see or app memory steadily increasing over time (we used PerfMon to monitor Private Bytes and Virtual Bytes, per ODBC documentation). If we terminate the threads which are retreiving the result sets, the memory drops back to the level noted prior to starting the threads. The code below is admittedly inefficient, however, it should not leak memory when accessing the database. Note that it works very well, returns the result sets that we expect exactly. SQLHENV henv = SQL_NULL_HENV; SQLHDBC hdbc = SQL_NULL_HDBC; SQLHSTMT hstmt1 = SQL_NULL_HSTMT; SQLRETURN retCode; SQLSMALLINT sColCount = 0; CODBCInterfaceColumnList lColumnList; CString strDSN; CString strUID = _T("AccountName"); CString strPWD = _T("Password"); CString strServer; CString strDatabase; CString strDebugMsg; if(!CreateDSN( pRecordList->m_strDefaultODBCConnect, strDSN, strDatabase, strUID, strPWD, strServer)) { strExceptionMsg.Format( _T("Cannot create DSN from connect string %s"), pRecordList->m_strDefaultODBCConnect); bReturn = true; return bReturn; } if(pRecordList->m_strDefaultODBCConnect.IsEmpty()) { bReturn = true; return bReturn; } // Allocate the environment handle retCode = SQLAllocHandle(SQL_HANDLE_ENV,NULL, &henv); if(retCode != SQL_ERROR && retCode != SQL_INVALID_HANDLE) { // Set the environment to ODBC Version 3.0 retCode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, SQL_IS_INTEGER); if(retCode != SQL_SUCCESS) { GetErrorMsgs(hdbc, SQL_HANDLE_ENV, strDebugMsg); } if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Allocate a ODBC connection handle handle retCode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { retCode = SQLConnect( hdbc, (UCHAR*)(LPCTSTR)strDSN, SQL_NTS, (UCHAR*)(LPCTSTR)strUID, SQL_NTS, (UCHAR*)(LPCTSTR)strPWD, SQL_NTS); if(retCode != SQL_SUCCESS) { GetErrorMsgs(hdbc, SQL_HANDLE_DBC, strDebugMsg); OutputDebugString(strDebugMsg); } if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Allocate a statement handle retCode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt1); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { // Fixup the select statement retCode = SQLPrepare( hstmt1, (UCHAR*)(LPCTSTR)pRecordList->m_strSelectStatement, pRecordList->m_strSelectStatement.GetLength()); if(retCode == SQL_SUCCESS) { retCode = SQLExecute(hstmt1); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { retCode = SQLNumResultCols(hstmt1,&sColCount); if(retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO) { if(sColCount > 0) { if(lColumnList.DescribeColumns(hstmt1, strExceptionMsg)) { if(lColumnList.BindColumns(hstmt1, strExceptionMsg)) { int i = 0; while((retCode = SQLFetch(hstmt1)) != SQL_NO_DATA) { if(retCode != SQL_SUCCESS) { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); break; } else { // Class to hold the result set. CTableColumnList* pColList = new CTableColumnList(); lColumnList.PopulateColumnListObject(pColList); pRecordList->AddColumnListRecord(pColList); } } } } } } } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } retCode = SQLFreeHandle(SQL_HANDLE_STMT, hstmt1); } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } retCode = SQLDisconnect(hdbc); } else { GetErrorMsgs(hstmt1, SQL_HANDLE_STMT, strExceptionMsg); } } retCode = SQLFreeHandle(SQL_HANDLE_DBC, hdbc); } } retCode = SQLFreeHandle(SQL_HANDLE_ENV, henv); We are at our wits end, not sure what to do next. Any help in sorting this out will be very, VERY much appreciated. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 6
    - reportviewer issue I am using the reportview in vb2005 to run a report that is on our report server. It just keeps says its processing and does not come up with any results. Any thoughts why this is happening and how I can fix Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 7
    - From and Thru Date parameters When I get those types of errors, it's usually from a dataset up the chain which automatically got a parameter slapped onto it by the IDE and is not getting the value from anything. You could search the rdl file in notepad to better find that specific section and dataset name, then go into the dataset and remove parameters from all areas: details, parameters tab, and in the designer, the query parameters toolbar button. It may also help to close and reopen the solution after this has been done to ensure there's no more sh going on from the IDE. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 8
    - Case expressions may only be nested to level 10 This is a little hoakie, but here we go: Code Snippet declare @a int , @b int , @c int , @d int , @e int set @a = 0 set @b = 0 set @c = 1 set @d = 0 set @e = 0 select coalesce ( replace ( convert ( char ( 1 ), nullif ( @a , 0 )), '1' , 'A' ), replace ( convert ( char ( 1 ), nullif ( @b , 0 )), '1' , 'B' ), replace ( convert ( char ( 1 ), nullif ( @c , 0 )), '1' , 'C' ), replace ( convert ( char ( 1 ), nullif ( @d , 0 )), '1' , 'D' ), replace ( convert ( char ( 1 ), nullif ( @e , 0 )), '1' , 'E' ) ) Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 9
    - conditions in where clause when i try this i get the error message, where is of none boolean type Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 10
    - Stored Proc creation script in T-Sql OJ has come up with the something similar in the following thread. Brilliant. http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=2218957&SiteID=17 HTH! Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 11
    - Report Builder and optional parameters What Filter tab are you uys talking about I have RS2005 and I don't see the "prompt" option. Is this in the data filter section Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 12
    - Error - SQL Server requires Encryption On Thank you John, that was it. I apologize for taking so long to respond but my sales person is in L.A. and I am in Florida and with the long weekend we couldnt connect until late yesterday. Would love to know how that got set in the first place though. That was a tough one to find. Thanks again. Jack Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 13
    - Applying snap shot at subscriber from DVD on SQL 2000 Connect to your subscriber in SQL Server Management Studio and pull it there. Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 14
    - How can i encrypt or mask a column in the database You can find encryption information on Books Online. Here are a couple of links to get you started: http://msdn2.microsoft.com/en-us/library/ms189586.aspx http://msdn2.microsoft.com/en-us/library/aa337557.aspx My blog also has several encryption examples. If you get stuck on anything specific, post on this forum. Thanks Laurentiu Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 15
    - Maximum size of the SSIS String Variable? jwelch wrote: 4000 is the limit on expressions. I'm not sure what the limit is on strings. This is all true. Technically, I'm not sure there's a limit on the string variables. Though you can't really use that variable anywhere without the 4000 character expression limit applying. (Most of the time the variable is used in an expression SOMEWHERE...) Tag: SqlDataSourceEnumerator.Instance; not returning all instances
  - 16
    - Enterprise Manager returns [MS Visual Database Tools] - The parameter is incorrect when returning all rows Yes you need to have service pack on client tools, that helps too. I do on all of my client tools too without any issues. Tag: SqlDataSourceEnumerator.Instance; not returning all instances

db-C

...static void Main()
{
// Retrieve the enumerator instance and then the data.
SqlDataSourceEnumerator instance =
SqlDataSourceEnumerator.Instance;
System.Data.DataTable table = instance.GetDataSources(); ...

Hi MS SMO folks,

I'm not getting all instances returned in my table. I know there are issues surrounding this call but I have 1 dev box, 1 nt 2003 server and a total of 3 sql srv instances. 2 of which are on my local dev machine. All are 2005. Both servers have SQL Browser enabled and all protocols are enabled. All of my MacAfee and Windows firewalls are temporarily Off.

The only instance returned is mylocalbox/sqlexpress. I can understand why it may not see the server, due router or other h/w, but what I really don't get is why it doesn't even see my other instance on my local box: mylocalbox/dbcdev1

Is there another more robust method of enumerating all sql instances on a LAN or getting this to work a bit better

Thanks

Jim

Re: SqlDataSourceEnumerator.Instance; not returning all instances

Jens K. Suessmeyer

Hi,

did the call only return one row

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Re: SqlDataSourceEnumerator.Instance; not returning all instances

db-C

Jens;

Yes the call only returned one row. i.e. The only instance returned is mylocalbox/sqlexpress

I do have another instance on this machine.

Do you have any idea as to why the other named instance was not returned into the datatable

Jim

Re: SqlDataSourceEnumerator.Instance; not returning all instances

Jens K. Suessmeyer

Hi,

have a look in the registry key:

and if all instances are mentioned here.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

There is a know issue if SQL Server Express is installed in the machine. Is SQL Server Express installed

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Re: SqlDataSourceEnumerator.Instance; not returning all instances

Cristian Rojas C.

Add the servers to file hosts located in Windows\System32\Drivers\Etc