-
Jul 31st, 2014, 03:01 PM
#1
Thread Starter
Hyperactive Member
[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.
-
Jul 31st, 2014, 04:26 PM
#2
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
-
Jul 31st, 2014, 05:09 PM
#3
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?
-
Jul 31st, 2014, 05:24 PM
#4
Thread Starter
Hyperactive Member
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"
-
Jul 31st, 2014, 05:51 PM
#5
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?
-
Jul 31st, 2014, 06:06 PM
#6
Thread Starter
Hyperactive Member
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]
-
Jul 31st, 2014, 06:33 PM
#7
Addicted Member
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
-
Jul 31st, 2014, 06:37 PM
#8
Thread Starter
Hyperactive Member
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.
-
Aug 1st, 2014, 06:24 AM
#9
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>
-
Aug 2nd, 2014, 11:29 AM
#10
Thread Starter
Hyperactive Member
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.
Thanks again for your help!!
-
Aug 2nd, 2014, 02:02 PM
#11
Re: [RESOLVED] How to "Allow Remote Connections" for Sql Server 2008 Express on a Cli
Excellent - glad I could help.
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
|