I Recently Installed Microsoft SQL Server 2014 (SSMS) on my local machine for development learning purposes. I am running Windows 10 32 bit. When i try to connect, Server Name does not appear. Screen Shot is attached.    According to my research, name of the local server should appear in the marked field.  I think that Installation is successful.  I am unable to find the solution to this problem. I installed SSMS 2015 RC0, Problem was not solved. Then i uninstalled it and Installed SSMS 2014. But the problem is not solved.  I remember perfectly that about a  year ago. I installed SSMS and there was no such problem. I can't figure out Why the server name is not appearing. When i try to connect by manually entering Local server name(./), the following error occurs   Any help would be appreciated.
121047
I just installed SQL Server and SQL Server Management Studio but it doesn't show anything in servers list and I don't know how to connect to it.  This shows that I have installed SQL Server:        But in this image you can see that my Browse for Servers dialog is empty:        Network servers is empty too.
105715
I have been using a local database on my laptop for the last view weeks. But today I cannot access it. I get the error:      A network-related or instance-specific error occurred while   establishing a connection to SQL Server. The server was not found or   was not accessible. Verify that the instance name is correct and that   SQL Server is configured to allow remote connections. (provider: Named   Pipes Provider, error: 40 - Could not open a connection to SQL Server)   The system cannot find the file specified"  The database connection is: my-pc.C:\DB\DBV8.1.1.MDF.dbo
15483
I'm experiencing an annoying problem with a table named SysMessages in one of our databases. When I run a select statement I don't get the contents of this table, but of the sys.sysmessages view in the master database. A use [DBNAME] doesn't help, nor select * from [DBNAME].dbo.SysMessages.  I'm in the middle of a migration to a newer SQL Server version. In SQL Server 2008 R2 I didn't encounter this problem with this database, but in SQL Server 2016 I'm not able to query my own SysMessages table.  Any help would be greatly appreciated.
83919
How do find out which edition is installed without having the management studio installed?  I have a server that functions as a license manager for another software.  Upon investigation of a high RAM usage alert, I found that the sqlservr.exe process is taking up almost 2 GB of RAM.  I looked through the program menu and found that the configuration manager was installed, otherwise, it is pretty bare bones.  I clicked on properties of the EXE file and found 10.50.1600.1, but there is no place that I've found that states whether it is Express, Dev, STN, ENT, etc.  If I had to guess, this is an express edition, but I wanted to know if there is an obvious tell-tale sign.  Update: @Bob - The file tells me what I know, not the edition.  @valo - I get the following error when I run that command and I did verify named pipes was enabled:     HResult 0x35, Level 16, State 1   Named Pipes Provider: Could not open a connection to SQL Server [53].   Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance->specific error has occurred while establishing a connection to SQL Server. Server is not >found or not accessible. Check if instance name is correct and if SQL Server is configured >to allow remote connections. For more information see SQL Server Books Online..   Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.   @thomas - I noticed the Stock Keeping Unit Name before I asked the question, but that seemed too easy, I guess my initial suspicion was correct.
58737
I Copied some database backups from one server to another server(new instance no databases are present).I tried restoring using below command   Restore database dbname from disk='g:\e2bak\dbname.bak' with  stats=10   It failed with below error     Directory lookup for the file "G:\MSSQL$s73g\MDF\dbname.mdf" failed   with the operating system error 3(The system cannot find the path   specified.)Msg 3156, Level 16, State 3, Line 1   Also server level default database settings are to store data and log in   G:\MSSQL10_50.SG\MSSQL   I can overcome the error by specfying move option. But my confusion here is  1.Why database .bak file is looking for G:\MSSQL$s73g\MDF\dbname.mdf",this is the path   of dbname database files in production from where we copied the .bak file  2.Also when I restored the database with move option and took a backup in same server,   I was able to restore the Database with below command  Restore database dbname  from disk='G:\e1ebk\dbname.bak' with replace,stats=10   Can you please help me understand why .Bak file location is pointing out to some other directory(which doesn't even exist in our server and existed only on production server) and in second case why this worked without move option.
32094
I have a standalone domain controller that was recently compromised. I've isolated it and cleaned it up, but I need to set about replacing it.   I've built a replacement, however when I try and join the domain, I'm getting 'The network path was not found'. It does prompt for credentials, so its like it can see the domain, but after about 30 seconds, it errors.     I've googled the hell out of this and I've tried various things with no success so far.  I believe DCDiag has shed some light on the cause of the issue, however I've not sure where to go from here...   Performing initial setup:  Trying to find home server...  Home Server = {machinename}  [{machinename}] Directory Binding Error 1722: The RPC server is unavailable. This may limit some of the tests that can be performed. * Identified AD Forest. Done gathering initial info.  Testing server: Default-First-Site-Name\{machinename}   Skipping all tests, because server {machinename} is not responding to directory service requests.   Any help or suggestions welcome!
7713
I know this is a total noob question but then again, when it comes to PostgreSQL I am a total noob...    I have installed the OpenGeo suite on my computer, running Windows 7, 64-bit.  I have downloaded the tutorial data and have been working through it.  I would like to access the database that I have made with ArcGIS so I can start learning about how that works.  However, when I try to connect to the database using the "Add Database Connection..." I can't seem to figure out what to put in for 'Instance' - everything I've tried (localhost, localhost,54321, my IP address with and without the port, my computer name) doesn't seem to work.  I installed and created the nyc test database according to all the instructions in the OpenGeo tutorial pages but am at a total loss here.  I know this must be an easy thing to deal with, I just can't get my head around it.  Can someone with more experience throw me a bone on this one?    Frustratingly enough, QGIS connects to the database with almost no effort and everything works fine - but my organization is heavily ESRI focused and switching to QGIS is a long shot...  EDIT Thanks everyone for pitching in on this.  I really appreciate the advice, it's what makes this site great.  I have installed    OpenGeo Suite 3.0.1 with no extensions ArcGIS Desktop 10.1, no license for server   I just went to the Opengeo website and downloaded the Windows installer and installed the default configuration. I have tried every permutation for the instance name that I can think of - using colons and commas, my machine name, localhost, postgresql, server, my IP address, random curse words, anything I can think of.  I have been using port 54321 instead of 5432 because that is what the OpenGeo workshop told me to set up my 'nyc' practice database to use.    It seems that localhost should work, here is a shot of the server properties from pgAdmin:
104252
I have this problem.  I need to do some administrative tasks on a MS SQL Database using SA account.   OS authentication is not set. SQL Server Manager Manager Studio is not installed. I have no other admin database account. I do have access to a Windows admin account The only tools installed on the database server are as shown:     How can I activate OS authentication so I can log into the database an reset the SA password ?
87043
The SQL Server instance is accessible and seems to be fine.     Microsoft SQL Server 2016 (SP1-CU2) (KB4013106) - 13.0.4422.0 (X64)   Mar  6 2017 14:18:16   Copyright (c) Microsoft Corporation  Enterprise   Edition (64-bit) on Windows Server 2012 R2 Standard 6.3  (Build   9600: ) (Hypervisor)   But what does the white question mark mean?  these icons dont go away when I refresh. I am sysadmin inside sql server and outside I am administrator on that box.      Another thing I noticed, you can see on the picture below. These are 2 different Management Studio sessions.  On the top one, I am logged in as myself, DBA and sysadmin,  on the second one I use Management Studio with run as a different user and I use a domain account that I use for the replication, which is not sysadmin.  The second one has the blue icon in this and other servers as well, whilst mine is the normal green one.
75370
During the migration of one of our databases from SQL Server 2012 (SP1, CU2) to SQL Server 2014 (SP1), we have experienced some strange issues.  One of the queries that completes within seconds on SQL Server 2012 seem to be hanging on SQL Server 2014.  SELECT  DISTINCT      src.[Id] FROM     [stg].[BaseVolumes] src JOIN          [tmp].[Dates] d ON src.[CalWeek_Nmbr] = d.[CalYrWkDense_Nmbr] WHERE        EXISTS (SELECT  *             FROM                     (SELECT     ctry.[ISOCode]                  AS  [Mkt_Code]                             , so.[Code]                     AS  [SlsOrg_Code_AK]                             , so.[DistributionChannelCode]  AS  [DistChnl_Code_AK]                             , prd.[SupplierCode]                AS  [SKU_Code_AK]                             , cl6.[Code]                        AS  [CstHierLvl06_Code_AK]                             , lp.[BaseDateID]                   AS  [Dte_EK]                  FROM   [PM_APP].[edw].[BaseVolumeDayCurrent]   lp                  JOIN   [PM_APP].[dbo].[Country]                ctry    ON  lp.[CountryID] = ctry.[ID]                  JOIN   [PM_APP].[dbo].[SalesOrganisation]      so      ON  lp.[SalesOrganisationID] = so.[ID]                  JOIN   [PM_APP].[dbo].[Product]                prd     ON  lp.[ProductID] = prd.[ID]                     JOIN   [PM_APP].[dbo].[CustomerLevel6]         cl6     ON  lp.[CustomerID] = cl6.[ID]                  WHERE                        lp.[ModifiedByApp] = 1) lkp             WHERE                    src.[Mkt_Code]                  =   lkp.[Mkt_Code]                 AND src.[SlsOrg_Code_AK]        =   lkp.[SlsOrg_Code_AK]                 AND src.[DistChnl_Code_AK]      =   lkp.[DistChnl_Code_AK]                 AND src.[SKU_Code_AK]           =   lkp.[SKU_Code_AK]                 AND src.[CstHierLvl06_Code_AK]  =   lkp.[CstHierLvl06_Code_AK]                 AND d.[Dte_EK]                  =   lkp.[Dte_EK]         )   Row count:   BaseVolumes:            23108  Dates:                  18628  BaseVolumeDayCurrent:   108115503  Country:                249 SalesOrganisation:      29 Product:                18446 CustomerLevel6:         295   Wait stats showing high CXPacket, but there is one hanging task with SOS_SCHEDULER_YIELD, (print from sys.sysprocesses)   spid | blocked | waittime | lastwaittype          | cpu     | physical_io   76   | 0       | 9886044  | CXPACKET              | 13902   | 31192  76   | 0       | 0        | SOS_SCHEDULER_YIELD   | 9829719 | 83077  76   | 0       | 11248    | CXPACKET              | 11110   | 0 . . .   Attached are the execution plans from SQL Server 2012 and SQL Server 2014.       Any help much appreciated.
47835
I just installed Windows Server 2016 in a development virtual machine and strangely there is an 'Unknown Locale (qaa-Latn)' listed in my language / input list (in the task bar) and it doesn't show up anywhere in the 'Clock, Language and Region' and > Language areas of the control panel nor in the newer Windows Settings dialog.  I have no idea how it got there and how I would remove it as it isn't listed anywhere explicitly.  Is there any way to remove this locale?  Update with more Details: This is/was a bare bones, fresh installation (using the Feb 2018 MSDN imnge of Windows Server 2016.. and I also tried re-installing it, again.. as new installation based on the RTM version of Server 2016 standard) without any 3rd party software. The only 'special' part is that it's running as a Hyper-V virtual machine (with Windows 10 Enterprise N being the host OS).
65898
Will preface this by saying I am not at all convinced yet this is not the vendor doing something wrong on their application server.  Just looking for new ideas  Instance X is a named instance of SQL Server 2008 R2.  It houses numerous databases and takes in connections from numerous application servers.  Browser service is running and all connections are made by way of server\instance name.  Moved DB from an old 2K5 instance over to it the other day and vendor claims he cannot connect to the DB.  He says he is just putting in the Server\instance name in his connection string and his connection fails. At this time he cannot/has not provided me with any real error message.  Whenever he tries, we see no evidence of success or failure.  As of right now there is no evidence he is even hitting the named instance.  He can hit a test 2008 R2 default instance though.  So, since the named instance appears to be the difference, I am thinking this has something to do with the port number.  We have not explicitly tried the port number because we need it to work with just the name and vendor swears it should.  However, we can connect with his credentials, via SQLCMD and by setting up a basic ODBC.  Application server is 2003R2 and in my opinion, craped up, but replacing it is not an option.  DBNETLIB.DLL version is 2000.86.3959.0 and native client version is 2005.90.3042.  You would have to go quite a ways back to not be able to hit a named instance.  Am I missing anything overly obvious?  From a customer service perspective would prefer to not just say “Works for everyone else!”.  EDIT 9:44PM Central - Should have noted on original post that the firewall is not on on the application server and we do not filter/block anything internal to the network.
27728
Our SQL Server (2008) instance is configured to send mail and everything is working correctly, but I can't figure out how to view the existing configuration, in particular the SMTP server.   From SSMS I can only start the configuration wizard, and I can't find anything online - plenty of info on how to set it up but nothing on how to view the current settings.   How can I view the existing settings?
18323
I'm not sure if I'm googling for the wrong thing but I can't find an answer. We're running SQL 2014. The SQL Server and SQL Agent processes are both running under Domain Managed Service Accounts.  When SQL was installed NT SERVICE\MSSQLSERVER, NT SERVICE\SQLSERVERAGENT, NT SERVICE\SQLWriter, NT SERVICE\Winmgmt are all setup as SysAdmins.  If I am running SQL and SQL Agent as a Domain user, do I still need these NT Service accounts, and/or do they need to be SysAdmin?
33576
Maybe I'm searching for the wrong thing, but I can't see how I can do this.  I have two servers:   Server A (has SQL Server 2012 installed) Server B (has SQL Server 2014 installed)   Server A provides an API via IIS. The code both inserts and gets data from the database depending on the API call.  Server B does exactly the same for its local database.  I would like to have it so that the two databases are consistent copies of each other. I do believe this is what HA accomplishes.   So a load balancer, for example, might direct API calls to A sometimes, and B sometimes, but the data needs to be consistent either way.  I found some documentation on HA for SQL Server 2012, but not on how to do this for a mixed environment of 2012 and 2014.  Any help or pointers to documentation would be great! Thanks.
80496
Well, luckily I got this error on my test environment. I'm so scared about this error that I disabled all logon triggers I was using on production environment.   I created the famous logon trigger, and I put a database in offline mode just to mess with something else. Then I discover that because the trigger can't find the table, I can't access the instance anymore. There are plenty of questions related to this, but even doing everything I could find, I still can't acces the instance, not even with SQLCMD.  I'm doing this:  sqlcmd -S server\instance -U sa -P &lt;pass&gt;  -A   If I don't use -A I receive the famous error:  logon failed for sa due trigger execution.   If I use -A:     Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : SQL Server   Network Interfaces: An error occurred while obtaining the dedicated   administrator connection (DAC) port. Make sure that SQL Browser is   running, or check the error log for the port number [xFFFFFFFF]. .   Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Login timeout   expired. Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : A   network-related or instance-specific error has occurred while   establishing a connection to SQL Server. Server is not found or not   accessible. Check if instance name is correct and if SQL Server is   configured to allow remote connections. For more information see SQL   Server Books Online..   Why i'm not able to connect to the sql server    sql server express here.  I could enable SQL Browser, but I still can't access it.  I don't think this question is duplicated because is not about the trigger, is about Why I can't access the server with SQLCMD. I pretty much know how to fix this. I just don't know how can I acces sql server without triggering the trigger.
90246
My server rebooted and I am not sure why.  Is there a way to find out, e.g. perhaps someone did it manually, or as a result of a windows update or a blue screen?  I've looked in the Event Viewer, but I am not sure what to look for - there are million items there.