Re: connection issue from our developer

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
Date: Fri, 23 Mar 2007 05:09:38 -0600

What is the exact error message and error number he gets
when he tries to log into SQL Server?

-Sue

On Thu, 22 Mar 2007 10:33:45 -0700, Lynn
<Lynn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi,

SQL 2005 EE is installed on W2k3 box and firewall is off in this server.

From my client machine, my window account and that developer window account

all can login into this server with ODBC, sql client, telent to 1433 or VS
connection. But, this developer can't login to SQL server from him machine
with any appliction. He is in the same domain as server and my machine. I
don't know what's the reason to cause this issue now.

Please advise. Thank you.

Lynn

Prev by Date: Re: Agent services
Next by Date: Re: VS2003 client with SQL Server 2005 server
Previous by thread: Agent services
Next by thread: Re: connection issue from our developer
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL2005: Cannot connect error 11001
... The famous Windows Firewall (turned on my Server from which I'm trying to ... Exception Details: System.Data.SqlClient.SqlException: Login failed for user ... Try starting the SQL Server ... if you changed the port ...
(microsoft.public.sqlserver.connect)
Re: error logging on SQL 2008
... I was, though, hoping for some more recognizable Reason for that error (state 11, " Token-based server access validation failed with an infrastructure error. ... Suggests that state 11 means "Valid login but server access failure", which doesn't really seem to rhyme with your description. ... How can you login to your SQL Server and use that tool if you can't log into your SQL Server? ... at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) ...
(microsoft.public.sqlserver.server)
Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess
... > file while you do changes, so the script file in the end contains the ... >> Server, doesn't have the right to grant DB access to Domain Groups. ... > Tibor Karaszi, SQL Server MVP ... >> site where they let me login as Domain Admin. ...
(microsoft.public.sqlserver.msde)
Re: SQL 2005 Express setup
... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server role or right click on it and choose properties from the popup menu, ... Login is a member of the "sysadmin" fixed server role now. ...
(microsoft.public.sqlserver.setup)
Re: SQL 2005 Express setup
... Connect to your SQL Server Instance, ... Double click on the Login that you want to add to the "sysadmin" server ... Mark the "sysadmin" checkbox to make this Login a member of this Server ...
(microsoft.public.sqlserver.setup)