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


Top 5 Contributors of the Month
satyapriyanayak
Ashutosh Jha
ASPEvil
Mahesh
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.

------------------------------
ADDITIONAL INFORMATION:


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.

------------------------------
ADDITIONAL INFORMATION:

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="8.0.0.0",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)

  

Hi,

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.


Montu

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?

Thanks


John



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=4.0.0.0, 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\10.0.0.0\user.config line 5) ---> System.IO.FileNotFoundException: Could not load file or assembly 'System, Version=4.0.0.0, 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

  

Hi!,

 

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]

  

Hi,

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 = "122.268.2.40, 2745"
    Dim MyRemot_ServIp As String = "122.268.2.50, 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("122.268.2.40,2745")
    MyServer.ConnectionContext.ServerInstance = MyServIp
    MyServer.ConnectionContext.LoginSecure = False
    MyServer.ConnectionContext.Login = "sa"
    MyServer.ConnectionContext.Password = "123"
    MyServer.ConnectionContext.Connect()
    MyBackup.Action = BackupActionType.Database
    MyBackup.Database = "Supplier_Accounts"
    MyBackup.Devices.Add(New BackupDeviceItem(PurDbName, DeviceType.Fi

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

  

Hi

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))

  Try

   MyRestore.SqlRestore(MyServer)

  Catch ex As Exception

   MsgBox(ex.Message)

  End 
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