CODEWITHSUNDEEP
sql-server-2005
SidharthRoy
SidharthRoy

Reputation: 11

Issue in installing SQL Server 2005

Before I have SQL Server 2005. It's gotten corrupted so I uninstalled and tried to installing a new one. While installing, the following error appears, but installed in Windows Authentication mode.

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually.

But when I tried to log in, the following error will appear:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

Upvotes: 1

Views: 1402

Answers (1)

Asif
Asif

Reputation: 2677

For your login issue check the following steps

  1. Run SQL Server Configuration Manager.
  2. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
  3. Make sure TCP/IP is enabled.

Check this link for detail.

http://support.webecs.com/KB/a375/how-do-i-configure-sql-server-express-to-allow-remote.aspx

Upvotes: 1

Related Questions