Login with Windows Authentication Problems

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Author

Topic

djorre
Yak Posting Veteran

94 Posts

Posted - 2010-03-03 : 10:16:24

Hi,

Some strange problem here on a working system.

Windows Server 2008 with SQL Server 2005 clustered installed
- Windows authentication login fails using hostname or ip address

Windows Server 2003 that connects to that SQL Server 2005 instance
- Windows authentication succeeds using ip address of 2005 instance

Though we are using the exact same domain login, that is in the Administrators group. Very Strange?

ahmad.osama
Posting Yak Master

183 Posts

Posted - 2010-03-04 : 05:53:14

quote:
Originally posted by djorre

Hi,

Some strange problem here on a working system.

Windows Server 2008 with SQL Server 2005 clustered installed
- Windows authentication login fails using hostname or ip address

Windows Server 2003 that connects to that SQL Server 2005 instance
- Windows authentication succeeds using ip address of 2005 instance

Though we are using the exact same domain login, that is in the Administrators group. Very Strange?

did u use the correct instance name?
what is the error msg?

Bru
Starting Member

4 Posts

Posted - 2010-03-04 : 10:37:13

Have you checked the Permissions for this Login on that Instance where you are not able to login..

As already asked, what is the error message?

Bru Medishetty

www.LearnSQLWithBru.com

djorre
Yak Posting Veteran

94 Posts

Posted - 2010-03-05 : 03:54:24

The error message is 'login failed for user ...'.

I added the user explicitely to the logins of sql server and than it worked on both.

We assumed Windows Server 2008 has problems with security of domain groups in SQL 2005.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources