As said in previous posts, using staging servers can be a great first step; but I would add formal policies in the mix so that developers understand how serious the...

Hi Marc,

I am not too sure about the internals of Access regarding linked servers, but it sounds to me that the issue is related to the way the credentials are...

Another approach would be to use 2 factor authentication for SQL Server - the logins would be database logins but hard tokens could be used to secure the logins and...

Interesting question... not all Proxies can forward SQL connection requests.

I only of two products that can be used as proxies - ISA Server and Enzo DB Firewall.

Were you...

Hello,

SQL Server uses the OS security subsystem to provide network authentication. If you use a local windows account, NTLM will be used - not Kerberos.

If you use a domain account...

Hi Goodguy,

In short, you can't. Sorry for the bad news...

Instead what other vendors do is keep a hash of their data structures and...

What if you add WITH RECOMPILE at the end of the procedure? I would be interested to know if you still get the same result with this option.

Windows Authentication is more secure by design. Creating database accounts basically creates shared accounts. Not to mention that it's pretty easy to sniff the network and find database account passwords when...

I am not sure what the objective is, but if all you want is a way to know which database hasn't been used in a while just look into sysprocesses...

Strange indeed... what version of SQL Server are you using? What version of the ODBC driver are you using? Also - do you have anything in the event log on...

You could setup a trace on Login events, store the events in a table and create a trigger on the table. The trigger can perform pretty whatever you want, including kicking off...

You may need an authentication proxy to control who can use TOAD or Access and from where.

If you can't change the application UID, then you may need to create a separate database...

Well, this is a rather complex requirement... Let me take a shot at this. I am assuming you are looking for an integrated solution as opposed to a simple backup/restore...

Technically if your users are connecting through VPN using their network account (as they should) they should be able to connect to SQL Server as usual.

Windows Authentication should work seemlessly.

If...

Hi - If I understand your question you are trying to find out if you can identify who is using the 'sa' account and from where.

There is a solution out...