Post reply

Problem connection Microsoft SQL Server Management Studio to SQL Server Express 2008

  • May 13, 2012 at 6:29 am

    #260815

    Hi

    I have just installed Microsoft SQL Server Management Studio and SQL Server Express 2008 on my local computer. Both applications seem to be running fine. I can connect to sql server from management studio using;

    Server name: myComputerName\SQLEXPRESS2008

    Authentication: SQL Server Authentication

    Login: golee

    Password: xxxxxx

    But I can't connect using details, change to localhost

    Server name: localhost

    Authentication: SQL Server Authentication

    Login: golee

    Password: xxxxxx

    I have enable TCP/IP port and all there too.

    Please could some one help.

    Many thanks

  • May 13, 2012 at 6:41 am

    #1486851

    Do you actually have a default instance on your computer? Localhost will be trying to connect to a server called "Mycomputer" (i.e. your computer name). You SQLExpress installation instance is called "<yourcomputername>\SQLExpress2008" . "localhost" will find nothing to connect to unless you have installed SQLserver twice, once as a "Default" instance.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply