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.

oddjob62 · 3 Mar 2010 at 22:38

Which database can't you see? Can you stick a screenshot of what you can see?

Yamahahahahaha · 3 Mar 2010 at 22:40

1) Are you sure you're logged into the right SQL instance?
If so;
2) Are you sure the DB has been mounted?

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?

oddjob62 · 4 Mar 2010 at 10:36

Ok, are you saying you can't actually connect to the SQL server with Management Studio? I infered from your OP that you had at least got that far.

If not, then make sure TCP/IP has been enabled in SQL Server Config Manager

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.

PAz · 4 Mar 2010 at 11:42

Right click SQL Management studio and run as administrator if you are launching it from the server

unclepablo · 4 Mar 2010 at 11:44

I've done several SQL 2008 installs recently on Windows 2008/Windows 7.

When you installed SQL, did you just leave the default instance name? If so, just try entering the machine name in the Management Studio login rather than any instance name.

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.