Hello,

I am running SQL server on my machine for the first time and have very
little experiance with this application. I am running this app on my machine
only (the client) and am attempting to log on using the Management Studio.
Unfortunately, the application does not seem to recognize my computer
identity. As I understand it, if I am not connected to a server machine,
then the SQL application should recognize my client machine as the local
server, right? Unfortunately, I cannot connect. I must be doing something
wrong.

Here are the steps I have taken:

1- Installed SQL with analysis services
2- accessed SQL Server Management Studio
3- logon screen appears: Server Type = Database Engine, Server Name =
(blank), Authentication = Windows Authentication.
4- The scoll-down list in Server Name is also blank so I located my computer
identity and entered it. I was unable to connect.

Please help!

srain

In the Server Name box, type the name of the computer.
If you installed a named instance (or SQL Server Express Edition which is a
named instance) then type the ComputerName\InstanceName, for example
testmachine\SQLEXPRESS
Extra info:
- In Management Studio, on the View menu, click Registered Servers. If your
server isn't listed, right-click Database Engine and then click Update Local
Server Registration. This will make it easier to connect to the instance on
the local computer.
- If you installed a named instance, you many need to start the SQL Server
Browser Service.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"srain001" <srain001 (AT) discussions (DOT) microsoft.com> wrote

In the Server Name box, type the name of the computer.
If you installed a named instance (or SQL Server Express Edition which is a
named instance) then type the ComputerName\InstanceName, for example
testmachine\SQLEXPRESS
Extra info:
- In Management Studio, on the View menu, click Registered Servers. If your
server isn't listed, right-click Database Engine and then click Update Local
Server Registration. This will make it easier to connect to the instance on
the local computer.
- If you installed a named instance, you many need to start the SQL Server
Browser Service.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"srain001" <srain001 (AT) discussions (DOT) microsoft.com> wrote

In the Server Name box, type the name of the computer.
If you installed a named instance (or SQL Server Express Edition which is a
named instance) then type the ComputerName\InstanceName, for example
testmachine\SQLEXPRESS
Extra info:
- In Management Studio, on the View menu, click Registered Servers. If your
server isn't listed, right-click Database Engine and then click Update Local
Server Registration. This will make it easier to connect to the instance on
the local computer.
- If you installed a named instance, you many need to start the SQL Server
Browser Service.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"srain001" <srain001 (AT) discussions (DOT) microsoft.com> wrote

In the Server Name box, type the name of the computer.
If you installed a named instance (or SQL Server Express Edition which is a
named instance) then type the ComputerName\InstanceName, for example
testmachine\SQLEXPRESS
Extra info:
- In Management Studio, on the View menu, click Registered Servers. If your
server isn't listed, right-click Database Engine and then click Update Local
Server Registration. This will make it easier to connect to the instance on
the local computer.
- If you installed a named instance, you many need to start the SQL Server
Browser Service.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"srain001" <srain001 (AT) discussions (DOT) microsoft.com> wrote

In the Server Name box, type the name of the computer.
If you installed a named instance (or SQL Server Express Edition which is a
named instance) then type the ComputerName\InstanceName, for example
testmachine\SQLEXPRESS
Extra info:
- In Management Studio, on the View menu, click Registered Servers. If your
server isn't listed, right-click Database Engine and then click Update Local
Server Registration. This will make it easier to connect to the instance on
the local computer.
- If you installed a named instance, you many need to start the SQL Server
Browser Service.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"srain001" <srain001 (AT) discussions (DOT) microsoft.com> wrote

In the Server Name box, type the name of the computer.
If you installed a named instance (or SQL Server Express Edition which is a
named instance) then type the ComputerName\InstanceName, for example
testmachine\SQLEXPRESS
Extra info:
- In Management Studio, on the View menu, click Registered Servers. If your
server isn't listed, right-click Database Engine and then click Update Local
Server Registration. This will make it easier to connect to the instance on
the local computer.
- If you installed a named instance, you many need to start the SQL Server
Browser Service.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"srain001" <srain001 (AT) discussions (DOT) microsoft.com> wrote

In the Server Name box, type the name of the computer.
If you installed a named instance (or SQL Server Express Edition which is a
named instance) then type the ComputerName\InstanceName, for example
testmachine\SQLEXPRESS
Extra info:
- In Management Studio, on the View menu, click Registered Servers. If your
server isn't listed, right-click Database Engine and then click Update Local
Server Registration. This will make it easier to connect to the instance on
the local computer.
- If you installed a named instance, you many need to start the SQL Server
Browser Service.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"srain001" <srain001 (AT) discussions (DOT) microsoft.com> wrote

In the Server Name box, type the name of the computer.
If you installed a named instance (or SQL Server Express Edition which is a
named instance) then type the ComputerName\InstanceName, for example
testmachine\SQLEXPRESS
Extra info:
- In Management Studio, on the View menu, click Registered Servers. If your
server isn't listed, right-click Database Engine and then click Update Local
Server Registration. This will make it easier to connect to the instance on
the local computer.
- If you installed a named instance, you many need to start the SQL Server
Browser Service.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"srain001" <srain001 (AT) discussions (DOT) microsoft.com> wrote

In the Server Name box, type the name of the computer.
If you installed a named instance (or SQL Server Express Edition which is a
named instance) then type the ComputerName\InstanceName, for example
testmachine\SQLEXPRESS
Extra info:
- In Management Studio, on the View menu, click Registered Servers. If your
server isn't listed, right-click Database Engine and then click Update Local
Server Registration. This will make it easier to connect to the instance on
the local computer.
- If you installed a named instance, you many need to start the SQL Server
Browser Service.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"srain001" <srain001 (AT) discussions (DOT) microsoft.com> wrote