-2147467259: failed to create SQL databaseAfter days of hacking I finally found the solution! All you need to do is use .\sqlexpress instead of localhost\sqlexpress or 127.0.0.1\sqlexpress in your connection string. I think (and I might be terribly wrong here) when you use .\sqlexpress in connection string installer uses Shared Memory instead of Named Pipes or TCP/IP.
Wednesday, 16 July 2008
Solution to -2147467259: failed to create SQL database
This one haunted my for weeks! I'm using WIX 3.0 as my app installer. During install i create a SQL database and run a SQL script. Everything seemed but on computers SQL Express database creation failed with
Subscribe to:
Post Comments (Atom)
4 comments:
Thank you for a solution, it saved me a lot of time :-)
Thanks for this! In my case I forgot to configure the firewall correctly, so it was going through TCP/IP and not being able to open the connection.
Which translates to "Gibberish number unknown error," apparently.
=)
Almost 10 years on, this still rings true. A Million thanks to you!
Thanks a lot! Life saver!
Post a Comment