Results 1 to 3 of 3

Thread: Adding a SQL Server alias during deployment of VB.Net 2008 project

  1. Aug 29th, 2012, 05:57 AM #1
    InvisibleDuncan
    InvisibleDuncan is offline

    Thread Starter
    Fanatic Member InvisibleDuncan's Avatar
    Join Date
    May 2001
    Location
    Eating jam.
    Posts
    819

    Adding a SQL Server alias during deployment of VB.Net 2008 project

    My VB.Net 2008 project uses a SQL server 2005 database as its back-end. Can I get my installer (a Visual Studio deployment project) to add the alias into the SQL Server Configuration Manager?

    Any advice gratefully received!
    Indecisiveness is the key to flexibility.

    www.mangojacks.com
    Reply With Quote Reply With Quote
  2. Aug 29th, 2012, 07:43 AM #2
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: Adding a SQL Server alias during deployment of VB.Net 2008 project

    You can add a Custom Action to your Setup project and then invoke some VB code that uses WMI to create the alias. I found this example in C# but the VB code would be very similar.

    http://blogs.msdn.com/b/sql_protocol...08/572057.aspx
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  3. Aug 30th, 2012, 04:22 AM #3
    InvisibleDuncan
    InvisibleDuncan is offline

    Thread Starter
    Fanatic Member InvisibleDuncan's Avatar
    Join Date
    May 2001
    Location
    Eating jam.
    Posts
    819

    Re: Adding a SQL Server alias during deployment of VB.Net 2008 project

    Thanks, JM - I'll give that a whirl.
    Indecisiveness is the key to flexibility.

    www.mangojacks.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width