Last post Jan 30, 2011 05:30 AM by Topspy
Jan 27, 2011 02:38 PM|mylespowell|LINK
I am trying to install SQL Server 2008 R2 on my local computer. I am just trying to make a .bak. I don't need it as a server or anything. It had 2008 on in. I uninstalled all of 2008, and then installed R2. When it installed I can not connect to it to make
my .bak file. The error Could not connect to server, error 26- error locating server/instance specified comes up.
I have ensured that the SQL Browser is running under the computer management, and have turned off the windows firewall (not connected to the net on that machine). I have reinstalled it three times and deleted all the files inbetween installs (Program data,
program files, my docs). I have also 'repaired' it after it has installed. But it won't let me in!
It installs successfully but won't connect. Please help! Thanks for your time.
sql server 2008
Jan 27, 2011 04:56 PM|mylespowell|LINK
Incase in helps the full error is: Cannot connect to \SQLEXPRESS Additional Information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the
instance name is correct and that SQL Server is configured to allow remote connections. (Provider: SQL Network Interfaces, error:25 - connection string is not valid) (Microsoft SQL Server error: 87) Thanks,
Jan 30, 2011 05:30 AM|Topspy|LINK
As a full version sql server, you can use "localhost" or your computer name as the sql server address instead of "\SQLEXPRESS".