Hi Ian,

To make it more clear Here is a pic

SSL and IPSec

To defend the privacy and integrity of data transmitted across a network, you should use either IPSec encrypted communication...

Hi,

SQL Server can be configured to encrypt all data transmitted between a client computer and a SQL Server instance. If the server is properly  configured, all connections will be encrypted using...

Hi Eric ,

How can i see the SSL Encryption data.

from

Raj

Hi,

 SOLUTION: To Disable AdHoc Queries in the registry for each one not set:                          '

 1. Start the Registry Editor. (Click on the Start menu, select...

Hi,

Veeresh,

Even I have tried but the problem is you .

("Will u pls explain what u are trying to say")

I havent asked for backup and restore within...

Sorry chris,

I am bound to do in sql server only.

from

Killer

Hi Everyone,

Error : Snap in creatin failed.

 The snap is not created ,it may not be installed properly.

CLSID:{}

How to resolve error:

The above  error means that

DSO is not working or...

Hi Don,

By using adhoc queries a user can run queries against other database provider, this 

also can be use by an attaker to brute force passwords.

i think it is clear...

Hi,

As working on the issue i reached to the point where i got the same result as u.

When doing backup on dump device can have some issues.Which i...

Hi,

Dettach the database and copy the logfile to diffrent location and attach again.

HTH

from

Killer

Thanx Phill,

I will edit my DTS pacakeges to be dynamic now.

Thanx once again.

It is too much for me to do this stup.editing

From

Killer

Sorry Phill

FOr late reply,

When we configure navision we assign a login name , so we assigned bmssa as recommended by microsoft.

So every user connect sql server by bmssa.All tables, views,...

Dear SQLBill,

I am running EM and QA from same machine,no login errors, can ping the server from network machine,

i am using windows 2003 sp1,yes i still have account,

1433 is the...

HI,

The project i am working is bit typical for me.

Few days back one of the DBA chnaged the database name not thinking about the pros and cons.

Now the director of...

Hi,

Have u enabled RPC in out.

Map the logins and remote logins too.

from

Killer