What's the deal with SQLServer 2005 Beta?
I've just got a magazine with a free cover disk with VB 2005 beta,
and also includes SQLServer 2005. I've installed it, but I can't get it
to do anything. It seems to have installed ok, there are the data files
for allthe usual system and example databases in place, and Task
Manager shows that SQLServer is definitely running. However the
only tool that came with it is called 'Computer Management' which
allows configuration options on the network, and to start and stop
SQL Server. There are none of the Enterprise Manager controls to
access the database, create tables, create users and so on. Enterprise
manager from SQL Server 2000 seems unable to detect the new
installation.
What's going on? Are there client tools I can download to access the
database with? 3 1708
"Peter Morris" <dont_sp@m_me.com> wrote in message
news:TZ****************@text.news.blueyonder.co.uk ... What's the deal with SQLServer 2005 Beta?
I've just got a magazine with a free cover disk with VB 2005 beta, and also includes SQLServer 2005. I've installed it, but I can't get it to do anything. It seems to have installed ok, there are the data files for allthe usual system and example databases in place, and Task Manager shows that SQLServer is definitely running. However the only tool that came with it is called 'Computer Management' which allows configuration options on the network, and to start and stop SQL Server. There are none of the Enterprise Manager controls to access the database, create tables, create users and so on. Enterprise manager from SQL Server 2000 seems unable to detect the new installation.
What's going on? Are there client tools I can download to access the database with? http://www.aspfaq.com/show.asp?id=2465 http://www.microsoft.com/downloads/d...displaylang=en
Assuming you have SQL Server Express 2005, then (as far as I know) there are
currently no client tools available except the command-line ones like
sqlcmd.exe.
Simon
"Peter Morris" <dont_sp@m_me.com> wrote in message news:<TZ****************@text.news.blueyonder.co.u k>... What's the deal with SQLServer 2005 Beta?
I've just got a magazine with a free cover disk with VB 2005 beta, and also includes SQLServer 2005. I've installed it, but I can't get it to do anything. It seems to have installed ok, there are the data files for allthe usual system and example databases in place, and Task Manager shows that SQLServer is definitely running. However the only tool that came with it is called 'Computer Management' which allows configuration options on the network, and to start and stop SQL Server. There are none of the Enterprise Manager controls to access the database, create tables, create users and so on. Enterprise manager from SQL Server 2000 seems unable to detect the new installation.
What's going on? Are there client tools I can download to access the database with?
If it SQL Server 2005 EXPRESS, then there aren't any other tools.
Anything you want to do with it (adding databases/tables, etc), you'll
have to do using transact SQL.
There are two command line SQL tools shipped with it. The recommended
one to use is SQLCMD.exe If it SQL Server 2005 EXPRESS, then there aren't any other tools. Anything you want to do with it (adding databases/tables, etc), you'll have to do using transact SQL.
There are two command line SQL tools shipped with it. The recommended one to use is SQLCMD.exe
Okay, thanks for the info. Yes, its SQL Express. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: ik |
last post by:
ERROR after uninstalling SQL Server 2005 Express
I get this message,
SQLDMO has not been registered. Please re-run your setupand contact your
system administrator.
GREAT!!! ReInstalled SQL...
|
by: byrocat |
last post by:
On the other database types, there is an audit capability in that you
record such items as
failed login attempts
attemtped access to tables user is not authroized to
changes to databse schema...
|
by: Mike P |
last post by:
I've been using Visual Studio 2005 Beta 1 for the last few weeks, and I
now want to try using SQL Server 2005 Beta with it. I've been to the
Microsoft URL...
|
by: Peted |
last post by:
Hi, sorry if this isnt the correct newsgroups for this questions but
im using vc++ 2005 express edition beta2 for learning to program vc++
..net, as in winforms applications and i was wondering...
|
by: Dan Sikorsky |
last post by:
Can I use SQLServer 2000 with ASP.NET 2.0 instead of SQLServer 2005, and use
the .Net 2.0 Membership functionality?
I've setup my Login page, controls, etc., and now it's time to use the Web...
|
by: pine |
last post by:
hi! i just joined this group today after a colleague told me about it.
anyway, i'm new to SQL and haven't tried installing any version of it.
I do have vb 6.0 though on my pc. My problem is that I...
|
by: =?Utf-8?B?SmVmZnJleQ==?= |
last post by:
I have some old ASP programs w/ SQLserver 2000 databases. Now I am
developing ASP.NET projects using VB 2005 and SQLserver 2005. What are the
best procedures to develop and test the ASP.NET...
|
by: Steve |
last post by:
Hi;
I thought I would rephrase a question I asked in another post to more
quickly get to the heart of the matter. My apologies for anyone who
is offended by what appears to be a repetition.
...
|
by: ad |
last post by:
How can I detect if my computer have installed SQLServer 2005 or SQLServer
2005 Express with program like c# or VB.NNET?
|
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,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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,...
|
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...
|
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...
| |