SQL Server / MSDE Installation Tip

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
FalconRime Members Profile Find Members Posts Newbie Joined: 07 July 2006 Status: Offline Points: 2	Post Options Post Reply Quote FalconRime Report Post Thanks(0) Quote Reply Topic: SQL Server / MSDE Installation Tip Posted: 07 July 2006 at 5:14pm
	Had a problem trying to get the SQL configuation script to work. Eventually tracked it down to the fact that my SQL Server instance was set to only allow Windows Authentication and not username / password authentication. To switch on username / password authentication, go to Enterprise Manager, right click on the SQL Server Group, choose Properties. On the Security tab select the "SQL Server and Windows" radio button (not the "Windows only" radio button). Hope this helps someone else. Falcon. PS Any work been done on an Oracle install?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 07 July 2006 at 9:10pm
	It is something that is worth considering now that a free version on Oracle is available, but as most ASP and ASP.NET developers use SQL Server it may not be worth the time doing the conversion as most will be hard pushed to use or have any benefit in using Oracle. Also, for SQL Server users you now have SQL Server 2005 Express, which has the same limitations as the free version of Oracle, which is simply it can only use one CPU and a 4 gig limit on database size, non of which would effect the running of software like Web Wiz Forums.
	Web Wiz Forums Hosting ASP.NET Web Hosting

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 07 July 2006 at 9:12pm
	By the way when you setup SQL Server it's best to select to have the instance running in 'mixed mode' so you don't run into the problem that you mention. I would also suggest using SQL Server 2005 Express rather than MSDE which had too many limitations and is now superseded by the much improved SQL Server Express.
	Web Wiz Forums Hosting ASP.NET Web Hosting

FalconRime Members Profile Find Members Posts Newbie Joined: 07 July 2006 Status: Offline Points: 2	Post Options Post Reply Quote FalconRime Report Post Thanks(0) Quote Reply Posted: 08 July 2006 at 8:01pm
	Agreed about SQL Server Express - it was just that I already had access to MSDE on the development environment so it was a quick and easy way to get started. You are probably right about the Oracle version not being that popular. But in my case all my software is ASP/Oracle for historical reasons. Being able to run the forums (and more importantly integrate the user directory) in the same DBMS would have been good.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 10 July 2006 at 9:35am
	An Oracle version is something that I am yet to look into but now that there is a free version of Oracle it will be something that will be looked into to see if there would be any difficulties in implementing it and gauge if people want an Oracle version.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum