473,804 Members | 2,265 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2441

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

Similar topics

1
1491
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. Looks like some setup issue in my database. Thanks for your help in advance.
0
287
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 "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...
0
1488
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 who care). In the documentation it says: To generate create scripts 1. In Server Explorer, right-click the database object for which you want to generate create scripts. This might be the entire database, a specific table, stored procedure,...
7
3970
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 attempt to create a new database on the local PC, I get the following error "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under default...
5
4233
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 Server. But when I open SQL Server Management Studio, I can only connect to the SQL 2000 engine. In the Object explorer, it says v8.0.2039 (which I think is SQL 2000 Server, because I can see the existing SQL 2000 databases). How can I get SQL...
10
5478
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 it- I would like to see it so I can create a new SQL server database. Any help much appreciated- trying to learn web programming using vb.net, asp, html, vbscript and SQL server. D
9
2626
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 don't receive the database list in the dropdown) "An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that
2
1707
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 wrote the database name. I have Windows Authentication selected.
3
2618
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 node of Enterprise Manager. However, I could not setup a database connection to Server from Client using Server Explorer of Visual Studio 2005. The detail is in the following. Configuration of server and client: Server: Windows Server 2000, SQL...
0
9714
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9594
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10346
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10347
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10090
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9173
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7635
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5673
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4308
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.