Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gert
Starting Member
4 Posts |
 Posted - 2005-04-07 : 03:50:03
|
| Hello,I have the following problem:- When I logon to my application with a user which is an Admin on Win2000 it automatically logs me on to my application because this user is also in the builtin\Administrators group of SQL 2000.- When I do the same on a machine which has SQL 7.0 it does not log me on. The a messagebox will popup which displays a SQL Server datasource which I defined.- When I start my application when I am logged in with a user which is not know on SQL level I get the messagebox "Login failed for user <Name of windows user>". After I click OK, the popup screen appears with the SQL Server Datasource and I then can type in another user and password to login.The big problem here is that my server automatically tries to log me in and I do not want that. Where can I specify that the Trusted Connection=false by default. On my SQL 7.0 machine it is default not selected but on the SQL 2000 it is default selected.Please help me with this problem. |
|
|
gert
Starting Member
4 Posts |
Posted - 2005-04-07 : 06:47:00
|
| I solved the problem by installing SP3a of SQL 2000. |
 |
|
|
|
|
|
Trusted connection in SQL 7.0 and SQL 2000