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

Post New Web Links

Cannot connect to SQL Server 2008 after Uninstalling VS2010 ultimate and installing VS2010 premium

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

I installed VS2010 Ultimate to test it out but had license for the VS2010 premium only.  After uninstalling ultimate and reinstalling VS2010 premium, my SQL Server 2008 now refuses to connect to my databases stating: 

TITLE: Connect to Server

Cannot connect to Q9300\SQL200801.


View Complete Post

More Related Resource Links

SQL Server 2008 Development problems with Visual Studio 2010 Ultimate uninstall and VS2010 premium i


I installed VS2010 Ultimate to test it out but had license for the VS2010 premium only.  After uninstalling ultimate and reinstalling VS2010 premium, my SQL Server 2008 now refuses to connect to my databases stating: 

TITLE: Connect to Server

Cannot connect to Q9300\SQL200801.


How to connect a remote Sqlserver 2008 r2 server with IP address and port? I use SMO and VS2010.


how to write SMO's conn.ConnectionString with IP address and port?

Error installing SQL Server 2008 R2 on a Windows 7 Ultimate 32 machine

HI all, I'm installing the Developer edition of MS SQL Server 2008 R2 (downloaded today) on a Windows 7 Ultimate 32bit virtual machine (using VMWare Workstation 6.5).  Yesterday I had tried MS SQL Server 2008 R0 with the same results.  Both give an error about 30% into the installation process: "An error occurred during the installation of assembly 'VSLangProj80,Version="",PublicKeyToken="b03f5f7f11d50a3a",Culture="neutral",FileVersion="8.0.50727.1826"' When I click the OK button, the install rolls that last bit back and then continues.  Unfortunatly I didn't take a screenshot of the main install window, just the error window. Any ideas what this error means?  The install yesterday seemed to work, but I'm not through the R2 install yet.  The R0 install also failed to install the documentation for some reason (I left it running during the night) Note that I have VS2010 (original release plus downloaded updates) installed and then just some small stuff like Snagit and Skype on this VM.  I updated Windows 7 completely before I started installing R2 so it is completely up to date as of midnight! Best regards, Arnor BaldvinssonArnor Baldvinsson

Installing sql server 2008 on windows 7 ultimate

When I was installing this sql server 2008 on windows 7 it showed me some compatility issue.. but then I proceeded. I have gone till configure step and then one rule fails which says "this system has sql 2008 server already isntalled and I should install sql server 2008 sp1. But I dont have sny sql server 2008 version and it did not work even if I install sql server 2008 sp1

Upgraded to SQL Server 2008 Express R2 64bit and now all my VS2010 db apps won't run

I am running WIN764bit, VS2010 and just "upgraded" from SQL server 2005 to SQL Server 2008 Express R2 64 bit.  When I went back into VS2010 and tried to run and test several database apps that I have developed, I find that I keep getting the error "Failed to generate a user instance of SQL server due to a failure in starting the process for the user instrance".  I have read a lot of threads here but I am not getting anywhere.  I can create a new SQL Server database, but can't find any of my existing .dbo connections and can't open any of the .mdf's from within Server Explorer (VS2010).  Any ideas? BTW the install went fine. And I have User Instance set to True in VS2010.

Cannont connect to New Installation of SQL SERVER 2008 from New Vista Ultimate machine(s)

I have a new SQL Server 2008 Development edition installation on a Newly setup Server running Windows Server 2008 Enterprise edition.  The server is mainly a file server and is not setup as a domain controller.  Since my test environment is fairly basic (server and two Vista Ultimate machines) I thought the connection through data sources on the client machines would be straight forward.  But it isn't working.  I can see the server, ping the server, etc. but when I try and connect the client through a system DNS it will not connect using SQL Server authentication using a loginId.  (since it isn't on a domain, I can't use Windows NT Authentication).   The error is SQL Error 10060 and SQL Error 17.  (connection failed and SQL Server does not exist or access denied)  Any thoughts or suggestions are appreciated. WB

Installing 2008 express after VS2010 pro

I have just installed Visual Studio 2010 Professional on my laptop and it installed a basic version of SQL Server 2008 Express with no management tools. I would like to install the Full SQL Server 2008 Express on my laptop, but when I download and run SQLEXPRADV_x86_ENU.exe (advanced version with tools) or even just 2008SQLManagementStudio_x86_ENU.exe (management studio only), it extracts the files, runs a command prompt window for about 2 seconds and then closes and deletes the files it just extracted. I am installing on a laptop with Windows XP Pro SP3. Any help would be greatly appreciated. Thank you!j

Error-Installing VS2010 on Windows Ultimate(64)



I am trying to install VS 2010 on Windows 7 Ultimate(X64) edition,but I am getting an error.I downloaded the VS2010 with MSDN subscription.Not sure how to resolve this.I installed SqlServer2008R2 and Sharepoint2010 on the same machine.

Kindly tell me where I am wrong.


SQL Server Express 2008 R2 and VS2010


Is anyone using this combination together?

I ask because I have posted previous questions without reply.  There seems to be a compatibility issue with the database in VS once opened up in R2 - any got any experience of this and how to work round it?



Error installing SQL Server 2008 R2 on Vista Ultimate x64


I installed IIS7 on a Vista Ultimate x64 machine and enabled all Application Development Features, all Common HTTP Features, and Request Filtering.  Now I'm trying to install SQL Server Express 2008 R2.  It proceeds for a while, but then stops short with Error Code 0x84B30002.  The detailed error message is below.  What solution is there to enable the installation? Thanks.


See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\Phillip Galey\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\\user.config line 5) ---> System.IO.FileNotFoundException: Could not load file or assembly 'System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the f

Dos window flashes when installing SQL Server 2008 R2 on a Windows 7 Ultimate 64 machine - then does

I downloaded the iso for SQL Server 2008 R2 but it will not install on my Windows 7 Ultimate or Windows Home Premium  (I upgraded to Windows 7 Ultimate when I could not get it to install on the Home Premium - but still the same issue)

Does any one have a clue or seen this before?

VS2010 Pro and SQL Server 2008 R2 Express




I have installed VS2010 Pro Trial (with the intention of buying VS2010 Pro). If I understand well, during the installation, SQL Server 2008 Express was also installed. I wonder if there are any clear instructions somewhere of how to upgrade from the (existing) SQL Server 2008 Express to SQL Server 2008 R2 Express edition. I have already spent hours researching and I am very confused with the various editions of SQL Server 2008! :( (It took me forever to realize that SQL Server 2008 Express with SP2 is NOT the same as SQL Server 2008 R2 Express since many of the links of the R2 site forward one to 2008 pages!!! :( )

And a side question... Is there a way (that I obviously haven't figured out yet!) to manage SQL Server Express (2008 plain or 2008 R2) from OUTSIDE VS? (I'm an old programmer from the VS6/MSDE era :P )

Thanks for your patience and any responses!

SMO.Backup Problem with Remote Server on Network [SQL Server 2008, VS2010]



The Below codes working fine while I create backup on SQL Server installed on same system. But When I try to take backup on Network, the backup says failure.

Really i can't understand. Just i changed the IP & I tried, but I get failure reply.

For that Any Ideas will be welcome.

 MyDTBaseName = "Supplier_Accounts"
    MyBckPth = "\\Unc_Path\Year_End_2010"
    PurDbName = MyBckPth + "\Sup_SQLSMO.bak"
    Dim MyServIp As String = ", 2745"
    Dim MyRemot_ServIp As String = ", 2745"
    Dim MyBackup As Microsoft.SqlServer.Management.Smo.Backup = New Microsoft.SqlServer.Management.Smo.Backup
    Dim MyServer As Microsoft.SqlServer.Management.Smo.Server = New Microsoft.SqlServer.Management.Smo.Server
    'Dim MyServer As Microsoft.SqlServer.Management.Smo.Server = New Microsoft.SqlServer.Management.Smo.Server(",2745")
    MyServer.ConnectionContext.ServerInstance = MyServIp
    MyServer.ConnectionContext.LoginSecure = False
    MyServer.ConnectionContext.Login = "sa"
    MyServer.ConnectionContext.Password = "123"
    MyBackup.Action = BackupActionType.Database
    MyBackup.Database = "Supplier_Accounts"
    MyBackup.Devices.Add(New BackupDeviceItem(PurDbName, DeviceType.Fi

SMO.Restore problem...[SQL Server 2008 & VS2010]



Iam using SqlServer 2008. & VS 2010 ultimate.

When I try to take backup from my remote server Backup works fine. No problem. But when I restore via, SMO [SqlRestore] , its always
showing on that restored database as "Restoring...."

My requirement is to take backup & restore the database in other name...

Is there any idea to fix the problem?

Dim ThisYear as string="2010"

dim MyDTBaseName as string= "MyPartyAccounts" + ThisYear

dim PurDbName as string = "My Server Path\Par_SQLSMO_" + ThisYear + ".bak"

dim MyNwMdfNm as string ="D:\Temp\MyPartyAccounts_2010.mdf"

dim MyNwLdfNm as string ="D:\Temp\MyPartyAccounts_2010.ldf"

Dim MyRestore As Microsoft.SqlServer.Management.Smo.Restore = New Microsoft.SqlServer.Management.Smo.Restore

  MyRestore.Database = MyDTBaseName

  MyRestore.Action = Microsoft.SqlServer.Management.Smo.RestoreType.Database

  MyRestore.ReplaceDatabase = True

  MyRestore.NoRecovery = True

  MyRestore.Devices.AddDevice(PurDbName, DeviceType.File)

  MyRestore.RelocateFiles.Add(New RelocateFile("MyPartyAccounts", MyNwMdfNm))

  MyRestore.RelocateFiles.Add(New RelocateFile("MyPartyAccounts_Log", MyNwLdfNm))



  Catch ex As Exception



Convert 2005 RDLC to 2008 using VS2010


Hi and thanks.


I'm getting an error on serveral reports that I built  in VWD2005 (express) using the reportviewer control.  Trying to edit the rdlc file in VS2010, VS2010 asks if i want to convert the file to RDLC 2008 format and I click ok.  When I build the site, I get this error (and of course also when the report is ran):


Error 1 The report definition is not valid.  Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. C:\inetpub\wwwroot\mastercardlcm\Reports\WorkLists\OpenSRStatus.rdlc 1 


Here is my web.config concerning the RDLC assemblies, etc.

			<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
		<compilation debug="true">
				<add assembly="Microsoft.ReportViewer.WebForms, Version=, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
				<add assembly="Microsof

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Having problems installing/setting up SQL Server 2008 Express/R2 for ASP.NET user management on deve

I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me. I'm currently building a couple of ASP.NET MVC 2 sites.  I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool.  The problem is that ASP.NET can't 'see' the database. I have SQL Server 2008 installed on my laptop.  It's the version which is available on the Web Platform Installer (I believe it's Express).  When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that I'm running any version of SQL Server at all.  I get an exception about 'named pipes', and some other things I don't understand at the moment. Obviously, this is all a bit over my head.  Is there an idiot proof guide or tutorial available that describes, step-by-step, how to: 1. Install SQL Server 2008 on a development PC 2. How to configure it to be used by Visual Studio 2010 Professional 3. How to properly upload/modify the db on the production server with what's on the development PC Essentially, all the things that the ASP.NET tutorials gloss over.  Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.
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