I'm trying to connect to a SQL server 2005 database on another server. This is my 1st attempt at using Crystal to connect with a SQL db. I assume I need to set up an ODBC connection (the option I see is OBDC (RDO)). I've been using the examples on connectionstrings.com to create a connection string. I'm not sure which string format I ought to use, or which values go where.
I know the server assigned name and the server ip address (which do I use?) I know the database name. I have a working user name and password. We use windows authentication to connect to SQL Server 2005, so I assume my username is domain\username in the connection string.
I'm currently seeing an error whenever I try to input any combination of values to make up a string. The error is: "Logon Failed. Details: Can not find DNS in Connection String". I'm not sure what that means. It's possible I have the entire string wrong or just one piece. (Beats me!)
Maybe there's another way to go about connecting entirely?
If someone could help a novice out I'd be very appreciative!
Thanks!
I know the server assigned name and the server ip address (which do I use?) I know the database name. I have a working user name and password. We use windows authentication to connect to SQL Server 2005, so I assume my username is domain\username in the connection string.
I'm currently seeing an error whenever I try to input any combination of values to make up a string. The error is: "Logon Failed. Details: Can not find DNS in Connection String". I'm not sure what that means. It's possible I have the entire string wrong or just one piece. (Beats me!)
Maybe there's another way to go about connecting entirely?
If someone could help a novice out I'd be very appreciative!
Thanks!