Hello,

I am getting the following error when I tried to connect with a user
logon through SQL Query Analyzer. And this user has Database Creator
server role, and public, db_owner database access granted. Does it
require more permission?


Unable to Connect to Server G1:
Server: Msg 18456, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][Sql Sever] Login failed for user
'V1'


Thanks in advance.

On Tue, 19 Oct 2010 15:09:49 -0700 (PDT), xo wrote:

Hi xo,

Have you checked the default database assigned to the login? If the
login has no permissions in that database, the login will fail.

Also, check the error log. Messages returned to the client on a login
error are deliberatly sparse to make the hackers' life miserable, but
more details should be included in the error log.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

xo (xo5555ox (AT) gmail (DOT) com) writes:
Look in the SQL Server Errorlog for the same message. Or almost the
same. What is different is the State. Then look at this page, which
explains the state numbers:
http://blogs.msdn.com/b/sql_protocol...21/536201.aspx

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx