I have Visual Studio 2003 Professional and MS SQL Server 2000 installed on
my laptop. For some reason, I can't create a new database with the Visual
Studio Server Explorer. The error message is "Cannot create databases on
this server". I made sure I started up my instance of SQL Server called
T30-THINKPAD so it is running. However, I can create (and delete) databases
with the Enterprise Manager. The views from Server Explorer and Enterprise
Manager look different too:
Enterprise Manager view:
Microsoft SQL Servers
SQL Server Group
(local)(Windows NT)
Databases
tables
Server Explorer view:
Servers
T30-Thinkpad
..
..
..
SQL Servers
T30-THINKPAD
tables (same as above)
Why doesn't T30-THINKPAD show up in the Enterprise Manager? Why can't I
create databases with the Server Explorer? I've tried "T30-THINKPAD",
"T30-Thinkpad", "(local)", "local", "LOCALHOST" for server names. What am I
doing wrong? Is this a limitation of Server Explorer in Visual Studio.NET
Professional?
