I bounced around between projects a lot last week. What each project had in common was the need to validate at least one SQL connection. Whether you have SQL tools like SSMS installed or not, this is a very easy task if you are aware of the UDL (Universal Data Link) files. Create a new [...]
Continue reading about Database Connectivity Test with UDL File
Okay. This post isn’t about configuring SQL to allow remote connections, but wait, I still may be able to help you out. "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server [...]
Continue reading about Configure SQL Server to Allow Remote Connections
A new ASP.NET MVC project includes preconfigured Membership, Profile and RoleManager providers right out of the box. Try it yourself – create a ASP.NET MVC application, crack open the web.config file and have a look. First, you’ll find the ApplicationServices database connection: <connectionStrings> <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/> </connectionStrings> Notice the connection [...]
Continue reading about Getting Started with ASP.NET Membership, Profile and RoleManager
IIS7 introduced the option to run your application pool as AppPoolIdentity. With the release of IIS7.5, AppPoolIdentity was promoted to the default option. You see this change if you’re running Windows 7 or Windows Server 2008 R2. On my Windows 7 machine, I’m able to define my Application Pool Identity and then create an associated [...]
Continue reading about Issue Creating SQL Login for AppPoolIdentity on Windows Server 2008
Let’s say you are viewing results in Enterprise Manager or the SQL Server Management Tools and you really want to update a cell will a NULL value. Sure you could script it. Heck, you’re welcome to wrap the one line script in a Transaction and produce a rollback script as well if you’d like. But, [...]
I have installed SQL Server 2008 and SQL Server Management Studio 2008 a number of times and it has always been a snap*..until yesterday. As it turns out, previous installations were always applied to machines (mostly VMs) which weren’t running early versions of the SQL Server and associated tools. Yesterday, I performed my first upgrade [...]
Continue reading about Upgrade to SQL Server 2008 with SQL Server Management Studio (SSMS) 2008
It is easy to see the subtle difference between the Product Tables below. The table to the left adds the table name as a prefix to nearly all of the column names. The table on the right represents very simple column names with no redundancy. Early in my career, I preferred the implementation to the [...]
I very recently posted about using SubSonic to generate my DAL and SSMS Tool Pack to generate the complementing stored procedures. In response to the post, Jon Galloway asked a great question in the comments: Thanks for the pointer to SSMS Tool Packs. It looks really interesting. One thing I’m having trouble picturing is the [...]
Continue reading about Code Generation with Stored Procedures?