Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hello
I installed visual studio 2010 in windows 7 32bit ultimate. It installed correctly and
works properly. And it installed Sql server express and connect to it and works.
But I want to create a data base in SQL server enterprise. So I installed SQL server 2008 R2. But when I click setup file after a few minutes I get this error. when I clicked the continue and I ignore from error it installs and when I write a code to connect to SQL Server management Studio in local database I get an error.
 
The Sql server 2008 r2 error before start installing:
Microsoft .Net Framework
Unhandled exception has occurred in your application. If you click Continue. the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.
An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Cnfiguration.LandingPage.Properties.Settings: Could not load file or assembly 'System. Version=4.0.0.0,culture=neutral, PublicKey Token=b77a5c561934e089' or one of its dependiencies. The system can not find the file specified.
(C:\Users\Administrator\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.co
 
I installed SQL Server 2008 R2 from my hard. I am a beginner,Please guide me by details.
 
This is the error that I got after installing sql server and I create a database in sql server management studio and from visual studio I want to connect it.
 
SQLException was unhandled 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:Named Pipes Provider,error:40-could not open a connection to SQL Server)
Posted 30-Oct-12 7:49am
suraty462
Comments
ryanb31 at 30-Oct-12 13:24pm
   
The error says it can't connect. Does it have an instance name? What does your connection string look like.
suraty at 30-Oct-12 13:30pm
   
Yes, it has.
the instance name is:SQLServer2k8.
and the connection string is:
cn = new SqlConnection();
cn.ConnectionString = "Data Source=(local); Initial Catalog=XXX_amlak; User ID=sa; password=XXX";
cn.Open();
joshrduncan2012 at 30-Oct-12 13:33pm
   
I thought SQL Server Compact and SQL Server Enterprise can't co-exist on the same machine. Has that restriction been lifted?
n.podbielski at 30-Oct-12 14:52pm
   
He wrote he have express and enterprise version. I had those 2 installed if I remember correctly.
suraty at 30-Oct-12 13:37pm
   
I don't know. How I understand that restriction has been lifted?
But, one year ago I install visual studio and SQL Server 2008 in windows XP.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Fix/Workaround/Solution:
 
Step 1) Make sure SQL SERVER is up and the instance you try to connect is running.
 
Step 2) Your system Firewall should not block SQL Server port.
 
Step 3) Go to Computer Management >> Service and Application >> SQL Server 2008 Configuration >> Network Configuration 
Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 565
1 Maciej Los 359
2 Kornfeld Eliyahu Peter 309
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,303
1 DamithSL 4,764
2 Maciej Los 4,306
3 Kornfeld Eliyahu Peter 3,914
4 Sergey Alexandrovich Kryukov 3,538


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 16 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100