Geeks With Blogs
Fred Sobel blog October 2006 Entries
SQLExpess supported at my host
Wow it looks like SQL Server Express is supported! My host had the following on their Knowledge Base. 1) Please make sure you have Initial Catalog=xxxxx in your connection string. You may sometimes receive an error regarding the log file. You can simply rename or remove the old log file, the application will attempt to create a new one. If it doesn't work, please try the following connection string as well: 2) Make sure you grant the folder "app_data" with read/write/execute/modify (or delete) permission ......

Posted On Monday, October 23, 2006 8:27 PM

Connecting to SQL Server Express
Trying to figure out the best way to connect to SQl Server express for VS2005 Web development is quite interesting. You may be able to connect from vs2005 and the new SQL Server Management studio but when it comes time to run your aspx page against a connection you need to do a little extra work. First thing is security. If you are using integrated security the ASPNET account needs access to your database. I found there is more than one way to do this which adds to the confusion. Option 1) Attach ......

Posted On Monday, October 23, 2006 8:18 PM

Copyright © Fred Sobel | Powered by: