.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

SmoApplication.EnumAvailableSqlServers() does not list default instance if sqlexpress is in same mac

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :Sql Server
 
Hi I am using SMO to find available sqlservers of a network.But in one machine it doesnot give Default instance name but for all other machines it gives the named and default instance wil be showing. Observe my Scenario. Ex: Machine Name :rkwrk3-vm-sr (local machine from where i am running app in which sqlserver2008 installed)    in this actually i have sql2008 as default instance and sqlexpress(2005) as named instance...    But it shows only one instance rkwrk3-vm-sr\sqlexpress and it doesnot ahows rkwrk3-vm-sr.    and some other machines Hr-2k3-tm(where sqlserver2005 installed)    for this it is showing Hr-2k3-tm and Hr-2k3-tm/sqlexpress How can i fix this .Any Help wil Greately Appreciated. Thanks in Advance.


View Complete Post


More Related Resource Links

Instance and Default connection properties on SQL Server 2005

  
We had a sql server fail and I have been having troubles.  I compared the connection properties on the server properties and noticed that multiple default settings are no longer set.  So I'm wondering if during the failure these could have some gotten flipped.  DB's that worked all of a sudden don't work and we had to migrate to a different instance.  I have never changed any of the setings below and wonder what impact they would have if I changed them back to the default of an installed instance? ansi warning is checked ansi padding is checked ANSI NULLS is checked arithmetic abort is checked quoted identified is checked No Count is checked concat null yields null is checked Could anyone tell me how clearing these checked options will impact my db?   -- Paul Bergson MVP - Directory Services MCITP: Enterprise Administrator MCTS, MCT, MCSE, MCSA, Security+, BS CSci 2008, Vista, 2003, 2000 (Early Achiever), NT4 http://www.pbbergs.com    Twitter @pbbergs Please no e-mails, any questions should be posted in the NewsGroup This posting is provided "AS IS" with no warranties, and confers no rights.

How can I Set default value for drop down list filled with Cascading

  
Hi AllI've this problem, how can I set the default value for drop down list filled with cascading. I can't catch the event that came after cascading to set the default value and I can't call any control in this function:  "AjaxControlToolkit.CascadingDropDownNameValue[]"   I've passed the Drop down list as a session and the default value in session   When I call the session of "Drop Down List" the session value Is NULL in this function:  "AjaxControlToolkit.CascadingDropDownNameValue[]"   Any help please. 

SharePoint List Source and Destination BIDS adapters not working for our sharepoint instance

  
It was with great anticipation I installed the SharePoint List Source and Destination BIDS adapters (from CodePlex, http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652). Unfortunately, the adapters are not working for our MOSS sharepoint instance.  We're a DOD (department of defense) site, so the level of security may be higher than normal and may be affecting the adapters. The error message was lengthy and I couldn't copy it and paste here.  I did screen shots and put the complete error message at http://www.christianbahnsen.com/sharepoint_source_error_message.pdf If I can get this to work I think it would be very useful.  I'd played around with KPI Lists, but one cannot create an Indicator directly from SQL Server 2008 (cf. my related thread at http://social.msdn.microsoft.com/Forums/en/sharepointbi/thread/bcc95f65-012e-4b8a-8850-b03fb0f16b0f).  I was hoping that these adapters would provide a work-around by populating sharepoint lists that could be the source for KPI Indicators. As always, thanks in advance for any assistance. Christian Bahnsen

Feature Upgrade Functionality - Adding a new Content Type and List Instance

  
I've successfully used the upgrade functionality in SP 2010 to upgrade my list structures as needed. So far, these updates have been adding new fields to existing content types. Now, I have some new fields, content types and list instances to add, and am having trouble getting this accomplished. The scenario is this: - A new content type with a single custom field (also new), and a list instance for this new content type - A new field that is a lookup back to the new list instance defined above. This new field is added as an existing content type. - In my feature.xml, I have the Element Manifest specified with both new fields and an AddContentTypeField element for the new field being added to an existing content type:   <ApplyElementManifests> <ElementManifest Location="V1_04\Elements.xml"/> </ApplyElementManifests> <AddContentTypeField ContentTypeId="0x0100..." FieldId="{8028A1C8-1147-4DF7-B5C3-8A1F84A30360}" PushDown="TRUE"/> The result of running the update on this feature is: - My new field that is part of an existing content type is added - My new field that is part of a new content type/instance is added - My new content type and list instance is NOT created, therefore my lookup is broken Any idea why my new Content Type and List Instance is not being created? Do I need to specify there

Feature Upgrade Functionality - Adding a new Content Type and List Instance

  
I've successfully used the upgrade functionality in SP 2010 to upgrade my list structures as needed. So far, these updates have been adding new fields to existing content types. Now, I have some new fields, content types and list instances to add, and am having trouble getting this accomplished. The scenario is this: - A new content type with a single custom field (also new), and a list instance for this new content type - A new field that is a lookup back to the new list instance defined above. This new field is added as an existing content type. - In my feature.xml, I have the Element Manifest specified with both new fields and an AddContentTypeField element for the new field being added to an existing content type:   <ApplyElementManifests> <ElementManifest Location="V1_04\Elements.xml"/> </ApplyElementManifests> <AddContentTypeField ContentTypeId="0x0100..." FieldId="{8028A1C8-1147-4DF7-B5C3-8A1F84A30360}" PushDown="TRUE"/> The result of running the update on this feature is: - My new field that is part of an existing content type is added - My new field that is part of a new content type/instance is added - My new content type and list instance is NOT created, therefore my lookup is broken Any idea why my new Content Type and List Instance is not being created? Do I need to specify there

List Instance based on Asset library

  
HI Guys, There are three content type associate with Asset library but now i want to create a list instance based on Asset Library but i dont want these three content type i want only the custom content type i have created. I know how to do this in browser interface but i want to do in VS2010. I Know i have to create listinstace item type i did that then i dont know what i have to do in order to hide all out of box content types associate with asset library. Please assist me with thisThanks Ron

Issue Adding a new Lookup Field to an existing List Instance

  
I have a code base that houses all of the column, content types, template, and list instance definitions. Am using the Update functionlaity a lot from version to version. Has been working well to this point. I just added two new columns (fields), one a Lookup and the other a Multi-Lookup. The fields are added fine on the update, columns look correct and the content type to which these were added also look fine. I can create a new List instance from the content type, and the new lookup columns are fine. The problem is this. Any existing list instances that were created from this same content type, now blow up when I try and access list items via the SP GUI. Something about a valid GUID, I dont't have the exect error anymore, but will repost it when I recreate the issue for the tenth time. I tried deleting the new lookup fields from this new list instance, thinking that I might be able to re-add them to fix the problem, but I get a new stack trace when I try and re-add them. Any hints on where I can start digging would be appreciated. I think I'll start with comparing the list instance schemas between an existing list and a newly created one.  

default value of dropdown list

  

hi

I have a DropDownList that is bound to sql datasource . How can i set its default value  to Null and change its value to one of its items programmicaly.

Best Regards. Morteza


Object reference not set to an instance of an object in Nested Repeater Control of CheckBox List con

  
 if ((item.ItemType == ListItemType.Item) || (item.ItemType == ListItemType.AlternatingItem))
            {
                Repeater rptsub = (Repeater)item.FindControl("rptsub");
                CheckBoxList Chksub = (CheckBoxList)rptsub.FindControl("Chksub");
                Label lblsubroot = (Label)rptsub.FindControl("lblsubroot");
                DataRowView row = (DataRowView)e.Item.DataItem;
                RootId = Convert.ToInt32(row["IdApplication"].ToString());
                MetadataPermissions metadataPermissions = new MetadataPermissions(); ;
                DataSet rptRootValues = new DataSet();
                rptRootValues = metadataPermissions.GetrptSubMenus(RootId);
                DataRow[] drows = rptRootValues.Tables[0].Select("IdApplicationroot = " + row["IdApplication"].ToString());
                foreach (DataRow chkpermsns in drows)
               {
                   
                   ListItem li = new ListItem(chkpermsns["PermissionName"].ToString());
                   Chksub.Items.Add(li);
                    
               }


Designpage.aspx

<asp:Repeater ID="rptroot" runat="server" OnItemDataBound="rptroot_ItemDataBound">
                    <ItemTemplate>
                        <td>
      

How to get a default value from dropdown list that contains vaules from a SQL Select statement

  

I want to have a default value/item of "---Select One---" and then list all of the values from the SQL statement. Currently I am having trouble doing this. I tried to add it to the List Item but it doesn't show on the page. Can anyone help with this. 


lookup field list instance

  

hi,

Got and problem with and lookupfield I create some list instances, list definitions, content types with a lookupfields and all works fine  the list resovels the good list source guid so I can selected te values but when I try to save I get;

<nativehr>0x80070057</nativehr><nativestack></nativestack>Invalid data has been used to update the list item. The field you are trying to update may be read only.

When I manualy create a new list instance from the list definition everything works fine.
I'm guessing that the create list instances in the feature is causing the problem?

What am I doing wrong?

 


List Instance based on Asset library

  

HI Guys,

There are three content type associate with Asset library but now i want to create a list instance based on Asset Library but i dont want these three content type i want only the custom content type i have created.

I know how to do this in browser interface but i want to do in VS2010.

I Know i have to create listinstace item type i did that then i dont know what i have to do in order to hide all out of box content types associate with asset library.

Please assist me with this


Thanks Ron

problem with connecting to local SQL Server 2008 default instance using windows authentication

  

Hello, 

 

I have a user getting some problem with connecting to local SQL Server 2008 default instance using windows authentication with a user which has sysadmin role and is owner of each existing database:

2010-09-28 15:40:35.04 Logon       Error: 18456, Severity: 14, State: 11.

 

2010-09-28 15:40:35.04 Logon       Login failed for user 'IIS APPPOOL\RoomViewSEWebClient'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 127.0.0.1]

 

 

This us

Custom Webpart in Default forms of a list not coming in new list created by using List Template in S

  

Hi,

I added a custom webpart in default editform.aspx of a list and saved it as a template in Sharepoint 2010. Now when I am trying to create a new list by using this custom list template I am not getting the custom webpart in the editform.aspx. Only default form is coming.

Any kind of help will be appreciated.


BDC: Cannot create default instance on a Parameter with DircetionType 'Out', 'Return' or 'SqlRe

  

Hi!

I created a ADF with the Application Definition Designer. Some things are allready working, some don't. One thing I want to achieve is the filtering on wildcard filters. I defined a method for a "Customers" table and added two "in"-parameters for "Name" and "FirstName". I also added an instance of type "Finder". Now I want to receive some data from this query with help of the "Execute" feature of the Application Definition Designer. But this return only an error "Cannot create default instance on a Parameter with DircetionType 'Out', 'Return' or 'SqlReturn'". What am I doing wrong?

Thanks for any help!

 

Gerrit


Error creating edit form for external list - Failed to find the default form for PAGETYPE PAGE_NEWFO

  

For the last few days we have been unable to create custom new/edit forms for External Lists in Sharepoint Designer.  When i try to create a form Sharepoint Designer show the message 'Could not save the list changes to the server'.  The corresponding message in the ULS log file is 'Failed to find the default form for PAGETYPE PAGE_NEWFORM'.  Does this mean i have somehow managed to break the form templates for External Lists?

I saw some other posts about the 'Could not save the list changes to the server' error and followed the suggested steps including removing all versions of the list and related content type, and recreatign htem but this didn't work.


Missing default instance

  
I am in a new company now and my machine has SQL Server 2008 installed. The only problem is, from what I am told, none of the machines here have a local instance installed, just connections to external instances such as a development and production environments. Without having the installation disc, is it possible to install a local instance on my machine without raising any red flags? If so, can you please provide the steps involved? Also would anyone know why a company would not want a local instance installed on a machine? It makes no sense because live data can still be accessed at external sources. Thanks in advance for any help.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend