Giganews Newsgroups
Subject: SQL
Posted by:  xo (xo5555…@gmail.com)
Date: Tue, 19 Oct 2010


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

Thanks in advance.