How do I create a db on a SQL server?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=10766
Printed Date: 12 April 2026 at 5:38pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: How do I create a db on a SQL server?
Posted By: pvillaca
Subject: How do I create a db on a SQL server?
Date Posted: 06 June 2004 at 8:45pm
|
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! |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 07 June 2004 at 5:02am
|
You need to have access to a server running MS SQL Server, you then use
MS SQL Server Enterprise manager to connect to the SQL server that can
be used to create the database. Your host will usually create the database for you on the SQL server in advance. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Mart
Date Posted: 07 June 2004 at 11:26am
|
Or use osql.exe by clicking Start > Run > "Cmd" Then type osql -S [server] -U [username] -P [password] -Q "CREATE DATABASE [databasename]" |
Posted By: pvillaca
Date Posted: 07 June 2004 at 11:02pm
| What's the extension of the db? mdb? db? |
Posted By: WebWiz-Bruce
Date Posted: 08 June 2004 at 5:38am
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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: pvillaca
Date Posted: 08 June 2004 at 11:47am
|
Oh, ok. You know what? I'm not going to try and do something I'm cleary not apt to. I'll have a friend to do it for me. Thanks anyway. |
Posted By: pvillaca
Date Posted: 09 June 2004 at 7:04pm
|
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?
|
Posted By: pvillaca
Date Posted: 09 June 2004 at 7:05pm
| Oh, and one more thing: the directory where the database is should have its Security configurations changed? |
Posted By: WebWiz-Bruce
Date Posted: 10 June 2004 at 3:32am
|
I think you are still confused. SQL Server is not a flat file like Access, you don't have a physical database file as such. You need to install MS SQL Server onto a server making sure you have set it up that it allows you to connect to it using TCP/IP You then need to create a database on the SQL Server (this is not a flat phsical file but a database on the actual MS SQL Server) You then need to enter the correct information into the forums connection page to connect to the database created on the MS SQL Server (you connect to the database on the MS SQL Server not a file). Try looking up on Google how MS SQL Server works as this should help you understand a little more as it is completly different to the flat physical file system that Access uses. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: pvillaca
Date Posted: 10 June 2004 at 3:38am
|
I expressed myself badly. I know it's not a flat file. It created a directory full of files. That was what I was referring to. But the SQL Server has to have a name doesn't it? (The string on that asp file says so... So.. my doubts are the same. Just replace "file" for system of files, or something like that. Anyway, I think I might just give up on this whole thing and keep the slow, access forum. |
)
Posted By: WebWiz-Bruce
Date Posted: 10 June 2004 at 4:32am
|
When you look at the SQL servers through enterprise mangager they should have names or IP addresses. For a local MS SQL install you can use 'localhost' as the name of the MS SQL server. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: pvillaca
Date Posted: 11 June 2004 at 11:07am
|
Believe it or not, I did it! I managed to make the forum work! Now... 1) Is there a way of "import" the users and the topics from the old forum to the new one? 2) I had already changed the skin and the language (including the images) of my forum to Portuguese. How do I "transfer" this to the new forum?
|
Posted By: jaj478
Date Posted: 29 March 2005 at 9:33pm
| I see that you made it work. How did you do it? |