Re: SQL Server Authentication issues!

2 choices:

a) move to mySql; where username/password security is secure. MS SQL
Authentication is _IMPOSSIBLE_ to secure
b) enable double-hop authenticaiton for SQL Server; setspn and 'trust
for delegation'

-Aaron




Tony wrote:
Hi all!

I am having a rather odd issue with VB.Net (Visual Studio 2005) and SQL
Server 2005. I developed a little app for our team but then decided to
make it available for others. Since out team was given admin rights to
our database, I used integrated security for the first version of the
app. When I opened it up to other groups, I changed to SQL
authentication.

The problem is that no one outside our group has been able to use the
app because of DB connection issues. It always works from my machine,
so I checked the activity monitor on the server. Sure enough, I am
logged in as myself instead of the user I set up for the application.

Here is the connection string:

Private m_SQLConStr As String = "Data Source=MYDB;Initial
Catalog=MYDATA;Integrated Security=False;Persist Security
Info=False;User ID=MYUSER;Password=MYPASSWORD"

Does anyone have any insight into this problem?

Thanks!

.

Relevant Pages

  • Re: local admin account password
    ... >> except its based on something specific about the server. ... >> more recovery console and don't think cached logins will work. ... >> The DB file would be encrypted with EFS so only the limited user SQL ... >> and the app itself doesn't really need to be secure as the ...
    (Focus-Microsoft)
  • Re: Forms authentication - change password
    ... Contact the server administrator. ... I think your authentication validation method needs to be set to Windows ... the change password feature within ISA ... FBA is only supported using Secure LDAP. ...
    (microsoft.public.isa)
  • RE: Confusion on standard security methodologies.
    ... Application will talk to a back-end SQL ... By "back-end," I assume you mean on a different box from IIS? ... If SQL is on a separate box, you won't be able to use NT authentication ... impersonations (meaning that once passed to the IIS server, ...
    (microsoft.public.inetserver.iis.security)
  • Re: IIS6 Authentication Problem with SQL Server 2000
    ... They're not accessing SQL directly right? ... > a) if you are using a Windows 2000 Domain, ... > backend SQL Server. ... You need to use Kerberos authentication for this (not ...
    (microsoft.public.inetserver.iis.security)
  • Re: Forms authentication - change password
    ... Did you enter a set of domain credentials for the LDAP server set? ... I think your authentication validation method needs to be set to Windows ... the change password feature within ISA ... FBA is only supported using Secure LDAP. ...
    (microsoft.public.isa)
Quantcast