I install SQL SERVER 2005 on my Windows 7 machine. Now, when connecting to the server there is nothing being displayed in the Server Name. Am I missing something?
Same happens with SQL SERVER 2000!
Personally, before I listen to any other replies on this I would apply the latest service pack to the SQL 2005 immediately. Most likely the service pack will fix the problem.
You mean that if you do the following, it returns NULL?
SELECT @@SERVERNAME
You can use this to set the server name:
sp_addserver <new_name>, 'local'
I think you will need to restart the MSSQL service.
You'll most likely want to use "(local)" to connect to your local instance. Is it named? If so, you need to specify that too:
(local)\myinstancename
Make sure the SQL service is running..
Sounds like the Windows account you're using doesn't have permissions to access the database instance (are you an administrator?). Try logging in using SQL authentication as sa and then adding your Windows account to Logins (Security > Logins).