| Author |
 Topic  |
|
|
jsphweid
Starting Member
7 Posts |
 Posted - 15 March 2006 : 23:33:01
|
Ok,
Im using SQL Express edition (SSX). I created a database. It is stored where all database files are stored when first made...
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\snitzdb.mdf
I edited config.asp accordingly. I got the strDBType, and here is what the connection strings look like:
strConnString = "Provider=SQLOLEDB;Data Source=directorserver.weidingerserver.local;database=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\snitzdb.mdf;uid=Administrator;pwd=********;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
strConnString = "driver={SQL Server};server=directorserver.weidingerserver.local;uid=Administrator;pwd=********;database=D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\snitzdb.mdf" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
I use IIS. I created a Virtual Directory corresponding to the folder containing all of the files. My site is (Im on dialup for now, so it might kick off when I am sleeping, but it should come back on after a few seconds):
http://weidingerserver.selfip.com
http://weidingerserver.selfip.com/snitz/setup.asp
That is the error message I get.
Thanks
Joseph |
Edited by - Gremlin on 16 March 2006 01:22:13 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 16 March 2006 : 01:18:44
|
Hi,
You don't put the path to the database file in the connection string when using SQL Server, that only applies to MS Access, you simply put the name of the database that you have created e.g. snitzdb into the connection string.
You also only need to set one connection string. I would recommend commenting back out the second one you've pasted in above and just use the Provider=SQLOLEDB one.
Your connection string should look something like this then
strConnString = "Provider=SQLOLEDB;Data Source=directorserver.weidingerserver.local;database=snitzdb;uid=Administrator;pwd=********;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
Note that I've masked the database password with ******** in case someone could use it to exploit your install, best to avoid posting passwords :).
|
Kiwihosting.Net - The Forum Hosting Specialists
|
Edited by - Gremlin on 16 March 2006 01:23:23 |
 |
|
|
jsphweid
Starting Member
7 Posts |
Posted - 16 March 2006 : 07:28:47
|
Thank you for your help.
I think it is getting closer, but I still got another error message (a different one I think).
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Thanks,
Joseph |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
jsphweid
Starting Member
7 Posts |
Posted - 16 March 2006 : 08:10:48
|
Well, my servername is directorserver (specifically directorserver.weidingerserver.local)and the password (I didn't realize at first) is my Administrator's password.
Thanks,
Joseph |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
jsphweid
Starting Member
7 Posts |
Posted - 16 March 2006 : 08:49:43
|
My builtin Administrator account is a member of every group (except guest, etc.). I don't have time right at this moment to look for Enterprise Manager, but I do know that when I 'manage' a computer, I cannot view logs (or at least I can't on this machine). Access is denied.
Thanks
Joseph |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 16 March 2006 : 15:23:05
|
Unfortunately SQL Express doesn't enable Mixed Mode Authentication by default, so your either going to have to connect using integrated security which would involve setting up a new Windows User, Giving access to that User to your Snitz DB in the SQL Express Manager, changing your connection string again and then finally changing the IIS user for this website to run under that logon as well or make some registry tweaks to enable Mixed Mode.
As you can see running integrated only is a bit of a hassle, so enabling Mixed Mode Authentication is probably the easiest thing to do.
See the section in this KB under the heading of "Enable Mixed Mode Authentication After Installation" and make the registry changes required.
http://support.microsoft.com/default.aspx?scid=kb;en-us;319930
|
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 16 March 2006 : 18:41:18
|
| Wasn't very familiar with it myself until just the other day when I decided to upgrade/downgrade a small application I'd written for work from SQL Server to express edition so we could free up a SQL License, Mixed Mode Authentication that was the very first hurdle I struck so it was still pretty fresh in my mind. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
jsphweid
Starting Member
7 Posts |
Posted - 16 March 2006 : 20:58:59
|
Thank you for your advice,
Ok, I changed it to mixed mode auth.(I think)(the test they described was nothing like what it seemed to be. , ) by finding the correct registry key and switching it to '2'. Then you mentioned 'express manager' so I ran a search, found, downloaded, and installed Microsoft SQL Server Management Studio Express. I then went into MSSMSE and viewed the properties of my database file 'snitzdb' and gave full permissions (except the ones that said deny in front of it, like 'db_denydatareader'... whatever it is...) to a new user I created called 'snitzoperator' (who is a member of Admins group and all of that good stuff). I finally went to IIS and changed the anonymous access user to 'snitzoperator' and went for it again. Same message.
Thanks,
Joseph |
Edited by - jsphweid on 16 March 2006 21:01:57 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 16 March 2006 : 21:07:14
|
I had a similar problem with an MSDE install. I'd forgotten to enable Mixed-Mode authorization, made the registry change, and it would never allow SQL Authentication until I uninstalled and reinstalled the MSDE...
I'm sure there is a better way, and I'd love to find out... but this has been my experience in the past.  |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
jsphweid
Starting Member
7 Posts |
Posted - 16 March 2006 : 21:51:04
|
Yes, I did,
I have time to reinstall...
Back in a while
Joseph |
|
|
|
jsphweid
Starting Member
7 Posts |
Posted - 16 March 2006 : 23:12:25
|
I must have uninstalled it in the wrong order (since there are about 6 'programs' under SQL Server in the Add/Remove columns) and it is not good.
I have WS03Enterprise 180 day trial. I'm in the process of learning, but I've decided to prolong this project until I get broadband (to make my final product actually worth it). Be back in a month or so maybe.
Thanks for all you help and wisdom!
Many thanks again, sorry if I wasted anyones time.
Joseph
|
|
|
| |
Topic |
|
Topic Locked
