Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elic05
Yak Posting Veteran
62 Posts |
 Posted - 2009-01-08 : 14:29:54
|
| I log in by SSMME to the remote host and try to modify a column datatype of a table of my db and I cant.It says i dont have permission, the table is readonlycan i myself define it to be read/writeor it has to be done by the serverI dont belive the want me to go through all the procces of uploading again on every little modificationmore than thatwhen i run the website the site modify the tables all the time i can register a new user i can login and so on, so i have permission to modify the tables. why cant I do that using SSMME??? |
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2009-01-08 : 14:57:43
|
| You may be dealing with two different types of permissions.I do not know what webserver you are running but I will presume it is IIS. So my post is referencing IIS webserver.One reason the webserver allows these modifications has to do with Windows NT authentication. Groups are setup and are granted privileges through policies (I think). It may also be the case that the user group 'anonymous' is being granted privileges. The latter case is usually less secure but may be ok if using an intranet.SSMS (you are talking about sql mgmt studio right?) I believe gives you the choice of sql authentication or NT authentication when you login to some server via the object explorer.Hope that helps u !r&r |
 |
|
|
elic05
Yak Posting Veteran
62 Posts |
Posted - 2009-01-08 : 15:02:05
|
The webserver is IIS.but I dont understand if I can fix it, and if yes, how? quote:
SSMS (you are talking about sql mgmt studio right?)
yes. |
|
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2009-01-08 : 15:10:44
|
| When you use SSMS to login, what authentication do you select? I would try both SQL Auth and NT Auth to see which one works as a simple check. Go to object explorer & select the FILE tab. Then simply select connect & a popup window will come up. From there you select either NT Auth or SQL Auth. I would think NT auth would work because If you can make changes on the webserver then you must have some NT authentication setup (your web admin can help you with determining your login status).r&r |
|
|
|
elic05
Yak Posting Veteran
62 Posts |
Posted - 2009-01-08 : 15:24:53
|
| I log with windows authentication when i want to modify the local dband i log with sql server when i want to modify the remote dbI am talking about the remote db, this one i cant modify |
|
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2009-01-08 : 15:47:37
|
| Is there a reason you cannot login to remote using Win Auth when you connect with SSMS? If you cannot then you would need admin privs associated to your SQL Auth due to how groups are setup to manage security.Once you have the correct privilege you can modify the table as you want.It just sounds to me like your SQL authorization and your NT authorization are different for the task at hand. Talk to whomever manages your network about granting the correct permissions.r&r |
|
|
|
|
|
|
modify tables that i uploaded to a host server