Please help me in sqlserver 2005 to open

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hello Sir,
I have installed sqlserver 2005 on windows authentication, in my laptop when i have XP Service Pack2 windows, on updating that window directly without formatting my laptop i updated with XP Service pack 3 from Service pack2 when i login to sqlsever it gives long error i.e.

The XP Service pack 2 was corrupted version now updated to service pack 3 from internet non-corrupted version

Cannot connect to DELL-2BC91843E4\sqlExpress i.e my Server name

Posted 14-Dec-11 8:43am

Prashant Srivastava LKO

Add a Solution

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)

Wendelius · Answer 1 · 2011-12-14T08:55:00

Solution 1

If your SQL Server isn't starting, check both Windows event log and the SQL Server error log. The SQL Server error log can be found in the LOG folder of your SQL Server instance (for example C:\Program Files\Microsoft SQL Server\MSSQL...\MSSQL\Log). Open the ERRORLOG file in notepad and search for errors preventing the startup.

If the SQL Server is running fine but you cannot connect to it, refer to for example http://www.databasejournal.com/sqletc/article.php/1569851/Solving-SQL-Server-Connection-Problems.htm[^]

Posted 14-Dec-11 8:55am

Wendelius

Comments

Prashant Srivastava LKO 14-Dec-11 14:59pm

Yes I am unable to connect to sqlsever yes it is coming on click it's software but when i click on connect it is not connecting..

Wendelius 14-Dec-11 15:05pm

Sorry, but I'm not quite following. You click on what? Are you actually talking about the SQL Server Management Studio? Also What is the exact error message you get?

Prashant Srivastava LKO 14-Dec-11 23:31pm

I am saying that When I open sql server software then a popup comes with details,when I click on connect link it gives error of not connecting. How could I make the software, so that it can again start working.

Wendelius 15-Dec-11 0:21am

It seems that reinstalling the SQL Server could work for you. However, I'd suggest that you try to install a new instance of SQL Server alongside to the existing one. This could possibly correct the problem if the problem lies on shared files.

If you have to reinstall the same SQL Server be prepared to do a database restore if the database is corrupted.

AmitGajjar 15-Dec-11 0:23am

Hi,

after click on "Connect" button what error you are getting in "Event Viewer" ?

fjdiewornncalwe · Answer 2 · 2011-12-14T10:25:00

Based on your comment to Mika's answer, I would suggest that the sql server instance is no longer running correctly on your system. The easiest way to correct this is to reinstall your SQL Server 2005. I understand that you can launch the management studio tool, but that is only a forms front end that still needs to connect to the database server instance, and it is the instance that is not working.