Run cliconfg.exe from Start | Run. Create an alias to the server. Register the Alias in EM with the second set of credentials.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide...

No. Dynamic SQL executes in a separate batch from the calling stored procedure. Therefore permissions are automatically rechecked.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

Odd that you should be having problems with vptray.exe but it's not unheard of. vptray.exe is what places the shield icon in your system tray when you log on to...

Unfortunately, a savvy user, regardless of database package is going to find a way around. In this particular case, stop the MSDE service, install a regular version of SQL Server,...

Application roles don't bypass security settings, per se. Rather, they use whatever security settings are for the application role. Problem is, when you turn an application role on for a...

Yes, the sa password can be sniffed over the network if you're not using SSL or IPSec. It is encrypted when connecting via ODBC, but the encryption is weak and...

The process you are trying to kill, did it perform a lot of operations? One thing to remember about the KILL command is it will attempt to roll back any...

Please do not cross-post. Most readers check all topics.

Post replies here:

http://www.sqlservercentral.com/Forum/topic.asp?TOPIC_ID=19221&FORUM_ID=5&CAT_ID=1&Forum_Title=Administration&Topic_Title=KILL+not+working

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Will the database be on the same computer as the end user?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

quote:

---

We are currently building a new database server with increased memory, processing power and server 2003, but I'm wondering whether capping the...

You mean vptray.exe, right?

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Use an IPSec policy to block IP traffic to the TCP port your SQL Server is listening on. Configure the destination IP address to be the NIC you want to...

Amazing what a little public scrutiny will do.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Sounds like something is up with the AV installation.

We do use AV software on SQL Servers where I work with the same exclusions. There can be a case made for...

quote:

---

We like to use one generic id to access database with proper permissions.

---

If it's one...