请帮我在sqlserver 2005中打开 [英] Please help me in sqlserver 2005 to open

问题描述

您好，先生，
我已经在Windows身份验证上安装了sqlserver 2005，在笔记本电脑中安装了XP Service Pack2窗口时，在不格式化笔记本电脑的情况下直接更新了该窗口，当我登录到sqlsever时，使用Service Pack2中的XP Service Pack 3更新了它，这会导致长时间错误，即br/>
XP Service Pack 2的损坏版本现已从Internet不受损坏的版本更新为Service Pack 3

无法连接到DELL-2BC91843E4 \ sqlExpress，即我的服务器名称

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

推荐答案

如果您的SQL Server没有启动，请同时检查Windows事件日志和SQL Server错误日志.可以在SQL Server实例的LOG 文件夹中找到SQL Server错误日志(例如C:\ Program Files \ Microsoft SQL Server \ MSSQL ... \ MSSQL \ Log).在记事本中打开ERRORLOG文件，然后搜索阻止启动的错误.

如果SQL Server运行正常，但是您无法连接到它，请参考例如

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[^]

根据您对Mika的回答的评论，我建议sql server实例不再在您的系统上正确运行.纠正此问题的最简单方法是重新安装SQL Server2005.我知道您可以启动Management Studio工具，但这只是一个表单前端，仍然需要连接到数据库服务器实例，并且该实例是无法正常工作.

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.

这篇关于请帮我在sqlserver 2005中打开的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！