1

SqlCmd : Login timeout expired from localhost

view story
linux-howto

http://serverfault.com – I've setup the instance SQLEXPRESS via SQL Server 2008 R2 installation, added a security login with all server roles, one called 'sqluser'. The server authentication is SQL Server and Windows Authentication mode. However, when i specify the -S property, login fails. There is no firewall enabled and SQL server even accepts connections from remote hosts. C:\Users\user>sqlcmd -U sqluser -P qwerty -Q "Select * FROM testdb.dbo.testtable" Output: integer ------- 1 2 3 4 (4 rows affected) However when specifying 'localhost' the query fails... Question is Why? C:\ (HowTos)

taskli's picture
Submitted by taskli on 11/11/2012

Stories similar to SqlCmd : Login timeout expired from localhost

I've installed Windows Server 2003 R2 and IIS role (no Active Directory role). I've setup a virtual directory named 'test' and under Security tab of the 'test' Virtual Directory I've disabled the Anonymous login and enabled Integrated Windows Authentication. The server is on the local network. What I do is I access the test/ directory on the server using the browser.

I am trying to connect from desktop to SQL Server 2012 (on a different server) and getting the following error:

Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and respond; Or it could have timed out while attempting to create multiple active connections.

I have a strange issue on IIS7 running on Windows 2008 (Domain Controller).

We have a website and we set to use "Windows authentication" only. So, all other authentication methods are disabled.

When the Windows server rebooted, users cannot login, and got 401 error.

But, if I restart the IIS server, it works fine ... until the next reboot.

Here is the logging when it does not work.

I've setup a FTP server in IIS 7.5 on Windows Server 2008 R2 Standard and enabled Basic Authentication. I have a basic user ("Ropstah") on the server which is in the Users and Some Custom groups. I've allowed the Some Custom group read/write access on the FTP folder.

Now when I connect to the server using "Ropstah" I get the following error:

530 User cannot login

Why is this?

I've just built my first LTSP, and have pxe booted my first client, I receive the login screen, but after putting in my user and password I get "ltsp login no response from server restarting" and I'm presented again with the login portal.

What I've done: I've enabled password authentication in the ssh config. I've tested the login account via SSH and can successfully login to the se

1 I have configured Ubuntu server with Key authentication & it is working fine. I have disabled password authentication for key authentication to work. Server is always accessed via remote terminals or putty.

Now all user accounts are able to login with the authentication Key and passphrase. But now I want to create only one new user without key authentication.

I'm trying to connect remotely from my Windows 8 client to manage my Hyper-V Server 2012.

I have a network where several users are using Office Accounting 2009 in multi-user client/server mode. OA is built on SQL Server.

We have Windows 2008 windows server in that we are running VISUAL SVN Server, Presently it has subversion login authentication which will be authenticated locally.

We are planning to go through Windows AD integration, What is the proper way of migration of users? will I loose any data while migration?

I am not much into windows server administration. Can anybody please guide me in this..