SQLSERVER connection problem - SQL Server Forums

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)

SQLSERVER connection problem

Author

Topic

wipro
Starting Member

1 Post

Posted - 2007-06-05 : 02:12:10

Hi,

Server Details : Serv

Windows 2003 sp1
SQL SERVER 2005 with Mixed Mode Authentication
Server not in domain.

Client Details : cli1

Windows XP prof
SQL Server 2005 Express - Mixed Mode Authentication

I am able to connect serv from cli1 using SQL Authentication sa. But I am not able to use windows autherntication and login the server

The connection explorer always says cli1 system windows credentials if I select windows authentication. So iam not able to enter serv systems username and password if I select windows authentication

Why I am trying the above:

I am installing BTS 2006 where I have to specify the server credentials where my Database is located.

if I give serv details it is failing. Eventhough I am able to connect serv/sqlserver using sa login, BTS installation fails with sa loging of serv.

[img src="d:\BTSInstallatin.GIF][/img]

Kindly do the needful. It's very urgent.

Please let me know if you need any extra info

Thanks

Vijay

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-05 : 09:59:12

You can't use windows authentication from remote client if sql server is not in domain at all. If sql server is in different domain than client machine, need to trust those domains to use windows authentication.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources