hi
I'm going to use Enterprise edition
when I want to log in Managment Studio I face a window asking me for Server Name in addition to Server Type and authentication mode.
what should I write in Server Name section.I know the format is:
ComputerName\Instance Name
but what should I write in Instance Name?
thanks
Hello -
If you've installed SQL Server on the system with all the defaults, you don't have to type anything in the instance name. It's just the name of the server. If you installed SQL Server Express, it installs as a named instance by default. Usually it is named SQLExpress, so the name would be:
(your Server name)\SQLEXPRESS
To find out if the server is default or named, open a command prompt in Windows and type this:
NET START
Look for the service that starts with "SQL Server" in the name and to the right you'll see if it is a named instance or not. It will have the name of the instance in parenthesis, and if it is MSSQLSERVER it's default, and you don't have to type anything other than the server name. If it has something else there, it is named and that is the name you type.
More here: http://www.mssqltips.com/tip.asp?tip=1048
Note: If this answers your question, make sure you mark it "answered" so that others can find it!
Buck Woody
http://www.buckwoody.com
You have to know what the instance name is; we can't tell you that. The best advice I can give you is to launch the SQL Server Configuration Manager (In your Start Menu->SQL Server 2005->Configuration Tools folder), browse to the Services tab, and locate any service that has a Service Type of "SQL Server", and then work from there.
If the service name is "SQL Server (MSSQLSERVER)" then you do not have an instance name (just use the computer name)
If the service name is "SQL Server (SQLEXPRESS)" then use ComputerName\SqlExpress
Check out my SQL Server 2005 video tutorials: http://www.learnsqlserver.com/
|||Where is it? I searched it and it does not come up in my search but when I go to microsoft .com they say it is already on the compuer