NeoNmaN


Hallo all, i get a small problems whit my MS SQL server this problem is i can't get my remote con allow bot how can i doe it :)

this error i get when i trying to connet from my laptop to my server

TITLE: Connect to Server
------------------------------

Cannot connect to 192.168.47.128\SQLEXPRESS.

------------------------------
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

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

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

i hob i can be helpt :)





Re: How to set my SQL Server Express to remote?

Hristo Markov


Hi,

I hope you do the next.

1. Allow SQL Server to pass via you firewall on your server computer.

2. Allow remote connection (using TCP/IP) from ¡°SQL Server 2005 Surface Area Configuration¡±

So, you must also check ¡°enable¡± to ¡°yes¡± for certain IP address.

You can do this from Start button ¨C Programs - Microsoft SQL Server 2005 - Configuration Tools - SQL Server Configuration Manager

Then from left part of appear window you must choose ¡°SQL Server 2005 Network Configuration¡± ¨C ¡°Protocols for SQLEXPRESS¡±. From right part of the window with right button of the mouse you must click on ¡°TCP/IP¡± and choose ¡°properties¡±. Then from appear popup window click on ¡°IP Addresses¡±. And then against your IP ¡°192.168.47.128¡± must choose ¡°Yes¡± to ¡°enable¡±.

For connect try to use the next format: IP (or name of the computer), Port or in your case 192.168.47.128, Port

My additional advice => first try to make connection on server computer to him self with 192.168.47.128, Port and if it is ok => try with computers from network. If you can make connection on your server computer, but you can¡¯t make with network computers then the problem is in the firewall.

Regards!

Hristo Markov







Re: How to set my SQL Server Express to remote?

Booloz

I am having the same problem, but with my own computer. I couldn't connect to the server because of the TCP/IP






Re: How to set my SQL Server Express to remote?

metallicaboy

Hi ive read your problem and i can say that i faced the same problem, i found a solution to my problem, i don't know if this should work for you but try it out. here it is

1st step - Enable your TCP/IP for remote sql server on the sql server surface area configuration

2nd step - Then open you SQL server configuration manager and browse the protocols for SQL EXPRESS, propeties and go to the IPAdresses

Active Yes

Enable Yes

IP Address 192.168.1.47 ( this is the IP where your sql server resides)

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

Then go down where its the IPALL and enter the following

TCP Dynamic ports (do not enter anything keep it blank)

TCP Port 1433 (this is the default SQL server port, you ar recommended to use this)

save your settings and restart your sql server express service

Then use 192.168.1.47\SQLEXPRESS as your connnection string *note that you did not need to enter the port number as you previously use the 1433 default sql port.so that any query will automatically first seach into the default port

lastly if u intent to use the service over a network, u need to enable port 1433 on your firewall if you did not previously perform that, but again as said in the previous post, test if it works first locally on your sql server machine..

let me know if it works.. bye