SQL Server 2000

[cooh23]

Hello All,

I just got a SQL Server installed but for some reason it's not allowing me to create a new database.
The New database button is grayed out under the SQL Server Enterprise Manager.

Does anyone know what seem to be the problem here?

Thank you,

 

[georgedwilkinson]

Hmmm. There are SQL Server tools which you can run on your desktop computer running Windows XP and there is the actual SQL Server RDBMS, which typically runs on a server, not running Windows XP.

Do you have a connection to a server that is running the RDBMS?

First, you gotta set Enterprise Manager up to "see" the server, then you can work with the built in databases or create a new database.

 

[cooh23]

Hmmm. There are SQL Server tools which you can run on your desktop computer running Windows XP and there is the actual SQL Server RDBMS, which typically runs on a server, not running Windows XP.

Do you have a connection to a server that is running the RDBMS?

First, you gotta set Enterprise Manager up to "see" the server, then you can work with the built in databases or create a new database.

Hi George,

I am running it from my own PC. I guess my question is how exactly do I create a server. It's funny because I have done this before but i just couldn't remember how to setup a Server so I can create a database.

What am I missing here? I can't connect to a server because I don't have one setup yet.

Thank you,

 

[georgedwilkinson]

The server is different than a database...you cannot create a server, only install it. And you cannot run the SQL Server server run-time on XP.

There is a faux SQL Server that comes with Access that you can install from the Access distribution disk (MSDE, I believe). It generally behaves like SQL Server and can run on Windows NT. Then you can connect to that (and manage it) from an Access project.

 

[cooh23]

The server is different than a database...you cannot create a server, only install it. And you cannot run the SQL Server server run-time on XP.

There is a faux SQL Server that comes with Access that you can install from the Access distribution disk (MSDE, I believe). It generally behaves like SQL Server and can run on Windows NT. Then you can connect to that (and manage it) from an Access project.

Okay, i will look into it. Thank you.