sql server 2008中的db连接错误 [英] db connection error in sql server 2008

问题描述

我是视觉工作室2010和sql server 2008的新手......但我很擅长使用visual studio 2008和sql server 2005中的数据库连接....现在最糟糕的部分是在安装vs2010之后我开始创建数据库为我跟随在vs2008

1）db explorer - >数据连接右键单击并选择添加连接

2）在下一个窗口中我选择的数据源为Microsoft SQL Server数据库文件（SqlClient）

3）在数据库名称我给了一些名字像db后我按下k按钮...它要求确认消息，因为数据库文件不存在你想创建我选择是的，但它显示错误，因为启动用户实例的进程失败，导致无法生成sql server的用户实例。
连接将被关闭



任何人都可以解决我的问题非常紧急......

i am new to visual studio 2010 and sql server 2008... but i am good with db connection in visual studio 2008 and sql server 2005.... now the worst part is after installing vs2010 i start to create database as i followed in vs2008
1)db explorer-->data connections right click and selected add connection
2)in next window i selected data source as Microsoft SQL Server Database File (SqlClient)
3)in database name i gave some name like db after tat i pressed k button... it asked for conformation message as database file does not exist would u like to create i selected yes but it shows error as
failed to generate a user instance of sql server due to failure in starting the process for the user instance. the connection will be closed

could anyone solve my prob its very urgent......

推荐答案

If you get that error message, the solution that worked for me was to clear the SQL Express user instance data store, located at:

%userprofile%\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
(or full path)

C:\Users\\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

这篇关于sql server 2008中的db连接错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！