August 20, 2008 at 9:16 am
We rebuilt our SQL Server box from bare metal. Joined it to the domain no problem. Before this rebuild the developers were able to access SQL Server using Windows authentication (i.e. without having to specifying a user name or password).
Since this rebuild the Windows authentication doesn't work, and we need to provide a user name and password to access SQL Server.
We've obviously managed to switch something off. Can anyone spot the deliberate error which has caused this?
Ta,
Andrew
August 21, 2008 at 5:38 am
windows authentication is a default, when you rebuilt did you script off any login info before hand? like sql logins, windows logins have to be added to the server too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 22, 2008 at 9:00 am
Right click on SQL Server name in Management Studio and click properties.
Go to the Security Tab
Choose SQL Server and Windows Authentication Mode
Click OK
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply