MS-SQL Login default

[pran0001]

Is it possible to default the MS-SQL login and password so that MS-SQL does not request a password when generating a Crystal report?

 

[pgtek]

Hi
i depends on your login id
if your using NT login it will not prompt you for login
but if your using sql login it will prompt to logon on
once you have the server connection open it will not prompt you after

cheers

pgtek

 

[synapsevampire]

Presumably you mean MS SQL Server.

As pgtek points out, if you are using NT Authentication, then the report will open if each user has authorization.

If you're using external code, such as VB, you might embed a user/pw in a connection, though it's generally frowned upon.

Crystal Enterprise will allow you to set a user/pw.

-k