Viewing 15 posts - 46 through 60 (of 285 total)
Lowell (5/30/2013)
not sure if that is an option for you, but i prefer a more robust GUI...
May 30, 2013 at 5:56 am
It looks as if SQLPSX will require a SMO install (which is not "policially suitable" for my situation), although SQLPSX itself appears to have a "manual installation" as an option.
May 30, 2013 at 5:44 am
Joie Andrew (5/30/2013)Alternatively you could maybe try installing the management tools on a reference system and copy over sqlcmd.exe and the associated .dlls somewhere you can access them.
I found an...
May 30, 2013 at 5:27 am
Joie Andrew (5/30/2013)
Alternatively you could maybe try installing the management tools on a reference system and copy over sqlcmd.exe and the...
May 30, 2013 at 3:06 am
Superdoc (5/29/2013)
There is Powershell that can be used instead of sqlcmd but it is not open source, can be used for many things and not only running queries.
Thanks for the...
May 30, 2013 at 2:59 am
cmarkowi (5/8/2013)
May 9, 2013 at 4:39 pm
Eric Zierdt (3/25/2013)
i there a parameter that can be set in the config file to do this at install?
This may help. Not sure. http://msdn.microsoft.com/en-us/library/ms144259.aspx
March 25, 2013 at 1:35 pm
My bad. I forgot to bounce SQL Server after making the TCP change.
get-service *sql*
+++ Begin screen output +++
Status Name ...
March 23, 2013 at 6:03 am
Jay Beta (3/22/2013)
Use powershell instead.
Thanks. That helped, but I am still unable to connect. Before I made the recommended changes, based on the link in the prior post (http://blogs.msdn.com/b/sql_protocols/archive/2008/08/29/configuring-sql-protocols-through-windows-powershell.aspx), this...
March 23, 2013 at 5:55 am
This non-deprecated command appears to work:
netsh advfirewall firewall add rule name=SQLPort_1433 dir=in action=allow protocol=TCP localport=1433
After the above command is executed on the local server, the following connections work from a...
March 9, 2013 at 12:01 pm
This command (from my previous post) must have something wrong in it:
netsh advfirewall firewall add rule name = SQLPort_1433 dir = in protocol = tcp action = allow localport =...
March 9, 2013 at 11:33 am
I rebuilt this environment again to clean up my notes because I am planning to build similar lab environments in the future. (I had tried numerous firewall configuration attempts prior...
March 9, 2013 at 8:24 am
Deque (3/6/2013)
Does the following do what you're looking for?
SELECT name, LOGINPROPERTY(name, 'DaysUntilExpiration') AS DaysUntilExpirationFROM sys.sql_logins
WHERE LOGINPROPERTY(name, 'DaysUntilExpiration') <= 30
Yes, that's what I need. I was unaware of LOGINPROPERTY.
Thank...
March 6, 2013 at 2:51 pm
shew (3/5/2013)
Lynn Pettis (3/5/2013)
You have 1434 open for out going but not incoming traffic.
That's it!!!!!!!!!!!! Good eye. I snagged the netsh commands from a web page, which had UDP 1434...
March 5, 2013 at 6:48 pm
Lynn Pettis (3/5/2013)
March 5, 2013 at 6:44 pm
Viewing 15 posts - 46 through 60 (of 285 total)