Need advice installing, web platform installer database information.

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
12/6/2011 1:35:39 PM
Gravatar
Total Posts 1

Need advice installing, web platform installer database information.

Hell all, I hope you are having a pleasent Monday afternoon!

I am still new to ASP.NET and MS SQL and I want to give this a try to see if I can work with it and to help me learn and understand how this all works.

I used the Web Platform Installer and it came up with a screen to enter database information. It is asking for database administrator login and password and i am not sure what to use here.

I am using .\SqlExpress and when I log in using Server Management Studio I use my windows authentication and I do not have a password to log into windows.

I also already have a database for the site that I am working on building right now, it also does not have a password. It will eventually be moved to GoDaddy.

If someone can please give me a bit more information on what information I should use here or if I need to do something different I would greatly appreciate it.

Thank you and have a great week!!

Sam

12/7/2011 8:53:42 AM
Gravatar
Total Posts 18439

Re: Need advice installing, web platform installer database information.

Hi Samuel,

If your SQL Server instalation is not already configured for mixed mode authentication which allows using either windows authentication or sql users, then you need to enable that. Google it if needed. If SQL server was not already installed the Platform Installer would install it and configure it for mixed mode.

Then since you are logged in as admin on the machine when you connect using windows auth from SQL Management tools, you can create sql user logins. Under the Logins node under the Security node you can set the sa password to something known to you or you can create a new login and make it a sql admin. sa is the default admin user created during installation of sql server.

For platform installer you need to use a sql user who is admin and it will create a sql user for the database that is not an admin but is a dbo (database owner) on the database and tha is the user it will use in the conneciton string. For public hosting like GoDaddy you usually must also use a sql user not windows auth.

Hope that helps,

Joe

You must sign in to post in the forums. This thread is closed to new posts.