Creating a new Server in SQL Server 2008

[anarchy-rabbit]

Hi,

I want to create a new server/server instance (?terminology?) in SQL Server 2008. When I open the Server Management Studio, at the server name it says "CLINT-LT\LOCALHOST'', the one I am connecting to. But I want to connect to "localhost", but when I type this in I get an error..

Any suggestions? I tried googling but no success, I think my teminology may be wrong in my search terms.

Thanks

 

[anarchy-rabbit]

Lol, I just came accross my own post in google

 

[Deenem]

To create a new instance you need to run the setup program and in one of the first screens you'll have an option to add a new instance to an existing server.

Not quite sure what you've done, but if the connection says 'CLINT-LT\LOCALHOST', then CLINT-LT is the name of the server and LOCALHOST is the name of the instance. Your LOCALHOST is not the same as TCP/IP localhost (127.0.0.1), you've actually got a database instance on CLINT-LT called LOCALHOST, (which confusingly, probably isn't listening on TCP/IP address localhost)

A default install of SQL 2008 only listens on shared memory, (local), not on TCP/IP or Named Pipes. You'll need to go into Network Configuration and enable TCP/IP to be able to connect on TCP address localhost.

 

[anarchy-rabbit]

Ahh, thanks Deenem for clearing this up! I'm not very clued up with the SQL Server installation, for me it's all about the defaults and the "Next" button

Since htis is the case I'll just keep it as it is. Not a major issue, just need to reconfigure the datasource in VB when I work at home.