| Author |
 Topic  |
|
|
fastrax
Starting Member
35 Posts |
 Posted - 11 November 2005 : 20:44:21
|
I was seting up some other databases in Microsoft SQL and used the same user name that I use for my data bases. When I went back into the forum I got a data base not found eror (don't remember exact wording.) Then I got the error below.
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'shadowme7'.
/inc_header.asp, line 111
Not sure what I did wrong or how to fix the mess. So if anyone can help that would be great. |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 November 2005 : 05:21:42
|
| Make sure the user shadowme7 is in the user list for the forum database. Also, to eliminate the possibility of password error, if the first suggestion does not fix the problem, change the password for the shadowme7 login. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 12 November 2005 : 16:45:38
|
| a 'database not found' error? sounds odd to me - you say it happenned when youwere setting up some db's, could you have renamed/damaged something in the process? Maybe you accidentally messed up the privs? |
|
|
|
fastrax
Starting Member
35 Posts |
Posted - 12 November 2005 : 19:20:23
|
I tried the change password idea, but that didn't fix it. Still couldn't access the DB. I ended up making a new DB and setup all the forums, then copied the old database over top it. After tweaking a few problems it seems to be working. Still don't know why I cant access the original. It's not even a full moon.  |
Edited by - fastrax on 12 November 2005 19:20:43 |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 14 November 2005 : 05:36:12
|
| Glad it's sorted - I don't understand how you copied the old db over the new one though if you couldn't access it?! |
|
|
|
fastrax
Starting Member
35 Posts |
Posted - 29 November 2005 : 17:47:24
|
I have no idea how either. It seemed that the forum just couldn't access the data base. Very strange.
I have been having a few problems popoing up since then though. I got this today when I tried to post a new pole.
quote:
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'POLL_ID', table 'fubar.fubar.FORUM_POLLS'; column does not allow nulls. INSERT fails.
/post_info.asp, line 1043
Any idea how to fix it? It will post the question, but not the choices.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
fastrax
Starting Member
35 Posts |
Posted - 29 November 2005 : 20:09:17
|
| no, it was all copied at the same time from the original database. I have access to the sql server. Is there somthing I can do in Enterprise Manager? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
fastrax
Starting Member
35 Posts |
Posted - 30 November 2005 : 17:55:41
|
| Sorry for my ignorance. How do you actually accomplish that? I am just learning sql. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
fastrax
Starting Member
35 Posts |
Posted - 01 December 2005 : 03:12:10
|
I had another error regarding forum_poll_votes. I did the same fix to that table and it seems to be working fine now. Thanks for you help.  |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
