大家好, 我更改了SQL Server选项,因此更改了特定的数据库 是默认数据库,前几天我出于某种原因分离了数据库 并且知道我无法连接到我的SQL Server,因为它的 寻找我发货的那个特定的数据库. 当我在SQL Server Management Studio中按下连接按钮时 它给了我这个错误:并且没有连接
连接 连接到 服务器 不能 连接 连接到 BEN-PC . 附加 信息: 无法 打开 用户 默认 数据库. 登录 失败. 登录 失败 用户"BEN-PC \ Ben". (Microsoft SQL 服务器,错误: 4064) 获得 帮助,点击: http: // go.microsoft/fwlink?ProdName=Microsoft + SQL + Server& EvtSrc = MSSQLServer& EvtID = 4064& LinkId = 20476解决方案
转到SQL Server Management Studio. 正常登录,然后在左侧窗格(对象资源管理器")中右键单击数据库". 选择附加..."并按照对话框进行操作.
引用:
www .linglom/2009/08/11/restore-database-from-sql-server-2008-to-sql-server-2005-part-1-introduction/ www.c-sharpcorner/uploadfile/raj1979/how-to-attach-a-database-in-sql-server-2005/ www.packtpub/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps www.mssqltips/sqlservertip/1894/attach-a-sql-server-database-with-a-missing-transaction-log-file/
Hi all, I changed my SQL server options so the specific DB is the default DB and the other day I detatched the DB for some reason and know I can''t connect to my SQL server because its looking for that specific DB that I detatched. When I press the connect button in SQL Server Management Studio it gives me this error: And doesn''t connect
Connect to Server Cannot connect to BEN-PC. ADDITIONAL INFORMATION: Cannot open user default database. Login failed. Login failed for user 'BEN-PC\Ben'. (Microsoft SQL Server, Error: 4064) For help, click: go.microsoft/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476Please help what can I do?
解决方案 Go to SQL Server Management Studio. Log in as normal, then right click "Databases" in the Left hand pane ("Object explorer"). Select "Attach..." and follow the dialogs.Quote:www.linglom/2009/08/11/restore-database-from-sql-server-2008-to-sql-server-2005-part-1-introduction/ www.c-sharpcorner/uploadfile/raj1979/how-to-attach-a-database-in-sql-server-2005/ www.packtpub/article/moving-a-database-from-sql-server-2005-to-sql-server-2008-in-three-steps www.mssqltips/sqlservertip/1894/attach-a-sql-server-database-with-a-missing-transaction-log-file/
更多推荐
附加SQL Server数据库
发布评论