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 |
|
NewFrontier
Starting Member
3 Posts |
 Posted - 2006-10-31 : 11:24:50
|
| Hello All,I was wondering in sql server, is there way to connect to the db without codeing you username and password in a program for a more secure connection.Thanks. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-10-31 : 11:31:56
|
which program?if you're talking about management studio you can connect with your windows account.if you're talking about a .net app you ca store that in trhe config file. in .net 2.0 you can even encrypt it.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
NewFrontier
Starting Member
3 Posts |
Posted - 2006-10-31 : 11:41:01
|
| I am just talking generically. If I have a piece of code with username and password(hardcoded)that connects to SQL Server, like JAVA. Sorry, I am new to Windows, what is .net app. What is a trhe config file? Does .net 2.0 come with encryption or do you have to develope it yourself?Thanks. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-10-31 : 11:46:13
|
| .net is a Microsofts development platform similar to JAVA.config file is an XML file that stores configuration settings for your app.like connection strings, and much more. .net 2.0 comes with enryption.i have no idea about java.Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
alternatives to hard-coding username/password