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


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

Problems with interaction between MS VS 2010 and MS SQL 2005

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
 
This is extremely frustrating.  I had bought MS VS 2005, years ago, and generally liked it.  I installed MS SQL 2005 (developer's edition) and found it easy to work with (though I haven't figured out how to create new login credentials on it - but that isn't a problem in my present context).  It appears to me that my problem is due to the clients for SQL server being incorporated and hidden somewhere inthe interface of MSVS 2010 from being apparently individual programs I am familiar with using. My employer just bought me a new machine (because my existing workstation was too heavily loaded), and required me to install both MS VS 2005 and MS VS 2010.  As part of my installation of MS VS 2005 on this machine, I installed MS SQL Server 2005 (but had forgotten to install teh corresponding clients).  And then I installed MSVS 2010.  When I noticed the clients I was used to  had not been installed, I went to install them and failed with an error message that a more recent version had been installed.  The old machine is runnign Windows XP and the new one is using Windows 7 Pro, if that matters. The problem is that I can not find the equivalent of Microsoft SQL Server Management Studio in MS VS 2010.  So I am at loss as to where the tools are in VS2010 to create new databases, tables, &c.  More annoyingly, I can not find the


View Complete Post


More Related Resource Links

Sharepoint Foundation 2010 problems with Office 2007 ActiveX controls

  
I have a SPF server that I recently upgraded from WSS 3 using the database attach method. The new server configuration is SQL 2008 R2 with SPF 2010 on Windows 2008 64bit SP2. Mostly things are working fairly well, though there have been a few fires to put out. The latest inflamation seems to be centered around ActiveX controls for Office 2007. I'm getting the following message whenever I try to create a new document using the New button: " 'New Document' requires a Microsoft SharePoint Foundation-compatible application and web browser. To add a document to this document library, click the 'Upload Document' button." On the client side, the browser is IE8 on Windows 7 (Windows is 64bit, though the browser is in 32 bit mode.) using Office 2007. I've also had the same problem with systems running XP. In terms of troubleshooting, other activeX related features seem to be working fine. I can open datasheet views, if I click on a document, it will open in the appropriate client. However, I have some libraries where the Word document template opens the document information panel and those will give thhe following message on open: "One or more ActiveX controls could not be displayed because either: 1)Your current security settings prohibit running ActiveX controls on thi page , or 2) You have blocked a publisher of one of the contols. As a result the page mi

Procedure to move all SP 2010 databases from SQL 2005 to SQL 2008 R2

  
I have a single SharePoint 2010 WFE with a single SQL 2005 64-bit backend.  I need to decomission the SQL 2005 server.  What is the best procedure to move all the SharePoint associated databases to SQL 2008 R2? I have already read this MS doc on moving all databases: http://technet.microsoft.com/en-us/library/cc512725.aspx So the actual move procedure is standard SQL fodder. What I'm not clear about is what to do about the "other" SharePoint databases and how to reassociate them once the DBs are on the new SQL server.  For example, the Usage and Health DB is going to "Wss_Logging" and it specifies my old SQL server.  It is greyed so I cannot chagne it in Central Admin.  How do I let SharePoint know that these databases have been moved too?

Problems with Report Services 2008 Integration in Sharepoint Foundation 2010

  
hi Folks, i ihave tried to solve my problem with this entry, but it has not fixed the issue. I would like to integrate RS in a Sharepoint Foundation 2010 environment, but when try to integrate the RS in Central Administration I am receiving the following error, see pic: Central Administration jpg When I try to access direct the RS Url the I get an access denied error please help.   thx a lot

Strange Problems in 2010

  
Hello, we have just upgraded to sharepoint 2010 from 2007, on the whole the upgrade went well, but we seem to be having problems accessing Manage Content and Structure or browsing for an Image or Link, I have turned on debugging in web.config to see what the error is, there are several different errors including this one:   Object reference not set to an instance of an object. body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } Server Error in '/' Application. Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullRe

Problems with access to external lists in SharePoint 2010

  
Our environment is SharePoint 2010 Enterprise, Windows Server 2008 R2 Standard and SQL server 2008 R2.   We have External lists that access a local database in SharePoint SQL Server. When new lists are added and permissions are given in the SharePoint Central Administration the domain users had to be in the Windows administration group to access the lists.   Recently in the same environment the domain users were removed from Windows Administration user group and could access the external lists.   In another similar test server we found adding the domain users to Windows Administration does not give the new domain users access to External lists.   The inconsistency is the issue. Has anyone seen this issue or provide a possible solution?

SQL Server 2005 Installation problems

  
I have SQL Server 2005 Developer Edition 9.00 1399.06 running on Windows XP.  I have upgraded to a Windows 7 64-bit computer, and have attempted to install SQL Server on this machine.  The install procedure failed, probably because I was installing from a copy of the install disks on a USB drive rather than the original CDs.  (I am carrying out the upgrade in a different country to my office and I did not want to risk losing the original install CDs). The install failed, and I realised that I had to install from CDs.  I then uninstalled all the SQL Server programs.  However, the uninstall procedure told me the program was already uninstalled.  However, when I try to reinstall from CDs, I am told that SQL Server Database Services, Analysis Servics, Notification Services and Integration Services are already installed. Therefore I am at an impasse.  I cannot uninstall the programs and I cannot reinstall the programs.  I have tried a registry cleaner (CCleaner) to get rid of registry settings and removed all SQL Server folders, but to no avail. How do I progress without having to reformat my entire computer?  I cannot believe that an installation procedure can be so limited - why isn't a reinstall option offered even if the computer records the programs to be present? I look forward to some suggestions on how to fix this. &n

Problems installing SQL Server 2005 Integration Services for Server 2008 R2

  
I am trying to install Microsoft Forefont and i have got a tick on every requirement bar 1. I can't install SWL Server 2005 Integration Services Component. I am running windows Server 2008 R2. I have tried numerous steps such as going into to control panel and adding component but the Integration services is not appearing on the options. Is it actually possible to install 2005 integration services on server 2008 and if so how? Thanks

problems in sql server 2005 installation

  
Hello everybody   Ok the problem is that i have sql 2000 in a computer with windows 2000 professional sp4. i'm trying to install the sql server 2005 in other instance. When the installation begins i don't have any problem, but when it ends, y try to enter to the manage studio and is not in the start menu. Sql 2000 is ok but i can't work in 2005 i reinstall both versions but the problem persist. I delete all the files in the instalation but when i install it again the problem apperas again. how can i install both versions?

Upgrade from SQL 2005 to SQL 2008 cause problems with MSDTC

  
We have recently upgraded our server from SQL Server 2005 to SQL Server 2008.  Previously we were running our asp.net application using MSDTC with no problems. Since we upgraded, we are encountering problems that seem to relate to Multiple Active Result Sets (MARS).  The error we receive is: "There is already an open DataReader associated with this Command which must be closed first" when we try and perform a save process.  To fix this problem we added MultipleActiveResultSets=True to the connection string.  We now get the error: "The transaction operation cannot be performed because there are pending requests working on this transaction." Within the transaction scope we save to a table and then load from the same table.  Our stack trace indicates this is where the first error occurs.  Again, this transaction worked using SQL Server 2005. If we do not use MSDTC by putting Enlist=false in the connection string, the request works. We are really stumped as to what to do.  We would prefer not to have to role back to SQL Server 2005 and would also prefer not to have to have sweeping code changes in our application.  We have test MSDTC by using DTC ping on our servers and it works. Your help is greatly needed and would be greatly appreciated. Regards, Steve and Nilesh

Upgrade from SQL 2005 to SQL 2008 cause problems with MSDTC

  
We have recently upgraded our server from SQL Server 2005 to SQL Server 2008.  Previously we were running our asp.net application using MSDTC with no problems. Since we upgraded, we are encountering problems that seem to relate to Multiple Active Result Sets (MARS).  The error we receive is: "There is already an open DataReader associated with this Command which must be closed first" when we try and perform a save process.  To fix this problem we added MultipleActiveResultSets=True to the connection string.  We now get the error: "The transaction operation cannot be performed because there are pending requests working on this transaction." Within the transaction scope we save to a table and then load from the same table.  Our stack trace indicates this is where the first error occurs.  Again, this transaction worked using SQL Server 2005. If we do not use MSDTC by putting Enlist=false in the connection string, the request works. We are really stumped as to what to do.  We would prefer not to have to role back to SQL Server 2005 and would also prefer not to have to have sweeping code changes in our application.  We have test MSDTC by using DTC ping on our servers and it works. Your help is greatly needed and would be greatly appreciated. Regards, Steve and Nilesh

Referencing SQL 2005 SMO from VS 2010

  
I've just migrated to Visual Studio 2010 and have found it strange to reference SQL 2005 SMO. Under VS2008, add reference dialog will show GAC in .NET tab. After installing VS2010, SQL 2008 SMO are also installed, and I saw two sets of SMO in GAC with version of 9.0 and 10.0. That's good. But when I open my project, VS 2010 told me that all is wrong. By using add reference dialog, I found no SMO objects in .NET tab. So I browse for dll files under c:\program files\microsoft sql server\90\SDK .... It will not work well since the project file will record relative path. After moving my project, I must repeat this. Why can't I find 2005 SMO in this dialog? I can understand that SMO for 2008 is not there. My project is a .NET 2.0 one and maybe SQL 2008 does not support .NET 2.0. But 2005 do. I can see it in GAC but cannot reference it from VS2010. Hope I've described clearly. Thanks for help!

Visaul studio 2010 has problems with sql server 2008 R2 64bit

  
Visaul studio 2010 has problems with sql server 2008 R2 64bit or it's my idea?because icant create a new database in my asp.net web site  it says to  go and download it

XML for Analysis Parser; The restriction value - sql server 2005 with Excel 2010 error

  

Trying to refresh an existing pivot table that is connected to Analysis Services Sql Server 2005 database.  My excel 2010  gets the eroor:\

XML for Analysis parser:  The restriction value provided by the consumer either does not match other restrictions or refers to an unknown object.

I already tried the pivot table patch and I am still experiencing the error.  I also tried starting a new excel spreadshsst and connecting to two other sql servers of newer verions and was succesful.


Win Forms from VS 2005 to VS 2010 Problem....

  

Hello Experts,

                 I'm working with Win forms using Visual Studio 2005 and code behind language is Visual Basic.My current project contains more than 450 forms.We were planning to migrate it from VS 2005 to VS 2010.So, I opened  my project with VS 2010.It had changed from framework 2.0 to framework 4.0. It builds and runs fine.

My Problem is that,

After  running my application . When I open any form it gives me an Exception System.outofmemoryexception...

If I clean my project It works fine...

What will I do for it?????

I'm googling in the internet... I had found lots of article... But no one is works for me...

Thanks in Advance


SQL Server 2005 bidirectional replication problems

  

I am having a system with two servers running SQL Server 2005 on Windows Server 2003.
Between the two SQL Server instances I am having a bidirectional replication of all my tables to always have the databases in sync.

When the replication is set up on the servers it normally runs fine for some time and then it stops working and I get errors like the following:

  Command attempted:
  if @@trancount > 0 rollback tran
  (Transaction sequence number: 0x000001B200005784000D00000000, Command ID: 1)
 
  Error messages:
  Violation of PRIMARY KEY constraint 'PK_MyTable'. Cannot insert duplicate key in object 'dbo.MyTable'. (Source: MSSQLServer, Error number: 2627)
  Get help: http://help/2627
  Violation of PRIMARY KEY constraint 'PK_MyTable'. Cannot insert duplicate key in object 'dbo.MyTable'. (Source: MSSQLServer, Error number: 2627)
  Get help: http://help/2627

And another error:

  Error messages:
  Agent 'SERV-A2-SYST-SERV-A1-10' is retrying after an error. 77 retries attempted. See agent job history in the Jobs folder for more details.


I do not know much about how the bidirectional replication works as I just set the replication up by some script

Problems when deploying sequential workflow with association Infopath form of sharepoint 2010 using

  

I’ve create a workflow project with infopath in it. And I get the error

 “Error occurred in deployment step 'Activate Features': Unable to locate the workflow's association data. To restore the association data to the workflow, restart the workflow settings wizard by selecting the workflow node in Solution Explorer and then clicking the ellipsis button (…) on one of the properties in the Properties window that has an ellipsis button.”

I'd really appreciate of 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