Results 1 to 3 of 3

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

  1. #1
    Fanatic Member InvisibleDuncan's Avatar
    Join Date
    May 01
    Location
    Eating jam.
    Posts
    758

    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

  2. #2
    .NUT jmcilhinney's Avatar
    Join Date
    May 05
    Location
    Sydney, Australia
    Posts
    80,847

    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

  3. #3
    Fanatic Member InvisibleDuncan's Avatar
    Join Date
    May 01
    Location
    Eating jam.
    Posts
    758

    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

Posting Permissions

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