Results 1 to 11 of 11

Thread: [RESOLVED] How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSMS

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2010
    Location
    Lake Gaston, NC
    Posts
    453

    Resolved [RESOLVED] How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSMS

    I have Sql Server 2008 Express installed on a Win8 computer that does not have SSMS.

    How do I set "Allow Remote Connections" on this server?
    Last edited by DexterRose; Jul 31st, 2014 at 03:12 PM.

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSM

    Thread moved to the 'Database Development' forum - this question has nothing to do with VB.Net, so does not belong in the VB.Net forum

  3. #3
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSM

    Do you have SURFACE AREA CONFIGURATION tools somewhere in the START/PROGRAMS menu?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  4. #4

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2010
    Location
    Lake Gaston, NC
    Posts
    453

    Re: How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSM

    No. I'm on a Win8 computer, but I do have "Sql Server Configuration Manager"

  5. #5
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,123

    Re: How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSM

    Would there be a problem if you are going to install SSMS?
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  6. #6

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2010
    Location
    Lake Gaston, NC
    Posts
    453

    Re: How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSM

    I have SSMS installed on my development computer that I want to use to manage my client Win8 computer w/o SSMS.

    I have just found the below and tried it with no success.

    [HIGHLIGHT=undefined]
    Name:  Capture88.jpg
Views: 133
Size:  30.6 KB

  7. #7
    Addicted Member
    Join Date
    Oct 2008
    Location
    Califorina
    Posts
    235

    Re: How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSM

    They changed it a bit from 2005 to 2008 Clicky here


  8. #8

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2010
    Location
    Lake Gaston, NC
    Posts
    453

    Re: How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSM

    The page can't be displayed from that link.

  9. #9
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSM

    This link should help

    http://stackoverflow.com/questions/1...s-without-ssms

    There is a SQLCMD command at CMD prompt - it can execute commands against the SQL instance - just get on the machine with 2008 running on it

    Code:
    Microsoft Windows [Version 6.1.7601]
    Copyright (c) 2009 Microsoft Corporation.  All rights reserved.
    
    C:\Users\Steve>sqlcmd
    1> exit
    
    C:\Users\Steve>sqlcmd -?
    Microsoft (R) SQL Server Command Line Tool
    Version 11.0.2100.60 NT x64
    Copyright (c) 2012 Microsoft. All rights reserved.
    
    usage: Sqlcmd            [-U login id]          [-P password]
      [-S server]            [-H hostname]          [-E trusted connection]
      [-N Encrypt Connection][-C Trust Server Certificate]
      [-d use database name] [-l login timeout]     [-t query timeout]
      [-h headers]           [-s colseparator]      [-w screen width]
      [-a packetsize]        [-e echo input]        [-I Enable Quoted Identifiers]
      [-c cmdend]            [-L[c] list servers[clean output]]
      [-q "cmdline query"]   [-Q "cmdline query" and exit]
      [-m errorlevel]        [-V severitylevel]     [-W remove trailing spaces]
      [-u unicode output]    [-r[0|1] msgs to stderr]
      [-i inputfile]         [-o outputfile]        [-z new password]
      [-f <codepage> | i:<codepage>[,o:<codepage>]] [-Z new password and exit]
      [-k[1|2] remove[replace] control characters]
      [-y variable length type display width]
      [-Y fixed length type display width]
      [-p[1] print statistics[colon format]]
      [-R use client regional setting]
      [-K application intent]
      [-M multisubnet failover]
      [-b On error batch abort]
      [-v var = "value"...]  [-A dedicated admin connection]
      [-X[1] disable commands, startup script, environment variables [and exit]]
      [-x disable variable substitution]
      [-? show syntax summary]
    
    C:\Users\Steve>

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  10. #10

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2010
    Location
    Lake Gaston, NC
    Posts
    453

    Re: How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSM

    Thanks for your help.

    The code below in sqlcmd did the trick. I had tried it before but did not realize that all of the instructions are case sensitive.

    Name:  snip5.PNG
Views: 123
Size:  3.1 KB

    Thanks again for your help!!

  11. #11
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: [RESOLVED] How to "Allow Remote Connections" for Sql Server 2008 Express on a Cli

    Excellent - glad I could help.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

Posting Permissions

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



Click Here to Expand Forum to Full Width