| Author |
 Topic  |
|
|
carywinton
Starting Member
USA
3 Posts |
 Posted - 07 August 2006 : 22:18:16
|
I am having a very difficult time with authentication. I believe that Microsoft should be shot for not making the authentication process between different programs more streamlined. Here is my problem. I have created a new database in SQL 2005 Express called rpggamerpro. If I open SSMSE I see my database directory as NS\SQLEXPRESS\Databases\rpggamerpro
I have added the USR_NS user to this database with db_write and db_read permissions
My Windows 2000 Server presently works fine, delivers web pages and such with no problems, so we know that DNS and IIS 5.0 are working properly.
My confusion and problem arises when trying to connect to the rpggamerpro database.
When I run the setup.asp file I receive this wonderful message:
There has been an error !!
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
Click here to retry.
I am at a loss as to what I should try next.
Here is the connection string I am currently trying:
strDBType = "sqlserver"
strConnString = "Provider=SQLOLEDB;Data Source=localhost\SQLEXPRESS;database=rpggamerpro;uid=IUSR_NS;pwd=;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 August 2006 : 05:29:02
|
| Try using just localhost as the Data Source. I don't have experience with SQL 2005 Express, but I would expect it to listen to the same port as SQL Server, so the conn string should not be any different. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
carywinton
Starting Member
USA
3 Posts |
Posted - 08 August 2006 : 18:19:32
|
ruirib
Yep I finally figured it out. It was how the new user is set up in SQL 2005 Express. I finally just killed off the newly created database, made a new database, simply called "snitz". Then I created a user at the top level of SQL 2005 Express under the "master" or \SQLEXPRESS database. This seems to be the key to getting the proper rights available when the new database is created and you want to assign "ownership" to the user for that database. Then of course I made sure the user had db_write and db_read permissions along with db_owner. In IIS 5.0 under the web site directory for the site which will use the forum, I created a "virtual directory" to the Snitz Forum directory. I used an alternate drive, instead of the default "C" for obvious security reasons. I just named the new directory "snitz" and the virtual directory alias to "Snitz Forum".
Then I used the following connection string to make it all happen.
strConnString = "Provider=SQLOLEDB;Data Source=YOUR_SERVER_NAME\SQLEXPRESS;database=snitz;uid=snitz;pwd=xxxxxxxx;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
The file permissions on Windows 2000 Server are set by IIS 5.0 when you choose the "public web site" template option, so this takes care of the massive permissions headache I was getting for the last several weeks, <enter don't even think Advil here>. I think the biggest error I was making while setting all this up was placing the Snitz Forum directory in under the same directory as the web site which will serve it. This does not work, it causes all kinds of permission problems, it must be a virtual directory connection from IIS 5.0 to the Snitz Forum directory. This way the "database permissions and the IIS 5.0 permissions don't start duking it out. In any event thanks for heading me in the right direction and I hope my long winded explanation will be of some benefit to the other people on here.
|
|
|
| |
Topic |
|
Topic Locked
