By login i meant that i had set it at windows authentication...

Oh really! I haven't set any password during installation. It worked fine until i reinstalled.

Any ideas?

Sonia

The authentication mode is sql server authentication.

I tried watever is given in the link. Doens't work for me. 🙁

I added the windows login.

Koen Verbeeck (2/6/2012)

---

Members of the built-in Adminstrators group in Windows are not automatically members of the sysadmin role since SQL Server 2008. Only the one that installed SQL Server is...

Hello,

I checked with my Network admin and he replied saying "You are a admin on this Windows 7 VM so you can just terminal service in to do anything including...

When i ran SELECT IS_SRVROLEMEMBER('sysadmin');

It resulted '0'.

Looks like i have not been assigned admin permissions.

sonia

Looks like i dont have the SQL Server Configuration Manager installed. I dont see it under configuration tools.

Hello! Thanks for replying.

My Network Engg in the US has done it for me.

He has just provided me with the instance name saying that i am an Admin there.

I...