| Author |
 Topic  |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 08 July 2002 : 22:25:36
|
quote:
Well I just set security to allow sql server authentication.
I didnt have to set a new user for the database because its the same as before..same login and password as the admin password for my computer with dbowner rights. As for the new login no i havent set one but do u mean from the Users Setup in my control panel on the computer or some way through Enterprise manager.
Any existing users are associated with logins configured to use Windows Authentication, because that is that method that was in place until now. So you cannot just use the same user, it won't work.
First you need to setup a new login. You can do that in Enterprise Manager, click Security, right click logins and choose New login. Make sure that you setup this login to use SQL Server authentication. You can even change the default database associated with this login to your Snitz database.
Then, you need to add a new user to your Snitz database, associated with this login and assign him the dbowner role. Use this user name and the associated login in the page where you are requested the name/password of a user with table creation rights, and you should be able to setup SNitz.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 08 July 2002 22:26:40 |
 |
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 08 July 2002 : 22:32:48
|
u know i was going thru and i just did all that.
now the conn String uses the login and password from the database user right?
still does thte same
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 July 2002 : 22:38:10
|
You need to specify the user name and the login password at the SQL Server setup page (the one where you need to choose between SQL 6 or SQL 7/2000). That's where it matters the most.
If it doesn't work, try to use the sa user and its new password, that you must have changed when you changed the SQL Server authentication settings.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 08 July 2002 : 22:43:28
|
and this sa user name and password should be the same user name and password in the connection string as well as the one that i enter into setup.asp right?
that is what i have been doing...
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 July 2002 : 22:48:36
|
You're obviously making some mistake there. Just don't know which one. I'm stumped.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 July 2002 : 22:58:30
|
How are you connected to the Internet? DSL, cable? Have a fixed IP? I'm asking this cause I could try to use my Enterprise Manager to your SQL Server and find out what's happening. You need to email me your server IP, and your login/password for a user capable of administering your SQL Server...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 09 July 2002 06:35:57 |
|
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 09 July 2002 : 19:38:10
|
i have sent you an email with the info! Thanks and let me know if everything is ok.
|
|
|
|
Topic |
|
Topic Locked
