Then that's likely why it appears as a remote connection. IPs don't match, etc.

Matt Miller (6/12/2008)

---

- Forget the dev server right now, I'd start by focusing on the transport mechanism. FTP is not secure as a transport, so transmitting data...

This might help:

California Office of Privacy Protection: Social Security Numbers

There's a guide for organizations that includes the California laws which are applicable.

The idea behind using encryption is one of the following:

- The data is being accessed by a service account from an application. Therefore, the service account has access to the...

This isn't something we typically post on the forums. However, there are tools readily available on the Internet if you do a search using Google.

Does the name and IP address of the SQL Server differ from the local server name and IP?

What happens when you double-click the .msc from the folder itself?

If you look in the msdb database, there is a database role called targetserver. It is not at the server level. The role is actually intended for multi-server administration (think...

It's undocumented, but to be able to view the jobs, you do need to be a member of the targetserver role in the MSDB database. It gives you the ability...

Disregard. I just read the whole thing and saw that you tried. that. Have you tried copying over the .msc file from another system to the path where it is...

Did you try Add/Remove Programs through the Control Panel?

Click on Microsoft SQL Server 2005 and click the Change button. This should allow you to install the Workstation components.

What version of SQL Server 2005? Is this a cluster?

If you are just talking about possessing sysadmin rights, here's the basic recommendation:

- Use Windows users

- Put all the Windows users in a particular Windows security group at the domain...

As a security best practice, you should never use the Administrator account for the domain (and on another note, it should be renamed).

The general recommendation against sa is valid. We've...

In SQL Server 2000, it is strongly recommended you use Enterprise Manager. So, yes, that's the correct way to do so. The reason is that Enterprise Manager will ensure the...