| Author |
Topic |
|
Jay123
Yak Posting Veteran
54 Posts |
 Posted - 2010-01-17 : 14:46:01
|
| TITLE: Connect to Server------------------------------Cannot connect to JAY-TOSH\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: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476------------------------------BUTTONS:OK------------------------------This is the error message i get when i try to connect to sql.it is installed on my laptop and im the only one who uses it.i use windows authentication.and it worked fine on thursday (the last time i turned it on).Any Ideas |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Jay123
Yak Posting Veteran
54 Posts |
Posted - 2010-01-18 : 08:40:52
|
quote:
Originally posted by tkizer
Is the SQL Server service started?
sorry what do you mean. The program loads but it doesnt let me connect. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Jay123
Yak Posting Veteran
54 Posts |
Posted - 2010-01-18 : 15:36:31
|
quote:
Originally posted by tkizer
Go to Control Panel..Admin Tools..Services. And then find the SQL Server service and check it is in a started state.
There are 2sql server (mssqlserver)andsql ser (sqlexpress)the mssqlserver is stated but the sqlespress is not.when i try to start it i get the following error:windows could not start the sql server on local computer: 1096 the service did not start due to logon failiersomeone told me this is due to incorrect password. But:i use windows authentication.i am the only one who uses this machine and password has been the same since the start.it was working fine when i turned it off and then out of noware it stoped.What do you think... Thanks. |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-01-18 : 16:57:10
|
| The service itself runs within a security context (e.g., Windows User/Password). If the User/Password used by the service are no longer valid, then the service won't start and your SQL connection will fail with exactly the message that you have encountered. So, if the service can't start, you need to resolve that before anything else will matter. As a test, try to log into Windows using the same User/Password that the SQL Service is trying to use.=======================================Few things are harder to put up with than the annoyance of a good example. (Mark Twain) |
|
|
|
Jay123
Yak Posting Veteran
54 Posts |
Posted - 2010-01-18 : 17:27:23
|
| Bustaz Kool that was spot on. the only thing i changed was the password for my account.so, it now lets me start the service, But sql still does not connect. it still gives the error i stated in the first post. do i have to start some of the other services, i noticed there are a few more. i tried to insert a screenshot but it this site doesent allow attachments.anyways what do you think. Thanks... Jay |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-18 : 18:13:42
|
| You have two SQL instances installed, the default and a named instance (SQLEXPRESS). Make sure you are attempting to connect with either HostName or HostName\SQLEXPRESS, where HostName is the name of your computer. If you are unsure what your computer is named, you can type in hostname into a cmd window (Start..Run..cmd).Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
Jay123
Yak Posting Veteran
54 Posts |
Posted - 2010-01-19 : 10:21:56
|
quote:
Originally posted by Jay123
TITLE: Connect to Server------------------------------Cannot connect to JAY-TOSH\SQLEXPRESS.------------------------------
that cant be the problem, In my first post. that is how i connect.any ideas why there is two. i only installed 1. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-19 : 13:21:14
|
| Is it worth "stopping" the service for one, whilst you try to work out how to Connect to the other?Assuming no one is using the other one that would stop you connecting, or trying to, to the wrong one during testing, and probably reduce the number of times around the merry-go-round quite a bit. |
|
|
|
Jay123
Yak Posting Veteran
54 Posts |
Posted - 2010-01-21 : 06:40:08
|
| Still no joy, i have played around with the services but it still doesnt log me in.still getting the error stated in the first post.if i cant find the problem soon im gona cheat and uninstall and reinstall sql.but i would like to find the problem if possible.Thanks |
|
|
|
|
cannot connect to JAY-TOSH\SQLEXPRESS