4 replies to this topic

[newphpcoder]

Good day!
I am newly in SQL Server 2005 and now I encountered error when i try to login. This is some of the information:

Microsoft SQL Server 2005 Express Edition

Server Type: Database Engine
Servername:Servername\MSFW
Authentication:SQL Server Authentication
Login: sa
Password:xxxx

and when i press the connect button the error appear:

Error:
Cannot connect to Servername\MSFW

Additional Informations:
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may becaused by the fact that under the default settings SQL Server does not allow remote connections.(Provider:SQL Network Interfaces error:26-Error Locating Server/Instance Specified) (Microsoft SQL Server).

I have no idea where i can solve this problem..

Any help is highly appreciated..

Thank you in advance.

[Orjan]

have you written "Servername\MSFW"? I think you shall connect to the server without the \MSFW (database?) added to it, because you select database when you're in.

[newphpcoder]

Orjan said:

have you written "Servername\MSFW"? I think you shall connect to the server without the \MSFW (database?) added to it, because you select database when you're in.

You mean i only put Servername in the Server Name, so ideleted the \MSFW?

by the way what is MSFW?

[WingedPanther]

Also, you may want to check your services and check that SQLserver is running.

[gokuajmes]

Ok here are troubleshooting steps:
1. Start - > Run -> Services.msc
To Do: a)Check if Sql Server Browser is started and Change start type to Automatic.
b)Check if the SqlServer(SqlExpress) is running and set start up type to Automatic
Follow Up: Now try Connecting
Result: Yet results in a error try step2

2.Start --> Programs -->Microsoft Sql Server 2005/2008 -->Configuration Tools--> Surface Area Configuration
To DO: The above will launch a application. Click the 'Surface Area Configuration for Services and Connections' link at the bottom of dialog. Now expand the 'DataBase Engine' tree and click Remote Connections. Select the Local and remote Connections on the right side. Subselect Using TCP/ip Only
Follow Up: Restart your PC and try connecting
Result: Should Connect

btw you need to install the sql server management studio express before you start executing commands[queries] and note that MSFW is the sqlServer Instance name[ which by default is always SqlExpress unless you changed it at installation]
You need to provide ServerName/InstanceName if you are connecting to a remote system and it should also accept remote connections[step2]