Enterpirse Manager problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

Enterpirse Manager problem

Author

Topic

Mark_Adams
Starting Member

2 Posts

Posted - 2005-07-05 : 16:38:56

Hi there

I'm very new to SQL Server (like about a week) with no previous knowledge so forgive me if this is a bit of a simple question:

I am trying to create a new Database and then a few tables so that I can extract some info using Visual Studio.Net.

When i open up Enterpirse Manager I open:

Microsoft SQL Servers followed by SQL Sever Group. It currently reads "No item" when I do this.

I'm guessing that I need to create something here (the database maybe??) in order to be able to create tables.

My question is: Is it a new database that I need to create here and if so, how do i do this? If not, what do I need to create here and how would i do it? Then, how do I add tables to this database.

From then on i'm fine (I think). No probs inputting the data to tables etc, it's just creating the damn thing in the first place!!!

Any ideas would be very gratefully recieved.

Thanks in advance...

Mark

nr
SQLTeam MVY

12543 Posts

Posted - 2005-07-05 : 16:45:48

First you need to register the server.
Right click on the group and select new sql server registration.
If you are on the server then you can use (local) as the name or the machine name - otherwise the m/c name.
Easiest to use sa and password for the first registration.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Mark_Adams
Starting Member

2 Posts

Posted - 2005-07-05 : 17:00:20

cheers mate - i'll give it a go!

kachun
Starting Member

1 Post

Posted - 2005-10-25 : 18:10:05

when I used the (local) for the server name, it prompt me "local - specificed sql server not found". When I used (computer name), it prompt me "computer name - sql server does not exist or access denied". Please advise.

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-10-26 : 00:54:03

Hi,
have you tried it with Query Analyzer ?!
1). open SQL SERVER Enterprise Manager
2). right click on SQL SERVER GROUP
3). select new server registration
4). click Next
5). Add the SQL SERVER NAME
6). Click Next
7). Connect Using (select SQL LOGIN)
8). Click Next
9). give login name as *SA* and password (give a password you set or leave it blank if not set)
10). click next
11). add the server to an existing group
12). Click Next
13). finish

then you will able to do work with Enterprise Manager

And
Kachun

quote:
when I used the (local) for the server name, it prompt me "local - specificed sql server not found". When I used (computer name), it prompt me "computer name - sql server does not exist or access denied". Please advise.

this is a list y get this error :

[url]http://support.microsoft.com/?kbid=888228[/url]

[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306[/url]

-----------------------------------------------------------
MSSQL Server encryption software http://www.activecrypt.com

pohaku
Starting Member

4 Posts

Posted - 2005-12-08 : 03:31:16

Hi, I try what you wrote, but I got an message said server does not exit or acess denied, any hint?

pohaku
Starting Member

4 Posts

Posted - 2005-12-08 : 03:32:32

I installed the sql 7.0 to a windows xp /sp2

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2005-12-08 : 09:33:31

You posted this in the SQL Server Express forum. Are you really using SQL Server Express?

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources