Cannot edit Databases on other SQL Servers in Visual Studio Server Explorer

[Paula Killen]

I am using Visual Studio .Net 2003 Server Explorer to
make any changes to my SQL Server 7 Database that is
local to my machine. I also have SQL Server 2000 running
on my machine and have recently upgraded the database to
SQL Server 2000.

Unfortunately I don't seem to be able to make any
modifications to the SQL Server 2000 database using
Server Explorer. I have also connected to other SQL
Server 7 and 2000 databases with the Server Explorer and
do not have access to modify any of these databases
either.

I can make adjustments to the SQL Server 2000 database
using Enterprise Manager but I really like the Stored
Procedure Editor with the "Design SQL Block" that doesn't
exist in Enterprise Manager.

Thanks

 

[Miha Markic]

Hi Paul,

Did you connect to server with right user/password (enough privileges?)

 

[Paula Killen]

I have tried using Windows Authentication and the System
Administrator username. Both of these logins allow me to
modify database structures in Enterprise Manager but not
in the MDE.