I want to sort by the Name column (which is the date the hotfix was installed). I LOVE it when it is SIMPLE and STRAIGHT. To get this to work, replace "YourInstanceNameHere" with the name of your instance. with the name of your instance. WebWhen installing a sql server instance, NT AUTHORITY\SYSTEM login is created , so you can get the instance installation date by searching for the NT AUTHORITY\SYSTEM login created date. Not sure I can make that happen with anything in the suggested link. I had this same issue when I was assessing 100+ servers, I had a script written in C# to browse the service names consist of SQL. Re: How to get SQL Server Version on multiple Servers on Azure using Power shell. So your full server name should include (localdb)\ in front of the instance name to connect. https://community.spiceworks.com/topic/1031239-powershell-check-for-servers-that-have-sql-installed, http://www.databasejournal.com/features/mssql/article.php/3752866/Check-your-SQL-Server-using-Windows-PowerShell-150-Part-1.htm, https://www.simple-talk.com/sql/database-administration/doing-a-sql-server-healthcheck-via-powershell/, Hereisascriptthatchecksthesqlserverversion: You specify the script file with the queries. I am using my RRS Feeds (https://blog.sqlserveronline.com/category/updates/feed/?withoutcomments=1), customized for my needs, but you can create your own, or to use RSS from other sources, such as http://sqlserverupdates.com/feed/(Excellent web page, all update information you need, Brent Ozar). If both computers are in the same Active Directory domain, you dont need to worry about providing alternate credentials to your PowerShell commands. Works great, however, the user (running the script) must be able to authenticate (e.g. WebOur client is migrating their existing on-premise server infrastructure to the Microsoft Azure cloud. Using indicator constraint with two variables. Asking for help, clarification, or responding to other answers. This, of course, will work for any client tool. Is it possible to rotate a window 90 degrees if it has the same length and width? So, they built in a traffic cop. This, of course, will work for any client tool. Additionally, this i All of the instances installed should show up in the Services Snap-In in the Microsoft Management Console. You can see an example of kicking off the installer here: If all goes well, you have an updated SQL Server once the installer finishes. "After the incident", I started to be more careful not to trip over things. This is my 1st attempt at powershell, so your help would be appreciated. msdn.microsoft.com/en-us/library/ms165662%28v=sql.90%29.aspx, http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx, http://msdn.microsoft.com/en-us/library/a6t1z9x2(v=vs.80).aspx, http://msdn.microsoft.com/en-us/library/ms181087.aspx, How Intuit democratizes AI development across teams through reusability. In Dungeon World, is the Bard's Arcane Art subject to the same failure outcomes as other spells? Configuration Tools then Can you write oxidation states with negative Roman numerals? None of the above high voted solutions can give a complete list as this method. PowerShell Whatever we did on method 1, same can be achieved using PowerShell also. The TechNet Gallery is a great site where you can find scripts of any kind, you can also try searching there! Here is a version I cobbled together from some sources here and there*. This is great because it allows you to then easily use the version number (or whatever you want) in the rest of your script. [duplicate], Determining the Actual Server Create Date, https://blog.sqlauthority.com/2012/07/05/sql-server-retrieve-sql-server-installation-date-time/, http://weblogs.sqlteam.com/mladenp/archive/2009/07/16/How-to-check-when-was-SQL-Server-installed-with-a.aspx, https://mssqlfun.com/2014/07/17/how-to-check-sql-server-installation-date-time/, https://sqldbpool.com/2013/08/27/how-to-find-out-the-sql-server-installation-date/, How Intuit democratizes AI development across teams through reusability. Sorry I cannot find the file. go to Sharing best practices for building any app with .NET. Just an expansion of Ben Thul's answer, It loops through a list of all my DB Servers and prints out the current version of the database engine: Well, here's the old school way, that's easy: Thanks for contributing an answer to Stack Overflow! oops missing sqlbrowser.exe from usual location! (Note: must be a capital L) This will list all the sql servers installed on your network. There are con Here's a good site which has links to the TechNet Gallery that has various of different scripts: http://powershellscripts.com/category.asp?cat=Windows+Update. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. In the enabled protocols list, select 'TCP/IP', then click properties. When installing a sql server instance, NT AUTHORITY\SYSTEM login is created , so you can get the instance installation date by searching for the NT AUTHORITY\SYSTEM login created date. WebI can help you make SQL Server responsive, highly available, and easier to manage. D Where does this (supposedly) Gibson quote come from? Enjoyed examining this, very good stuff, thanks . Hes a consultant, Microsoft MVP, blogger, trainer, published author and content marketer for multiple technology companies. Heres how to do it: Youve successfully remotely installed a SQL Server service pack using nothing but a file and a PowerShell script. Description: SQL Server Instance Update Status PowerShell script which can be invoked remotely from another PC trough the command line, with PowerShell or executed remotely through task scheduler adding servers names. For my configuration the routing table showed a lower metric for teh virtual adapter then for the physical. Here is a simple method: Obviously, replace "." I am a data specialist with more than 15 years of hands-on experience in database administration and optimisation. How do I import an SQL file using the command line in MySQL? Does there exist a square root of Euler-Lagrange equations of a field? WebGet SQL Instances & More. Install the SqlServer module from the PowerShell Gallery. [[-ResourceGroupName] ] [[-ServerName] ] [-DefaultProfile ] [-WhatIf] [-Confirm] []. We can use the Get-Service commandlet to grab all of the SQL Services Installed when there are more than one installed on a single server. Take Screenshot by Tapping Back of iPhone, Pair Two Sets of AirPods With the Same iPhone, Download Files Using Safari on Your iPhone, Turn Your Computer Into a DLNA Media Server, Control All Your Smart Home Devices in One App. By default, the SQL Server PowerShell components use Windows Authentication when connecting to an instance of the Database Engine. Read more Like any other piece of software, Microsoft SQL Server needs to be kept up to date. I prefer to use a function called Test-PendingReboot. Can't connect to new instance of SQL Server, Multi-instance SQL Server Standard Editon MaxDop settings, Missing options in Feature Selection when installing SQL Server 2016 on existing server. The remote instances are resolved by UDP broadcast (port 1434) and SMB. How can I delete using INNER JOIN with SQL Server? Login to edit/delete your existing comments. As you can see in the picture above, we All you need is to connect to SQL Server and run this query: select @@version All you need is to connect to SQL Server and run this query: This, of course, will work for any client tool. There are configuration options you can set to prevent a SQL Server from showing in the list. How can I determine what default session configuration, Print Servers Print Queues and print jobs. Connect and share knowledge within a single location that is structured and easy to search. The following command lists all of the installed hotfixes on all domain computers: The same command as above, but it writes it out to a CSV file: Here's a few ways on how to get the last installed updates: Sharing knowledge and contributing to the SQL Server community is my passion. Is there a solution to add special characters from software and how to do it. You can run extract the contents of the service pack on the remote SQL Server, using the following code: At this point, youre ready to begin the installation process. This assumes SQL Server 2005, or greater; dotnetengineer's recommendation to use the Services Management Console will show you all services, and should always be available (if you're running earlier versions of SQL Server, for example). Use "sqlbrowser.exe -c" to list the requests. DR - Moving databases from Active/Active cluster to Standalone server with LUN sync. The commands OSQL -L and SQLCMD -L will show you all instances on the network. This only tells you the name of the current instance associated with the executing query. rev2023.3.3.43278. or OSQL -L YMMV. Does ZnSO4 + H2 at high pressure reverses to Zn + H2SO4? Best practices and the latest news on Microsoft FastTrack, The employee experience platform to help people thrive at work, Expand your Azure partner-to-partner network, Bringing IT Pros together through In-Person & Virtual events. In "General" section, check the Version field number. The SqlServer module is the current PowerShell module to use. Run the following command to install DBATools module. When you purchase through our links we may earn a commission. @LearnByReading See Mohammed Ifteqar Ahmed's answer below. The nature of simulating nature: A Q&A with IBM Quantum researcher Dr. Jamie We've added a "Necessary cookies only" option to the cookie consent popup. Is it possible to rotate a window 90 degrees if it has the same length and width? The only possible date is [msdb] creation date, which I see it changing for different sql server instances. Do I need a thermal expansion tank if I already have a pressure tank? When Microsoft implemented named instances with SQL Server 2000 they had to have a way to direct incoming traffic pointed to a single IP to the correct TCP port. Is that value for SID going to be the same across all instances?? [CDATA[ I fixed it by setting it to automatic and then starting it. WebTo verify that the KMS host is configured correctly, you can check the KMS count to see if it is increasing. Adam Bertram is a 20+ year veteran of IT and an experienced online business professional. http://msdn.microsoft.com/en-us/library/cc281847.aspx My code is GPL licensed, can I issue a license to have my code be distributed in a specific MIT licensed project? Script is checking server registry values for (Version, PatchLevel, Edition, SQLPath), you can choose and add other values from registry if needed. How to find server name for SQL Server 2005, How to check if a column exists in a SQL Server table, How to concatenate text from multiple rows into a single text string in SQL Server. http://blogs.technet.com/b/heyscriptingguy/archive/2013/05/07/use-powershell-to-discover-diagnose-and-document-sql-server.aspx, Thanks for the info,I don't need this command ,I need to write my own automation script to test the SQL server is installed or not in my machine using windows power shell. How do I check which version of Python is running my script? Invoke-Sqlcmd -Query "SELECT @@VERSION;" -QueryTimeout 3 Example 1, PowerShell: Collect information about installed Updates (Hotfixes) on all Domain Computers. Formore,gothroughtheselinks: By default, the SQL Server provider and cmdlets use the Windows account under which it is running to make a Windows Authentication connection to the Database Engine. I am suggesting using proxy to connect to any outside RSS Feeds, in this example your SQL Server Instances need internet connection. PowerShell / SQL Server / Check SQL Server current Update Status and send Email Report, https://gallery.technet.microsoft.com/Use-PowerShell-to-check-05ca591f, https://blog.sqlserveronline.com/category/updates/feed/?withoutcomments=1, SQL Server / PowerShell / Check SQL Server version and a current patch level for all servers you specify using PowerShell, Powershell / Use PowerShell to Backup all user databases to Azure Storage, Microsoft SQL Server 2016 Updates / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.2.5026.0) / SP3 (13.0.6300.2 or 13.3.6300.2), Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169), Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0), https://blog.sqlserveronline.com/wp-content/uploads/2017/10/IndexUsageReportProject.mp4, Microsoft SQL Server 2022 Updates / Release Candidate (RC 1) Evaluation Edition (16.0.950.9), Microsoft SQL Server 2019 Updates / BETA (15.0.1000.34) / RTM (15.0.2000.5), Microsoft SQL Server 2014 Updates / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0) / SP3 (12.0.6024.0 or 12.3.6024.0), SQL Server / Remove SCHEMABINDING from the multiple VIEWs without DROP and CREATE statements, #DataWeekender CU5 / Virtual Event / 14th of May 2022, SQL Server / Configure an Azure Load Balancer for a SQL Server Always On AG in Azure Virtual Machines / Possible Floating IP and Health Probes Connectivity and Networking issues. Note: This works for named instances on a standalone server but not clusters, you also will need to modify to include a default instance if installed too. How to Use Cron With Your Docker Containers, How to Check If Your Server Is Vulnerable to the log4j Java Exploit (Log4Shell), How to Pass Environment Variables to Docker Containers, How to Use Docker to Containerize PHP and Apache, How to Use State in Functional React Components, How to Restart Kubernetes Pods With Kubectl, How to Find Your Apache Configuration Folder, How to Assign a Static IP to a Docker Container, How to Get Started With Portainer, a Web UI for Docker, How to Configure Cache-Control Headers in NGINX, How Does Git Reset Actually Work? How can I check before my flight that the cloud separation requirements in VFR flight rules are met? Use Invoke-Sqlcmd Cmdlet to Check the SQL Server Version Using PowerShell Checking the version of a program is one of the common operations you can Googling the numbers then was easy. It is easy to gather hotfix information on Windows8.1 (and Windows8, Windows Server2012R2, and Windows Server2012). -- T-SQL Query to find list of Instances Installed on a machine DECLARE @GetInstances TABLE I have RSS feed for the SQL Server Version 2012 and newer. What is SSH Agent Forwarding and How Do You Use It? Oncetheinstallerisonthe server, you can extract the contents of the installer. This example uses the read-host cmdlet to prompt the user for a password, and then connects using SQL Server Authentication. The command and its associated output are shown here: This looks pretty good, but it is a bit random. There are two SQL Server PowerShell modules; SqlServer and SQLPS. If you're looking for a broader discovery process, however, you might consider third party tools such as SQLRecon and SQLPing, which will scan your network and build a report of all SQL Service instances found on any server to which they have access. $inst = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Micro reg query "HKLM\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL". WebGenerate the configuration file using the following steps: Load your SQL Server install disk or image and launch the setup.exe file. You could query this registry value to get the SQL version directly: Alternatively you can query your instance name and then use sqlcmd with your instance name that you would like: If you are using C++ you can use this code to get the registry information. If you have any questions, send email to me at [email protected], or post your questions on the Official Scripting Guys Forum. The results displayed are not always complete. Find what sql versions(!) requires you to login to the instance. How to update SQL Server 2005 clustered instances? All actions you can perform in an instance of the Database Engine are controlled by the permissions granted to the authentication credentials used to connect to the instance. Can you check to see if it is present, Your email address will not be published. There is a check box for 'Hide server'. Your email address will not be published. This version does not hit the registry, does not hit SQL, and doesn't even require that the instance be running. Connect and share knowledge within a single location that is structured and easy to search. >Install-Module I also added a cinnamon stick for sweetness. Is it suspicious or odd to stand by the gate of a GA airport watching the planes? All I need to do is to use the Get-Hotfix cmdlet. How can I use Windows PowerShell to see all the versions of SQL Server I have installed? See: SqlLocalDB Utility. What if the SQL instance has crashed and fails to start up? When using the SQL Server provider, you must associate the SQL Server login credentials with a virtual drive, and then use the change directory command (cd) to connect to that drive. *I also received help from and help from this this friend of mine https://stackoverflow.com/users/1518277/mqutub and I didn't want it to go uncredited. Here you have it: # This scripts detecs installed SQL instances through registry and returns version information $inst = (get-itemproperty A quick way to do so is to use PowerShell. I can see that in August 2014, there were three separate hotfix collections of 2, 13, and 1 (a total of 16 hotfixes for August). Find centralized, trusted content and collaborate around the technologies you use most. Below youll find a PowerShell script that checks the OS version details and the SQL Server build, which then can be compared against the latest build to see if it Hey, Scripting Guy! Is there a single-word adjective for "having exceptionally strong moral principles"? The registry is the source definition of installed software. I am attempting to use powershell to get the latest update date and or patch applied to servers in my environment. 2.In SQL Server Configuration Manager, on the left pane, click SQL Server Services. Right-click on Server Name > Properties. By the way, I am running Windows8.1 with all of the latest patches, updates, and whatevers from Microsoft. SQL Server 2005 Network Configuration then Then, whenever you use the change directory command (cd) to connect to a path by using the virtual drive name, all operations are performed by using the SQL Server Authentication login credentials that you supplied when you created the drive. Below is the method where we query the registry. Why is there a voltage on my HDMI and coaxial cables? The nature of simulating nature: A Q&A with IBM Quantum researcher Dr. Jamie We've added a "Necessary cookies only" option to the cookie consent popup. I am trying to compile a list of SQL Servers and their databases. Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2, How to check if SQL Server version 2008 or higher in c# Windows Forms, How to read a value from the Windows registry. How to check whether SQL server installed or not in my machine using windows powershell scripting ? Based on our current migration plan, you would need to be familiar with provisioning and configuring the following Azure resources: - Virtual Network Can you hook me up? not exactly native PS. Browse other questions tagged, Start here for a quick overview of the site, Detailed answers to any questions you might have, Discuss the workings and policies of this site. Making statements based on opinion; back them up with references or personal experience. $srv = New-Object "Microsoft.SqlServer.Management.Smo.Server" "." Toextracttheinstaller, usethearguments /extract:"C:TempSQLSP"/quiet. The associated KMS GVLKs for these products are documented in KMS client setup keys as they become available. The local instance is resolved by registry entry. Get-AzureRmSqlServer[[-XYZ] ] [[-ABC] ] [-DefaultProfile ] [-WhatIf] [-Confirm] []. I'm trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are telling me to run a SQL query to determine this which assumes I'm already connected to a particular instance. - the incident has nothing to do with me; can I use this this way? By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. I know this thread is a bit old, but I came across this thread before I found the answer I was looking for and thought I'd share. I had to come up with this today when working with a SQL Server compliance item in With Wireshark, sqlbrowser.exe (which can by found in the shared folder of your SQL installation) I found a solution for my problem. The command and a typical output are shown here: If I pipe the output to the Format-List cmdlet, select all of the properties, and use the Force parameter to reveal any hidden properties, I can see that there are indeed other properties available. You have one last task to perform, though, cleaning up. Here you can locate all the instance installed onto your machine. or OSQL -L I am open to any ideas, please advise. Learn more about Stack Overflow the company, and our products. Since we launched in 2006, our articles have been read billions of times. Invoke-Sqlcmd-Query"SELECT@@VERSION;"-ServerInstance"MyServer" How-To Geek is where you turn when you want experts to explain technology. Why did Ukraine abstain from the UNHRC vote on China? You cannot call a method on a null-valued expression. Microsoft SQL Server 2005 then All of the instances installed should show up in the Services Snap-In in the Microsoft Management Console. To get the instance names, go to Start Setup your own KMS server on Ubuntu 20. do I need to specify a subnet on this or domain, its coming back null for me, can you please update. +1 The source of the information about the instances is the same as the answer by Brian. using "Windows authentication" to run this code as it is). (e in b.c))if(0>=c.offsetWidth&&0>=c.offsetHeight)a=!1;else{d=c.getBoundingClientRect();var f=document.body;a=d.top+("pageYOffset"in window?window.pageYOffset:(document.documentElement||f.parentNode||f).scrollTop);d=d.left+("pageXOffset"in window?window.pageXOffset:(document.documentElement||f.parentNode||f).scrollLeft);f=a.toString()+","+d;b.b.hasOwnProperty(f)?a=!1:(b.b[f]=!0,a=a<=b.g.height&&d<=b.g.width)}a&&(b.a.push(e),b.c[e]=!0)}y.prototype.checkImageForCriticality=function(b){b.getBoundingClientRect&&z(this,b)};u("pagespeed.CriticalImages.checkImageForCriticality",function(b){x.checkImageForCriticality(b)});u("pagespeed.CriticalImages.checkCriticalImages",function(){A(x)});function A(b){b.b={};for(var c=["IMG","INPUT"],a=[],d=0;d Is there any other reliable way that can indicate the sql server instance creation date? Start then Note: the NT AUTHORITY\SYSTEM login SID is 0x010100000000000512000000. http://msdn.microsoft.com/en-us/library/cc281847.aspx?_e_pi_=7%2CPAGE_ID10%2C8699528354 Microsoft Scripting Guy, Ed Wilson, is here. The sqldrive function prompts you to enter the password for your login, masking the password as you type it in. To add to Brendan's code.. this fails if your machine is 64-bit, so you need to test appropriately. Function Get-SQLSvrVer { This will list all the sql servers installed on your network. PowerShell forums, I can give you a few examples though! This example creates a function named sqldrive that you can use to create a virtual drive that is associated with the specified SQL Server Authentication login and instance. vegan) just to try it, does this inconvenience the caterers and staff? Nice commands but for some reason it detected the SQLExpress instance on a network computed but failed to detect the SQLExpress instance on my local machine. Microsoft routinely releases service packs for SQL Server that must be installed. Adam Bertram is a 20+ year veteran of IT and an experienced online business professional. Copy the service pack installer to the remote SQL Server. As well I am active blogger and speaker at different SQL events such as SQL Saturdays, Meetups etc. By pointing this function to a server, it returns a simple True/False, letting you know if the server is pending a reboot. More info about Internet Explorer and Microsoft Edge. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. What Is a PEM File and How Do You Use It? Don't touch the $ if you do it won't work. Additionally, this is also available: SELECT SERVERPROPERTY ('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') More ways to determine the SQL Server version here: functions can be called from any PowerShell script once the library is sourced. If you preorder a special airline meal (e.g. There are many ways of doing this, if you want to go deeper into PowerShell I suggest you ask in the Using the Invoke-Program PowerShell function again, run the setup.exe installer that was extracted from the original file, and provide /q and /allinstances switches to it. Browse other questions tagged, Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide. More ways to determine the SQL Server version here: http://support.microsoft.com/kb/321185. If I close my eyes, it feels like I am in Florida, and I can hear the seagulls squawking. Thanks, the query worked for me. Does anyone have any examples $p does not get correct values for remote machines. SQL Server Configuration Manager was exactly what I needed. Which PowerShell technique should I use to talk to SQL Server? I can then select the InstalledOn property as the property upon which to group. (Note: must be a capital L) This will list all the sql servers installed on your network. Soft, Hard, and Mixed Resets Explained, How to Set Variables In Your GitLab CI Pipelines, How to Send a Message to Slack From a Bash Script, The New Outlook Is Opening Up to More People, Windows 11 Feature Updates Are Speeding Up, E-Win Champion Fabric Gaming Chair Review, Amazon Echo Dot With Clock (5th-gen) Review, Grelife 24in Oscillating Space Heater Review: Comfort and Functionality Combined, VCK Dual Filter Air Purifier Review: Affordable and Practical for Home or Office, LatticeWork Amber X Personal Cloud Storage Review: Backups Made Easy, Neat Bumblebee II Review: It's Good, It's Affordable, and It's Usually On Sale, How to Deploy SQL Server Service Packs for Free with PowerShell, How to Win $2000 By Learning to Code a Rocket League Bot, How to Watch UFC 285 Jones vs. Gane Live Online, How to Fix Your Connection Is Not Private Errors, 2023 LifeSavvy Media. Select the Automatically select an AD or KMS client key option and then click Install Key. ("naturalWidth"in a&&"naturalHeight"in a))return{};for(var d=0;a=c[d];++d){var e=a.getAttribute("data-pagespeed-url-hash");e&&(! -- T-SQL Query to find list of Instances Installed on a machine. I tried to check the [master] database creation date, and found (for sql 2012 onward at least) it is always Apr 8, 2003. This works for me but the resulting string is truncated. If you want to have a list of all instances on the server and doesn't feel like doing scripting or programming, do this: The instances should be listed in the "User Name" column as MSSQL$INSTANCE_NAME. Azure SQL Database How to tell which packages are held back due to phased updates, Recovering from a blunder I made while emailing a professor. Linear regulator thermal information missing in datasheet, Tick the checkbox "Show processes from all users" or equivalent. The SqlDataSourceEnumerator class exposes this information to the application developer, providing a DataTable containing information about all the visible servers. Assuming the service pack is on your local hard drive is C:SQLServerServicePacksSQL2016SP2.exe and your remote SQL Server is called SQLSRV, open up a PowerShell console and run: You should now have the service pack installer on the root of the C drive of your SQL Server. To learn more, see our tips on writing great answers. You can use SQL Server Authentication by either defining a PowerShell virtual drive, or by specifying the -Username and -Password parameters for Invoke As well check latest patches/updates available for installed SQL Server version and send email with results. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. How do you get out of a corner when plotting yourself into a corner. I have 300 servers on azure, i have to find the detailsof SQL Server Version in all servers on Azure. SQL Server 2012 connection string: can no longer find Server?