September 7, 2010 at 8:47 am
I have a SQL Server box that is not on our domain. I can connect to the server using RDP with a local user and then login to SQL Server. The problem is that I also need to connect to this SQL Server instance to run data queries. Unfortunatly the application that is running in this standalone server does not support mixed mode authentication. I have a user on that server and SQL Server called SVRX\DBA howver I'm not sure how to use this login from another server to access the database. Any ideas?
September 13, 2010 at 9:59 am
Are you try to connect remotely via SSMS or from your application? If via SSMS, you should be able to connect to it using SQL auth. As you mentioned that the server is not on your domain, you may need to using the IP address if the server name is not resolveable via your DNS. You need to ensure that SQL Server Browser service on the server is running so that it can listen to remote connection requests.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply