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.
| Author |
Topic |
|
shaminda
Starting Member
25 Posts |
 Posted - 2003-09-23 : 10:56:45
|
| Here is a scenario. A client named LONDON is trying to connect to the server named ROME (Windows 2000). The ROME server has SQL Server 2000 running. The user on LONDON is Charles. And Charles is a member of ‘Users’ on the ROME server. And Charles is also the database owner of a database on SQL Server called dbShipping. For some reason Charles cannot connect to the SQL Sever using sequel authentication. Why can’t Charles connect to the SQL Server? If I make Charles an Administrator he might be able to connect because I have done this in the past. But I really don’t want to make Charles an Administrator.On the domain controller which has active directory Charles is a user. The server ROME is part of the domain. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-23 : 11:28:07
|
| Was mixed-mode selected when SQL Server was installed? By default, only windows authentication is allowed. To change it just go into the properties of the server in EM, then go to security tab. You can see and change the setting there.What is the error that he is getting?Tara |
 |
|
|
|
|
|
connecting to SQL server issues