By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,357 Members | 1,021 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,357 IT Pros & Developers. It's quick & easy.

Can't create SQL Server database with Server Explorer?

P: n/a
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?
Jul 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.