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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

VS 2010 Express can't add SQLEXPRESS Data Source

Posted By:      Posted Date: September 18, 2010    Points: 0   Category :Sql Server
Hi all, I've spent a couple of days on this now and have tried everything I can find on the web to fix this issue. I can add Access data sources to VS 2010 Express, but can't find how to add SQL Server 2008 Express data sources. I keep getting the "40" and "26" errors.   I am running both VS2010 and SQLServer on a local machine, no network connection involved. I have granted corrected permissions in SQLServer. I have opened the correct ports, set the correct protocols, ensured my SQLServer is open for remote connections and changed my windows firewall settings. My question relates to the "Advanced" window in the data source wizard - it refers to .\SQLEXPRESS. I have noticed that this service is not running in my SQL Server Configuration manager and cannot even be started. I also do not have an Express SQL Server Browser at all! (I had one yesterday before I reinstalled SQL Server for the 3rd time!). Could this be the source of the problem? (the .\SQLEXPRESS) ? Thanks in advance for any help, Henry

View Complete Post

More Related Resource Links

Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.

VS 2010 and data source issues

I've been banging my head against the wall for the past 4 hours on this one and think I'm going to need a little help here. I must be missing something. I'm in VS 2010 on Windows 7. I've got a web project which has been going fine, but no matter what I do I can't get a data source to show up in the Data Source window. I've added a data source using Data > Add New Data Source, and the "wizard" appeared to complete successfully. I have a data source showing in my solution explorer, and if I open the .xsd file I see all my tables from a remote SQL 2005 database. I have a good data connection to the database server showing up in the Server Explorer window. But no matter what I do I cannot get anything to appear in the Data Sources window, which is greyed out (the commands at the top are grayed out and there's gray text in the middle of the window reading "There are no data sources to show for the selected project"). Under the main Data menu at the top of VS, the "Show Data Sources" and "Add New Data Source" commands are missing. I can sometimes get them to reappear if I restart Visual Studio or reboot the OS, but not consistently. I've been all over Google on this and have tried every suggested solution I can find, to no avail. Anybody have any ideas? Thanks.

REST Connection Data Source is getting overriddeen by SPD 2010

Hi, I used a Linked Datasource consist of two REST Connection Data Source with the credentials saving with the data source. The first time i add the Data View to the Web Part Zone everything is fine and the data is shown fine but the moment i save it and close the aspx page and open it again, SPD overrides and adds some of the attributes in the DataSources tag, which makes it giving an error saying connection problem and if i copy paste the original Datasource tag with the values it works fine. Any Idea guy's i am just fighting with this from 2 days. Thanks Girish

Search Server 2010 Express Error when crawling LOB Data with BCS Error while crawling LOB contents.

Ok so search server is crawling our BCS external data source which has some columns that allow null. When it hits a null in one of these columns it dies out with: Error while crawling LOB contents. ( '.', hexadecimal value 0x00, is an invalid character. Line 94, position 11. ) This is in the crawl log Is the a Fix / Update / Work around for this (other than modifying the table, taking off allow nulls and using a "blank" default value)

Can I create an ADO.NET Entity Data Model for a MySQL database using Visual Web Express 2010?


Can I create  an  ADO.NET Entity Data Model for a MySQL database using Visual Web Express 2010?

If yes, are there any documentation or tutorials?


How do you create a ADO.NET Entity Data Model for a MySQL database using Visual Web Express 2010?


Can I create a ADO.Net Entity Data Model for a MySql(5.0.1) Database using a Visual Web Express 2010? If yes, can anyone please let me know how to do this.

SharePoint Designer 2010 External Content Types Data Source Already Exists in Business Data Connecti


I used the Secure Store to create connection in SharePoint 2010 Designer External Content Types Data Source Explorer.  Later I changed some column names in the table.  I deleted the connection from Data Source Explorer and recreated it. I right clicked on the table and selected Create All Operations. When I clicked the Finish button, I got "The system definition with the same name as this data source already exists in the Business Data Connectivity Metadata Store and it refers to a different data source.  Cannot complete operation generation.  Add a connection to this data source with a different name and try again." 

I re-created the Secure Store using a different name in SharePoint 2010 Central Administration.  I didn't find the option to choose the connection name in SharePoint 2010 Designer. After I clicked Add Connection, I entered the Database Server and the Database Name, selected Connect with Impersonated Window Identity, entered Secure Store name, and clicked OK. The connection created with the database name as before.

SharePoint List Data Source with Express Edition


Hello All,

I am working on SQL Server Express Edition with Advance Services 2008 R2. I am using Report Builder 3.0 to build report.

In Report Builder, there is data source type called Microsoft SharePoint List .

Can anybody please confirm whether this option will work with SSRS in Express Edition? I did not get information from above link.



Copy and modify Data Source crashes SPD 2010 - List Threshold error


When I try to copy and modify a data source, I get a server error that the operation is prohibited because it exceeds the list view threshold, but I only have 10 items in my list, well below the default threshold.  I get the same error if I try to create a new page from master.  Anybody run across this one?

Confirmed the threshold with my administrator and even upped it to 10,000 but that did not help.

SP Designer 2010 - SOAP Data Source - Pulling User Profiles with XML QueryEx


Hello Everyone,


I have been searching this all day and i have yet to find a solution that works.
NOTE: What im about to descibe, ive created previously in MOSS2007.  Im now trying to recreate this in SharePoint Server 2010.


Ok, What im trying to do is pull in Profile information from sharepoints stored list of profiles.  In SharePoint Designer, im creating a SOAP Service Connection in DataSources.

The connection info is as Follows:

Service Location: http://intranet.mycompany.com/_vti_bin/Search.asmx?WSDL

Data Command:  Select

Port:  QueryServiceSoap

Operation: QueryEx

queryXml contains (All on 1 line of course):

<?xml version="1.0" encoding="utf-8" ?>
<QueryPacket xmlns="urn:Microsoft.Search.Query" Revision="1000">
<Query domain="QDomain">
<QueryText language="en-US" type="MSSQLFT">
<![CDATA[ SELECT Size, Rank, Path, Title, Description, Write, PreferredName, WorkEmail, JobTitle, Department, WorkPhone FROM scope() WHERE  ( ("SCOPE" = 'People') ) ORDER BY PreferredName ASC]]>

SQL CE 4.0 Data provider is not shown in VS 2010 Express and also in VS 2008 Express


I have installed SQL CE 4.0 CTP1 to overcome the identity column problem in 3.5, when programming with Entity Framework. I have successfully upgraded my SQL CE 3.5 database to 4.0.  But I didn't see the 4.0 data provider in model building wizard/data source adding wizard. 

Am I required to install/configure other than installing SQL CE 4.0.

Please help me.




PerformancePoint 2010 - Denied Access to Existing Data Source


We have SharePoint 2010 farm using Kerberos for authentication that works fine for almost all scenarios, except this last issue we see with PerformancePoint and the Dashboard Designer.

When our Data Connections library is empty I can start the Dashboard Designer and create a New Data Source. Clicking on Save the data source is saved in the correct location (default PPS library).

However, once I do an action that requires the Dashboard Designer to read the list of data sources from this library I get an access issue. This could be by trying to create a report using the saved data source or by closing the Dashboard Designer and opening it again to create a data source.

This error is logged in the ULS log and Event Viewer:

The user "domain\loginname" attempted to access an item in the following location: http://sp-server/PWA/ProjectBICenter/Data Connections for PerformancePoint


PerformancePoint 2010 - SharePoint Lists as a data source


I am in the midsts of planning for an upgrade from 2007 to 2010, and we are looking for quick-wins for the client, one of which obviously being PerformancePoint 2010 integration with SPS 2010. So i am tooling around, following some basic tutorials of creating scorecards/kpis/filters/dashboards all from the contoso sample data, which is all fine and well, but my client doesn't have a datawarehouse, and doesn't plan on moving to one.

This puts me in the situation where I need to be able to create these pieces from SP Lists instead of an analysis services DB/DW. I go through and create the data connection, and all seems to be working fine...In the data connection windows, I can click the View tab and preview the data, and actually see all the data thats in the task list I've created and linked to (all demo data, just created a couple of tasks and etc).

Now the trouble comes when I try to create a simple scorecard based off of this list. When I am in the Create tab, and click Scorecard, (Use Tabular > SP List) I can select my data source (Task Tracking Data Source) and thats all well and good.

I then go to the SharePoint Site tab (on the select data source on the wizard), I am able to select my Task Tracking Data source as well. When I get to the KPI scre

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

About Dynamic Data in Visual Studio 2010 / .NET 4



Does anybody here have any pointers to screencasts, demos, webcasts for the latest enhancements in Dynamic Data as listed in above link? I'm repeating them here for ready reference :


  • EnableDynamicData method which enables Dynamic Data features in existing ASP.NET applications and DataSource controls
  • A new QueryExtender control, contained in the sample projects to simplify common data filtering operations. It supports a rich ASP.NET declarative query syntax that makes it easy to do things like search data for text or have filters based on ranges
  • A new Dynamic Data filter model that enables the developers to apply templates to pages just like field templates (including user defined filters)
  • New field templates of Email, URL and Enum columns
  • Support for inheritance in Entity Framework and Linq to SQL
  • Support for many to many relationships in Entity Framework
  • New Entity Templates which allow fine control over how an object is displayed and edited
  • DynamicHyperLink control for building links to tables and actions
  • Declarative support for D

Visual Web Developer 2010 Express "Copy Web Site" using different login


I created a site and am trying to grant another pesron access to upload changes to it without giving them my super-user login.

I made a login for her but I can't test whether it works or not because no matter how much I "disconnect" in the Copy Web Site page of VWD 2010, reconnecting to the same site always logs in as my superuser account without prompting me for a login again.

How do I test is the account it set up correctly before having her try to upload to it?    I want to force the login to remote site dialog to pop up again to test her account.

Any ideas?

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