Cannot Login to SQL Server Database (New Instance)

[mickeyj2]

Hi,

I'm having trouble logging into my SQL Server Database Engine.

Here's what I did:
1. I installed SQL Server 2005 Developer Edition on an XP Pro machine.
2. I put the machine on my company's network. In doing this, XP Pro asked me to identify the machine with a valid network login. (I used the same login that I use to connect my other "regular computer" to the network.) This was sucessful because I could see the SQL DB machine on the network.
3. After rebooting my SQL DB machine, I am now asked for a login. I login to my company's domain sucessfully.
4. Now when I access SQL Server 2005 and try to connect to the database, I get the message: "Login failed for user {DOMAIN\username} (MS SQL Server, Error 18456)." This DOMAIN\username is the same that I use for Windows Authentication.

Here's what my login screen looked like:

Server type: Database Engine
Server name: {NAME OF MY SQL DB COMPUTER}
Authentication: Windows Authentication
Username: {DOMAIN\user}
Password: {blank}

Also, if I try to use SQL Server Authentication, using "sa" as the username and a blank password, I can't login either. (I haven't been able to setup a login.)

How can I get around this? Do I need to take the machine off the network? Also, I heard that if you're not running Windows 2000 or 2003, then you can't use Windows Authentication. Is that true?


Thanks in advance.

 

[mickeyj2]

Hey,
I solved my own problem. How about that?

If anyone else is having the same trouble, the fix was I re-created my Username {DOMAIN\user} and verified that it had Administrator rights.

You can do this in the Windows Network ID Wizard. Its the screen that asks "What level of access do you want to grant to DOMAIN\user".

Hope this helps someone in the future.