cooh23
05-14-2008, 05:38 PM
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
05-14-2008, 07:09 PM
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
05-14-2008, 09:17 PM
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
05-14-2008, 09:54 PM
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
05-14-2008, 10:37 PM
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.