i cannot connect to database

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
froggzy Members Profile Find Members Posts Newbie Simpleton Joined: 05 October 2010 Status: Offline Points: 5	Post Options Post Reply Quote froggzy Report Post Thanks(0) Quote Reply Topic: i cannot connect to database Posted: 05 October 2010 at 5:18pm
	hello all, i upgraded my access database from webwiz forum 7 to sql 2008. i then try to upgrade from web wiz forum 7 to 9 but when it asks me the databases connection details, it doesn't accept my credential for the database. i even tried creating a new user and assigned him full control over the database but it still doesn't accept the credentila, it says: Error details:- Microsoft OLE DB Provider for SQL Server Login failed for user 'wwforum'. thank you all for your help regards,

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: 05 October 2010 at 6:07pm
	The error means that the connections details you are are incorrect. Make sure that the SQL Server is installed in mixed mode and allows TCP/IP connections. If you are using SQL Server Express TCP/IP connections are turned off by default even if you install in mixed mode and need to be enabled. SQL Server Express is often installed with a name pipe so you would use something like localhost\SQLEXPRESS as the host name. SQL Server is a very complex beast and for further help it maybe worth buying a book on it, or asking questions on a wesite dedcated to SQL Server.
	Web Wiz Forums Hosting ASP.NET Web Hosting

froggzy Members Profile Find Members Posts Newbie Simpleton Joined: 05 October 2010 Status: Offline Points: 5	Post Options Post Reply Quote froggzy Report Post Thanks(0) Quote Reply Posted: 06 October 2010 at 9:12am
	Thank you webwiz bruce, the sql server is installed in mixed mode and it allows tcp/ip connection. also, the sql server 2008 (full blown version, not the express one..) is on the same server as the forum. could it be that the conversion from access db to sql did not work propely? i used SMA as access 2007 have some problem uprising to sql server...

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: 06 October 2010 at 10:03am
	Although there are issues that will need to be fixed when using SMA, the problem that you have here is that your login to your wwforum has failed. This error means that the database server either can not be logged in to, or the login credentials that you have given have been rejected. Connections from web wiz forums to the database need to use an SQL Server login to the database and not a trusted connection. Make sure you have created a user in SQL Server that has DBO permissions over the database and use that for your login credentials to the database.
	Web Wiz Forums Hosting ASP.NET Web Hosting

froggzy Members Profile Find Members Posts Newbie Simpleton Joined: 05 October 2010 Status: Offline Points: 5	Post Options Post Reply Quote froggzy Report Post Thanks(0) Quote Reply Posted: 06 October 2010 at 10:11am
	Hi webwiz Bruce, Basicaly the user i created did not work because of this: i found the issue: http://patrick.eviltools.com/must_change-is-on/ and with your explaination, i understand the users from AD did not work!! thank's a lot for your help thought! :)

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