473,386 Members | 1,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Can't create SQL Server database with Server Explorer?

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
0 2402

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: CV | last post by:
Hi, I am not getting option as 'new view' and 'new table' when I right click on views and tables option in VisualStudio.net IDE server explorer sqlservers database to create new objects. ...
0
by: Mark Huebner | last post by:
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...
0
by: tommie.nygren | last post by:
I am using Visual Studio.NET 2003 Enterprise Architect Edition (according to my IT guy... how do I actually check what version of it I am using?) and SQL Server Developer Edition (8.00.194 for you...
7
by: wally | last post by:
I have Visual Studio 2005 Pro. I installed SQL Express 2005 and rebooted. But, when I right click on "Data Connections" in the Server Explorer and choose "Create New SQL Server Database..." and...
5
by: Jack | last post by:
Hello, I had SQL2000 server running fine on the windows 2003 box. I then installed SQL 2005 Express. They both worked together fine. I then uninstalled SQL 2005 Express and installed SQL 2005...
10
by: danofweaver | last post by:
In SQL Server Configuration Manager I apparantly have a server named SQL Server(SQL Express) running - however, in VS 2005 when I try to 'add conection' (right click in server explorer) I cant see...
9
by: Gabriel | last post by:
Hello, I installed SQL server 2005 SP1 on a Windows XP SP2 From Visual Studio, I'm trygin to create a connection to a database, but I receive this error but I'm creating the connection (I...
2
by: shapper | last post by:
Hello, I just installed VS 2008. I opened the Server Explorer window and right clicked on Data Connections and selected "Create New SQL Server Database". Then I selected the Server Name and...
3
by: =?Utf-8?B?ZGF2aWQ=?= | last post by:
Last week I asked a question about connection to database from client machine (developer machine). I have changed the database security setup for "SQL Server and Windows" under (local)Windows NT...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.