Local instance registration on 2005

I just installed the workstation components for SQL 2005 and have opened
Management Studio.
I am trying to register a local instance for testing and am not having any
success. If I select "New" under database engines, I do not have any local
servers to choose from. If I attempt to enter my local computer name for the
server name in New Server Registration properties, it will not connect.
Any idea how to set up a local instance?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1Reading you text I see that you installed the Workstation components and then try to access a local
instance. But the Workstation components doesn't include the database engine...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message news:5da4d493ce717@.uwe...
>I just installed the workstation components for SQL 2005 and have opened
> Management Studio.
> I am trying to register a local instance for testing and am not having any
> success. If I select "New" under database engines, I do not have any local
> servers to choose from. If I attempt to enter my local computer name for the
> server name in New Server Registration properties, it will not connect.
> Any idea how to set up a local instance?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||I have "Database Engine".
In SQL 2K you could register a server as [local].
How is that done in SQL 2005?
Tibor Karaszi wrote:
>Reading you text I see that you installed the Workstation components and then try to access a local
>instance. But the Workstation components doesn't include the database engine...
>>I just installed the workstation components for SQL 2005 and have opened
>> Management Studio.
>[quoted text clipped - 5 lines]
>> Any idea how to set up a local instance?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1|||cbrichards via SQLMonster.com wrote:
> I have "Database Engine".
> In SQL 2K you could register a server as [local].
> How is that done in SQL 2005?
> Tibor Karaszi wrote:
>>Reading you text I see that you installed the Workstation components and then try to access a local
>>instance. But the Workstation components doesn't include the database engine...
>>
>>I just installed the workstation components for SQL 2005 and have opened
>>Management Studio.
>>[quoted text clipped - 5 lines]
>>Any idea how to set up a local instance?
>
Where do you have "Database Engine"? You can check under services if you
have sqlserver service and if it's running. If it's there it should be
running. If it isn't there, you haven't installed the database engine.
Regards
Steen|||I do have sqlserver service running.
Under registered servers when I right click on [local computer name]\
SQLExpress, then select connect, I get an error saying I cannot connect to
the above instance with "error 26 - Error Locating Server/Instance Specified"
Steen Persson (DK) wrote:
>> I have "Database Engine".
>[quoted text clipped - 11 lines]
>>Any idea how to set up a local instance?
>Where do you have "Database Engine"? You can check under services if you
>have sqlserver service and if it's running. If it's there it should be
>running. If it isn't there, you haven't installed the database engine.
>Regards
>Steen
--
Message posted via http://www.sqlmonster.com|||cbrichards via SQLMonster.com wrote:
> I do have sqlserver service running.
> Under registered servers when I right click on [local computer name]\
> SQLExpress, then select connect, I get an error saying I cannot connect to
> the above instance with "error 26 - Error Locating Server/Instance Specified"
>
> Steen Persson (DK) wrote:
>
Have you tried to go through the SQL Server Configuartion Manager and/or
SQL server Surface Area Configuatio? Maybe there're something you're
missing to setup/enable.
Regards
Steen