Local SQLEXPRESS error

Question

Local SQLEXPRESS error

hmsqltech

SSC Rookie

Points: 33
More actions
February 26, 2010 at 3:23 pm

#219457

I have a local sql express server MYNAME\SQLEXPRESS
It has the DEV database
When I run this query on my development SQL server:
Select *
FROM OPENDATASOURCE('SQLNCLI','Data Source=my_ip_address\SQLEXPRESS;Password=mypassword;Persist Security Info=False; User ID=sa;').DEV.dbo.[MyTable]
I get this error:
OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "Login timeout expired".
OLE DB provider "SQLNCLI10" for linked server "(null)" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 65535, Level 16, State 1, Line 0
SQL Server Network Interfaces: Server doesn't support requested protocol [xFFFFFFFF].
Any idea what I am missing?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

What documentation are you using to configure the Linked Server?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

hmsqltech SSC Rookie Points: 33 More actions · Answer 2

hmsqltech

SSC Rookie

Points: 33

February 26, 2010 at 8:56 pm

#1125931

I am sorry, I don't understand your question.

VRR Ten Centuries Points: 1170 More actions · Answer 3

Is your Server is configured to mixed mode authentication?

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

I'm sorry but I will defer to the distiquished members of this forum.

Unfortunately I have gone through some tough times and I do not feel that I could give good advise. 🙁

I'm sure that you will get a significant number of responses to your challenge.

WC AKA Richard

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

kalyan.nimbala Mr or Mrs. 500 Points: 524 More actions · Answer 5

Express doesnt allow remote connections, so please check the requirement....as you can extract data from two tables into your application and you can use LINQ if you are using C# to join the two tables...or you can write query linking servers on the other server only if it is not express edition.....

hmsqltech SSC Rookie Points: 33 More actions · Answer 6

This is what we noticed:

We can access the development server from the SQL express server but not vice versa.

Thanks

Fidel Rodriguez SSC Enthusiast Points: 145 More actions · Answer 7

My advice kind of takes it "from the top."

It sounds like you have a unidirectional firewall rule. Try a simple telnet to the port that SQL is supposedly listening on. You can check the sql configuration checker to confirm the port.

Another thing I'd try is to RDP to the box and then locally (emphasis on locally) telnet into the port and then telnet to the port from the other system. If the former works and the latter doesn't, I would suspect that there's some firewall preventing this. Could be local / software based or actual infrastructure. Give that a shot and see what happens?

If that works, then review the linking documentation --> http://msdn.microsoft.com/en-us/library/ms188279(SQL.90).aspx