Permissions

  • Thread starter Thread starter Joseph Byrns
  • Start date Start date
J

Joseph Byrns

I have a desktop application, which I use to connect to an SQL Server
database as follows :

m_ConnectionString = "Data Source=ServerName; Initial
Catalog=FlattedProperty;"

using no username or password, and it all works fine and I can collect and
update data happily. My problem is that I have created a load of users and
given them various permissions on the database, but my application can still
connect to the database without specifying a username and password. How do
I prevent my application getting access to the database without specifying
the appropriate password?

In enterprise manager and query analyser I must specify any of the username
and passwords I have created.
 
¤ I have a desktop application, which I use to connect to an SQL Server
¤ database as follows :
¤
¤ m_ConnectionString = "Data Source=ServerName; Initial
¤ Catalog=FlattedProperty;"
¤
¤ using no username or password, and it all works fine and I can collect and
¤ update data happily. My problem is that I have created a load of users and
¤ given them various permissions on the database, but my application can still
¤ connect to the database without specifying a username and password. How do
¤ I prevent my application getting access to the database without specifying
¤ the appropriate password?
¤
¤ In enterprise manager and query analyser I must specify any of the username
¤ and passwords I have created.
¤

Are you using mixed mode security (Windows and SQL Server Authentication)? It sounds like you're
authenticating transparently through a trusted connection.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Ahhh, that's it, I forgot about the mixed mode, I've just run it from
outside our network, where I must specify the correct username and password
to get it to work, which further enforces what you say.

Thanks
 
Back
Top