November 4, 2005 at 3:09 pm
Hi,
I was using terminal service to login and access the sql server machine. Now I have installed a sql server client utility on my desktop. From the enterprise manager I can view all my databases, tables and stored procedures. But I am not able to edit or modify anything. I thought there might be some read-only property that need to be unchecked. But I could not find anything like that. Can any one tell me what settings or properties to change to make this work?
Thanks.
November 7, 2005 at 8:00 am
This was removed by the editor as SPAM
November 7, 2005 at 8:18 am
What credentials are you using to connect ? If you are using SQL Server authentication, then check the permissions assigned to the user (in the user databases) to which that login is mapped. Same goes for Windows Authentication mode as well.
From Enterprise Manager, security/logins and then double-click the login that you are using and check the server-role(s) and/or database role(s) that that login is assigned to.
November 7, 2005 at 2:18 pm
I am using sql server authentication. The credentials work if I terminal-in into the sql server machine. But if I open the client utility enterprise manager from my desktop, everything is disabled.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply