Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2015-03-17 : 11:55:47
|
| Hi,This is a strange question. We have a server with some database on it, mostly created by consultants for prove of concept kind of deals.Now when I tried to connect by SSMS, it said the evaluation period has expired. So, I upgraded it to SQL1012 enterprise and SP2. I want to restore some database on it under the default instance.What should I do? Btw, I am a member of the admin group. Also, there are other named instances, but I couldn't connect to them either.Thanks!Now it said. TITLE: Connect to Server------------------------------Cannot connect to machineXYZ.------------------------------ADDITIONAL INFORMATION: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) (Microsoft SQL Server, Error: 2)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476------------------------------The system cannot find the file specified |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2015-03-17 : 12:12:46
|
| Look in SQL Server configuration manager to make sure that the SQL Server services are running. The default instance would have the name "SQL Server (MSSQLSERVER)". If there are other SQL Server services running, the name in the brackets is the instance name.If the services are running, check if you can connect to that server locally, i.e., from the server box.If you are able to do that, but not able to connect to it from a remote machine using SSMS you will need to trouble-shoot. This is a good article on how to http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-17 : 12:16:41
|
| Determine the port (error log, registry or Config Manager) and then connect with ServerName,PortNumber.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2015-03-17 : 12:23:35
|
| Thank you for both of your replies!I remoted into the box, and under configuration manager, there is No service listed under SQL Server Services.I think I need to start with the SQL install instead of just upgrade from eval to full edition. |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2015-03-17 : 14:32:48
|
| You should be able to upgrade from EVAL to FULL, at least based on the info here: https://technet.microsoft.com/en-us/library/ms143393%28v=sql.110%29.aspx |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2015-03-17 : 16:45:29
|
| I did upgrade successfully. However, none of the services are there, and it wouldn't connect. |
|
|
|
|
|
|
|
|
how to reclaim default instance?