Discussion:
trusted_connection
(too old to reply)
Paul DeWitt
2005-11-18 19:16:07 UTC
Permalink
Hi,
I have a .Net application I am developing which connects to a MS Sql server
database. I currently am testing the location in a couple of locations. I
am connecting to the database using a connection string. At some locations,
I am forced to set "trusted_connection=false" in the connection string and
other "trusted_connection=true" works. The locations with the false
connection are experiencing Crystal Reports problems.

1) What is the trusted_connection statement for?
2) How to make a SQL server database allow "trusted_connection=true"?


Thanks for any Help
Paul DeWitt
burt_king
2005-11-18 20:21:02 UTC
Permalink
Trusted connections is another way of saying to use windows authentication.
What do you mean you are "forced" to set trusted_connections = false?
--
Post by Paul DeWitt
Hi,
I have a .Net application I am developing which connects to a MS Sql server
database. I currently am testing the location in a couple of locations. I
am connecting to the database using a connection string. At some locations,
I am forced to set "trusted_connection=false" in the connection string and
other "trusted_connection=true" works. The locations with the false
connection are experiencing Crystal Reports problems.
1) What is the trusted_connection statement for?
2) How to make a SQL server database allow "trusted_connection=true"?
Thanks for any Help
Paul DeWitt
Paul DeWitt
2005-11-18 20:30:02 UTC
Permalink
Thanks Burt

When we try to connection to the database, if we have
trusted_connection=true,
the database connection is refused. If we change the string to have a
trusted_connection=false, the connection is accepted. Most of the function
work either way, but a Crystal Reports report with sub-reports crashes if the
trusted_connection is equal to false.

Paul
Post by burt_king
Trusted connections is another way of saying to use windows authentication.
What do you mean you are "forced" to set trusted_connections = false?
--
Post by Paul DeWitt
Hi,
I have a .Net application I am developing which connects to a MS Sql server
database. I currently am testing the location in a couple of locations. I
am connecting to the database using a connection string. At some locations,
I am forced to set "trusted_connection=false" in the connection string and
other "trusted_connection=true" works. The locations with the false
connection are experiencing Crystal Reports problems.
1) What is the trusted_connection statement for?
2) How to make a SQL server database allow "trusted_connection=true"?
Thanks for any Help
Paul DeWitt
burt_king
2005-11-18 20:56:03 UTC
Permalink
Can you put the connection string information here. Something sounds odd....
--
Post by Paul DeWitt
Thanks Burt
When we try to connection to the database, if we have
trusted_connection=true,
the database connection is refused. If we change the string to have a
trusted_connection=false, the connection is accepted. Most of the function
work either way, but a Crystal Reports report with sub-reports crashes if the
trusted_connection is equal to false.
Paul
Post by burt_king
Trusted connections is another way of saying to use windows authentication.
What do you mean you are "forced" to set trusted_connections = false?
--
Post by Paul DeWitt
Hi,
I have a .Net application I am developing which connects to a MS Sql server
database. I currently am testing the location in a couple of locations. I
am connecting to the database using a connection string. At some locations,
I am forced to set "trusted_connection=false" in the connection string and
other "trusted_connection=true" works. The locations with the false
connection are experiencing Crystal Reports problems.
1) What is the trusted_connection statement for?
2) How to make a SQL server database allow "trusted_connection=true"?
Thanks for any Help
Paul DeWitt
Paul DeWitt
2005-11-18 21:32:02 UTC
Permalink
The connection string I am using is:

workstation id=P_DEWITT;packet size=4096;integrated security=SSPI;data
source="P_DEWITT\ICI";persist security info=True;initial catalog=ICI;User
ID=guest;Password=guest;trusted_connection=false

This connection string is used to connect to another machine's database.
Post by burt_king
Can you put the connection string information here. Something sounds odd....
--
Post by Paul DeWitt
Thanks Burt
When we try to connection to the database, if we have
trusted_connection=true,
the database connection is refused. If we change the string to have a
trusted_connection=false, the connection is accepted. Most of the function
work either way, but a Crystal Reports report with sub-reports crashes if the
trusted_connection is equal to false.
Paul
Post by burt_king
Trusted connections is another way of saying to use windows authentication.
What do you mean you are "forced" to set trusted_connections = false?
--
Post by Paul DeWitt
Hi,
I have a .Net application I am developing which connects to a MS Sql server
database. I currently am testing the location in a couple of locations. I
am connecting to the database using a connection string. At some locations,
I am forced to set "trusted_connection=false" in the connection string and
other "trusted_connection=true" works. The locations with the false
connection are experiencing Crystal Reports problems.
1) What is the trusted_connection statement for?
2) How to make a SQL server database allow "trusted_connection=true"?
Thanks for any Help
Paul DeWitt
Continue reading on narkive:
Loading...