> Hello!
>
> I have been messing with this all day and it is beginning to aggrivate me.
> I am installing an instance of SQL Server 2005 on one of our machines to
> support WSUS and SCOM 07. I installed it a bit differently because I
> wanted
> the data files in a specific location and I dont know if that woudl cause
> this problem (i doubt it but you never know) To start the installation I
> type at the run prompt:
>
> E:\Servers\setup.exe INSTALLSQLDATADIR=D:\MSSQL2005\DATA\
>
> Where E is the optical drive
>
> After the install I also installed SP2. When i go to connect to and
> manage
> the instance using 2005 management studio I get the following error:
>
> ===============================================
>
> TITLE: Connect to Server
> ------------------------------
>
> Cannot connect to EARTH-PA\SQLSERVER2005.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified) (Microsoft SQL Server, Error: -1)
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
>
> ===================================================
>
> I should note that this is SQL Server 2005 Standard, meaning that by
> default
> remote connections are enabled (even though I am not connecting
> remotely...I
> am trying to connect on the same machine on which it is installed) I
> verified that remote and local connections were enabled in SQL Server
> Surface
> Area Configuration.
>
> Any ideas as to what could be causing this? Could it be possible that
> starting the installer that way is throwing it off? In configuration
> manager
> it has the default locations of the master etc databases set properly.
>
> Any help would be much appreciated...thanks!