| Author |
 Topic  |
|
tle
Starting Member
USA
26 Posts |
 Posted - 07 June 2002 : 19:08:35
|
quote:
Did you restart the SQL server? Did you create a new login, configured to use SQL Server authentication?
Yes I did restart SQL server and restart machine... I dont have [SQL server authentication]. I use Enterprise Management to create the user under the database (forum) is the new one... Don't see where is [SQL server authentication] at?
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 June 2002 : 19:12:06
|
We seem to be playing cat and mouse here...
Did you change your SQL Server to support mixed (Windows and SQL Server) authentication?
<edit>
Well, just checked your previous post and you said you did. Ok.
Now, use Enterprise Manager to create a new login. In the login creating dialog you have the option to choose Windows authentication or SQL Server authentication. Choose SQL Server authentication and then specify the password.
Then go to the Snitz database, create a new user associated with the new login and assign him to dbowner role.
</edit>
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 07 June 2002 19:16:08 |
|
|
|
tle
Starting Member
USA
26 Posts |
Posted - 07 June 2002 : 19:13:57
|
Yes, I get into Enterprise, change the security mode to both WINNT & SQL, restart, then create blank db with default dbo is me in this machine
|
|
|
|
tle
Starting Member
USA
26 Posts |
Posted - 07 June 2002 : 19:18:36
|
Yeah, Can you tell me exactly what place in enterprise I can create new login?
Thanks
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 June 2002 : 19:22:11
|
quote:
Yeah, Can you tell me exactly what place in enterprise I can create new login?
Thanks
You have several folders below your server name. One of the folders is Database, where you can see your databases and create new ones. One of the other folders is Security. There is a Logins subfolder. That's where you create a new login, by right-clicking the Logins subfolder or by right clicking over the right pane of the dialog. On the menu that will show up, choose New Login.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
sue_mmcxii
Starting Member
5 Posts |
Posted - 08 June 2002 : 14:04:29
|
The usual here....error 80040E4D
MSSQL 7 and IIS 5 on same Win2000 machine. (just testing in this setup)
DB name = theboard
strDBType = "sqlserver"
strConnString = "driver={SQL Server};server=<myserver>;uid=sa;pwd=<password>;database=theboard" '## MS SQL Server
Security setting on the server level is for SQL and WinNT (not SQL only..)
Should I be using the path to the database?
i.e. ;database=C:/MSSQL7/data/theboard_Data.MDF ?
I'm using the sa user as dbo. I've tried setting up other users as dbo on the database level and it just didn't work, so thought I'd give sa a try.
Any help is appreciated! ;)
Thanks
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 June 2002 : 18:01:00
|
If you chose to post at the end of a long thread at least you could have tried some of the suggestions posted above. I'd say you should try Doug's sugestion regarding the UDL file. Also make sure that the instructions I posted above about SQL Server authenticated login and associated DB user are followed.
Next time, please start a new thread. The way I see it, you have a new problem start a new thread. If you post at the end of another thread I would assume you've tried everything suggested in that thread. Did you?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
sue_mmcxii
Starting Member
5 Posts |
Posted - 09 June 2002 : 15:41:15
|
Indeed, I did try everything posted above, and have spent three days doing so. I believe that the topic of this thread was the error message I am getting. I apologize for incovenincing the forum.
Thank You,
Susan Fleming
PS - Perhaps an email address would be appropriate - susan.fleming@peregrine.com
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 June 2002 : 18:41:17
|
quote:
Indeed, I did try everything posted above, and have spent three days doing so. I believe that the topic of this thread was the error message I am getting. I apologize for incovenincing the forum.
Ok, so did you manage to connect using the .udl file, or not?
Also are you hosting this SQL Server database? Can it be connected from the Internet?
Feel free to drop me an email if you want further help with this: ruirib @ computer.org.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
tle
Starting Member
USA
26 Posts |
Posted - 10 June 2002 : 12:08:29
|
quote:
quote:
Yeah, Can you tell me exactly what place in enterprise I can create new login?
Thanks
You have several folders below your server name. One of the folders is Database, where you can see your databases and create new ones. One of the other folders is Security. There is a Logins subfolder. That's where you create a new login, by right-clicking the Logins subfolder or by right clicking over the right pane of the dialog. On the menu that will show up, choose New Login.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
HI Ruirib,
Thanks a lot... I able to get in... Urahahahah
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
miekp
Starting Member
6 Posts |
Posted - 10 June 2002 : 14:51:05
|
I still have not gotten this to work :-( I have been sick the past week, and finally got a chance to try some of the new stuff, still nothing. I was able to test connect with the .udl file. But when I copied the code, it wont work.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 10 June 2002 : 17:00:34
|
That stefan user - is it associated with a login configured to use SQL Server Authentication?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 10 June 2002 : 19:00:08
|
If you use a .udl file to create a string, you MUST do it on the webserver. The string won't work if you create the .udl file on your workstation (unless it's the webserver too).
======
Doug G
====== |
|
|
|
miekp
Starting Member
6 Posts |
Posted - 11 June 2002 : 11:23:41
|
I used the SA user account, I am able to get the the snitz logon screen now. Yeah! But when I put in the admin/ admin. I get a whole new error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_MEMBERS'.
/forum2/setup_login.asp, line 80
I can post this new error under a new topic, to keep it organized, let me know.
Mike
|
|
|
|
Topic |
|
Topic Locked
.