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 |
|
fcmessi
Starting Member
2 Posts |
 Posted - 2009-09-21 : 02:53:59
|
| I have SQL Server 2005 newly installed. I opened the management studio in order to start a college project. Now here, it asks for server type which I entered as "Database Engine" and authentication which I entered as Windows Authentication. But what do I enter in server name? When I browse for more there are (naturally) no servers on my PC. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-21 : 03:28:53
|
| If it is the default instance, enter either:- the machine name- .- localhostOprn the configuration manager to get the server name. |
 |
|
|
fcmessi
Starting Member
2 Posts |
Posted - 2009-09-21 : 03:36:56
|
| On entering ./localhost/machine name, I am getting the following error:"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, the failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. [provider: Named Pipes Provider, error 40: Could not open a connection to SQL Server)(Microsoft SQL Server, Error: 2)" |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-21 : 07:39:39
|
| Open up SQL Server Configuration Manager from Start --> Programs...Ensure that the "SQL Server(MSSQLSERVER)" service is running.Check that the "Named Pipes" protocol is enabled in the Network Configuration tab. |
|
|
|
|
|
|
Setting up SQL Server 2005