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 |
|
alksys7
Starting Member
5 Posts |
 Posted - 2007-06-11 : 13:35:41
|
| Greetings All,I installed SQL 2000 with SP4 on a 2003 Server. I added a NT Group to the Server and created 2 users exactly the same in the SQL Server Enterprise Manager.My issuse is with the other user I created. When I go to a database in the Server Enterprise Manager and right click on tables, and select New Table with my user, the New Table window pops up with no problem. When the other user follows the exact same steps, Internet Explorer opens up and says page not found.Is this an SQL Issue or maybe an IIS issue?Thanks in advance. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-11 : 17:22:58
|
| Did you work on same machine? Sql server doesn't need IIS. |
 |
|
|
alksys7
Starting Member
5 Posts |
Posted - 2007-06-11 : 18:02:58
|
| I set up terminal services on the server and we both connect through an RDP connection. We need IIS for another application, so I thought that could have something to do with the problem. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-11 : 18:22:01
|
| On which step did other users get IE error? Do they have full access to sql em on terminal server? |
|
|
|
alksys7
Starting Member
5 Posts |
Posted - 2007-06-12 : 13:32:06
|
| They got the error when they clicked "New Table..." All if the User Rights are exactly the same. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-12 : 20:19:01
|
| Those users are in db_owner or db_ddladmin db role? |
|
|
|
alksys7
Starting Member
5 Posts |
Posted - 2007-06-13 : 10:54:32
|
| For the db_owner we have dbo and for db_ddladmin there is nothing. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-13 : 10:58:50
|
| That means the user doesn't have permission to create table. |
|
|
|
alksys7
Starting Member
5 Posts |
Posted - 2007-06-13 : 11:26:39
|
| I'll change the permissions and see what happens.My permissions are exactly the same and I am having no problems.Thanks! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-13 : 11:29:25
|
| Are you member of sysadmin? |
|
|
|
|
|
|
Internet Explorer Page Not Found