You are Here: Home > ASP.NET Home > Asp.net Questions > SQL Server Express connection string, without \"Server=\" ?
|Subscribe to Question|
SQL Server Express connection string, without "Server=" ?With venerable old Access, it was possible to make a DNS-less connection string by pointing to the MDB file. As long as the file was in the expected location within my ASP.NET site, all was well.
Is this possible as well with SQL Server Express?
I'm thinking not, because the only connection strings I can conjure up that connect to it either need:
- User Instance=True (which causes all sorts of file-creation activity in the c:Documents and Settings
- User ID=MyName;Password=pwd; (which free-standing SQL Server Express files don't seem to understand, as login credentials are usually handled at the "server" level...and I'm trying to use SSE without a SQL Server installation)
If any of this doesn't make sense, first, I'm not surprised. Second, please ask me to elaborate.
Nov 11, 2007 - tkc