Avatar of Dragon0x40
Dragon0x40
 asked on

SQL server 2008 windows authentication

I have an application that I am trying to connect to a SQL server database but I keep getting an error that it cannot connect?

I am using windows authentication on the application wizard and on the SQL server.

The user account that I am putting into the wizard is on the sql server and is not disabled and seems to have the same permissions as the sa account which is disabled.

What is windows authentication comparing?

I can telnet to the sql server on port 1433 and it seems the port is open.

Does the accounts that are in the log on tab for the sql server services have anything to do with the windows authentication?

It seems like it should be easy to connect as both the sql server and the client computer are members of the same domain.

I think that I know the general steps to follow but I am new to sql administration so I probably having some huge gaps in my knowledge.

I got it working before using sql authentication which I guess has less configuration and things to go wrong.

Just had to enable the sa account, make sure both sides were using sql authentication and the same username and password and it connected.
DatabasesMicrosoft SQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Dragon0x40

8/22/2022 - Mon
SOLUTION
Matt Bowler

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
pinaldave

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Guy Hengel [angelIII / a3]

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Dragon0x40

ASKER
I will have the servers up again soon and will post results.
Dragon0x40

ASKER
My VM crashed so I can not recreate problem thanks for the help
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck