April 17, 2006 at 1:14 pm
when trying to connect to the sql 2000 server i read that you have to enter the connectiion as machine\dsn
but in visual studio 2005 when i enter SQL01\Servicing i get an error. and if i remove the SQL01\ i get
Err: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
what is the problem here?
April 17, 2006 at 8:13 pm
is your SQLServer installed as Multiple Instance ?
If it is, you specify the SQLServer by referencing the machinename\instancename
If you install as default instance, you can reference it with machinename (without the '\')
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply