July 12, 2017 at 5:49 am
"Can not access / login to SQL Server" [Sql Server 2014 Express]
Q1: Is there a way to fix this problem?
When I installed this instance as MYSVR\Admin, I was under the impression that the sa account could be used to gain access and that the system would create a windows account for the user (MYSVR\Admin) who installed it. I set an sa password and configured it for dual login (windows + user/password). Neither account seem to be on this instance! Or something else prevents me connecting.
So I configured this instance to start in single user mode (startup parameter -m) in the belief than any valid user could gain access, and that a valid windows user would be mapped to a local sql server admin account. [ Q2: Does it still work that way with Sql Server 2014 Express? ]
In computer management, Services. It now shows:
Name: SQLEXPRESS
Status: Running
Startup Type: Automatic
Log On As: Local System
So now I try to connect to the running service via SQL Server Man Studio:
Server Name: MYSVR\SQLEXPRESS
Authentication: Windows
User Name: MYSVR\Admin
While I am logged on to this server using the MYSVR\Admin account. It just throws back "A network-related or instance specific error occurred while establishing a connection to Sql Server." [Error: 2]
July 12, 2017 at 6:02 am
mark4asp - Wednesday, July 12, 2017 5:49 AMthat the system would create a windows account for the user (MYSVR\Admin) who installed it.
Only if you told the setup to do so 😉
Mark4asp - Wednesday, July 12, 2017 5:49 AMOr something else prevents me connecting.
Very likely
Mark4asp - Wednesday, July 12, 2017 5:49 AMSo I configured this instance to start in single user mode (startup parameter -m) in the belief than any valid user could gain access
You need to understand what constitutes a valid user.
The user must be a member of the local administrators group on the Windows machine
Mark4asp - Wednesday, July 12, 2017 5:49 AM
While I am logged on to this server using the MYSVR\Admin account. It just throws back "A network-related or instance specific error occurred while establishing a connection to Sql Server." [Error: 2]
Check sql server configuration manager to see if the service is actually running
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2017 at 6:36 am
Is there anything relating to network protocols or the login failures in the ERRORLOG file?
path similar to:
C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\Log
And are you connecting locally on the box, or remotely from another? SSMS?
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply