| Author |
 Topic  |
|
Etymon
Advanced Member
United States
2385 Posts |
 Posted - 21 June 2009 : 17:41:01
|
Go to:
Start
Control Panel
Administrative Tools
Services
Scroll down to:
SQL Server (the name of your registered server is listed here)
Right click and choose:
Start
Then try it and see what you get.
The error I get with it turned off is:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. |
 |
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 21 June 2009 : 18:38:32
|
Looks like I can log in fine, the event viewer shows the account logging in 3 times
Etymon, the service started (it was already started)
and I got the same error
quote:
Originally posted by ruirib
Seems that you are having problems with the access to the DB. Can you connect to the database using that account through SQL Server Management Studio?
|
|
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 21 June 2009 : 18:53:00
|
Just so I'm sure this is not a simple syntax issue, if the name of the server is server-pc <--- not the real name
under computer name and the name of the data base is forum then the strConnString should read
strConnString = "Provider=SQLOLEDB;Data Source=server-pc;database=FORUM;uid=database user id;pwd=database password;" <--- not real user name and password
is this corect? |
Edited by - Volnar on 21 June 2009 18:54:27 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 22 June 2009 : 01:12:53
|
Ok the server name was wrong, so I'm further but still not there, it does not seem to like the user name/password for some reason.
I'm now getting this error
Error Description :
Cannot open database "edited for security" requested by the login. The login failed.
I've checked and rechecked this and I know it's the right password, I then changed the password to a deliberately wrong one and I get this message
Error Description :
Login failed for user '*****'.
I have no idea why it's doing this, I have tested the password in SQL management studio and it works just fine.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 22 June 2009 : 11:28:20
|
I'm not sure what you mean by provider.
I changed the user name and password and no change
This is the same for ODBC and OLEDB
Native client still returns an internal server error
quote:
Originally posted by ruirib
Changing the password and / or the provider doesn't help?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 June 2009 : 11:43:52
|
| Create a DSN using the Data Sources option (ODBC) in the Administrative Tools menu and test it while creating it, to see if you can connect to the DB from the computer. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 22 June 2009 : 16:37:53
|
here is the result
is this what you where looking for?
quote:
Originally posted by ruirib
Create a DSN using the Data Sources option (ODBC) in the Administrative Tools menu and test it while creating it, to see if you can connect to the DB from the computer.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 22 June 2009 : 18:49:05
|
still no luck
I now get this error
Code : 80040E4D
Error Description :
[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user ''.
I tried changing the logon to a windows logon (just as a test)and got this error
Code : 80040E4D
Error Description :
[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'NT AUTHORITY\IUSR'.
I don't understand why it's failing to log in with asp.
Both user names and passwords worked fine in the ODBC data source administrator
quote:
Originally posted by ruirib
Yes, that was it. Maybe use the DSN for the forum, then?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 22 June 2009 : 20:20:50
|
I think so, this is what is have for the user
quote:
Originally posted by ruirib
Did you add that login as a database user for the database you want to use for Snitz.
|
|
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 22 June 2009 : 20:34:13
|
ok I added IUSR as a database admin and got sone success as I got this message
You need to create all the tables in the database before you can start using the forum.
looks like the database is set somehow to only authenticate though a windows account, I'm not sure if I even care to change it at this point but I've heard this is a bad idea right?
How do I set the data base to use SQL authentication? I thought I had it set. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
