For SQL Server 2000 what are the basic folder security permissions that need
to be applied to the MSSQL folder for SQL to operate? The SQL server will
be primarly accessed from a seperate web server via ASP with DSN
connections. I was interested in the local account requirements and the DSN
requirements.
cannot access website ... Nerve.com--this started a few weeks ago; I do not get the error message on ...Microsoft OLE DB Provider for ODBC Drivers Error '80040e4d' ... Not defined as a valid user of a trusted SQL Server connection.... The DSN used to connect to the Commerce database is misconfigured to use ... (microsoft.public.windows.inetexplorer.ie6.browser)
RE: Invalid authorization specification ... Does your application use a DSN to connect to SQL Server?... DSN is setup correctly on the client machine.... How to troubleshoot connectivity issues in SQL Server 2000 - ... (microsoft.public.sqlserver.connect)
Re: Programmatically create DSN usind SQL Server Authentication ... Not when you create the DSN programmatically.... >Server using SQL Server Authentication.... >is off-topic for my purpose because it only shows Windows authentication.... (microsoft.public.sqlserver.odbc)
Re: Understanding SQL Connection ...production SQL server being hosted by a 3rd party on an external domain. ..."Rick Brandt" wrote: ... >> the linked table wizard and created a DSN.... > credentials are automatically passed when the DSN is actually used later on. ... (microsoft.public.access.forms)
Re: Word 2003 MailMerge with SQL Server 2000 problem ... Okay, I switched the way I was connecting, and started using a DSN... If I could either create a DSN-less connection string for Mail Merge, ... Personally I wouldn't use the 1=1 workaround on the grounds that the query...SQL Server does but I once did this with Oracle to get around some problem ... (microsoft.public.word.mailmerge.fields)
