SQL Server Connection String - Hide Password From Other Developers

Jun 1, 2010

We're migrating one of our sites to ASP.Net. We do not want to use integrated security, which uses the windows account to connect to sql server (not going to get into why, its just out of the question). We created a username and password to connect to SQL Server, and would like to use that username and password, however, we also do not want other developers to see this information (easily read from the web.config).... I know it can be encrypted, but it can just as easily be decrypted by the developers - plus encryption has a performance hit.

View 5 Replies


Similar Messages:

Windows Authentication To SQL With AD Username And Password In Connection String?

Jul 29, 2010

I'm writing an ASP.Net MVC intranet application which is accessed via handhelds and a range of browsers. My users all have AD accounts and have different permission to our SQL database views/procs depending on who they area. The database also uses CURRENT_USER for horizontal partitioning.

Because of the range of devices that need to access the application I can't rely on impersonation/delegation or the trusted subsystem. I want the user to simply input username and password (same as AD) when the above mechanisms fail.

Does anyone know how I can use AD username and password in a connection string to access the database without creating a set of SQL mirror accounts? I can't login with network service or a sql proxy account because the database needs to be user aware.

View 1 Replies

Databases :: Oracle - Connection String Without Username And Password?

May 10, 2010

I am connecting to Oracle database from .net using OLEDB.

My Connection string :

[Code]....

I am using above ConnectionString to communicate with database. To make it work, I have to store password (don't want to do that) in session and use it every time I need to talk to db.

1) Is there any other connection string without username and password with oledb?

2) I use "Integrated Security" for MSSQL. How can I use the same with OLEDB - Oracle database?

string sConnectionString = "Provider=OraOLEDB.Oracle;"

View 2 Replies

C# - How To Include Ampersand In Connection String Password After Using Entity Framework

Sep 29, 2010

I'm using Entity Framework 4 for a simple app and would like to bake my connection credentials into the following connection string:

<connectionStrings>
<add name="MyEntities"
connectionString="metadata=res://*/MyDataModel.csdl|res://*/MyDataModel.ssdl|res://*/MyDataModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=localhostDEV;Initial Catalog=MyDB;UserId=myUser;Password=jack&jill;MultipleActiveResultSets=True""
providerName="System.Data.EntityClient" />
</connectionStrings>

However, the password (which I cannot change) contains an ampersand. ASP.NET throws:
Configuration Error: An error occurred while parsing EntityName. Line XX, position YYY.

If I replace the ampersand in the password with &, I get a SqlException: Login failed for user 'myUser'. Usually this trick works, but I'm guessing that something is failing because this is technically a connection string inside a connection string.

What should I do here? Most of my classes include code like:

using (var context = new MyEntities()) {
// do work
}

Update: It turns out that the credentials I am using are a domain account, so what I really need is Integrated Security=True in the connection string rather than a password.

Encoding the ampersand as indicated in the accepted answer should work fine, though I haven't tested it.

View 3 Replies

Security :: Add A Connection String By Using A Window Authentication With The Username And Password?

Jan 3, 2011

In the web.config, how do add a connection string by using a window authentication with the username and password? I have tried like this and it keeps ignoring the username and password

<connectionStrings>
<clear/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Integrated Security=SSPI;Initial Catalog=ufiledb;Data Source=MyServer;User Id=user1;Password=xxxxxx" providerName="System.Data.SqlClient"/>
</connectionStrings>

View 2 Replies

Configuration :: Give Password In Connection String For Ms Access Database In Configuration File?

May 2, 2010

I have an ms access db file and now i want to use it in my app. i have given like

Provider=MSDASQL.1;Password=pwd123;Persist Security Info=True;User ID=swgp;Data Source=SWGP;Initial Catalog=C:swgp BJswgp

but it is giving error to me.If anybody know how to give this connection string for password enabled ms access database,

View 2 Replies

Provider Connection String Of Entity Framework Be Substituted With A DB Connection String Already Defined In Web.config?

Feb 2, 2011

I have a db connection string 'ApplicationServices' defined in the connectionString section of web.config and 3 Entity Framework connection strings which have the provider connection string attribute with the same connection string as the one in 'ApplicationServices'. Is there a way to reference connectionString in 'ApplicationServices' for the provider connection string attribute of the EF connection string in the web.config, rather than providing the connection string all over again?

View 1 Replies

SQL Server Connection String?

Mar 10, 2011

total noob question here. I'm toying around with Silverlight, and need to connect to a database. When I connect in server explorer (VS 2010) it works fine, because it's using my windows account to authenticate. However, when I start debugging the server side stuff is running on a different account (NT-SERVICE or something to that effect) which has no privileges on the SQL server. I've tried embedding my username/password like this:

connectionString="Data Source=.;Initial Catalog={DATABASE};Integrated Security=True;User={DOMAIN}{USERNAME};Password={redacted}"

but it doesn't seem to be working. I keep getting an error:The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.

View 2 Replies

C# - Changing A SQL Server Connection String In App

Mar 9, 2011

I'm a web developer and I work primarily in Django -- I've never used ASP.Net or anything like that before, but I'm troubleshooting a problem for a friend's parents / client so I need some advice!

It's pretty simple: I need to change the parameters of their SQL Server database connection because of some server upgrades that happened at their hosting company -- is it ok for me to go in and just edit a .cs file, or does it need to be compiled or some other business?

Literally just need to change the parameters of

mySqlConn = new SqlConnection("server=hostname;database=dbname;uid=username;pwd=password;");

View 5 Replies

How To Create A SQL Server 2005 Connection String

Jan 20, 2011

How to create a SQL Server 2005 connection string .... if my site path on server is

[URL]

View 1 Replies

SQL Server :: Connection String For Plesk Panel?

Oct 23, 2010

I am new for web hosting.My hosting provider use plesk panel for manage websites.I have created MS SQL database using plesk panel. but every time I am getting error when trying to connect ro database. I am using the following connection string.

<add name="ACN" connectionString="Data Source=209.59.179.205SQLEXPRESS;Initial Catalog=ACN;User ID=xxxxx;Password=xxxxxx" providerName="System.Data.SqlClient" />

U can check error detail by just clicking on Login button on [URL]

View 2 Replies

SQL Server :: Connection String In Config File?

Aug 6, 2010

I am having trouble connecting to a ms sql database on the server. The hosting company said that the .sql file was imported successfully, but when I try to use the 'login' or 'create account' features im getting an error page saying:

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. make sure the user has a local user profile on the computer. The connection will be closed.

I am sure all the connection info is correct so it is really frustrating trying to work the problem. I have listed the connection string in my web.config file to see if anyone can see anything wrong with it.

View 4 Replies

SQL Server :: Connection String To Connect With 2008?

Sep 23, 2010

be it's a wrong place to ask the following question. Sorry for that. Our hosting provider has recently upgraded their database server from Sql Server 2005 to 2008 and I'm getting errors to connect with remote server from my development machine. Error Message "Invalid connection". Tried to find solution on net but couldn't find it.I'm using .Net 1.1. Though we've updated versions 2.0,3.5 & 4.0 but due to some certain circumstances I've no way to update it. It's a web based project. The following connection string works fine for Sql Server 2000 & 2005 but not for 2008.<add key="ConnectionString" value="Data Source=Remote Server's domain name;Initial Catalog=database name;User ID=user name;Password=surround;Persist Security Info=True;Pooling=false;Connect Timeout=45;" />Here Remote Server's domain name indicates to remote db server like: test.mysite4now.comdatabase name for example: test_surrounduser name like test_surroundpassword: surround.Can anyone inform me what's wrong with the above connection string to connect to Sql Server 2008.

View 9 Replies

SQL Server :: Connection String For Systemdatabases For 2005?

Jan 14, 2011

in my project i am connected to sqlserver.i have created some jobs in sqlserver 2005. there are some stored procedures(sp) present in Ststem Databases->msdb->programmability->storedprocedures->System Stored Procedures.we can use these sp to create or edit the jobs through code(c#).want the connection string to access these sp's.can any one help me.

View 1 Replies

SQL Server :: Connection String For Sql Server 2005?

Jul 15, 2010

I have some windows application with database. Now I want to make a server.

Like one pc will host MS SQL server 2005 and other pc can access that database. How can I do this?

and what will be the connection string for this. and mind it, its for windows application developped by C#.net

View 5 Replies

Web Forms :: Give A Client Side Validation All The Function Work,but In Confirm Password Its Not Hide Wen Give A Correct Password?

Jun 16, 2010

I have create a masterpage and add content page include user (firsname,lastname,password,new password,confirm new password adn etc..)detail update field. i try to give a client side validation all the function work,but in confirm password its not hide wen give a correct password.. anybody give correct solution..code are below..

[Code]....

View 2 Replies

The Number Of Developers Vs PHP Developers?

Aug 19, 2010

A client has approached me requesting that I quote to build a project in .NET. One of their reasons for this is because it's easier to find a .NET developer than it is a PHP developer.I've tried searching google, but I can't find any stats on this. I suspect that there are more PHP developers, then .NET, I certainly don't know any .NET developers, but know a few PHP developers.Does anyone have a link to any stats which should how many developers their are for each path?

View 2 Replies

SQL Server :: Accessing Database Without Using Connection String In Web.config

Aug 2, 2010

To give some background details, I have created a website for a friend that has a few pages that require a database in the background. I've used Visual Studio templates for most of it, so there's the standard ASPNETDB.MDF file that's created for users and groups, a login page and a page to view and manage those users etc etc. The login page uses the standard controls for logging in, retrieving lost passwords and so on. Being standard controls, by default they get the connection string from the web.config file. Upon attempting to upload the site to my host (1and1.co.uk in case anyone else has any dealings with them) I discovered that storing the connectionstring doesn't work. 1and1 support say that the sql databases can only be accessed using scripts like this (this is an example of theirs):

<html>
<title>Queries from the MS-SQL database with ASP</title>
<body bgcolor="FFFFFF">
<h2>Query from table <b>products</b> with ASP</h2>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=mssqxxx.1and1.com;UID=dboxxxxxxxxx;PWD=xxxxxxxx;DATABASE=dbxxxxxxxxx"
'This code block will create a recordset
Set rs = Server.CreateObject("ADODB.Recordset")
SQL = "select * from products"
rs.open SQL, conn
'will iterate to display the records got from the database
While Not rs.EOF
&nbsp; response.write(rs("id") & " " & rs("price"))
&nbsp; rs.MoveNext
Wend
'closes the connection
rs.close
conn.close
Set rs = Nothing
Set conn = Nothing
%>
</body>
</html>

So my question, is it possible to get the standard asp.net controls to access a database through a script like this?

View 8 Replies

SQL Server Express 2008 Using (local) In Connection String

May 18, 2010

Is it possible to connect to a SQL Server Express 2008 database in ASP.NET with a server name of (local) like "server=(local);integrated security=SSPI;database=DBNAME"? I'm working with another developer on a project and it's getting annoying having to have 2 different version of web.config because he is using SQL Server 2008 and (local) works, but I can't seem to get it to work with SQL Server 2008 Express locally. The database is located on the same computer as the .NET code in case that matters.

View 2 Replies

SQL Server :: Connection String For Sql 2008 Express R2 And Publishing?

Sep 17, 2010

I am currently working on a project and I am hosting it on my IIS to test it every so often but now i have an issue:

When i run in debug mode with this connection string:

Data Source=.;AttachDbFilename=c:New folderdbname.mdf;Database=dbname;Trusted_Connection=Yes;

everything works fine and i can access the database but once its published onto my iis it doesnt find the database?

View 5 Replies

Configuration :: SQL Server 2008 - Can't Get Connection String Right After Many Attempts

Mar 8, 2011

I have a new server that I am attempting to deply my very first asp.net website on. I have installed SQL 2008 r2 and loaded my DB on it. I am able to access the server/DB through Visual Stuidio. At least I know i can call it from the webserver to my local PC.

For some reason I just cant get my we.config's connection strong right. It might even be the <provider> info that I have wrong. I am just too inexperienced to know for sure. My Web.Config is very short so I will post all of it here.

-- Code is posted at the end --

How do I modify my local project to use my webservers DB instead of the standard SQL Express DB? The only connection string

Machine.Config that points to the sqlexpress database. Again I lack the experience to know how to do this. I am using Visual Studio 2010 and SQL Server 2008 r2 on my local pc.

[Code]....

View 3 Replies

SQL Server :: Unrecognized Escape Sequence In Connection String?

Sep 25, 2010

In my program, I want to make database connectivity, but when i write a connection string, complier says that it is unrecognized escape sequence(which is bolded in the following string), the string is :

Data Source=HIMANSHUSQLEXPRESS;Initial Catalog=Himanshu;Integrated Security=True

View 3 Replies

SQL Server :: Connection String Pointing To A Database On A Different Network?

Jan 3, 2011

I have this following requirement.

My Web Application is hosted on Server A. My Database is hosted on Server B.

Server A and Server B are not on same network. How can i point my connection string to the database in this scenario? Can any one give an example for this kind of Connection String?

View 4 Replies

Sql Server - Essential Training Topics For Supervisors Of .NET Developers

Mar 18, 2010

I have a co-worker who supervises a group of ASP.NET developers who are doing lots of ASP.NET/SQL Server apps. My co-worker was very technical at one time, but his last programming assignment was writing Fortran code in the 1980s.

He has asked me to help him gain a deeper knowledge of ASP.NET Web application development to equip him in his supervisory role. I will be spending an hour every other week with him providing training, and he will probably not have a lot of time to commit otherwise.

What would you recommend as topics to cover, tutorial resources, etc. so that I can help him get up to speed in his role as a supervisor of ASP.NET developers?

View 1 Replies

Retrieving Server Name And Database From Connection String For Crystal Report ?

Dec 16, 2010

I am retrieving connection string based on value stored in cookie.NowI am making crystal report. I cannot hard code server credential. I have to get these credential from connection string from web.config. so that i can pass these credentials to my crystal report .

ConnectionInfo reportConnectionInfo = new ConnectionInfo();
reportConnectionInfo.ServerName = connection string server name from web.config
reportConnectionInfo.DatabaseName = connection string database name from web.config
reportConnectionInfo.UserID = ...;
reportConnectionInfo.Password = ...;

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved