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 |
|
rmh
Starting Member
7 Posts |
 Posted - 2004-11-08 : 12:28:48
|
| Dear allOn the local network I can connect to MSDE in Enterprise Manager by registering the server INTRANET1So now I am at home. I have a connection to INTRANET1 down a VPN, I can get at it with a RDC connection or by setting up a network drive.Both of these are done via an ip number.So now, in my home copy of enterprise manager I want to connect to INTRANET1.How do I register it in Enterprise manager? It doesn't show up in available servers, but if I press on anyway:Entering INTRANET1 gets "Specified SQL server not found"Entering server name 192.168.4.3 gets "Login failed for user '(null)' Reason: Not associated with a trusted SQL server connection"Both of these are 'use Windows authentication' which I would prefer...Can you help? Thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-08 : 15:41:12
|
| Use the Clietn Network Utility to create an "Alias" to the server?You may ahve to set the SQL box to accept "SQL logins" - in addition to Windows style loginsKristen |
 |
|
|
rmh
Starting Member
7 Posts |
Posted - 2004-11-09 : 05:31:08
|
Yes!! I've done it. Alias created, and finally got to register it with a DB login, Windows authentication doesn't seem to work. THANKS!quote:
Originally posted by Kristen
Use the Clietn Network Utility to create an "Alias" to the server?You may ahve to set the SQL box to accept "SQL logins" - in addition to Windows style loginsKristen
|
|
|
|
|
|
|
Remote connect