MSDE - ADP Question

Hi,

After upsizing on MSDE, I created ADP on my terminal.

When the created ADP I need to copy to another user to get connected to MSDE hosted on my pc I followed these steps.

First I copied ADP to the user's pc and

1. Opened Administration Tools on user's pc
2. Clicked twice Data Source (ODBC) icon
3. Selected System DSN and clicked Add
4. Selected SQL Server (Last item) and Finish
5. Given new connection name (any name) in the field 'Name'. Description left empty. In Servaer, typed server name.
6. In the next page, I selected SQL Server Authentication and...

Here is my question:

Should I use at this step System Administrator's login id and password ?

OR

Should I use user's pc id and password ?

I tried both way. But login fails.

Where might have gone wrong? BTW, this the first user I trying on.

Any help would be highly appreviated.

With kind regards,

Ashfaquecreate a sql login in our MSDE using sp_addlogin and then use sp_adduser to grant them specific db access. see details in BOL. if you are using Wndows XP SP2 you may have to create an exception in the personal firewall r drop it altogether.|||Thanks Thrasymachus,

I would appreciate it very much if you could little bit in detail as I am new bee for this area.

With kind regards,

Ashfaque|||Do you have Books Online? If so (it's included free with SQL Server), open it up and go to the Index tab. Type in "logins-SQL Server" and start reading. It will give you more than enough information to accomplish this task. You can also type in the stored procedures he gave you to get syntax and usage information.|||oh why use the reference material. I drove for a couple of years without a license when I was a kid.|||Hi Guys,

No, I don't have Books Online..

Justi moving around with the help of you people...

I attached jpg image to give you a clear pic to know whats wrong..

With kind regards,

Ashfaque|||Hello Gentlemen,

I am still waiting for your valuable response..

With kind regards,

Ashfaque