Ann K
asked on
Login Error
Can you please tell me how to fix that error?
Vitor Montalvão
In the Server Name field, instead of (local), type the server name that you want to connect to.
ASKER
i don't know the server name.
How do you want to connect to a server that you don't know the name?
ASKER
Where can i find the server name?
Ok, let's rewind and go to the starting point.
Tell us what do you want to do and we'll try to guide you.
Tell us what do you want to do and we'll try to guide you.
From the SQL Server configuration tools open the SQL Server Configuration Manager as shown below :
Here check the SQL Server Instance Name
then enter it as Domain Name\Server Name
Here check the SQL Server Instance Name
then enter it as Domain Name\Server Name
ASKER
Trying to enter into ssms
The domain name is your My Computer Properties
ASKER
Where is the server name?
Select the SQL Server Services (as shown in ID: 42330807)
ASKER
There is nothing their.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How to install sql server?
try this .\
ASKER
I tried in the server name but got the same error.
Ann, you'll need the SQL Server setup media.
What version and edition do you need or want to be installed?
What version and edition do you need or want to be installed?
ASKER
I am using 2008 version.
You can try the SQL Server 2017 Express Edition. It's free and can be downloaded here.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You.
Ann, please explain the comment that you choose as an answer.
If you don't have SQL Server installed how could you start the service? It shouldn't even appear in the Services.
If you don't have SQL Server installed how could you start the service? It shouldn't even appear in the Services.