Re: SQL Server Authentication


George,

I'm sorry to hear you are having some troubles with SQL authentication. If I
can I would love to persuade you to use Windows authentication if at all
possible. It offers such a cleaner model for deployment and maintenance. For
example, if you alter the login credentials for the SQL logins, the deployed
applicaiton that relies on those baked-in credentials will be broken until
an update is laid down. Now, you can get around this by using a config file
of some sort, but then you have to think about locking that down (security
concerns) and managing it. With Windows authentication, you need only
configure the perms on the server for the user accounts and you are back in
business!

If you do elect to go with SQL perms instead of Windows, make sure you are
doing your dev work in an account other than SA. I cannot tell you how many
applicaitons I have gone in to troubleshoot as a consultant and I find that
they are still using the SA account WITH A BLANK PASSWORD! Yes, it's sadly
true. Some of them were notable companies, and I found myself persuading the
IT/DEV departments to bite the bullet and re-work their infrastructure to
eliminate dependence on SA and the blank password.

HTH
--
John R. Durant [MSFT]

blog: http://blogs.msdn.com/johnrdurant

This posting is provided "AS IS" with no warranties, and confers no rights.
"George" <George@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8CDDB097-60EB-46FC-8212-F047DFEF431F@xxxxxxxxxxxxxxxx
> With VSTO using Visual Studio 2005, has anyone manage to use SQL Server
> authentication method to connect to a SQL Server database ?
>
> In the Visual Studio 2005 VSTO hands-on example provided in MSDN, I was
> able
> to use WINDOWS AUTHENTICATION to connect but for some reason, SQL Server
> Authentication method fail to connect.
>


.

Relevant Pages

  • Re: integrated security over vpn
    ... SQL 2000 is using Windows Authentication, and I can access tables, Stored ... > Are you using Windows authentication with SQL Server or SQL Server ... > easy to do on a home machine scenario as I would expect the home machine ...
    (microsoft.public.dotnet.security)
  • Re: Q: Named pipes and Windows (integrated) authentication
    ... >By the way, if you don't have SQL Enterprise Manager, there's an MSDE ... >>>his windows authentication to connect to the server. ... >>>Creating databases is only acomplished after you've already connected. ...
    (microsoft.public.sqlserver.connect)
  • Re: Q: Named pipes and Windows (integrated) authentication
    ... SQL Tools - he's referring to SQL Query Analyzer and SQL Enterprise Manager ... If you don't have a full copy of SQL Server 2K you're not ... but you'll replace the Domain with the Workgroup name. ... >>his windows authentication to connect to the server. ...
    (microsoft.public.sqlserver.connect)
  • RE: MELL and SQL
    ... At this point I'm logged in as admin and since ... have the necessary permissions for the installation. ... > Most third party apps don't use Windows Authentication, they use SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Express setup -- whats my username - from a Newbie
    ... SQL Browser service is not started ... The sa login is a special login in SQL Server, and is a member of the system ... that use the SQL authentication mode, and is not used in Windows ... that when using Windows authentication mode, ...
    (microsoft.public.sqlserver.setup)