how to access database from remote sql server through DSNgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
Sir, my database is on my server and i want to access it from remote PC through DSN the connectivity is through ISDN line (modem). i can connect with my server means its listing in browser but how can i make DSN in wich i can map my central database. please notify me as soon as possible. Hope for prompt reply thank you
-- Anonymous, May 01, 2003
To make a DSN that connects to a remote SQL Server, create the DSN as you would locally, except use the server's IP Address instead of the server name.
Also, you will have to use SQL Server authentication rather than NT Authentication. That is, you will have to provide a valid SQL Server Login ID and Password because you cannot be automatically authenticated by the remote Windows network.
Hope this helps,
-- Anonymous, May 02, 2003