Connection String To Connect To SQLServer Express?

Feb 22, 2006

Hi

I've been trying to get DotNetNuke to connect to a SQLServer Express database but no luck. I've had no luck with info from their forums...

The connection string I'm supposed to use is:

<add
name="SiteSqlServer"
connectionString="Data Source=.SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" />

I just can't get it to connect to the database. Says something that remote connections are not allowed. I've done the Area thing and allowed all connection including remote connections.

Can't we use the standard string like:

<add
name="SiteSqlServer"
connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"
providerName="System.Data.SqlClient" />

...to connect? I'd like to setup a user and give the username and password in the connection string - real easy and non-complicated...

Any ideas or help?

Andre

View 3 Replies


ADVERTISEMENT

Why Can't I Connect To SQLServer With An Incomplete Conn. String ?

Dec 23, 2004

I found out that I could use SQLDMO to enumerate objects in a SQL server. However, I can't connect to my server, even though I have both "windows and SQL server" authentication on "(local) Windows NT".

Here is the code (it does not contain the validation in this snippet):


Imports System.Data.SqlClient
Imports SQLDMO

Public Class ADO_2
Inherits System.Web.UI.Page
Protected WithEvents txtQuery As System.Web.UI.WebControls.TextBox
Protected WithEvents txtresults As System.Web.UI.WebControls.TextBox
Protected WithEvents lstDB As System.Web.UI.WebControls.DropDownList
Protected WithEvents lblResult As System.Web.UI.WebControls.Label
Protected WithEvents cmdExecute As System.Web.UI.WebControls.Button
Protected WithEvents cmdNext As System.Web.UI.WebControls.Button

Private m_objConn As New SqlConnection()
Private m_objSQLServer As SQLDMO.SQLServer

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

EnumerateDatabases()

'TEMP
lstDB.Items.Add("Northwind")
lstDB.Items.Add("Pubs")
'END TEMP
End Sub

Private Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Unload

m_objConn.Close() 'Just in case.....
End Sub


Private Sub cmdExecute_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExecute.Click

Dim objCommand As SqlCommand
Dim objDataReader As SqlDataReader
Dim intField As Integer

txtresults.Text = String.Empty
m_objConn.ConnectionString = "server=radu;database=" & lstDB.SelectedItem.Text & ";integrated security=SSPI;"
m_objConn.Open()

objCommand = New SqlCommand(txtQuery.Text, m_objConn)
objDataReader = objCommand.ExecuteReader

While objDataReader.Read
txtresults.Text &= vbNewLine
For intField = 0 To objDataReader.FieldCount - 1
txtresults.Text &= objDataReader(intField).ToString.PadRight(15)
Next
End While

objDataReader.Close()
objDataReader = Nothing
objCommand = Nothing
m_objConn.Close()

End Sub

Private Sub EnumerateDatabases()

On Error GoTo EnumerateDatabasesError

Dim objSQLDatabase As SQLDMO.Database

m_objSQLServer = New SQLDMO.SQLServer()
m_objSQLServer.Connect("radu")

'Iterate through all databases on the target server:
For Each objSQLDatabase In m_objSQLServer.Databases
lstDB.Items.Add(objSQLDatabase.Name)
Next objSQLDatabase

EnumerateDatabasesExit:
objSQLDatabase = Nothing
m_objSQLServer.Close()
m_objSQLServer = Nothing
Exit Sub

EnumerateDatabasesError:
lblResult.Text = Err.Number.ToString & ", " & Err.Description
Resume EnumerateDatabasesExit
End Sub
End Class


Why can't I connect with m_objSQLServer.Connect("radu") ? I also tried m_objSQLServer.Connect("radu", "", ""). Otherwise, I can connect just fine with m_objConn.Open() (after I select a db from the dropdownlist, which is for now populated by hand)....

Thanks a lot for your time.

Alex.

View 1 Replies View Related

Sqlserver Connection String

Mar 6, 2007

I have to supply a sqlserver connection string in the format:

ip address:port, how do i go about finding out what the port number is on the sqlserver server ??? This is for an R25 collegent interface connection, if that helps .

View 3 Replies View Related

Connection String For MS SQLServer 2000

Aug 31, 2005

For nearly 6 wks I have been trying to workout with GoDaddy.com a connection string that will connect to the SQL Server 2000 from my ASP.Net web application.  In my programming, I have placed the connection string in the web.config file and then call it from there within code behind using the SQLConnection object.  My web.config entry has the following form:
<appSettings>
<add key="Conn" value="server=GoDaddyserver;integrated security=SSPI;database=databaseonGoDaddyserver;" />
</appSettings>I have also written the key supplying the UID and pwd.  Nothing works and their support is of no help.Has anyone else had this difficulty either in general or with GoDaddy in particular?

View 15 Replies View Related

Connection String OLEDB - SqlServer

Jul 23, 2005

I need to conect my software from a remote client to a server, mystandard connection:Provider=SQLOLEDB.1;Persist Security Info=False;UserID=sa;Password=;Initial Catalog=MyDb;DataSource=192.168.0.100;Network=DBMSSOCN;andProvider=SQLOLEDB.1;Persist Security Info=False;UserID=sa;Password=;Initial Catalog=MyDb;DataSource=192.168.0.100;Network=DBNMPNTW;make a error connection,i have tryed with ODBC connection and its OK only in Named Piped.Can any one help me write the right connection string?thanksrm

View 2 Replies View Related

How Can I Connect To Sqlserver Express Manually When I Use Text Boxed

Feb 27, 2006

hi guys,
i am very happy that i found this forum which discuss ASP.net.i am new to ASP.net 2.0 and some need serious help. when i debug my application and try to insert data an error occur saying:"Cannot open database "ecb" requested by the login. The login failed. Login failed for user 'HOME-USERuser'."the code that i have used to submit data is as follow:Imports System.Data.SqlClient...  Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click      Dim objConn As SqlConnection      Dim objCmd As SqlCommand
objconn = New SqlConnection("data source= localhostsqlexpress; initial catalog =ecb; persist security info =true; trusted_connection=true")
objCmd = New SqlCommand("INSERT INTO staff (firstname, surname) VALUES (@firstname, @surname,)", objConn)objCmd.Parameters.Add("@FirstName", Data.SqlDbType.VarChar).Value = txtFirstName.TextobjCmd.Parameters.Add("@Surname", Data.SqlDbType.VarChar).Value = txtSurname.TextobjConn.Open()objCmd.ExecuteNonQuery()objConn.Close()
i also used this data connection but didn't help: objconn = New SqlConnection("Server=localhost; Database=ecb;user ID='  ';Password='  ' ") when i use this data
connection i get this message: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
as far as i can remember i have used windows authentication when creating my database in sql server 200 express edition.
the funny thing is that when i use datagrid wizard or dataform the connection is fine ( i mean is automatically done for me but i don't know when i like to do it manually does not work).can anyone help? thank you in advanced

View 5 Replies View Related

SqlServer Connection String For JDBC When Using Named Pipe

Apr 27, 2008

Hi!

I'm writing a java application that queries sqlserver 2005 (and 2000). In case the sql browser service is stopped I need to use the named pipe property or the port property, right?
But how could the program know at runtime what is the port and what is the pipe name? And how should a connection string to sqlserver 2005 (and 2000) that includes named pipe, look like?

Thanks!

View 4 Replies View Related

How Do You Connect To Networked SqlServer 2005 Express Using The Add New Data Source Wizard

Sep 7, 2006

Hi All,

I want to connect to SQLExpress database on the network. I can do so using code but I want to use the Data Source Configuration Wizard. It seems this only works for local instances of SQL server. Is this true?

I can connect just fine to the database on the network using Microsoft SQL Server Management Studio Express...for what this is worth.

I have tried to map a drive to the SQL server machine and pick the mdf file but I get the error msg of network path is not supported for database files....I have turned on allow remote connections, allow tcp/ip, named pipes, added sqlserv.exe and sqlbrowser.exe to my firewall exceptions ect..

I want to be able to use Table Adapters, SqlDataAdapters ect. After reading numerous forum questions/ kb articles this seems to be a common problem. I am on the verge of just saying forget it and use MS Access instead.

Thanks in advance!















View 4 Replies View Related

Facing Problem In Increasing Connection String Pool Size Sqlserver

Mar 4, 2005

Hi to all,

I am using a connection string like

data source=RemoteHostName;initial catalog=myDb;password=sa;user id=sa;
Max pool size = 200;

And now strange thing is happening ,, I am receiving error :

Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were in
use and max pool size was reached

The SqlServer Activity Manager is telling that only 100 connections are pooled, and I guess that the Max pool size is 100, It is not being changed by my Connection string. As I am trying to change the default 100 pool size value to 200.

Huh , So stucked up , how to increase the Max pool size.. Is there any way .

I am getting worrried.

Any help ??

Thx and Regards

View 1 Replies View Related

Connection To SQLServer 2005 Express

Oct 10, 2006

Hi to all GURUS,

I am very (almost two days) new to SQL Server Express (in fact SQL Server). In my old applications I am using VB.Net 2005 Express with MS Access database and now I wants to go for SQL Server Express.

One thing I am unable to find till now is : if SQLServer Express is installed on my Server machine (say ServerPC) with attached database (say MyDB.mdf), how I can access it through ADO.Net 2.0 from client machine. (using VB.Net Express)

Thanks and hope you will encourge me to use SQL Server .

View 1 Replies View Related

Connection String Required To Connect Asp.net And Sql Server 7.0

Nov 15, 2007



Hi
I am new to .net and sql server....i have just installed VS 2005 and sql server7.0...
I am doing my coding in vb.net......so i wanted to know the connection of the datagrid to the db in my sql server 7.0.
Can some one pls help me with this urgently.

View 6 Replies View Related

SQL Express Connection String

Jul 31, 2007

Hello. I have created a website with a local database file. When I had it locally the connection worked just fined. When I put the files on the IIS the site can't find the database anymore. This is the connectionstring that i have locally:
<connectionStrings>
<add name="conn" connectionString="Data Source="GjoniSQLEXPRESS; AttachDBFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataACO.MDF; Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>

View 2 Replies View Related

SQL Express Connection String !!

Mar 14, 2007

Hello everybody
Im writing an application in VB6 (with sp5) and using SQL Express 2005 for database. I need to run this application over the network with clients working on Winxp and Win98 also.

I've used the connection string as

con.connectionstring = "Driver={SQL Server};Server=Factory;Database=Production;Trueste _Connection=yes;"
con.open

This works fine the the host system(where the SQL express is installed) but if i try to run the applicatoin from a network PC, running on Windows 98, Im getting an error
"Login failed for user '' Factory/Guest"

When i Change the connection string to use User id and password of SQL Logins , (The user is set 'Public' as DB Role membership in SQL Express for the Production database)

con.connectionstring = "Driver={SQL Server};Server=Factory;Database=Production;UID = dbUser PWD=Pass;"
con.open

I'm getting an error : The user is not associated with a Trusted SQL Server Connection

How can i resolve this problem,

please suggest some remedy...
thanks in advance...

regards:

View 3 Replies View Related

Sql Express Connection String

Nov 9, 2006

Hai,

We created one application, with deployment. When we install the
application on another machine, it will attach a database in sqlexpress
instance. For eg. c:Programfilesoursoftwarenamekmsdb.mdf.


Now i am having one more webservice running on that machine as
dll(not webservice source code). In this web service i am reading that
database values. But the connection string is giving some error
message.


actually my coding is


sCon = "Server = ./SqlExpress;Database =KMSDB;Integrated Security =
SSPI;"


gsCon = New SqlClient.SqlConnection(sCon)
If gsCon.State = ConnectionState.Closed Then
gsCon.Open()
End If


sQuery = "SELECT KeyCode 'Key Code',Status
'Status',UserCode 'User Code',JobCode 'JobCode' " & _
" FROM KeyHolders"
oDaKeyHolders = New SqlClient.SqlDataAdapter(sQuery, gsCon)
oDaKeyHolders.Fill(oDsKeyHolders)


For this I am getting the error is


"Cannot open database "KmsDb" requested by the login. The login failed.
Login failed for user 'DESIGN-EMB2user'."



Regards,
Raju

View 3 Replies View Related

SQL Express Connection String.

Mar 22, 2007

Hi all

Is there any article out there that explains why we nedd to put "SQLExpress" in the connection string for SQLExpress db. ( need to show by boss why ) ..

View 1 Replies View Related

Connection String For Express

Jul 3, 2007

Hi,



I'm trying to set up a connection string to a simple SQL Express database file

but I keep getting an error.



I copied this string from the Database object in the Database explorer. I changed the slashes to forward slashes to get rid of the escape sequence issue & changed the timeout & Integrated seccurity but apart from that it's the same.



The file is in the same directort as the Solution so I guess you can say it's Local.



Any ideas on a correct conenction string would be most appreciated



Thanks very much in advance



Ant






Code Snippet

string conString = "Data Source=./SQLEXPRESS;"
+ "AttachDbFilename="
+ "'C:/Documents and Settings/aklune/My Documents/Visual Studio 2005/Projects/WindowsApplication1/WindowsApplication1/test.mdf';"
+"Integrated Security=True;"
+ "Connect Timeout=10;"
+"User Instance=True;";

SqlConnection con = new SqlConnection(conString);


con.Open();

con.Close();





View 6 Replies View Related

Need Help With Connection String In C# And SQL Server Express

Apr 28, 2007

 
 I am using SQL server express 2005. I can drag and drop a grid control on to my web form and choose the data source to point to a SQL server database. Then datais nicely displayed on my web form.
Now I need to manually create my connection to the database as I need to read from a text file and then populatea database table with those values I read from the text file. I have not had any success with this though and I am stuck and need some help.
Below is my C# code and I list the web.config code where my connection string is stored.
Note that I can trace into the C# line of code below. If I then do a "Quick Watch" on "myConnection" in the debugger, the followingerror message is displayed:
ServerVersion 'myConnection.ServerVersion' threw an exception of type 'System.InvalidOperationException'          string {System.InvalidOperationException}
So I don't know what the problem is here. If someone can help me out I would be forever thankfull
 
 C# code:
    SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["TheDividerConnectionString"]);
 
 Here is the connection string as defined in the web.config file:
 <connectionStrings>  <add name="TheDividerConnectionString" connectionString="Data Source=BVCOMPUTERSQLEXPRESS;Initial Catalog=TheDivider;Integrated Security=True"   providerName="System.Data.SqlClient" /> </connectionStrings>
 
 

View 3 Replies View Related

Connection String To SQL Express On Another Computer

Jun 28, 2007

I have an XP Pro machine running a classic ASP site in IIS - the version that comes on the XP Pro CD.  The site makes a connection to an MSDE database on the same machine named InControl.  I have moved that database to SQL Express 2005 and want to test it with the ASP site.  SQL Express 2005 is running on a separate Vista machine.  I am currently using this connection string:
objConn.ConnectionString = "Provider=SQLOLEDB;Data Source=400SC;Initial Catalog=InControl;User ID=" & uid & ";Password=" & upass & ""
Where 400SC is the name of the XP Pro machine and InControl is the database.  The variables uid and upass are pulled from Session when the connection string is created.
I have tried different Provider names and various combinations of server name and ip address with and without port numbers for the Data Source.  All of them yield some variation of this error:
 Microsoft OLE DB Provider for SQL Server (0x80004005)[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. 
What should the connection string look like?
 Thanks for the help.
PS - If the solution involves a port, do I need to make that port an exception in the Vista Firewall?

View 4 Replies View Related

SQL Server Express Connection String

Aug 18, 2007

I'm trying really hard to set this website up so that I can have a web layer... bll, and dal. But I can't figure out the connection string in the config file. Can someone take a look? <connectionStrings>        <add name="SearchConnectionString" connectionString="Data Source=AURORASQLEXPRESS;Initial Catalog=Search;"/>        <add name="SearchEngine.DAL.Properties.Settings.SearchConnectionString" connectionString="Data Source=AURORASQLEXPRESS;Initial Catalog=Search;" providerName="System.Data.SqlClient"/></connectionStrings>

View 3 Replies View Related

Problems Ith Connection String To SQL Express

May 25, 2006

My application is usning traditional connection string:
<add key="DbConnection" value="driver={SQL Native Driver}; provider=SQLNCLI;server=localhost;trusted_connection=yes;database=ebay" />
It works fine with database attached to SQL Server, how do I make this working with SQL Express attachable file in data directory?

View 1 Replies View Related

SQL EXPRESS 2005 Connection String

Dec 25, 2006

I try to use this conn string but it is not working I think the problem is with the provider
DataBaseSource = "Provider=SQLOLEDB; Password=sa2006; User ID=sa;Initial Catalog=coupon; Data Source=YAELSQLEXPRESS;"
I get error message
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

do you know which provider can I use?
or maybe it is a sacurity problem

Yael

View 1 Replies View Related

ASP - Connection String With SQL Server Express

Feb 1, 2008

Hello,

I'm working with classic ASP and am having a terrible time trying to get a proper connection string working with my database. Could someone please advise me on how to get the following code to connect to my database (which is using Windows Authentication)?

If fileSize > 0 Then
' Connection string
Dim connStr
connStr = "Provider=SQLNCLI;Server=Dell-LaptopSQLEXPRESS;Database=Upload;Trusted_Connection=yes;"
' Recordset object
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Files", connStr, 2, 2

Right now the error I'm receiving is:
"SQL Network Interfaces: Error Locating Server/Instance Specified

Also, I'm using II7 with Vista.
Thanks,

Trix.

View 9 Replies View Related

Access To SQL Express Connection String

Jun 1, 2007

I need to hardcode my TCP port to a SQL Server Express named instance. You guys have any examples I could see. I keep getting an error when I try to connect:



Run-time error 2147467259 BBNETLIB connection open parse connection paramaters, invalid connection. I'm trying to connect to a local instance on a Windows 2003 server.

View 3 Replies View Related

SQL Express Connection String (via Visual Web Developer) .. Asp.net V2.0

Apr 20, 2007

View 5 Replies View Related

Connection String For Sql Server 2005 Express

Jan 10, 2008

does anyone kbnow the connection string used to connect to the database in sql server 2005 express?
can someone one give me sample codes for it? thanks.


thanks

View 1 Replies View Related

Sql Server Express Connection String And Login

Mar 12, 2007

Hi there

I'm trying to connect to sqlserver express using dreamweaver mx. TYhey are both installed on the same machine (win 2000 server),

What I am confused about is the user and password, I have installed the example Northwind database and attempting to connect to it.

In dreamweaver I add a connection (SQL Server connection) , a template shows and I add the data:

Persist Security = false;
Data Source =mycomputersqlexpress;
Initial Catalog = Northwind;
User ID = ?
Password = ?

What do I put in the User ID, Password and how do I configure sqlserver (I'm using Server Management Studio).. As I said I already have Northwind under the database section? but don't know how to set permissions.. Thanks

View 2 Replies View Related

Connection String In The SQL Server Management Studio Express

Jan 3, 2007

i want to change the database from access to SQL Server Management Studio Express
the old connection string in the asp is <% Set strConn = Server.CreateObject("Adodb.Connection") Provider="provider=microsoft.jet.oledb.4.0;" dbpath="data source=" & Server.MapPath("../data.mdb") Pwd = ";jet oledb:database password=dolunlimit" strConn.open provider & dbpath & Pwd%>
i have write the new connection in the SQL server, but it can not work
<%Set conn=CreateObject ("adodb.connection")strConn="driver={SQL Server};server=192.168.0.102;uid=sa;Pwd=sa;database=sadb" conn.open strConnSet rs=CreateObject("adodb.recordset")%>
can someone tell me what wrong of my coding

View 1 Replies View Related

Connection String To SQL Server 2005 Express Database

Apr 10, 2008

Hi, all. I am using VS.NET 2005 and SQL Server 2005 Express. I tried to use the following code to connect to a database named "AMSPROD" that I attached to SQL Server 2005 Express:
 dbConn = new OleDbConnection(Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAMSPROD_Data.MDF";Integrated Security=True;Connect Timeout=30;User Instance=True);
dbConn.Open();
I got an error asking for provider with the above connection string, then I changed the conncection string to be like follows:
Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAMSPROD_Data.MDF";Provider=SQLNCLI;Integrated Security=True;Connect Timeout=30;User Instance=True
I got error: No error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21)
Then I changed the Provider to be like: Provider=SQLOLEDB, now I am getting the following error:
Message: "Invalid authorization specification
Invalid connection string attribute"
Source: "Microsoft SQL Native Client"
StackTrace: " at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at ISESAMSData.DbConnections.MakeConnection() in C:\ISES\ISESCommon\ISESAMSData\DbConnections.cs:line 74"
TargetSite: {Void .ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection)}
Strange thing is, when I use the Connect To Database under Tool menu of VS.NET 2005, I could make the connection to this database. Then I copied this connection string to the code, the connection couln't be made. I feel very confused.
I am wondering if I need to add ASP.NET user to SQLExpress. But I don't know how to do it?
Can anyone please help me out! Many thanks!

View 7 Replies View Related

SQL Server 2005 Express Edition Connection String (dns-less)

Jun 12, 2006

Junifer writes "Hello guys,

Can you give me a simple example of a dns-less connection to SQL Server 2005 Express Edition?



Thanks."

View 1 Replies View Related

SQL Express 2005 Connection String Vs SQL Server (latest)

Oct 28, 2007

I'm a student at Boise State university and we're using SQL Express as part of one of our projects for ASP.NET programming. I liked it and I'm trying to use it to power a wiki that I'll be hosting from my home internet connection. The wiki is compatible with MSSQL server, but it won't connect to SQL Express.

I suspect that the problem is in the connection string, mainly because the apps we're developing for class use a connection string like:
<add name="AspNetForumConnectionString" connectionString="Data Source=localhostsqlexpress;Initial Catalog=gaming.forum.nxnw;User ID=*********;Password=*********;" providerName="System.Data.SqlClient"/>

and note the Data Source. The wiki I'm using is PHP based and uses ADObd to connect databases and has a driver for MSSQL, but not SQL Express (no surprise, really). I know just enough php to be dangerous to code and I've tried modifying the adodb-mssql.inc.php, but I can't seem to make the right change.

So, all that said, my question is: Is there a way to change what SQL Express 2005 will accept as a connection string? I've been looking, but I'm not even sure what the setting would be called.

Thanks,
Les

View 6 Replies View Related

Sql Server Express - Shared Hosting - Connection String - What Do You Guys Do?

Feb 2, 2007

Hey,

I have a asp.net 2.0 app that has a sql server express backend. I have been scratching my head for weeks trying to find a good wasy to encrypt my connection string. I store the string in web.config (which in itself is in theory "safe" because it's not servable) and I have scoured the web to try to find a simple way to encrypt the connection string. Even using user store would require running aspreg_iis.exe on the host with a command prompt (which clearly I cannot do). It seems that everyone's solution requires running a command prompt executable on the server.

So I am left to wonder what everyone else does. I am not comfortable using just the web.config because a determined hacker could get to that info. Then again, a determined hacker could get into any system , I guess. There are no credit card #'s stored in this app, but in theory there must be a way. I run all access to the db through stored procedures with permissions, for whatever it's worth.

Thanks in advance!
David

View 3 Replies View Related

CONNECTION STRING TO A REMOTE SERVER WITH SQL EXPRESS 2005, FIXED IP ADDRESS

Jan 28, 2008



I'M HAVING AN ISSUE, UNDERSTANDING, THE CONNECTION STRING.
I WANT TO CONNECT TO AN INSTANCE OF SQLEXPRESS ON A REMOTE SERVER WITH A FIXED IP ADDRESS
THE TCP PORT IS OPEN TO 1433
I OPENED THE PORT ON THE ROUTER AND THE WINDOWS 2003 FIREWALL

MY CODE IS AS FOLLOWS:
S = "Provider=SQLNCLI;"
S = S & "DATA SOURCE=44.66.777.888,1433SQLEXPRESS;"
S = S & "INITIAL CATALOG=TESTDB;"
S = S & "Persist Security Info=false;"
S = S & "UID=TEST999;"
S = S & "Pwd="TEST999888;"
CnMgt.ConnectionString = S
CnMgt.Open S

I'VE FOLLOWED THE STEPS OUTLINED IN ARTICLE 914277

CAN SOMEONE HELP?
THANK YOU


PS. IF THE CLIENT IS LOCAL, I HAVE NO ISSUE OPENING THE DATABASE.
I DO NEED TO OPEN THE DB FROM FROM CLIENTS.

View 5 Replies View Related

Making SQL 2005 Developer Accept The Connection String For SQL Express Edition

Feb 18, 2007

Hi, I have installed on my laptop SQL server 2005 Developer edition, I can change ANY of the settings of the SQL server and OS.

I am writing code with a team using continuous integration where the connection string is the following:
"Provider=SQLNCLI;Server=.SQLEXPRESS;Database=Secret;Trusted_Connection=Yes;"

is there a way (create an alias,rename server, other?) to make my local dev SQL server accept the connection string above, as at the moment I have to rename the connection string every time before checking in code and after downloading the latest version from the code repository.

any advice or tips will be greatly appreciated

Thanks

JW.

View 1 Replies View Related







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