Cannot open database "db1" requested by the login. The login failed.
来源:互联网 发布:淘宝网店一颗心 编辑:程序博客网 时间:2024/05/20 17:41
今天一直出现这个问题,之前这个数据库都可以正常使用,在网上找了半天,这个应该是比较好的解决方式了。
Oh! I could solve it.
Let me share it so that other people can get the benefit if they fall in this problem:
I've just changed the authentication mode to sql authentication and then rewrite my connection string with the user name and password of the sql server. But remember to add Trusted_Connection=no; in the connection string other wise it wont work.
Now it looks like:
"Server=localhost;Database=test;integrated security=sspi;Uid=sa;Pwd=test;Trusted_Connection=no;";
For help on how to change the authentication mode plz visit:
http://blogs.solidq.com/EN/rdyess/Lists/Posts/Post.aspx?ID=12
Now I think I don't need the ASPNET user anymore for accessing the database.
C、无法打开数据库 "MSCUPTDB"
在"设置"对话框的"数据源"选项卡配置新服务器名称,显示以下消息:
Cannot open database "mscuptdb" requested by the login. The login failed. Login failed for user 'username'
排除此错误引起的故障时,请验证以下内容:
必须在运行 SQL Server 的计算机上创建 mscuptdb 数据库。如果未创建数据库和数据库角色,请运行位于 Updates Publisher 安装文件夹的 CreatePubToolDb.sql SQL 脚本,以创建 mscuptdb 数据库和 System_Center_Updates_Publisher_User 数据库角色。
安装 Updates Publisher 的用户必须具有访问 SQL Server 数据库的权限。用户必须具有 mscuptdb 数据库中的 System_Center_Updates_Publisher_User 数据库角色成员身份的 SQL Server 用户登录。
- Cannot open database "db1" requested by the login. The login failed.
- Cannot open database "WWALMDB" requested by the login.The login failed Login failed for user sa
- Cannot open user default database. Login failed. Login failed for user 'Machine/ASPNET'
- Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
- Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
- BAM部署视图失败 - OLE DB or ODBC error: Cannot open database "BAMStarSchema". login failed 42000.
- The Error "Login failed for user"
- tomcat error:The requested resource (/servlet/Login) is not available.
- The requested resource (/ggOA/phone/login.jsp) is not available
- Error while performing database login with the oracle 解决方案
- error while performing database login with the DriveName driver
- eclipse : Error while performing database login with the driver null
- error while performing database login with the oracle driver
- error while performing database login with the oracle driver
- error while performing database login with the oracle driver
- myeclipse error while performing database login with the MySQL driver
- Error while performing database login with the mysql driver
- Error while performing database login with the com.mysqtest driver
- iPhone How-to:播放gif动画
- Sandcastle初探——官方版的NDoc
- iPhone How-to:给导航栏贴图
- Using Fixpoint to Solve Mathmatic Equation ( 无限float运算的扩展 stream style)
- 使用MyGeneration生成NHibernate映射文件
- Cannot open database "db1" requested by the login. The login failed.
- 数组循环移位
- 一些PHP Coding Tips
- 十五: TranslateMessage(&msg) 函数 和DispatchMessage(&msg)函数
- 编码的问题--编码有三种(页面编码,文件格式的编码,后台处理所使用的编码)
- cat指令详解
- Android启动init.c
- FileVersionInfo类显示dll信息
- cmd 命令大全