Don't try this at home ...
-
I had nothing better to do today so decide to install SQL Server 2008 Express for some testing etc. (This download[^]) The installation goes fairly straightforward. I start a new Visual Studio project to test it, create a new SMO Server object, trying to enumerate the databases on the server, and of course it doesn't work. I check all the usual stuff, enable everything in Configuration Manager, the firewall, etc. (all this time I am succesfully connected with SSMS) After a ton of googling I stumble upon this.[^]. Of course, it had to happen to me - the thing installed itself as an instance named SQLEXPRESS although I distinctly remember selecting a default instance installation. So I use the name and succesfully connect using SMO. Ok, so far so good. The next thing I try is to use sqlcmd, but of course that fails even though i specify the correct instance name, saying that SQL Native Client is not installed correctly. I check and it is installed so I do another google session but nothing turns up. I end up downloading it from here.[^]. I repair the installation, uninstall, install it again, unregister the dll, register it again and nothing helps.Having tried everything else, i finally try to run the bcp utility and bingo! it complains about a missing dll. Only it is not the Sql Server 2008 Native Client dll that I have installed, it misses the Sql Server 2005 Native Client. That one is also available as a separate download which I found here.[
-
I had nothing better to do today so decide to install SQL Server 2008 Express for some testing etc. (This download[^]) The installation goes fairly straightforward. I start a new Visual Studio project to test it, create a new SMO Server object, trying to enumerate the databases on the server, and of course it doesn't work. I check all the usual stuff, enable everything in Configuration Manager, the firewall, etc. (all this time I am succesfully connected with SSMS) After a ton of googling I stumble upon this.[^]. Of course, it had to happen to me - the thing installed itself as an instance named SQLEXPRESS although I distinctly remember selecting a default instance installation. So I use the name and succesfully connect using SMO. Ok, so far so good. The next thing I try is to use sqlcmd, but of course that fails even though i specify the correct instance name, saying that SQL Native Client is not installed correctly. I check and it is installed so I do another google session but nothing turns up. I end up downloading it from here.[^]. I repair the installation, uninstall, install it again, unregister the dll, register it again and nothing helps.Having tried everything else, i finally try to run the bcp utility and bingo! it complains about a missing dll. Only it is not the Sql Server 2008 Native Client dll that I have installed, it misses the Sql Server 2005 Native Client. That one is also available as a separate download which I found here.[
Yeah I had some fun with SQLExpress 2008 yesterday. I wanted to set up IIS 6 (easy) with php (easy) and then use SQLExpress2008 as the db. Setup seemed to be a hundred pages long.... I used microsoft's tool for creating the database- but it isn't very good for adding viewing deleting data. So I downloaded SQL Maestro and the MS version (i forget the name). Setup a connection in both programs host = local user = root user password = root password Fails. So tried windows authentication. Fails. Documentation was useless in all 3 programs for this issue. Had to fix a bug in the install to do with a samples folder as well. Doesn't really seem like a finished product to me. Especially when I use a XAMPP environment on a regular basis. PHPMyAdmin is a fantastic tool. I can't even get the mssqle 2008 equivalent to log in. Sorry, just felt like a rant. Hopefully, I'm finished with the worst of it though.
-
I had nothing better to do today so decide to install SQL Server 2008 Express for some testing etc. (This download[^]) The installation goes fairly straightforward. I start a new Visual Studio project to test it, create a new SMO Server object, trying to enumerate the databases on the server, and of course it doesn't work. I check all the usual stuff, enable everything in Configuration Manager, the firewall, etc. (all this time I am succesfully connected with SSMS) After a ton of googling I stumble upon this.[^]. Of course, it had to happen to me - the thing installed itself as an instance named SQLEXPRESS although I distinctly remember selecting a default instance installation. So I use the name and succesfully connect using SMO. Ok, so far so good. The next thing I try is to use sqlcmd, but of course that fails even though i specify the correct instance name, saying that SQL Native Client is not installed correctly. I check and it is installed so I do another google session but nothing turns up. I end up downloading it from here.[^]. I repair the installation, uninstall, install it again, unregister the dll, register it again and nothing helps.Having tried everything else, i finally try to run the bcp utility and bingo! it complains about a missing dll. Only it is not the Sql Server 2008 Native Client dll that I have installed, it misses the Sql Server 2005 Native Client. That one is also available as a separate download which I found here.[
I installed SQL Server 2008 Express a few times last year, and found several unexpected things such as that, also that if VS 2008 is on the system it must have SP1. When I was done I sent an email to some colleagues warning them, but I didn't think it was worthy of an article.
-
I had nothing better to do today so decide to install SQL Server 2008 Express for some testing etc. (This download[^]) The installation goes fairly straightforward. I start a new Visual Studio project to test it, create a new SMO Server object, trying to enumerate the databases on the server, and of course it doesn't work. I check all the usual stuff, enable everything in Configuration Manager, the firewall, etc. (all this time I am succesfully connected with SSMS) After a ton of googling I stumble upon this.[^]. Of course, it had to happen to me - the thing installed itself as an instance named SQLEXPRESS although I distinctly remember selecting a default instance installation. So I use the name and succesfully connect using SMO. Ok, so far so good. The next thing I try is to use sqlcmd, but of course that fails even though i specify the correct instance name, saying that SQL Native Client is not installed correctly. I check and it is installed so I do another google session but nothing turns up. I end up downloading it from here.[^]. I repair the installation, uninstall, install it again, unregister the dll, register it again and nothing helps.Having tried everything else, i finally try to run the bcp utility and bingo! it complains about a missing dll. Only it is not the Sql Server 2008 Native Client dll that I have installed, it misses the Sql Server 2005 Native Client. That one is also available as a separate download which I found here.[
-
Yeah I had some fun with SQLExpress 2008 yesterday. I wanted to set up IIS 6 (easy) with php (easy) and then use SQLExpress2008 as the db. Setup seemed to be a hundred pages long.... I used microsoft's tool for creating the database- but it isn't very good for adding viewing deleting data. So I downloaded SQL Maestro and the MS version (i forget the name). Setup a connection in both programs host = local user = root user password = root password Fails. So tried windows authentication. Fails. Documentation was useless in all 3 programs for this issue. Had to fix a bug in the install to do with a samples folder as well. Doesn't really seem like a finished product to me. Especially when I use a XAMPP environment on a regular basis. PHPMyAdmin is a fantastic tool. I can't even get the mssqle 2008 equivalent to log in. Sorry, just felt like a rant. Hopefully, I'm finished with the worst of it though.
Try pouring soda on the 'H' key. At this point it couldn't hurt. :)
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
-
I installed SQL Server 2008 Express a few times last year, and found several unexpected things such as that, also that if VS 2008 is on the system it must have SP1. When I was done I sent an email to some colleagues warning them, but I didn't think it was worthy of an article.
PIEBALDconsult wrote:
if VS 2008 is on the system it must have SP1
Yes, I forgot that one - at least they did say that it had "tight integration with Visual Studio 2008 with SP1" :) .
Ko seje so, nicu mu skakavci.