How do I create a db on a SQL server?

Hi,

well, after receiving some important advices from our friends here at WWGuide, I decided to change my Forum to a SQL version. However, one of the first instructions is: Create a database or use an existing one. Well, how do I do that? I have acess to my server through Terminal Services, but I don't know how to create a db. I've already uploaded all the files, but now what?

Thanks!

Or use osql.exe by clicking Start > Run > "Cmd" Then type

osql -S [server] -U [username] -P [password] -Q "CREATE DATABASE [databasename]"

I think you are getting confused here.

Access is a flat file database system so you have a file like myDatabase.mdb that can be downloaded etc.

MS SQL Server is a server database system so doesn't have a flat file that can be downloaded like you can with access.

This then means that MS SQL Server performs much better than access as it doesn't require a flat file to be completely loaded into memory every time it is accessed.

Have a look on google for some sites on MS SQL Server so that you get a better idea of how it works.

To create a MS SQL Server database you need to connect to the SQL Server via frontend software like MS SQL Server Enterprise manager, from there you need to create a database on the SQL Server.

Edited by -boRg-

Ok, the SQL Server database was created. Good.

HOWEVER (oh, boy), I'm getting an error message while trying to run the mssql_server_setup.asp thingy. Now, I know the message below says the data is incorrect, but I checked and rechecked: everything is correct (User Name, password, SQL Server Name, Database Name), so... my questions are:

1) The database was created in a directory different from the one where the Forum files are. It's not even in the Inetpub directory, but on a local directory. Is there a problem?

2) When entering the data on the sql_server_connection.asp do I have to specify the directory of the database?

3) Are the names CaSe Sensitive? (Well, I did use everything correctly anyway).

4) Am I lost or what?

Error Connecting to database on SQL Server Check the following is set up and correct:- SQL Server User Name SQL Server Password Name of the SQL Server Database name set up by you on the server Empty Database set up by you on the SQL Server Check also that you have entered the correct details in the file 'SQL_server_connection.asp' found in the admin directory