SQL Server 2008 install

ringo747 · 3 Mar 2010 at 21:17

I have just completed the install of the above on a VM and added SP1. For some reason I cannot see the DB in SQL Management studio. All the processes are running and I am using the correct login credentials.

Any ideas? It is a local instance so I don't think it would be a firewall issue.

Really tearing my hair out with this one.

ringo747 · 4 Mar 2010 at 09:44

I have just installed SQL, patched with SP1 and thats it.

I want to connect to the management studio to add certain users as SQL Admins.

There is no database created as yet. Should I not see a listing under the local servers tab?

ringo747 · 4 Mar 2010 at 10:39

Yes sorry, the first post maybe was a bit confusing.

I can't actually connect to the server instance. I am getting an error in the error log:

Login failed for user Username Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.

It's something to do with UAC blocking it apparently.

ringo747 · 4 Mar 2010 at 11:54

Running as administrator didn't work, UAC turned off, firewall off.

I did install using default instance name. I have tried the machine name and instance name but no luck getting logged in.

It might be a user login issue perhaps. Really can't understand it.

ringo747 · 4 Mar 2010 at 12:30

All sorted. It was a bit of a stupid one actually.

During the install I had only added a domain account to be the main administrator and also enabled only windows authentication.

Had to use sqlservr.exe -m to run local instance then add my current user account to the security list.

All sorted now.