Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Adding a subsciber to a merge replication

Author  Topic 

SamLogan
Starting Member

2 Posts

Posted - 2011-04-20 : 14:10:46
TITLE: Connect to Server
------------------------------

Cannot connect to TC04\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

Failed to connect to server TC04\SQLEXPRESS. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible.
Verify that the instance name is correct and that SQL Server is configured to 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

------------------------------
BUTTONS:

OK
------------------------------

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-20 : 15:24:37
So did you try enabling remote connections on the SQL Express instance?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

SamLogan
Starting Member

2 Posts

Posted - 2011-04-20 : 15:39:12
If you mean "Allow remote connectionsto this server" yes it is checked.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-20 : 15:47:43
Here you go then: http://weblogs.sqlteam.com/tarad/archive/2008/05/23/60609.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-04-28 : 08:26:53
checkout the login that ur using to connect. u need to give a login which exists at subscriber
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-28 : 12:29:00
This error is not a user account problem.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -