View Full Version : SQLLogin() and 2003 server

Daniel K
08-09-2005, 05:33 AM
Hi, I'm using the Installshield SQLLogin() dialog. It's working fine when connecting to SQL Servers on most operating systems, but is failing when I attempt to connect to an SQL server running on a 2003 server machine. Has anyone else come accross this? It looks like a straight forward Installshield bug to me, but I'd be glad to hear it if there's something I could be doing wrong/or a workaround for the issue.

08-09-2005, 11:35 AM
Are you able to connect from the ODBC Data Source Administrator?

Launch the Administrative Tools | Data Sources from the Control Panel.
Click Add. (The Create New Data Source panel should be displayed)
Select “SQL Server” and click Finish. (The Create a New Data Source to SQL Server wizard should be displayed)
Expand the Server: dropdown list. (Should see all SQL Servers on the network)
Type “Test” in the Name: filed, and select or type the server in question in the Server: field.
Click Next. The Authentication panel of the Create a New Data Source to SQL Server wizard should be displayed.
Select your authentication type and provide a valid Login ID and password if you choose SQL authentication.
Make sure the “Connect to SQL Server to obtain default settings for the additional configuration options.” box is checked.
Click Next. (Should proceed to the next dialog.)

Daniel K
08-10-2005, 04:23 AM
Hi, thanks for your response. It appears at the moment that our testing department may have made some sort of mistake installing the SQL Server; as I re-imaged the machine this morning, installed SQL Server and tried reproducing the issue. The problem seems to have disappeared...