Unhandled exception has occurred in my sql server 2008 enterprise r2

Question

0.00/5 (No votes)

See more:

VS2010

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 6:49am

suraty

Add a Solution

Comments

ZurdoDev 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 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 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 30-Oct-12 14:52pm

He wrote he have express and enterprise version. I had those 2 installed if I remember correctly.

suraty 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.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Shanalal Kasim · Answer 1 · 2012-10-31T18:41:00

VB

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.

Amol_M_Kulkarni · Answer 2 · 2013-04-15T22:46:00

Solution 2

http://dyslexicanaboko.blogspot.in/2012/01/sql-server-2008-r2-will-not-install.html[^]

Posted 15-Apr-13 22:46pm

Amol_M_Kulkarni