Menu
I want to install SQL Server 2008 R2, so I need to put "server name", I tried my computer name but I got an exception, would you tell me how to find it please
and this is the exception ![enter image description here][2]
779
If so, please note that when your SQL Server instance is installed as a default instance named “MSSQLSERVER” , you can use ".","localhost" or "(local)" to connect to it.
In the Server name box, type the name of the instance of the Database Engine. For the default instance of SQL Server, the server name is the computer name. For a named instance of SQL Server, the server name is the <computer_name>\<instance_name>, such as ACCTG_SRVR\SQLEXPRESS.
Use MachineName property to get the computer name on which the SQL Server instance is running. For a cluster, it returns the virtual server name. Select SERVERPROPERTY('MachineName') as 'MachineName'.
You can use .\SQLEXPRESS as the server name.
Check this link
EDIT:-
From the comments below posted by the user(thought that it is useful)
You can install SQL Server as an instance, which allows you to run multiple environments on the same machine (ie. localhost\dev and localhost\prod). If you install MSSQL Server Express, it defaults the instance name to localhost\SQLEXPRESS
124
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
