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

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
Fri Dec 05 03:34:43 CST 2003

Hi Paul,

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

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com

"Paula Killen" <anonymous@discussions.microsoft.com> wrote in message
news:077201c3bada$995be840$a401280a@phx.gbl...
> 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

Paula
Wed Dec 10 17:37:12 CST 2003


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.

>-----Original Message-----
>Hi Paul,
>
>Did you connect to server with right user/password
(enough privileges?)
>
>--
>Miha Markic - RightHand .NET consulting & software
development
>miha at rthand com
>
>"Paula Killen" <anonymous@discussions.microsoft.com>
wrote in message
>news:077201c3bada$995be840$a401280a@phx.gbl...
>> 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
>
>
>.
>