February 28, 2012 at 2:12 am
Hi
I am having problems connecting to a local instance of sqlexpress.
ive tried (local)\sqlexpress but i get the error saying that the server cant be found
i click on browse for more and i get the list including [database engine, analysis services, reporting services, sql server compact databases, integration services] and the only node with anything in is the INtegration services.
Can anybody help please?
Thanks in advance
February 28, 2012 at 2:15 am
what is the error message you are getting?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
February 28, 2012 at 2:20 am
cannot find instance of the server
February 29, 2012 at 4:10 am
Start with the basics--if you run SQL Server Configuration Manager, does it show your local SQLEXPRESS instance under SQL Server Services? If so, is that service running?
February 29, 2012 at 6:38 am
If it is SQL Server Express Edition, the TCP/IP connection type may not be turned on by default. To check, go to Start > All Programs > find the SQL server install > Configuration Tools > SQL Server Configuration Manager.
Expand all the + signs, and click on each Protocols line. For normal Server-type usage of SQL Server, where people all connect to the same database, turn off Shared memory, and turn on TCP/IP. May need to also turn on Named Pipes, according to whether you are connecting using legacy connection methods. At least turn on TCP/IP. For the order, make TCP/IP first, and if turned on, Named Pipes second.
Do this for all protocols lines (Client Protocols, protocols for MSSQLSERVER, etc.).
Changing these values requires that the SQL Server service be shut down and restarted. Can also reboot the server, up to you.
Once that is done, recheck connection ability.
At least something to try.
February 29, 2012 at 6:45 am
Pretty sure you don't need TCP/IP to connect to a local SQL installation. Connecting over the network from a remote machine is a different matter.
February 29, 2012 at 7:29 am
Sorry, didn't notice the "local" part. Back to lurk mode.....
February 29, 2012 at 3:55 pm
dunne.neal (2/28/2012)
HiI am having problems connecting to a local instance of sqlexpress.
ive tried (local)\sqlexpress but i get the error saying that the server cant be found
i click on browse for more and i get the list including [database engine, analysis services, reporting services, sql server compact databases, integration services] and the only node with anything in is the INtegration services.
Can anybody help please?
Thanks in advance
check the list of running sql services and verify the correct instance name
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply