Wednesday, March 21, 2012

Error: 18456, Severity: 14, State: 11

We have SQL Server 2005 Developer Edition with SP2 installed on Windows
Server 2003 Standard Edition SP1. When one of our programmers tries to
connect to the SQL instance he receives the 'Error: 18456, Severity: 14,
State: 11' error.
I found where this refers to a connect to server error and have checked, he
does have connect priviliges. I deleted both the server account and database
account and recreated them but he still receives the error. The only way he
can get access is to be a member of the sysadmin role. This was done for
testing but cannot be given as normal practice.
Does anyone have any ideas or solutions?
Thank You,
Bertbert
CREATE LOGIN test
WITH PASSWORD = 'balabalabala';USE AdventureWorks;
CREATE USER 'test' FOR LOGIN test;
GO Note , you can use ALTER LOGIN ... WITH default_database=..."-bert"
<bert@.discussions.microsoft.com> wrote in message
news:C9CDD261-B1AD-48BC-B821-9DCC80F64480@.microsoft.com...
> We have SQL Server 2005 Developer Edition with SP2 installed on Windows
> Server 2003 Standard Edition SP1. When one of our programmers tries to
> connect to the SQL instance he receives the 'Error: 18456, Severity: 14,
> State: 11' error.
> I found where this refers to a connect to server error and have checked,
> he
> does have connect priviliges. I deleted both the server account and
> database
> account and recreated them but he still receives the error. The only way
> he
> can get access is to be a member of the sysadmin role. This was done for
> testing but cannot be given as normal practice.
> Does anyone have any ideas or solutions?
> Thank You,
> Bert

No comments:

Post a Comment