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 |
|
goalie1
Starting Member
2 Posts |
 Posted - 2008-04-28 : 16:25:11
|
| We have a SQL 2005 box that requires windows authentication but I have to connect a laptop that is not part of the domain. Is there any way to do this? Per company policy, the SQL server cannot be changed to use SQL Auth AND Windows Auth. Also per policy, the user's laptop cannot be joined to the domain since it's not a company laptop. I've tried using the following command:net use \\SQLServerName\ipc$ /user:DomainName\DomainAccount Passwordand then using enterprise manager to register the sql server but it still says that the computer is not trusted.Is there something else to this that I am missing or is this just not possible?Thanks in advance for the help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 16:30:08
|
| Have the user do a Run As when they open Enterprise Manager.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
goalie1
Starting Member
2 Posts |
Posted - 2008-04-28 : 16:37:22
|
Thanks - I'll give that a try. It's amazing the obvious things you can overlook sometimes...quote:
Originally posted by tkizer
Have the user do a Run As when they open Enterprise Manager.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
|
|
|
|
|
|
|
Windows Authentication from non-domain laptop