Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramone_johnny
Starting Member
35 Posts |
 Posted - 2003-11-02 : 21:49:31
|
| Hi guys,Could someone please offer assistance in the areas of securing my database. Im completely new at this...How do I set a username and password to my SQL server database and what is the correct syntax for assigning a connection string within my asp web based application.Thanks guys,Regards,JohnComplete newbie. Please forgive me for having to ask such stupid questions... |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-11-02 : 22:12:36
|
| Hi thereThis is what you want :http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServerDamian |
 |
|
|
ramone_johnny
Starting Member
35 Posts |
Posted - 2003-11-02 : 22:52:08
|
Thanks Merkin!I actually tried this the other day but didnt have any luck...obviously I had something wrong? But not sure what. Ill print this off and give it another shot tonight.PS. "Funky drop bear"....ever heard of the "R" beetles and hoop snakes? Complete newbie. Please forgive me for having to ask such stupid questions... |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-11-02 : 23:06:16
|
OK, try this :Provider=SQLOLEDB; Data Source=MyServerName; Initial Catalog=MyDatabaseName; User ID=MyUserName; Password=NotBlankand yes, you gotta watch for the hoop snakes  Damian |
|
|
|
ramone_johnny
Starting Member
35 Posts |
Posted - 2003-11-02 : 23:15:08
|
| Ok then Im assuming it would be something like this...?Provider=SQLOLEDB; Data Source=RAMONE; (thats the name of my box)Initial Catalog=calendar.mdb;(do I have to put the whole path in here or just the filename????) Actually looking at that now, its probably not even an *.mdb file is it??? Derrrr...or is it?User ID=MyUserName; Password=NotBlankWhere do you actually assign the username and password within sql server? Ive only had a quick look but didnt see anything? Also, is it ok to simply hold the username and password within the connection string like that? Does this allow anonymous web connections as well?Regards,JohnComplete newbie. Please forgive me for having to ask such stupid questions... |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-11-02 : 23:34:42
|
| It's not an MDB file, if you look in enterprise manager you will see each database has a name. That is what you want to use. SQL Server isn't file based like access, it's service based. When you retrieve data from it, you aren't reading a file, you are streaming the data from the server.In Enterprise Manager, look under the Security tab to set up new logins.Also, start reading through Books Online (the included help app). It has lots of info about security and logins.Damian |
|
|
|
ramone_johnny
Starting Member
35 Posts |
Posted - 2003-11-03 : 00:42:04
|
| Thanks again Damian...You're right. I need to get myself a book on SQL server. Thanks for your time,Regards,JohnComplete newbie. Please forgive me for having to ask such stupid questions... |
|
|
|
|
|
|
|
|
Connection string / Securing the database