SQL Server - User Accounts
来源:互联网 发布:知你所想,予你所求歌词 编辑:程序博客网 时间:2024/05/22 08:35
/*
Author: Jiangong SUN
*/
I've made a web site prototype these days, I've found there are some useful information to share with you about some usual problems about users.
1/ How to create a user and give it rights to access a database
2/ Once you have correctly created your user, but you can't login with it in SQL Server. You get error 18456.
Then you need to check if the sql server is well configured.
These are possible reasons listed by Microsoft:
If you are trying to connect using SQL Server Authentication, verify that SQL Server is configured in Mixed Authentication Mode.
If you are trying to connect using SQL Server Authentication, verify that SQL Server login exists and that you have spelled it properly.
If you are trying to connect using Windows Authentication, verify that you are properly logged into the correct domain.
If your error indicates state 1, contact your SQL Server administrator.
If you are trying to connect using your administrator credentials, start you application by using the Run as Administrator option. When connected, add your Windows user as an individual login.
If the Database Engine supports contained databases, confirm that the login was not deleted after migration to a contained database user.
Well the most common correction is you activate SQL Server authentication.
3/ Sometimes you want to drop a login, but a job is associated with it.
You have to firstly get all the jobs in your DB. And then delete the job.
I hope this post do help to your daily work! Enjoy coding!
- SQL Server - User Accounts
- Types of user accounts
- Windows User and computer accounts
- SQL Server之user关键字
- KrbGuess – Guess/Enumerate Kerberos User Accounts
- Creating AD user accounts in PowerShell
- oracle官方文档之Predefined User Accounts
- sql server user附近有语法错误
- Sql server 关键字 'User' 附近有语法错误
- SQL Server 2012中的user和login
- sql server 2005 T-SQL ALTER USER (Transact-SQL)
- Security Tutorials系列文章第五章:Creating User Accounts
- mezzanine用户扩展/PUBLIC USER ACCOUNTS(一)
- Create a SQL Server Database and User for vCenter Server
- SQL Server : 使用SQL Express的User Instance特性
- [SQL server 2000] Don't build User table
- Do SQL Server User Defined Datatypes (UDT) affect performance?
- Sql Server 中的Login,Schema,User,Role之间的关系
- linux的目录结构及作用
- 读取properties文件和属性
- 关于用户满意度问题的设置
- Java操作符
- servlet上传图片 服务器路径
- SQL Server - User Accounts
- Ext切换tab页导致内嵌的<object>重新加载数据
- 详解Android中AsyncTask的使用 .
- Uploadify 3.2 使用
- 大数阶乘
- jQuery“复制到剪贴板”插件
- 关于类成员变量为引用与指针的思考
- 【露】4.26软件和UK联合加解密
- js验证总结