Wednesday, March 7, 2012

Error connecting to instance using Server Management Studio

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:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=-1&LinkId=20476[/url]
================================================== =
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!
1. Check if your instance is running (I know, I know :-)).
2. Check if SQL Server Browser service is enabled and is running.
3. Check the TCP/IP port of the instance (use Configuration Manager). Set
static port.
4. If steps 1 and 2 did not help try to connect to the instance with SSMS
using the following instead of EARTH-PA\SQLSERVER2005:
tcp:EARTH-PA,<port_number_set_in_step_3>
Regards
Pawel Potasinski
Uytkownik "Ehren" <Ehren@.discussions.microsoft.com> napisa w wiadomoci
news:AD3DDD41-6FB3-438A-A3FD-418FB466961D@.microsoft.com...
> 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:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLS erver&EvtID=-1&LinkId=20476[/url]
> ================================================== =
> 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!

No comments:

Post a Comment