Re: Permissions

From: Joseph Byrns (josephbyrns_at_nnoossppaamm-yahoo.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 15:23:10 -0000

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

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:omstr0deq20ao576mu4hme6265k103remk@4ax.com...
> On Tue, 14 Dec 2004 10:40:09 -0000, "Joseph Byrns"
> <josephbyrns@nnoossppaamm-yahoo.com> wrote:
>
> ¤ 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 ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Relevant Pages

  • Re: How do I give ASP.NET process network credentials?
    ... Then you can specify as userName= and password= and it will have ... > processModel settings specify 'machine'. ... >>> Source Safe database is not a database in the traditional sense of the ... >>> my interactive session network credentials. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Ruby-net-ldap fail
    ... Is it necessary to specify the organization unit? ... on username to get the DN and then use that to bind. ... than run an extra search for every authentication request. ... Ask for "Username" and append the UPN suffix ...
    (comp.lang.ruby)
  • Re: active directory search doesnt work
    ... > Hi, Arild! ... > Thanks after i specify domain username and password it works fine. ... > AB> for the searchroot DirectoryEntry. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: OutlookSecureTempFolder script
    ... default directory (Temporary Internet Files), but if I specify the username, ...
    (microsoft.public.scripting.wsh)
  • Re: File Transfer
    ... I dont want to go to owner applet in control panel and manually set the ... Is there a way to specify those parameteres ... username, password and domain. ...
    (microsoft.public.dotnet.framework.compactframework)
Loading