October 18, 2014 at 1:57 am
Hi All,
I am using sql server 2012 past 1 year. It is installed on my laptop and it's my organisations laptop not my personal one.
Till 3-4 days back it was running ok when I was connecting the database engine with the local server either by dot(.) or my laptop name using the sql server authentication(using sa).
Suddenly It stopped connecting to my local server and giving error like.
[
TITLE: Connect to Server
------------------------------
Cannot connect to LAP022-PC.
------------------------------
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
------------------------------
The system cannot find the file specified
------------------------------
BUTTONS:
OK
------------------------------
]
I am using the same password that I was using previously and there is no change in it. I was connecting the same with the saved password and suddenly it started giving this error. Although I tried to connect to clinet sqls server with the same and it is running successfully without any error.
I don't want to re-install the same and want to fix the same. Do you have any idea why it is done like that and how can I fix it.
thanks in advance.
ammy
October 18, 2014 at 3:17 am
First thing, go to sql server configuration manager and check the protocols, check the services states. After changes restart the services.
Second thing could be the Firewall, but since you've installed it on your laptop it should not be the issue.
Do you have more than one instances? In case of, then Browser service should be running in order as well.
This video is useful - https://www.youtube.com/watch?v=1k00z82u4OI
Igor Micev,My blog: www.igormicev.com
October 18, 2014 at 3:42 am
Quick thought, in command prompt run "net start", the sql server instance will show up in the output if running, if not, start the instance.
😎
October 18, 2014 at 4:21 am
Thanks for your reply on the services.
I checked the services "SQL Server(MSSQLSERVER) is not running. When I am trying run the same and refresh the settings it again gets stopped automatically.
Is there a possibility of virus attack? :w00t:
Also, once this was not working I installed a new Named instance but same issue with it too. Browser service is also running.
October 18, 2014 at 4:23 am
What do you see in the Windows Event Log?
😎
October 18, 2014 at 4:31 am
It shows the below error.
[
The log scan number (61:328:1) passed to log scan in database 'model' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
]
October 18, 2014 at 4:47 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply