Opening tables through SQL Server Enterprise Manager

[StevenK]

I have recently put a password on my local copy of SQL Server 7.0. Since doing this I am experiencing problems when I try to open tables through SQL Server Enterprise Manager. When I right click a table in the list (within a database) I get the 'All Tasks.... Open Table' option. On doing this I get an error indicating a problem opening the data with the 'sa' profile. I then am forced to re-enter the password to view the data (password entered when I connect to server through Enterprise Manager).
Am I missing a setting that uses the same profile/password (as for server log-on) when I open tables.
Can anyone tell me what I'm overlooking ?
Thanks in advance.
Steve

 

[redshadow]

after entering the password on the sa account are you able to access the database? If so, you might have just enable the SQL Server Authentication with the checkbox always prompt for password checked. Try to check it out by right clicking your registered SQL Server Groups and selecting edit registration. uncheck the always prompt for password.

 

[StevenK]

I do have 'Always prompt for password' checked. My understanding (as part of the properties against the SQL Server Registration entry) was that this meant I was prompted for the password for indicated user ('sa') each time I connected to the server - not to each table. If I'm logged onto the server with a valid user/password I would surely be able to open a table containing data without having to re-enter this password - I'm not prompted to do so - I get an error indicating that the user 'sa' is unable to before being prompted.
Am I missing something with this ?
Thanks in advance.
Steve