CODEWITHSUNDEEP
sql-serversql-server-2012
Jamie Tayam
Jamie Tayam

Reputation: 1

Wrong SERVER NAME in SQL Server 2012

First, I started the SQL Server Browser in SQL Server Configuration Manager, because it was stopped. No problem to that, done. Next I started the SQL Server Agent, but there was an error:

"The request failed or the service did not respond in a timely fashion. . .".

I also fixed that in SQL Server Instance name properties. Then I successfully started the SQL Server Agent. Then, I tried to go and put the server name in SQL Server 2012..

BUT THERE'S STILL AN ERROR! I don't know what to do any more. The server name is default. MSSQLSERVER I tried to put MSSQLSERVER, PCNAME\MSSQLSERVER... error is still there. what should I do?

Upvotes: 0

Views: 197

Answers (1)

marc_s
marc_s

Reputation: 754200

The MSSQLSERVER service is the default, un-named instance - which means you can connect to it using a server/instance name of:

  • .
  • (local)
  • localhost
  • pcname

The point is: it's the unnamed instance, so you don't have to specify any instance name like MSSQLSERVER at all

Upvotes: 1

Related Questions