Cannot connect to SQL server using MS SQL Server management studio express
Posted on 2010-11-29
I have installed SQLserver 2005 express on my win xp sp3 32 bit.
Everything was working fine and i was able to login to my server (VIRTUALXP\SQLEXPRESS) using windows authentication. Suddenly I started getting this problem:
Cannot connect to VIRTUALXP\SQLEXPRESS
A network-related or instance-specific error occured while establishing a connection to SQL Server. The Server was not found or was not accessible. Verify that 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)